Abfragezeit: 0.60 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 0.727 MB
DELETE
FROM `dof0p_session`
WHERE `time` < '1745257057'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `dof0p_session`
WHERE `time` < '1745257057'
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.06 ms |
| Updating | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:822 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.53 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 0.737 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `dof0p_session`
WHERE `session_id` = 'afgm3ug3unou0gk06u1no39el6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| End of update loop | 0.03 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 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:82 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:648 |
| 9 | JSession->_start() | JROOT/libraries/joomla/session/session.php:608 |
| 8 | JSession->start() | JROOT/libraries/joomla/session/session.php:486 |
| 7 | JSession->get() | JROOT/libraries/joomla/session/session.php:443 |
| 6 | JSession->isNew() | JROOT/libraries/cms/application/cms.php:829 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 2.87 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.755 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `dof0p_session`
WHERE `session_id` = 'afgm3ug3unou0gk06u1no39el6'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.59 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 0.762 MB
INSERT INTO `dof0p_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('afgm3ug3unou0gk06u1no39el6', 1, '1745257957', 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `dof0p_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('afgm3ug3unou0gk06u1no39el6', 1, '1745257957', 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.03 ms |
| Update | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:216 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 1.28 ms Nach letzter Abfrage: 4.81 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.788 MB Zeilen zurückgegeben: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dof0p_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | ref | extension | extension | 82 | const | 35 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.55 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:447 |
| 8 | JComponentHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:455 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 6.15 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.833 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `dof0p_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.05 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1061 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.847 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM dof0p_usergroups AS a
LEFT JOIN dof0p_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.10 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1093 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.72 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.932 MB Zeilen zurückgegeben: 97
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM dof0p_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | ALL | extension | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 245 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.96 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:327 |
| 8 | JPluginHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:332 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.73 ms Nach letzter Abfrage: 52.74 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.361 MB Zeilen zurückgegeben: 1
SELECT template
FROM dof0p_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.59 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.371 MB Zeilen zurückgegeben: 1
SELECT template
FROM dof0p_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.88 ms Nach letzter Abfrage: 16.94 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.518 MB Zeilen zurückgegeben: 2
SELECT extension, file, type
FROM dof0p_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_rokcommon_configs | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.17 ms Nach letzter Abfrage: 50.91 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.861 MB Zeilen zurückgegeben: 127
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| checking permissions | 0.44 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:78 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 1.46 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.885 MB Zeilen zurückgegeben: 0
SELECT file_id
from dof0p_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2025-04-21 19:52:38'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_jdownloads_files | ALL | idx_published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:106 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.892 MB Zeilen zurückgegeben: 0
SELECT file_id
from dof0p_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2025-04-21 19:52:38'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_jdownloads_files | ref | idx_published | idx_published | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.06 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.03 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jdownloads/jdownloads.php:114 |
| 8 | plgSystemjdownloads->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.48 ms Nach letzter Abfrage: 1.51 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.886 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `dof0p_extensions`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `dof0p_extensions`
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.49 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.10 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Removing tmp table | 0.14 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 12 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 11 | JTable->__construct() | JROOT/libraries/joomla/table/extension.php:31 |
| 10 | JTableExtension->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 9 | JTable::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.92 ms Nach letzter Abfrage: 4.14 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.931 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `dof0p_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.15 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.08 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:120 |
| 9 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.942 MB Zeilen zurückgegeben: 1
SELECT *
FROM dof0p_extensions
WHERE `extension_id` = '10057'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.07 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 9 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.949 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `dof0p_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.16 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:120 |
| 9 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.957 MB Zeilen zurückgegeben: 1
SELECT *
FROM dof0p_extensions
WHERE `extension_id` = '10057'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 9 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 4.84 ms Nach letzter Abfrage: 925.45 ms Abfragespeichernutzung: 0.196 MB Speichernutzung vor Abfrage: 2.220 MB Zeilen zurückgegeben: 139
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 dof0p_menu AS m
LEFT JOIN dof0p_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 3 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 3.97 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 16 | JMenuSite->{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:444 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:59 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:198 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:549 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:402 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1145 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.54 ms Nach letzter Abfrage: 59.46 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 2.971 MB Zeilen zurückgegeben: 127
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| checking permissions | 0.60 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:353 |
| 8 | plgSystemjdownloads->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.07 ms Nach letzter Abfrage: 1.79 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.999 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dof0p_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.29 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 13 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 12 | JLibraryHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 11 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 10 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 9 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 8 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1023 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.72 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 2.992 MB
UPDATE `dof0p_extensions`
SET `params` = '{\"mediaversion\":\"b0cdffb23a88928d139afa9ebdb37cf6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `dof0p_extensions`
SET `params` = '{\"mediaversion\":\"b0cdffb23a88928d139afa9ebdb37cf6\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.17 ms |
| Updating | 0.10 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:1023 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.77 ms Nach letzter Abfrage: 3.45 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.031 MB Zeilen zurückgegeben: 1
SELECT *
FROM dof0p_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_languages | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:327 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.17 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.046 MB Zeilen zurückgegeben: 6
SELECT id, home, template, s.params
FROM dof0p_template_styles as s
LEFT JOIN dof0p_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | web688_2016_db.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.15 ms |
| Preparing | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.24 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 4 | JApplicationSite->getTemplate() | JROOT/libraries/cms/application/site.php:165 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 2.04 ms Nach letzter Abfrage: 14.13 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.105 MB Zeilen zurückgegeben: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `dof0p_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jdownloads','com_jmgadventcalendar','com_jnews','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_pressearchiv','com_redirect','com_roksprocket','com_search','com_spidercontacts','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 43 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.21 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.96 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 16 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 15 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 14 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:434 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:248 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.89 ms Nach letzter Abfrage: 6.92 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.236 MB Zeilen zurückgegeben: 30
SHOW FULL COLUMNS
FROM `dof0p_content`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `dof0p_content`
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.58 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.20 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.15 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 12 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:33 |
| 11 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 10 | JTable::getInstance() | JROOT/components/com_content/models/article.php:250 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 10.42 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 3.309 MB Zeilen zurückgegeben: 1
SELECT *
FROM dof0p_content
WHERE `id` = '321'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 10 | JTable->load() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.349 MB
UPDATE dof0p_content
SET `hits` = (`hits` + 1)
WHERE `id` = '321'
„EXPLAIN“ unmöglich für Abfrage: UPDATE dof0p_content
SET `hits` = (`hits` + 1)
WHERE `id` = '321'
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.05 ms |
| Updating | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/table/table.php:1240 |
| 10 | JTable->hit() | JROOT/components/com_content/models/article.php:252 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.19 ms Nach letzter Abfrage: 4.29 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.376 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 dof0p_content AS a
INNER JOIN dof0p_categories AS c
on c.id = a.catid
LEFT JOIN dof0p_users AS u
on u.id = a.created_by
LEFT JOIN dof0p_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dof0p_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 321
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.16 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:148 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/legacy/view/legacy.php:422 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.09 ms Nach letzter Abfrage: 6.09 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 3.442 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=13
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 32 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.13 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.15 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 20 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 19 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 18 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 17 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 16 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 15 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 14 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 13 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 12 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 11 | JRoute::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.485 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `dof0p_contentitem_tag_map` AS m
INNER JOIN `dof0p_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 321
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.09 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 11 | JHelperTags->getItemTags() | JROOT/components/com_content/views/article/view.html.php:180 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.24 ms Nach letzter Abfrage: 16.03 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 3.618 MB Zeilen zurückgegeben: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM dof0p_fields AS a
LEFT JOIN `dof0p_languages` AS l
ON l.lang_code = a.language
LEFT JOIN dof0p_users AS uc
ON uc.id=a.checked_out
LEFT JOIN dof0p_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN dof0p_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN dof0p_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `dof0p_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 (13,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | web688_2016_db.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.15 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:326 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 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:190 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 3.71 ms Nach letzter Abfrage: 139.03 ms Abfragespeichernutzung: 0.175 MB Speichernutzung vor Abfrage: 4.199 MB Zeilen zurückgegeben: 177
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM dof0p_modules AS m
LEFT JOIN dof0p_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN dof0p_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 <= '2025-04-21 17:52:39')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-21 17:52:39')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 6 | const,const | 47 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | web688_2016_db.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.id | 14 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.11 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 2.64 ms |
| End of update loop | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 16 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:424 |
| 15 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:360 |
| 14 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 13 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 12 | JDocumentHtml->countModules() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->count() | JROOT/templates/jp-school/layouts/theme.config.php:28 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 107.07 ms Nach letzter Abfrage: 197.78 ms Abfragespeichernutzung: 2.251 MB Speichernutzung vor Abfrage: 4.786 MB Zeilen zurückgegeben: 293
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM dof0p_content as a
LEFT JOIN dof0p_categories AS c
ON c.id = a.catid
LEFT JOIN dof0p_users AS ua
ON ua.id = a.created_by
LEFT JOIN dof0p_users AS um
ON um.id = a.modified_by
LEFT JOIN dof0p_content_rating AS v
ON a.id = v.content_id
LEFT JOIN dof0p_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN dof0p_languages AS l
ON a.language = l.lang_code
LEFT JOIN dof0p_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN dof0p_tags AS t
ON t.id = ct.tag_id
LEFT
OUTER JOIN (select rsi.provider_id, rsi.
order
from dof0p_roksprocket_items as rsi
where module_id = 275) rsi
on a.id = rsi.provider_id
WHERE ((a.access IN(1,1)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.state != -2))
AND a.id IN (321)) OR ((a.access IN(1,1)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.state != -2))
AND a.catid IN (13,32))
GROUP BY id
ORDER BY rsi.
order
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | ct | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_access,idx_state,idx_catid | PRIMARY,idx_catid | 4,4 | NULL | 283 | Using sort_union(PRIMARY,idx_catid); Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.catid | 1 | Using where |
| 1 | SIMPLE | vl | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.access | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.created_by | 1 | Using where |
| 1 | SIMPLE | um | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.modified_by | 1 | Using where |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | web688_2016_db.a.language | 1 | Using where |
| 1 | SIMPLE | rsi | ALL | idx_module,idx_module_order | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 597 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.35 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.23 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.43 ms |
| Preparing | 0.05 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.13 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 97.56 ms |
| Creating sort index | 6.72 ms |
| Removing tmp table | 0.56 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.88 ms Nach letzter Abfrage: 43.15 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 7.805 MB Zeilen zurückgegeben: 0
SELECT ct.content_item_id as article_id, t.title as tag
FROM dof0p_contentitem_tag_map as ct
LEFT JOIN dof0p_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (739,737,735,736,734,733,732,731,730,729,727,728,726,724,723,720,721,722,718,715,713,706,710,709,707,708,705,703,704,702,701,698,697,696,695,694,692,693,686,684,683,682,681,680,643,642,665,657,663,647,645,659,660,662,666,667,670,671,672,673,678,679,640,639,638,636,637,635,633,631,632,630,629,628,627,626,625,624,623,622,621,620,619,618,617,616,614,613,612,611,610,607,605,603,601,600,599,598,597,596,595,594,591,590,587,586,582,579,576,575,574,573,571,570,569,568,567,566,564,561,559,558,557,556,555,554,552,551,550,549,546,545,540,538,537,536,532,530,526,520,519,516,515,514,513,511,508,506,505,504,502,501,499,497,493,492,491,490,487,486,485,484,482,481,480,479,477,474,473,471,470,468,465,462,461,458,457,456,454,453,452,451,450,449,448,447,446,444,443,441,440,439,438,437,436,431,430,426,425,424,423,422,421,419,418,417,416,414,412,411,410,409,408,407,406,404,402,399,397,394,391,384,383,382,381,377,376,372,371,369,366,365,360,353,351,349,347,346,344,343,342,340,339,338,337,336,334,333,332,331,329,328,326,325,324,323,322,321,320,318,313,312,311,309,307,306,305,304,303,297,296,295,290,285,284,283,282,277,276,271,269,268,257,256,245,242,238,236,227,215,214,212,197)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.09 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 24 | JDatabaseDriver->loadAssocList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 |
| 23 | RokSprocket_Provider_Joomla_TagMerge->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 |
| 22 | RokSprocket_Provider_Joomla->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 4.43 ms Nach letzter Abfrage: 946.00 ms Abfragespeichernutzung: 0.533 MB Speichernutzung vor Abfrage: 8.819 MB Zeilen zurückgegeben: 298
SELECT i.provider_id as id, i.
order, i.params
FROM dof0p_roksprocket_items as i
WHERE i.module_id = '275'
AND i.provider = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | idx_module,idx_module_order | idx_module | 137 | const | 255 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 3.76 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139 |
| 22 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.71 ms Nach letzter Abfrage: 1920.87 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.408 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=14
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.26 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.25 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.86 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 5.432 MB Zeilen zurückgegeben: 8
SELECT `id`,`name`,`rules`,`parent_id`
FROM `dof0p_assets`
WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | dof0p_assets | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 945 | Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.12 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.96 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:357 |
| 21 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:224 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:538 |
| 19 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 18 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 17 | JUser->authorise() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.464 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=15
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.12 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.19 ms |
| End of update loop | 0.03 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.493 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=16
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.17 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.514 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=17
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.15 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.97 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.535 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=25
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.14 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.35 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.556 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=26
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 7 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.17 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.22 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 18 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 17 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 16 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/models/calendar.php:68 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.57 ms Nach letzter Abfrage: 5.40 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 5.606 MB Zeilen zurückgegeben: 0
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `dof0p_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN dof0p_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from dof0p_dpcalendar_caldav_principals memberp
inner join dof0p_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join dof0p_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | mainp | eq_ref | uri | uri | 602 | web688_2016_db.c.principaluri | 1 | Using where |
| 1 | SIMPLE | m | index | principal_id | principal_id | 8 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | memberp | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.member_id | 1 | Using where |
| 1 | SIMPLE | linkp | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.principal_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.06 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.43 ms |
| Creating sort index | 0.05 ms |
| Removing tmp table | 0.11 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 22 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 21 | JModelList->getItems() | JROOT/components/com_dpcalendar/models/profile.php:38 |
| 20 | DPCalendarModelProfile->getItems() | JROOT/plugins/system/dpcalendar/dpcalendar.php:235 |
| 19 | PlgSystemDpcalendar->fetchCalendars() | JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509 |
| 18 | DPCalendarPlugin->onCalendarsFetch() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/components/com_dpcalendar/models/calendar.php:100 |
| 15 | DPCalendarModelCalendar->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.52 ms Nach letzter Abfrage: 3.43 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 5.624 MB Zeilen zurückgegeben: 47
SHOW FULL COLUMNS
FROM `dof0p_dpcalendar_events`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `dof0p_dpcalendar_events`
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.39 ms |
| After opening tables | 0.02 ms |
| System lock | 0.05 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.04 ms |
| checking permissions | 0.17 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.11 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 20 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 19 | JTable->__construct() | JROOT/administrator/components/com_dpcalendar/tables/event.php:19 |
| 18 | DPCalendarTableEvent->__construct() | JROOT/components/com_dpcalendar/models/events.php:570 |
| 17 | DPCalendarModelEvents->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 16 | JModelList->getItems() | JROOT/components/com_dpcalendar/models/events.php:137 |
| 15 | DPCalendarModelEvents->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 2.95 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 5.722 MB Zeilen zurückgegeben: 15
SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `dof0p_dpcalendar_events` AS a
LEFT JOIN dof0p_categories AS c
ON c.id = a.catid
LEFT JOIN dof0p_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN dof0p_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN dof0p_users AS ua
ON ua.id = a.created_by
LEFT JOIN dof0p_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1)
AND a.original_id > -1
AND a.catid IN ('14','15','16','17','25','26')
AND (c.access IN (1,1) or c.access is null)
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.start_date >= '2025-04-21 17:45:00')
AND a.language in ('de-DE','*')
GROUP BY a.id
ORDER BY a.start_date asc
LIMIT 15
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | range | idx_access,idx_start_date,idx_state,idx_catid,idx_language | idx_start_date | 5 | NULL | 24 | Using index condition; Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.catid | 1 | Using where |
| 1 | SIMPLE | rel | ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.id | 1 | Using where; Using index |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.rel.location_id | 1 | Using where; Using index |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.created_by | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.18 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.12 ms |
| Creating tmp table | 0.07 ms |
| Sorting for group | 0.05 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 1.17 ms |
| Creating sort index | 0.14 ms |
| Removing tmp table | 0.14 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_dpcalendar/models/events.php:573 |
| 17 | DPCalendarModelEvents->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 16 | JModelList->getItems() | JROOT/components/com_dpcalendar/models/events.php:137 |
| 15 | DPCalendarModelEvents->getItems() | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.76 ms Nach letzter Abfrage: 9.56 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.889 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=913
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.73 ms Nach letzter Abfrage: 6.01 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.911 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=914
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.72 ms Nach letzter Abfrage: 2.79 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.932 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=937
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.70 ms Nach letzter Abfrage: 2.69 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.953 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=915
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.972 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=916
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.992 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=917
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.97 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.012 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=918
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.68 ms Nach letzter Abfrage: 2.80 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.033 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=919
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.92 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.054 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=920
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.72 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.074 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=921
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.095 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=922
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.82 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.115 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=923
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.135 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=924
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.68 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.155 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=925
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.63 ms Nach letzter Abfrage: 1.93 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.176 MB Zeilen zurückgegeben: 0
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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=926
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43 |
| 23 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 22 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 21 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 20 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/components/com_dpcalendar/helpers/route.php:61 |
| 16 | DPCalendarHelperRoute::getEventRoute() | JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107 |
| 15 | require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php | JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73 |
| 14 | include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.46 ms Nach letzter Abfrage: 98.51 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.232 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 dof0p_categories as c
LEFT JOIN dof0p_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=23
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 32 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.24 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.23 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.16 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 25 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 24 | JCategories->get() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134 |
| 23 | RokSprocket_Provider_Joomla_Filter->category() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120 |
| 22 | RokSprocket_Provider_AbstractJoomlaPlatformFilter->process() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 16.07 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.141 MB Speichernutzung vor Abfrage: 6.257 MB Zeilen zurückgegeben: 82
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM dof0p_content as a
LEFT JOIN dof0p_categories AS c
ON c.id = a.catid
LEFT JOIN dof0p_users AS ua
ON ua.id = a.created_by
LEFT JOIN dof0p_users AS um
ON um.id = a.modified_by
LEFT JOIN dof0p_content_rating AS v
ON a.id = v.content_id
LEFT JOIN dof0p_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN dof0p_languages AS l
ON a.language = l.lang_code
LEFT JOIN dof0p_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN dof0p_tags AS t
ON t.id = ct.tag_id
LEFT
OUTER JOIN (select rsi.provider_id, rsi.
order
from dof0p_roksprocket_items as rsi
where module_id = 276) rsi
on a.id = rsi.provider_id
WHERE ((a.access IN(1,1)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.state != -2))
AND a.id IN (524,565)) OR ((a.access IN(1,1)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-21 17:52:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-21 17:52:39')
AND (a.state != -2))
AND a.catid IN (23))
GROUP BY id
ORDER BY rsi.
order
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | ct | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_access,idx_state,idx_catid | PRIMARY,idx_catid | 4,4 | NULL | 86 | Using sort_union(PRIMARY,idx_catid); Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.catid | 1 | Using where |
| 1 | SIMPLE | vl | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.access | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.created_by | 1 | Using where |
| 1 | SIMPLE | um | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.a.modified_by | 1 | Using where |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | web688_2016_db.a.language | 1 | Using where |
| 1 | SIMPLE | rsi | ALL | idx_module,idx_module_order | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 597 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.24 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.16 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.21 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.24 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.10 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 12.55 ms |
| Creating sort index | 1.27 ms |
| Removing tmp table | 0.24 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.05 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.86 ms Nach letzter Abfrage: 1.11 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 6.630 MB Zeilen zurückgegeben: 0
SELECT ct.content_item_id as article_id, t.title as tag
FROM dof0p_contentitem_tag_map as ct
LEFT JOIN dof0p_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (711,700,691,687,688,675,668,674,669,658,634,608,592,584,583,580,578,572,565,543,544,529,524,518,510,509,507,496,495,494,489,488,478,476,475,469,467,466,445,433,420,415,413,405,403,401,400,396,393,364,359,350,345,341,335,330,310,308,302,301,300,299,298,293,292,291,289,288,286,280,279,278,275,274,273,267,266,265,264,243,211,173)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.04 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 24 | JDatabaseDriver->loadAssocList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 |
| 23 | RokSprocket_Provider_Joomla_TagMerge->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 |
| 22 | RokSprocket_Provider_Joomla->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.98 ms Nach letzter Abfrage: 164.60 ms Abfragespeichernutzung: 0.119 MB Speichernutzung vor Abfrage: 6.905 MB Zeilen zurückgegeben: 79
SELECT i.provider_id as id, i.
order, i.params
FROM dof0p_roksprocket_items as i
WHERE i.module_id = '276'
AND i.provider = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | idx_module,idx_module_order | idx_module | 137 | const | 87 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 1.21 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139 |
| 22 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64 |
| 21 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 20 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 19 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 18 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 17 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 16 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 15 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 14 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:198 |
| 13 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 12 | JDocumentRendererHtmlModule->render() | JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
| 11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/jp-school/layouts/theme.config.php:74 |
| 10 | include JROOT/templates/jp-school/layouts/theme.config.php | JROOT/templates/jp-school/layouts/theme.php:10 |
| 9 | include JROOT/templates/jp-school/layouts/theme.php | JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49 |
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/jp-school/index.php:16 |
| 7 | require JROOT/templates/jp-school/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.55 ms Nach letzter Abfrage: 505.80 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 7.174 MB Zeilen zurückgegeben: 127
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.04 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| checking permissions | 0.64 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 8 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:253 |
| 7 | plgSystemjdownloads->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1122 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.72 ms Nach letzter Abfrage: 5.23 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.277 MB Zeilen zurückgegeben: 0
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `dof0p_dpcalendar_caldav_calendars` c
LEFT
OUTER JOIN dof0p_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from dof0p_dpcalendar_caldav_principals memberp
inner join dof0p_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join dof0p_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | mainp | eq_ref | uri | uri | 602 | web688_2016_db.c.principaluri | 1 | Using where |
| 1 | SIMPLE | m | index | principal_id | principal_id | 8 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | memberp | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.member_id | 1 | Using where |
| 1 | SIMPLE | linkp | eq_ref | PRIMARY | PRIMARY | 4 | web688_2016_db.m.principal_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.11 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| Creating sort index | 0.06 ms |
| Removing tmp table | 0.11 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 21 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 20 | JModelList->getItems() | JROOT/components/com_dpcalendar/models/profile.php:38 |
| 19 | DPCalendarModelProfile->getItems() | JROOT/plugins/system/dpcalendar/dpcalendar.php:235 |
| 18 | PlgSystemDpcalendar->fetchCalendars() | JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509 |
| 17 | DPCalendarPlugin->onCalendarsFetch() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:77 |
| 14 | DPCalendarHelper::getCalendar() | JROOT/components/com_dpcalendar/router.php:86 |
| 13 | DPCalendarRouter->build() | JROOT/libraries/cms/router/site.php:519 |
| 12 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:489 |
| 11 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:282 |
| 10 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 9 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 8 | JRoute::_() | JROOT/plugins/system/sef/sef.php:110 |
| 7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1122 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Ein geschichtsträchtiges Datum Am Donnerstag, den
Zwei Projekte mit großem Potenzial Forschung
Mit Eloquenz und pädagogischem Feingefühl zeigt
Future Founders Initiative zu Gast am
Am 27. März 2025 brachte die
Das GymBo gratuliert Wolfgang Sykorra zu
Auch in diesem Jahr war die
Demonstration für Vielfalt, Toleranz und Respekt
Mathe-Teamwettbewerb 2025 Auch in diesem Jahr
Mit dem Gastspiel des fast 200
Ein eigenes Business starten, Verantwortung übernehmen,
...und das soll auch so bleiben!
Letzter Tag vor den Weihnachtsferien: Wie
Wenn an zwei Abenden im Dezember
Es ist still beim ersten Vorlesewettbewerb
In unserer neuen Aula in
Jedes Jahr begleitet unser Deutschkollege Herr Gibowski lese- und literaturaffine
Einstimmung in die Weihnachtszeit Alljährlich
Der Deutsch LK 1 der Q1