Abfragezeit: 1.38 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.828 MB Zeilen zurückgegeben: 1
SELECT `data`
FROM `nusa6_session`
WHERE `session_id` = X'3235313465346337303166326633656130393762323665643234383730336633'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.15 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | 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:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 2.73 ms Nach letzter Abfrage: 9.17 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 4.101 MB Zeilen zurückgegeben: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nusa6_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | extension | extension | 62 | const | 39 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.12 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.44 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | 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:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.24 ms Nach letzter Abfrage: 6.17 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.361 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `nusa6_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.30 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.373 MB Zeilen zurückgegeben: 0
SELECT b.id
FROM nusa6_usergroups AS a
LEFT JOIN nusa6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| executing | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.95 ms Nach letzter Abfrage: 1.29 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.439 MB Zeilen zurückgegeben: 196
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM nusa6_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | extension | extension | 62 | const | 218 | 0.40 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.68 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 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:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.05 ms Nach letzter Abfrage: 48.96 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.944 MB Zeilen zurückgegeben: 388
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.07 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| checking permissions | 1.69 ms |
| Sending data | 0.79 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
| 8 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jasocial_feed/jasocial_feed.php:93 |
| 7 | plgSystemjasocial_feed->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.72 ms Nach letzter Abfrage: 18.49 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 6.457 MB Zeilen zurückgegeben: 0
SELECT extension_id
FROM nusa6_extensions
WHERE type = "component"
AND element = "com_cck_webservices"
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.07 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.18 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.11 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.06 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/cck/database.php:132 |
| 12 | JCckDatabase::loadResult() | JROOT/libraries/cms/cck/database/cache.php:74 |
| 11 | JCckDatabaseCache::loadResult() | JROOT/libraries/cms/cck/webservice.php:28 |
| 10 | JCckWebservice::_setConfig() | JROOT/libraries/cms/cck/webservice.php:45 |
| 9 | JCckWebservice::getConfig() | JROOT/plugins/system/cck/cck.php:776 |
| 8 | plgSystemCCK->_isRestApi() | JROOT/plugins/system/cck/cck.php:49 |
| 7 | plgSystemCCK->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.75 ms Nach letzter Abfrage: 19.73 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 7.030 MB Zeilen zurückgegeben: 68
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 nusa6_menu AS m
LEFT JOIN nusa6_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 85 | 10.00 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.16 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.14 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| Creating sort index | 2.77 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.05 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Der selbe Aufruf in der Zeile darunter. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/cck/cck.php:178 |
| 8 | plgSystemCCK->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.35 ms Nach letzter Abfrage: 3.11 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.364 MB Zeilen zurückgegeben: 0
SELECT extension_id
FROM nusa6_extensions
WHERE type = "component"
AND element = "com_cck_toolbox"
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/cck/database.php:132 |
| 11 | JCckDatabase::loadResult() | JROOT/libraries/cms/cck/database/cache.php:74 |
| 10 | JCckDatabaseCache::loadResult() | JROOT/libraries/cms/cck/toolbox.php:25 |
| 9 | JCckToolbox::getConfig() | JROOT/plugins/system/cck/cck.php:184 |
| 8 | plgSystemCCK->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.52 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.371 MB Zeilen zurückgegeben: 3
SELECT type, scriptfile, options
FROM nusa6_cck_more_processings
WHERE published = 1
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_cck_more_processings | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 4 | 25.00 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.14 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.14 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/cck/database.php:172 |
| 11 | JCckDatabase::loadObjectListArray() | JROOT/libraries/cms/cck/database/cache.php:61 |
| 10 | JCckDatabaseCache::loadObjectListArray() | JROOT/libraries/cms/cck/toolbox.php:101 |
| 9 | JCckToolbox::process() | JROOT/plugins/system/cck/cck.php:185 |
| 8 | plgSystemCCK->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.65 ms Nach letzter Abfrage: 37.57 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 8.081 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nusa6_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 |
| 8 | plgSystemDJjQueryMonster->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.94 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.073 MB
UPDATE `nusa6_extensions`
SET `params` = '{\"mediaversion\":\"8f2418032b969bd493c40d18ef076b86\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | nusa6_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.11 ms |
| updating | 0.21 ms |
| end | 0.03 ms |
| query end | 3.44 ms |
| closing tables | 0.05 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 |
| 8 | plgSystemDJjQueryMonster->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.36 ms Nach letzter Abfrage: 4.93 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.250 MB Zeilen zurückgegeben: 25
SELECT id, home, template, s.params
FROM nusa6_template_styles as s
LEFT JOIN nusa6_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 9 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 152 | DB2760044.e.element | 3 | 92.59 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.17 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.49 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:836 |
| 9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 |
| 8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.47 ms Nach letzter Abfrage: 37.40 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 9.496 MB Zeilen zurückgegeben: 1
SELECT *
FROM nusa6_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_languages | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.10 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.70 ms Nach letzter Abfrage: 24.30 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 9.957 MB Zeilen zurückgegeben: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nusa6_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_cck','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djmediatools','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rstbox','com_search','com_securitycheckpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_assets | NULL | range | idx_asset_name | idx_asset_name | 152 | NULL | 40 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.10 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.11 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.25 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.71 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 10.012 MB Zeilen zurückgegeben: 344
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nusa6_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_assets | NULL | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 599 | 21.43 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.51 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.88 ms Nach letzter Abfrage: 4.49 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 10.423 MB Zeilen zurückgegeben: 34
SHOW FULL COLUMNS
FROM `nusa6_content`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nusa6_content`
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.23 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.08 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.09 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
| 11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.02 ms Nach letzter Abfrage: 9.86 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.674 MB
UPDATE nusa6_content
SET `hits` = (`hits` + 1)
WHERE `id` = '228'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | nusa6_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.06 ms |
| updating | 0.11 ms |
| end | 0.02 ms |
| query end | 2.70 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.90 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 10.799 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM nusa6_content AS a
INNER JOIN nusa6_categories AS c
on c.id = a.catid
LEFT JOIN nusa6_users AS u
on u.id = a.created_by
LEFT JOIN nusa6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nusa6_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 228
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-20 09:17:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-20 09:17:53')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|
| starting | 0.20 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 |
| Opening tables | 0.22 ms |
| init | 0.12 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.17 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.10 ms Nach letzter Abfrage: 6.60 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 11.022 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `nusa6_categories` AS `s`
INNER JOIN `nusa6_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 = 106
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | filesort wurde genutzt |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 46 | 19.66 | Using where |
| Status | Duration |
|---|
| starting | 0.25 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.10 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.19 ms |
| preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.24 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.07 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 22 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 21 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 20 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
| 19 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 18 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 17 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 16 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 15 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 12 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.11 ms Nach letzter Abfrage: 1.47 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.077 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `nusa6_contentitem_tag_map` AS m
INNER JOIN `nusa6_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 228
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 61 | 1.64 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | DB2760044.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.24 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.41 ms |
| init | 0.12 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.80 ms Nach letzter Abfrage: 30.36 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 11.959 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM nusa6_fields AS a
LEFT JOIN `nusa6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nusa6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nusa6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nusa6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `nusa6_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 (106,0,105))
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | l | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | DB2760044.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.44 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.09 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.39 ms |
| init | 0.15 ms |
| System lock | 0.02 ms |
| optimizing | 0.06 ms |
| statistics | 0.34 ms |
| preparing | 0.10 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.56 ms |
| Creating sort index | 0.07 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.13 ms |
| query end | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.45 ms Nach letzter Abfrage: 5.04 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 12.240 MB Zeilen zurückgegeben: 1
SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, a.author_id AS author, b.id AS type_id, b.alias AS type_alias, b.indexed, b.parent, b.stylesheets, b.options_content, b.options_intro, c.template AS content_template, c.params AS content_params, d.template AS intro_template, d.params AS intro_params, f.app as folder_app
FROM nusa6_cck_core AS a
LEFT JOIN nusa6_cck_core_types AS b
ON b.name = a.cck
LEFT JOIN nusa6_template_styles AS c
ON c.id = b.template_content
LEFT JOIN nusa6_template_styles AS d
ON d.id = b.template_intro
LEFT JOIN nusa6_cck_core_folders AS f
ON f.id = b.folder
WHERE a.id = "26"
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | const | name | name | 202 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | d | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | f | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.22 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.42 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.42 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:149 |
| 15 | JCckDatabase::loadObject() | JROOT/plugins/content/cck/cck.php:241 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.19 ms Nach letzter Abfrage: 12.22 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 12.827 MB Zeilen zurückgegeben: 24
SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.restriction, c.restriction_options, c.position
FROM nusa6_cck_core_type_field AS c
LEFT JOIN nusa6_cck_core_types AS sc
ON sc.id = c.typeid
LEFT JOIN nusa6_cck_core_fields AS cc
ON cc.id = c.fieldid
WHERE sc.name = "mitglieder"
AND sc.published = 1
AND c.client = "content"
AND c.access IN (1,1)
ORDER BY c.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sc | NULL | const | PRIMARY,name | name | 202 | const | 1 | 100.00 | filesort wurde genutzt |
| 1 | SIMPLE | c | NULL | ref | PRIMARY,typeid | PRIMARY | 4 | const | 48 | 2.00 | Using where |
| 1 | SIMPLE | cc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.c.fieldid | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.25 ms |
| init | 0.12 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.21 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| Creating sort index | 1.09 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/cck/database.php:160 |
| 15 | JCckDatabase::loadObjectList() | JROOT/plugins/content/cck/cck.php:312 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.25 ms Nach letzter Abfrage: 97.67 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 16.103 MB Zeilen zurückgegeben: 7
SELECT *
FROM nusa6_cck_core_type_position AS a
LEFT JOIN nusa6_cck_core_types AS b
ON b.id = a.typeid
WHERE b.name = "mitglieder"
AND a.client ="content"
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | b | NULL | const | PRIMARY,name | name | 202 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | a | NULL | ref | PRIMARY,typeid | PRIMARY | 4 | const | 11 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.19 ms |
| init | 0.09 ms |
| System lock | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.20 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.18 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/cck/database.php:160 |
| 16 | JCckDatabase::loadObjectList() | JROOT/plugins/content/cck/cck.php:432 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.46 ms Nach letzter Abfrage: 6.30 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 16.323 MB Zeilen zurückgegeben: 23
SHOW FULL COLUMNS
FROM `nusa6_cck_store_form_mitglieder`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nusa6_cck_store_form_mitglieder`
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.51 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| Opening tables | 0.21 ms |
| checking permissions | 0.09 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.05 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.19 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/cms/cck/table.php:44 |
| 23 | JCckTable->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/cms/cck/table.php:19 |
| 21 | JCckTable->__construct() | JROOT/libraries/cms/cck/table.php:29 |
| 20 | JCckTable::getInstance() | JROOT/libraries/cms/cck/plugin/location.php:90 |
| 19 | JCckPluginLocation->g_onCCK_Storage_LocationPrepareContent() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:88 |
| 18 | plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/plugins/content/cck/cck.php:467 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.49 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 16.372 MB Zeilen zurückgegeben: 1
SELECT *
FROM nusa6_cck_store_form_mitglieder
WHERE `id` = '228'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_cck_store_form_mitglieder | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 22 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 21 | Joomla\CMS\Table\Table->load() | JROOT/libraries/cms/cck/table.php:59 |
| 20 | JCckTable->load() | JROOT/libraries/cms/cck/plugin/location.php:93 |
| 19 | JCckPluginLocation->g_onCCK_Storage_LocationPrepareContent() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:88 |
| 18 | plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/plugins/content/cck/cck.php:467 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.40 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 16.389 MB Zeilen zurückgegeben: 1
SELECT *
FROM nusa6_content
WHERE `id` = '228'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.34 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 20 | Joomla\CMS\Table\Table->load() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:437 |
| 19 | plgCCK_Storage_LocationJoomla_Article::_getTable() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:90 |
| 18 | plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/plugins/content/cck/cck.php:467 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.24 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 16.395 MB Zeilen zurückgegeben: 1
SELECT a.title, a.alias
FROM nusa6_categories AS a
WHERE a.id = 106
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 21 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:149 |
| 20 | JCckDatabase::loadObject() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:440 |
| 19 | plgCCK_Storage_LocationJoomla_Article::_getTable() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:90 |
| 18 | plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/plugins/content/cck/cck.php:467 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.09 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 16.409 MB Zeilen zurückgegeben: 0
SELECT `t`.`id`
FROM `nusa6_tags` AS t
INNER JOIN `nusa6_contentitem_tag_map` AS m
ON `m`.`tag_id` = `t`.`id`
AND `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` IN ( 228)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 61 | 1.64 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.m.tag_id | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 2.52 ms |
| preparing | 0.07 ms |
| executing | 0.02 ms |
| Sending data | 0.17 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.06 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 21 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Helper/TagsHelper.php:506 |
| 20 | Joomla\CMS\Helper\TagsHelper->getTagIds() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:451 |
| 19 | plgCCK_Storage_LocationJoomla_Article::_getTable() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:90 |
| 18 | plgCCK_Storage_LocationJoomla_Article->onCCK_Storage_LocationPrepareContent() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/plugins/content/cck/cck.php:467 |
| 15 | plgContentCCK->_render() | JROOT/plugins/content/cck/cck.php:365 |
| 14 | plgContentCCK->_prepare() | JROOT/plugins/content/cck/cck.php:218 |
| 13 | plgContentCCK->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.66 ms Nach letzter Abfrage: 34.41 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 17.450 MB Zeilen zurückgegeben: 0
select b.*
from nusa6_rstbox b
where b.published = 1
AND b.testmode=0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | b | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.14 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rstbox/helpers/helper.php:283 |
| 8 | EBHelper::getBoxes() | JROOT/plugins/system/rstbox/rstbox.php:78 |
| 7 | PlgSystemRstBox->onAfterDispatch() | 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/SiteApplication.php:199 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.44 ms Nach letzter Abfrage: 35.90 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 17.707 MB Zeilen zurückgegeben: 27
SELECT id
FROM nusa6_template_styles
ORDER BY id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_template_styles | NULL | index | NULL | PRIMARY | 4 | NULL | 27 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:297 |
| 9 | JMFTemplate->setup() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:121 |
| 8 | JMFTemplate->__construct() | JROOT/templates/jm-animals/index.php:18 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.82 ms Nach letzter Abfrage: 16.27 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 18.601 MB Zeilen zurückgegeben: 35
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nusa6_modules AS m
LEFT JOIN nusa6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nusa6_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 <= '2024-11-20 09:17:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-20 09:17:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 84 | 1.60 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | DB2760044.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | DB2760044.m.id | 4 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.23 ms |
| init | 0.11 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.23 ms |
| preparing | 0.07 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 2.74 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | Der selbe Aufruf in der Zeile darunter. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:444 |
| 11 | JMFTemplate->countModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:437 |
| 10 | JMFTemplate->checkModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1644 |
| 9 | JMFTemplate->getAllColumnsClasses() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:174 |
| 8 | JMFTemplate->__construct() | JROOT/templates/jm-animals/index.php:18 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 8.48 ms Nach letzter Abfrage: 23.86 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 18.939 MB Zeilen zurückgegeben: 4
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 nusa6_content AS a
LEFT JOIN nusa6_categories AS c
ON c.id = a.catid
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_by
LEFT JOIN nusa6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN nusa6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nusa6_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 (128)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-20 09:17:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-20 09:17:53')
ORDER BY a.created DESC
LIMIT 4
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 97 | 14.68 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| 1 | SIMPLE | v | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.47 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.02 ms |
| Opening tables | 0.06 ms |
| init | 0.24 ms |
| System lock | 0.03 ms |
| optimizing | 0.05 ms |
| statistics | 0.26 ms |
| preparing | 0.10 ms |
| Creating tmp table | 0.13 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 5.13 ms |
| Creating sort index | 0.40 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| removing tmp table | 0.26 ms |
| query end | 0.03 ms |
| closing tables | 0.04 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 19 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_news/helper.php:100 |
| 18 | ModArticlesNewsHelper::getList() | JROOT/modules/mod_articles_news/mod_articles_news.php:15 |
| 17 | include JROOT/modules/mod_articles_news/mod_articles_news.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.03 ms Nach letzter Abfrage: 0.83 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 19.047 MB Zeilen zurückgegeben: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `nusa6_categories` AS `s`
INNER JOIN `nusa6_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 = 128
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | filesort wurde genutzt |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 46 | 50.38 | Using where |
| Status | Duration |
|---|
| starting | 0.27 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.14 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.18 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.19 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 30 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 29 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 28 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
| 27 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 26 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 25 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 24 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 23 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 22 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 21 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 20 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 19 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_news/helper.php:113 |
| 18 | ModArticlesNewsHelper::getList() | JROOT/modules/mod_articles_news/mod_articles_news.php:15 |
| 17 | include JROOT/modules/mod_articles_news/mod_articles_news.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.60 ms Nach letzter Abfrage: 2.37 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 19.104 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM nusa6_fields AS a
LEFT JOIN `nusa6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nusa6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nusa6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nusa6_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_articles_news.content'
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | l | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.group_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.22 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 |
| Opening tables | 0.05 ms |
| init | 0.10 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.22 ms |
| preparing | 0.06 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.43 ms |
| Creating sort index | 0.05 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| removing tmp table | 0.11 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 30 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 29 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 28 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 27 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 26 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 25 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 24 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 23 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 22 | JHtmlContent::prepare() | Der selbe Aufruf in der Zeile darunter. |
| 21 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 20 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 19 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_articles_news/helper.php:123 |
| 18 | ModArticlesNewsHelper::getList() | JROOT/modules/mod_articles_news/mod_articles_news.php:15 |
| 17 | include JROOT/modules/mod_articles_news/mod_articles_news.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.01 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 19.120 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM nusa6_fields AS a
LEFT JOIN `nusa6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nusa6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nusa6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nusa6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `nusa6_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 (128,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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | l | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | DB2760044.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.16 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.05 ms |
| Creating tmp table | 0.07 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.29 ms |
| Creating sort index | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.07 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 26 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 25 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 24 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 23 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 22 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 20 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 19 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/modules/mod_articles_news/helper.php:164 |
| 18 | ModArticlesNewsHelper::getList() | JROOT/modules/mod_articles_news/mod_articles_news.php:15 |
| 17 | include JROOT/modules/mod_articles_news/mod_articles_news.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.17 ms Nach letzter Abfrage: 11.19 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 19.122 MB Zeilen zurückgegeben: 14
SHOW FULL COLUMNS
FROM `nusa6_djmt_albums`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nusa6_djmt_albums`
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.32 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 0.12 ms |
| checking permissions | 0.08 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.13 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_djmediatools/tables/categories.php:32 |
| 21 | DJMediatoolsTableCategories->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 20 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_djmediatools/models/categories.php:164 |
| 19 | DJMediatoolsModelCategories->getItem() | JROOT/components/com_djmediatools/models/categories.php:210 |
| 18 | DJMediatoolsModelCategories->getParams() | JROOT/modules/mod_djmediatools/mod_djmediatools.php:43 |
| 17 | include JROOT/modules/mod_djmediatools/mod_djmediatools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.17 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 19.157 MB Zeilen zurückgegeben: 1
SELECT *
FROM nusa6_djmt_albums
WHERE `id` = '10'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_djmt_albums | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 20 | Joomla\CMS\Table\Table->load() | JROOT/components/com_djmediatools/models/categories.php:167 |
| 19 | DJMediatoolsModelCategories->getItem() | JROOT/components/com_djmediatools/models/categories.php:210 |
| 18 | DJMediatoolsModelCategories->getParams() | JROOT/modules/mod_djmediatools/mod_djmediatools.php:43 |
| 17 | include JROOT/modules/mod_djmediatools/mod_djmediatools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.25 ms Nach letzter Abfrage: 4.44 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 19.264 MB Zeilen zurückgegeben: 1
SELECT manifest_cache
FROM nusa6_extensions
WHERE element='com_djmediatools'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nusa6_extensions | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 20 | JDatabaseDriver->loadResult() | JROOT/components/com_djmediatools/helpers/helper.php:82 |
| 19 | DJMediatoolsLayoutHelper->__construct() | JROOT/components/com_djmediatools/helpers/helper.php:67 |
| 18 | DJMediatoolsLayoutHelper::getInstance() | JROOT/modules/mod_djmediatools/mod_djmediatools.php:54 |
| 17 | include JROOT/modules/mod_djmediatools/mod_djmediatools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.41 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 19.277 MB Zeilen zurückgegeben: 46
SELECT a.*
FROM nusa6_djmt_items AS a, nusa6_djmt_albums AS c
WHERE a.catid = 10
AND a.catid = c.id
AND c.published = 1
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-20 09:17:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-20 09:17:53')
ORDER BY a.ordering ASC
LIMIT 50
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | filesort wurde genutzt |
| 1 | SIMPLE | a | NULL | ref | catid | catid | 5 | const,const | 46 | 16.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.49 ms |
| init | 0.07 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.10 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.50 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djmediatools/helpers/helper.php:320 |
| 20 | DJMediatoolsLayoutHelper->getImagesFromDJMediatools() | JROOT/components/com_djmediatools/helpers/helper.php:159 |
| 19 | DJMediatoolsLayoutHelper->getSlides() | JROOT/components/com_djmediatools/layouts/mslider/helper.php:33 |
| 18 | MsliderDJMediatoolsLayoutHelper->getSlides() | JROOT/modules/mod_djmediatools/mod_djmediatools.php:60 |
| 17 | include JROOT/modules/mod_djmediatools/mod_djmediatools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/top3.php:15 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/top3.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.94 ms Nach letzter Abfrage: 89.97 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 19.492 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.name, a.alias, a.description, a.access, a.content, a.location, a.storage_location, a.stylesheets, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item
FROM nusa6_cck_core_searchs AS a
LEFT JOIN nusa6_cck_core_folders AS b
ON b.id = a.folder
WHERE a.name ="termine_und_veranstaltungen"
AND a.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | name | name | 202 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.18 ms |
| init | 0.08 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.17 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 21 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:149 |
| 20 | JCckDatabase::loadObject() | JROOT/libraries/cck/base/list/list.php:319 |
| 19 | CCK_List::getSearch() | JROOT/libraries/cck/base/list/list_inc.php:31 |
| 18 | include JROOT/libraries/cck/base/list/list_inc.php | JROOT/modules/mod_cck_list/mod_cck_list.php:58 |
| 17 | include JROOT/modules/mod_cck_list/mod_cck_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/sample-block.php:18 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/sample-block.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.07 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 19.514 MB Zeilen zurückgegeben: 2
SELECT a.id, a.title, a.name, a.folder, a.type, a.description, a.published, a.label, a.selectlabel, a.display, a.required, a.validation, a.defaultvalue, a.options, a.options2, a.minlength, a.maxlength, a.size, a.cols, a.rows, a.ordering, a.sorting, a.divider, a.bool, a.location, a.extended, a.style, a.script, a.bool2, a.bool3, a.bool4, a.bool5, a.bool6, a.bool7, a.bool8, a.css, a.attributes, a.storage, a.storage_cck, a.storage_location, a.storage_table, a.storage_field, a.storage_field2, a.storage_params, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.restriction, c.restriction_options, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position
FROM nusa6_cck_core_fields AS a
LEFT JOIN nusa6_cck_core_search_field AS c
ON c.fieldid = a.id
LEFT JOIN nusa6_cck_core_searchs AS b
ON b.id = c.searchid
WHERE b.name = "termine_und_veranstaltungen"
AND (c.client = "search" OR c.client = "
order")
AND c.access IN (1,1)
GROUP BY c.client, c.fieldid
ORDER BY c.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | b | NULL | const | PRIMARY,name | name | 202 | const | 1 | 100.00 | Using index; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | c | NULL | ref | PRIMARY,searchid,fieldid | PRIMARY | 4 | const | 4 | 3.80 | Using where |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | DB2760044.c.fieldid | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.28 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.18 ms |
| init | 0.18 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.21 ms |
| preparing | 0.07 ms |
| Creating tmp table | 0.22 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 1.29 ms |
| Creating sort index | 0.16 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.17 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.05 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/cck/database.php:172 |
| 20 | JCckDatabase::loadObjectListArray() | JROOT/libraries/cck/base/list/list.php:159 |
| 19 | CCK_List::getFields() | JROOT/libraries/cck/base/list/list_inc.php:73 |
| 18 | include JROOT/libraries/cck/base/list/list_inc.php | JROOT/modules/mod_cck_list/mod_cck_list.php:58 |
| 17 | include JROOT/modules/mod_cck_list/mod_cck_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/sample-block.php:18 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/sample-block.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.39 ms Nach letzter Abfrage: 9.21 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 19.835 MB Zeilen zurückgegeben: 0
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `nusa6_cck_core` AS t0
LEFT JOIN `nusa6_content` AS t1
ON t1.id = t0.pk
LEFT JOIN `nusa6_cck_core_types` AS tt
ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2024-11-20 09:17' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2024-11-20 09:17' )
AND t0.storage_location = "joomla_article"
AND t1.catid = 129
ORDER BY FIELD(t1.datum,"")
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | t1 | NULL | index_merge | PRIMARY,idx_access,idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 16 | 16.00 | Using intersect(idx_catid,idx_state); Using where; filesort wurde genutzt |
| 1 | SIMPLE | t0 | NULL | ref | idx_pk | idx_pk | 4 | DB2760044.t1.id | 1 | 10.00 | Using where |
| 1 | SIMPLE | tt | NULL | eq_ref | name | name | 202 | DB2760044.t0.cck | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.26 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.12 ms |
| System lock | 0.03 ms |
| optimizing | 0.10 ms |
| statistics | 0.21 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.41 ms |
| end | 0.02 ms |
| query end | 0.04 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/cck/cck.php:341 |
| 22 | plgSearchCCK->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 20 | JEventDispatcher->trigger() | JROOT/libraries/cck/base/list/list.php:211 |
| 19 | CCK_List::getList() | JROOT/libraries/cck/base/list/list_inc.php:338 |
| 18 | include JROOT/libraries/cck/base/list/list_inc.php | JROOT/modules/mod_cck_list/mod_cck_list.php:58 |
| 17 | include JROOT/modules/mod_cck_list/mod_cck_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/sample-block.php:18 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/sample-block.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.18 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 19.848 MB Zeilen zurückgegeben: 1
SELECT COUNT(t0.id)
FROM `nusa6_cck_core` AS t0
LEFT JOIN `nusa6_content` AS t1
ON t1.id = t0.pk
LEFT JOIN `nusa6_cck_core_types` AS tt
ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2024-11-20 09:17' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2024-11-20 09:17' )
AND t0.storage_location = "joomla_article"
AND t1.catid = 129
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | t1 | NULL | index_merge | PRIMARY,idx_access,idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 16 | 16.00 | Using intersect(idx_catid,idx_state); Using where |
| 1 | SIMPLE | t0 | NULL | ref | idx_pk | idx_pk | 4 | DB2760044.t1.id | 1 | 10.00 | Using where |
| 1 | SIMPLE | tt | NULL | eq_ref | name | name | 202 | DB2760044.t0.cck | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.22 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.05 ms |
| statistics | 0.21 ms |
| preparing | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 0.35 ms |
| end | 0.03 ms |
| query end | 0.04 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 23 | JDatabaseDriver->loadResult() | JROOT/plugins/search/cck/cck.php:393 |
| 22 | plgSearchCCK->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 20 | JEventDispatcher->trigger() | JROOT/libraries/cck/base/list/list.php:211 |
| 19 | CCK_List::getList() | JROOT/libraries/cck/base/list/list_inc.php:338 |
| 18 | include JROOT/libraries/cck/base/list/list_inc.php | JROOT/modules/mod_cck_list/mod_cck_list.php:58 |
| 17 | include JROOT/modules/mod_cck_list/mod_cck_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:713 |
| 14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:868 |
| 13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-animals/tpl/blocks/sample-block.php:18 |
| 12 | include JROOT/templates/jm-animals/tpl/blocks/sample-block.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-animals/tpl/default.php:74 |
| 10 | include JROOT/templates/jm-animals/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:636 |
| 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:647 |
| 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-animals/index.php:19 |
| 7 | require JROOT/templates/jm-animals/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.29 ms Nach letzter Abfrage: 49.65 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 20.389 MB Zeilen zurückgegeben: 6
SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `nusa6_contentitem_tag_map` AS `m`
INNER JOIN `nusa6_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `nusa6_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1)
AND `t`.`published` = 1
AND `m`.`type_alias` = `c`.`core_type_alias`
AND `c`.`core_state` = 1
AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0)
AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-11-20 09:17:53')
AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-11-20 09:17:53')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC
LIMIT 6
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | range | PRIMARY,tag_idx,idx_access,idx_content_type | tag_idx | 5 | NULL | 10 | 16.00 | Using index condition; Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | m | NULL | ref | idx_tag_type,idx_core_content_id | idx_core_content_id | 4 | DB2760044.c.core_content_id | 3 | 10.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | DB2760044.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.25 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.19 ms |
| init | 0.14 ms |
| System lock | 0.02 ms |
| optimizing | 0.07 ms |
| statistics | 0.30 ms |
| preparing | 0.09 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 1.61 ms |
| Creating sort index | 0.12 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.16 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.05 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_tags_popular/helper.php:134 |
| 14 | ModTagsPopularHelper::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:600 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_tags_popular/mod_tags_popular.php:22 |
| 10 | include JROOT/modules/mod_tags_popular/mod_tags_popular.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `nusa6_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nusa6_extensions`
2 × SELECT extension_id
FROM nusa6_extensions
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM nusa6_fields AS a
LEFT JOIN `nusa6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nusa6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nusa6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nusa6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `nusa6_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `nusa6_categories` AS `s`
INNER JOIN `nusa6_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT `data`
FROM `nusa6_session`
1 × SELECT id
FROM nusa6_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nusa6_modules AS m
LEFT JOIN nusa6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nusa6_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM nusa6_content AS a
LEFT JOIN nusa6_categories AS c
ON c.id = a.catid
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_by
LEFT JOIN nusa6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN nusa6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nusa6_content_rating AS v
ON a.id = v.content_id
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM nusa6_fields AS a
LEFT JOIN `nusa6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN nusa6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN nusa6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN nusa6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN nusa6_fields_groups AS g
ON g.id = a.group_id
1 × SELECT *
FROM nusa6_djmt_albums
1 × SELECT `t`.`id`
FROM `nusa6_tags` AS t
INNER JOIN `nusa6_contentitem_tag_map` AS m
ON `m`.`tag_id` = `t`.`id`
AND `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` IN ( 228
1 × SELECT manifest_cache
FROM nusa6_extensions
1 × SELECT a.*
FROM nusa6_djmt_items AS a, nusa6_djmt_albums AS c
1 × SELECT a.id, a.title, a.name, a.alias, a.description, a.access, a.content, a.location, a.storage_location, a.stylesheets, b.app as folder_app, a.options, a.template_search, a.template_filter, a.template_list, a.template_item
FROM nusa6_cck_core_searchs AS a
LEFT JOIN nusa6_cck_core_folders AS b
ON b.id = a.folder
1 × SELECT a.id, a.title, a.name, a.folder, a.type, a.description, a.published, a.label, a.selectlabel, a.display, a.required, a.validation, a.defaultvalue, a.options, a.options2, a.minlength, a.maxlength, a.size, a.cols, a.rows, a.ordering, a.sorting, a.divider, a.bool, a.location, a.extended, a.style, a.script, a.bool2, a.bool3, a.bool4, a.bool5, a.bool6, a.bool7, a.bool8, a.css, a.attributes, a.storage, a.storage_cck, a.storage_location, a.storage_table, a.storage_field, a.storage_field2, a.storage_params, c.client, c.label as label2, c.variation, c.variation_override, c.required, c.required_alert, c.validation, c.validation_options, c.live, c.live_options, c.live_value, c.markup, c.markup_class, c.match_collection, c.match_mode, c.match_options, c.match_value, c.stage, c.access, c.restriction, c.restriction_options, c.computation, c.computation_options, c.conditional, c.conditional_options, c.position
FROM nusa6_cck_core_fields AS a
LEFT JOIN nusa6_cck_core_search_field AS c
ON c.fieldid = a.id
LEFT JOIN nusa6_cck_core_searchs AS b
ON b.id = c.searchid
1 × SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `nusa6_cck_core` AS t0
LEFT JOIN `nusa6_content` AS t1
ON t1.id = t0.pk
LEFT JOIN `nusa6_cck_core_types` AS tt
ON tt.name = t0.cck
1 × SELECT COUNT(t0.id)
FROM `nusa6_cck_core` AS t0
LEFT JOIN `nusa6_content` AS t1
ON t1.id = t0.pk
LEFT JOIN `nusa6_cck_core_types` AS tt
ON tt.name = t0.cck
1 × select b.*
from nusa6_rstbox b
1 × SELECT *
FROM nusa6_cck_core_type_position AS a
LEFT JOIN nusa6_cck_core_types AS b
ON b.id = a.typeid
1 × SELECT a.title, a.alias
FROM nusa6_categories AS a
1 × SELECT *
FROM nusa6_content
1 × SELECT *
FROM nusa6_cck_store_form_mitglieder
1 × SELECT cc.*, c.label as label2, c.variation, c.link, c.link_options, c.markup, c.markup_class, c.typo, c.typo_label, c.typo_options, c.access, c.restriction, c.restriction_options, c.position
FROM nusa6_cck_core_type_field AS c
LEFT JOIN nusa6_cck_core_types AS sc
ON sc.id = c.typeid
LEFT JOIN nusa6_cck_core_fields AS cc
ON cc.id = c.fieldid
1 × SELECT a.id, a.pk, a.pkb, a.cck, a.storage_location, a.store_id, a.author_id AS author, b.id AS type_id, b.alias AS type_alias, b.indexed, b.parent, b.stylesheets, b.options_content, b.options_intro, c.template AS content_template, c.params AS content_params, d.template AS intro_template, d.params AS intro_params, f.app as folder_app
FROM nusa6_cck_core AS a
LEFT JOIN nusa6_cck_core_types AS b
ON b.name = a.cck
LEFT JOIN nusa6_template_styles AS c
ON c.id = b.template_content
LEFT JOIN nusa6_template_styles AS d
ON d.id = b.template_intro
LEFT JOIN nusa6_cck_core_folders AS f
ON f.id = b.folder
1 × SELECT `m`.`tag_id`,`t`.*
FROM `nusa6_contentitem_tag_map` AS m
INNER JOIN `nusa6_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM nusa6_content AS a
INNER JOIN nusa6_categories AS c
on c.id = a.catid
LEFT JOIN nusa6_users AS u
on u.id = a.created_by
LEFT JOIN nusa6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN nusa6_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM nusa6_languages
1 × SELECT id, home, template, s.params
FROM nusa6_template_styles as s
LEFT JOIN nusa6_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT type, scriptfile, options
FROM nusa6_cck_more_processings
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 nusa6_menu AS m
LEFT JOIN nusa6_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM nusa6_extensions
1 × SELECT b.id
FROM nusa6_usergroups AS a
LEFT JOIN nusa6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `nusa6_viewlevels
1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `nusa6_contentitem_tag_map` AS `m`
INNER JOIN `nusa6_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `nusa6_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
