Abfragezeit: 0.37 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.031 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jsmwh_session`
WHERE `session_id` = X'626c6d3633306f756d6271677068623464336c723161307531317139696b6172'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Derselbe Aufruf in der Zeile darunter. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.045 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jsmwh_session`
WHERE `session_id` = X'626c6d3633306f756d6271677068623464336c723161307531317139696b6172'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.050 MB
INSERT INTO `jsmwh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'626c6d3633306f756d6271677068623464336c723161307531317139696b6172', 1, 1685483310, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jsmwh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'626c6d3633306f756d6271677068623464336c723161307531317139696b6172', 1, 1685483310, 0, '', 0)
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init for update | 0.01 ms |
Update | 0.04 ms |
Waiting for query cache lock | 0.00 ms |
Update | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.081 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_extensions | ref | extension | extension | 82 | const | 40 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.11 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Derselbe Aufruf in der Zeile darunter. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.118 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jsmwh_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.130 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jsmwh_usergroups AS a
LEFT JOIN jsmwh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
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 | 2 | Using where; Using index |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.151 MB Zeilen zurückgegeben: 102
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jsmwh_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_extensions | ALL | extension | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 252 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.26 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Derselbe Aufruf in der Zeile darunter. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.74 ms Nach letzter Abfrage: 6.40 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 1.655 MB Zeilen zurückgegeben: 43
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 jsmwh_menu AS m
LEFT JOIN jsmwh_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 | 43 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.28 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Derselbe Aufruf in der Zeile darunter. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 7.29 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.499 MB Zeilen zurückgegeben: 1
SELECT id
FROM jsmwh_zoo_item
WHERE alias = 'oltner-abraeumer-an-den-aargauermeisterschaften'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_item | const | ALIAS_INDEX | ALIAS_INDEX | 767 | const | 1 | |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:87 |
12 | DatabaseHelper->queryResult() | JROOT/administrator/components/com_zoo/helpers/alias.php:119 |
11 | AppAlias->translateAliasToID() | JROOT/components/com_zoo/router.php:263 |
10 | ZooParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.524 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM jsmwh_template_styles as s
LEFT JOIN jsmwh_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,idx_client_id,idx_client_id_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | ttcolte_jo35.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:345 |
9 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
8 | plgSystemT3->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.65 ms Nach letzter Abfrage: 2.88 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.888 MB Zeilen zurückgegeben: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jsmwh_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper','com_zoo')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | Using index condition |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.17 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
14 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
13 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
12 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
11 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
10 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/sourcerer/helper.php:55 |
9 | plgSystemSourcererHelper->__construct() | JROOT/plugins/system/sourcerer/sourcerer.php:96 |
8 | plgSystemSourcerer->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.943 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Derselbe Aufruf in der Zeile darunter. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.933 MB
UPDATE `jsmwh_extensions`
SET `params` = '{\"mediaversion\":\"602e7284dc13be4d071efffc6761fd75\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `jsmwh_extensions`
SET `params` = '{\"mediaversion\":\"602e7284dc13be4d071efffc6761fd75\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init for update | 0.03 ms |
Updating | 0.03 ms |
End of update loop | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.953 MB Zeilen zurückgegeben: 2
SELECT *
FROM jsmwh_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.43 ms Nach letzter Abfrage: 3.14 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.039 MB Zeilen zurückgegeben: 1
SELECT *
FROM jsmwh_zoo_item
WHERE id = 380
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_item | const | PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
11 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:399 |
10 | AppTable->_queryObject() | JROOT/administrator/components/com_zoo/framework/classes/table.php:189 |
9 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:136 |
8 | AppTable->get() | JROOT/administrator/components/com_zoo/helpers/zoo.php:75 |
7 | ZooHelper->getApplication() | JROOT/components/com_zoo/zoo.php:32 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.076 MB Zeilen zurückgegeben: 1
SELECT *
FROM jsmwh_zoo_application
WHERE id = 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_application | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
13 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:399 |
12 | AppTable->_queryObject() | JROOT/administrator/components/com_zoo/framework/classes/table.php:189 |
11 | AppTable->find() | JROOT/administrator/components/com_zoo/tables/application.php:131 |
10 | ApplicationTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:136 |
9 | AppTable->get() | JROOT/administrator/components/com_zoo/classes/item.php:326 |
8 | Item->getApplication() | JROOT/administrator/components/com_zoo/helpers/zoo.php:76 |
7 | ZooHelper->getApplication() | JROOT/components/com_zoo/zoo.php:32 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.44 ms Nach letzter Abfrage: 2.51 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.211 MB Zeilen zurückgegeben: 8
SELECT *
FROM jsmwh_zoo_category
WHERE application_id = 3
AND published = 1
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_category | ALL | PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2 | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 17 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.07 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
18 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
17 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/framework/classes/table.php:192 |
16 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:165 |
15 | AppTable->all() | JROOT/administrator/components/com_zoo/tables/category.php:230 |
14 | CategoryTable->getAll() | JROOT/administrator/components/com_zoo/classes/application.php:425 |
13 | Application->getCategories() | JROOT/administrator/components/com_zoo/classes/application.php:449 |
12 | Application->getCategoryTree() | JROOT/administrator/components/com_zoo/helpers/route.php:295 |
11 | RouteHelper->item() | JROOT/components/com_zoo/controllers/default.php:131 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.53 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.248 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jsmwh_zoo_category_item AS a JOIN jsmwh_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=380
AND b.published = 1 UNION SELECT 0
FROM jsmwh_zoo_category_item AS a
WHERE a.item_id=380
AND a.category_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | a | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 2 | |
1 | PRIMARY | b | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | ttcolte_jo35.a.category_id | 1 | Using where |
2 | UNION | a | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | Using index |
NULL | UNION RESULT | <union1,2> | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Removing tmp table | 0.01 ms |
Sending data | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
15 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
14 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
13 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:565 |
12 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
11 | RouteHelper->item() | JROOT/components/com_zoo/controllers/default.php:131 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.46 ms Nach letzter Abfrage: 4.06 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 3.263 MB
UPDATE jsmwh_zoo_item
SET hits = (hits + 1)
WHERE id = 380
„EXPLAIN“ unmöglich für Abfrage: UPDATE jsmwh_zoo_item SET hits = (hits + 1) WHERE id = 380
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.04 ms |
Updating | 0.07 ms |
End of update loop | 0.00 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
13 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/tables/item.php:178 |
12 | ItemTable->hit() | JROOT/administrator/components/com_zoo/classes/item.php:674 |
11 | Item->hit() | JROOT/components/com_zoo/controllers/default.php:167 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.61 ms Nach letzter Abfrage: 1.99 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.476 MB Zeilen zurückgegeben: 6
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jsmwh_assets`
WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_assets | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 395 | Using where |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.20 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
23 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
22 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
21 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
20 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
19 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
14 | Item->canEdit() | JROOT/media/zoo/applications/blog/templates/sans/item.php:23 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.67 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 3.517 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `jsmwh_assets`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jsmwh_assets`
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.17 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
checking permissions | 0.04 ms |
closing tables | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.04 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
26 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
25 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
24 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 |
23 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 |
22 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
21 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
20 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
19 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
14 | Item->canEdit() | JROOT/media/zoo/applications/blog/templates/sans/item.php:23 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.543 MB Zeilen zurückgegeben: 0
SELECT *
FROM jsmwh_assets
WHERE `name` = 'com_zoo.application.3.article'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.00 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
24 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
23 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
22 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
21 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
20 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
19 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
14 | Item->canEdit() | JROOT/media/zoo/applications/blog/templates/sans/item.php:23 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.556 MB Zeilen zurückgegeben: 0
SELECT *
FROM jsmwh_assets
WHERE `name` = 'com_zoo.application.3.article'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
23 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
22 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
21 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
20 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
19 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
18 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
17 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
14 | Item->canEdit() | JROOT/media/zoo/applications/blog/templates/sans/item.php:23 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.53 ms Nach letzter Abfrage: 1.73 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.681 MB Zeilen zurückgegeben: 1
SELECT *
FROM jsmwh_zoo_item
WHERE id IN (118)
AND state = 1
AND access IN (1,5)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-05-30 21:48:30')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-05-30 21:48:30')
ORDER BY FIELD(id,118)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_item | const | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
23 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
22 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/framework/classes/table.php:192 |
21 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:165 |
20 | AppTable->all() | JROOT/media/zoo/elements/relateditems/relateditems.php:178 |
19 | ElementRelatedItems->_getRelatedItems() | JROOT/media/zoo/elements/relateditems/relateditems.php:28 |
18 | ElementRelatedItems->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php:36 |
16 | include JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
14 | ItemRenderer->render() | JROOT/media/zoo/applications/blog/templates/sans/item.php:36 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.723 MB Zeilen zurückgegeben: 1
SELECT *
FROM jsmwh_zoo_application
WHERE id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_application | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
27 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:399 |
26 | AppTable->_queryObject() | JROOT/administrator/components/com_zoo/framework/classes/table.php:189 |
25 | AppTable->find() | JROOT/administrator/components/com_zoo/tables/application.php:131 |
24 | ApplicationTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:136 |
23 | AppTable->get() | JROOT/administrator/components/com_zoo/classes/item.php:326 |
22 | Item->getApplication() | JROOT/administrator/components/com_zoo/classes/item.php:339 |
21 | Item->getType() | JROOT/media/zoo/elements/relateditems/relateditems.php:55 |
20 | ElementRelatedItems->render() | JROOT/components/com_zoo/renderer/element/comma.php:23 |
19 | include JROOT/components/com_zoo/renderer/element/comma.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
18 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:186 |
17 | ItemRenderer->renderPosition() | JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php:38 |
16 | include JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
14 | ItemRenderer->render() | JROOT/media/zoo/applications/blog/templates/sans/item.php:36 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.45 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.788 MB Zeilen zurückgegeben: 9
SELECT *
FROM jsmwh_zoo_category
WHERE application_id = 1
AND published = 1
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_category | ALL | PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2 | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 17 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
28 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
27 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/framework/classes/table.php:192 |
26 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:165 |
25 | AppTable->all() | JROOT/administrator/components/com_zoo/tables/category.php:230 |
24 | CategoryTable->getAll() | JROOT/administrator/components/com_zoo/classes/application.php:425 |
23 | Application->getCategories() | JROOT/administrator/components/com_zoo/classes/application.php:449 |
22 | Application->getCategoryTree() | JROOT/administrator/components/com_zoo/helpers/route.php:295 |
21 | RouteHelper->item() | JROOT/media/zoo/elements/relateditems/relateditems.php:64 |
20 | ElementRelatedItems->render() | JROOT/components/com_zoo/renderer/element/comma.php:23 |
19 | include JROOT/components/com_zoo/renderer/element/comma.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
18 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:186 |
17 | ItemRenderer->renderPosition() | JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php:38 |
16 | include JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
14 | ItemRenderer->render() | JROOT/media/zoo/applications/blog/templates/sans/item.php:36 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.43 ms Nach letzter Abfrage: 2.62 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 3.951 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jsmwh_fields AS a
LEFT JOIN `jsmwh_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jsmwh_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jsmwh_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jsmwh_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_zoo.element.textarea'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
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; Using temporary; filesort wurde genutzt |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | ttcolte_jo35.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.a.group_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.18 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.03 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
34 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
33 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
32 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
31 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
30 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
29 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
28 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
27 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
26 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
25 | JHtmlContent::prepare() | Derselbe Aufruf in der Zeile darunter. |
24 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
23 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
22 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_zoo/helpers/zoo.php:181 |
21 | ZooHelper->triggerContentPlugins() | JROOT/media/zoo/elements/textarea/textarea.php:146 |
20 | ElementTextarea->render() | JROOT/components/com_zoo/renderer/element/block.php:25 |
19 | include JROOT/components/com_zoo/renderer/element/block.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
18 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:186 |
17 | ItemRenderer->renderPosition() | JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php:64 |
16 | include JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
14 | ItemRenderer->render() | JROOT/media/zoo/applications/blog/templates/sans/item.php:36 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.952 MB Zeilen zurückgegeben: 0
SELECT name
FROM jsmwh_zoo_tag
WHERE item_id = 380
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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
22 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
21 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/tables/tag.php:93 |
20 | TagTable->getItemTags() | JROOT/administrator/components/com_zoo/classes/item.php:631 |
19 | Item->getTags() | JROOT/media/zoo/elements/itemtag/itemtag.php:40 |
18 | ElementItemTag->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php:76 |
16 | include JROOT/media/zoo/applications/blog/templates/sans/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
14 | ItemRenderer->render() | JROOT/media/zoo/applications/blog/templates/sans/item.php:36 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.65 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.031 MB Zeilen zurückgegeben: 1
SELECT *
FROM jsmwh_zoo_comment
WHERE item_id = 380
AND (state = 1 OR (author = ''
AND email = ''
AND user_id = ''
AND user_type = ''))
ORDER BY created DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jsmwh_zoo_comment | ref | STATE_INDEX,ITEMID_INDEX,AUTHOR_INDEX,ITEMID_STATE_INDEX | ITEMID_INDEX | 4 | const | 1 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.09 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
21 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
20 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/framework/classes/table.php:192 |
19 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:165 |
18 | AppTable->all() | JROOT/administrator/components/com_zoo/tables/comment.php:94 |
17 | CommentTable->getCommentsForItem() | JROOT/administrator/components/com_zoo/classes/item.php:685 |
16 | Item->getComments() | JROOT/administrator/components/com_zoo/classes/item.php:696 |
15 | Item->getCommentTree() | JROOT/administrator/components/com_zoo/helpers/comment.php:75 |
14 | CommentHelper->renderComments() | JROOT/media/zoo/applications/blog/templates/sans/item.php:37 |
13 | include JROOT/media/zoo/applications/blog/templates/sans/item.php | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 |
12 | Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 |
11 | Joomla\CMS\MVC\View\_JHtmlView->display() | JROOT/components/com_zoo/controllers/default.php:199 |
10 | DefaultController->item() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
9 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.94 ms Nach letzter Abfrage: 6.30 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.223 MB Zeilen zurückgegeben: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jsmwh_modules AS m
LEFT JOIN jsmwh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jsmwh_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 <= '2023-05-30 21:48:30')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 21:48:30')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 106 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 31 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | ttcolte_jo35.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | ttcolte_jo35.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.22 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | Derselbe Aufruf in der Zeile darunter. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441 |
16 | Joomla\CMS\Helper\_ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371 |
15 | Joomla\CMS\Helper\_ModuleHelper::load() | JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87 |
14 | Joomla\CMS\Helper\_ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:653 |
12 | T3Template->countModules() | JROOT/templates/purity_iii/tpls/blocks/header.php:123 |
11 | include JROOT/templates/purity_iii/tpls/blocks/header.php | JROOT/plugins/system/t3/includes/core/template.php:200 |
10 | T3Template->loadBlock() | JROOT/templates/purity_iii/tpls/corporate.php:38 |
9 | include JROOT/templates/purity_iii/tpls/corporate.php | JROOT/plugins/system/t3/includes/core/template.php:226 |
8 | T3Template->loadLayout() | JROOT/templates/purity_iii/index.php:35 |
7 | require JROOT/templates/purity_iii/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT *
FROM jsmwh_zoo_item
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`
2 × SELECT *
FROM jsmwh_assets
2 × SELECT *
FROM jsmwh_zoo_category
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jsmwh_assets`
2 × SELECT *
FROM jsmwh_zoo_application
1 × SELECT `data`
FROM `jsmwh_session`
1 × SELECT *
FROM jsmwh_zoo_comment
1 × SELECT name
FROM jsmwh_zoo_tag
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jsmwh_fields AS a
LEFT JOIN `jsmwh_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jsmwh_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jsmwh_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jsmwh_fields_groups AS g
ON g.id = a.group_id
1 × SELECT b.id
FROM jsmwh_zoo_category_item AS a JOIN jsmwh_zoo_category AS b
ON a.category_id = b.id
1 × SELECT *
FROM jsmwh_languages
1 × SELECT `session_id`
FROM `jsmwh_session`
1 × SELECT id, home, template, s.params
FROM jsmwh_template_styles as s
LEFT JOIN jsmwh_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT id
FROM jsmwh_zoo_item
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jsmwh_menu AS m
LEFT JOIN jsmwh_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jsmwh_extensions
1 × SELECT b.id
FROM jsmwh_usergroups AS a
LEFT JOIN jsmwh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jsmwh_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jsmwh_modules AS m
LEFT JOIN jsmwh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jsmwh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Kommentare (1)
Willi Häusler
1. Wir sind keine Profi- sondern Genussraucher!
2. Das T-Shirt wurde am Top 16 bei den
Herrenleibchen gekauft..Modell Samsunov.
Wenn ich die Leibchen des Verfassers
anschaue..ohne Worte!!
3. Es wird spekuliert, ob der angehende
Zahnarzt nur soviele Turnier spielt und
Preise holt, damit er sie einschmelzen kann
um für zukünftige Kunden sie als
Zahnfüllung zu benutzen!!
4. Dominik Zeltner hat keine Goldmedaille
geholt, nur Ehrenplätze, also ewiger
Zweiter!!
antworten