Abfragezeit: 0.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.170 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `kasjos_session`
WHERE `session_id` = X'6236323965313164323337393636316539323739313466656564393437306233'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 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 |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.12 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.265 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `kasjos_session`
WHERE `session_id` = X'6236323965313164323337393636316539323739313466656564393437306233'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.00 ms |
Statistics | 0.01 ms |
Preparing | 0.00 ms |
Executing | 0.00 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.22 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.270 MB
INSERT INTO `kasjos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6236323965313164323337393636316539323739313466656564393437306233', 1, 1729848374, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `kasjos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6236323965313164323337393636316539323739313466656564393437306233', 1, 1729848374, 0, '', 0)
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init for update | 0.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.00 ms |
Writing to binlog | 0.01 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.41 ms Nach letzter Abfrage: 1.49 ms Abfragespeichernutzung: 0.056 MB Speichernutzung vor Abfrage: 4.459 MB Zeilen zurückgegeben: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kasjos_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 | kasjos_extensions | ref | extension | extension | 82 | const | 34 | 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.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.17 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.00 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.16 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.748 MB Zeilen zurückgegeben: 8
SELECT id, rules
FROM `kasjos_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 8 | |
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.00 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 |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.21 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.762 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM kasjos_usergroups AS a
LEFT JOIN kasjos_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 |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 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.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.62 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 4.830 MB Zeilen zurückgegeben: 113
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kasjos_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 | kasjos_extensions | ALL | extension | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 279 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.01 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.35 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.37 ms Nach letzter Abfrage: 19.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.666 MB Zeilen zurückgegeben: 1
SELECT *
FROM `kasjos_nextend2_section_storage`
WHERE `application` = 'smartslider'
AND `section` = 'settings'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_nextend2_section_storage | ref | application,application_2 | application_2 | 284 | const,const | 1 | Using index condition; 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.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
12 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
11 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
10 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17 |
9 | Nextend\SmartSlider3\Settings::getAll() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25 |
8 | Nextend\SmartSlider3\Settings::get() | JROOT/plugins/system/smartslider3/smartslider3.php:16 |
7 | require_once JROOT/plugins/system/smartslider3/smartslider3.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.95 ms Nach letzter Abfrage: 10.58 ms Abfragespeichernutzung: 0.143 MB Speichernutzung vor Abfrage: 9.757 MB Zeilen zurückgegeben: 70
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 kasjos_menu AS m
LEFT JOIN kasjos_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,published,parent_id | idx_client_id_parent_id_alias_language | 1 | const | 76 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | d018783a.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.07 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.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.56 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 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 |
---|
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.41 ms Nach letzter Abfrage: 10.65 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.561 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kasjos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.05 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.02 ms |
Statistics | 0.11 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.29 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 11.552 MB
UPDATE `kasjos_extensions`
SET `params` = '{\"mediaversion\":\"fa98cbb359d5f831ae75e43c4ecde44d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `kasjos_extensions`
SET `params` = '{\"mediaversion\":\"fa98cbb359d5f831ae75e43c4ecde44d\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init for update | 0.09 ms |
Updating | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Writing to binlog | 0.02 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.26 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 11.770 MB Zeilen zurückgegeben: 2
SELECT *
FROM kasjos_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
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.32 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 11.783 MB Zeilen zurückgegeben: 1
SELECT id, home, template, s.params
FROM kasjos_template_styles as s
LEFT JOIN kasjos_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 | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | d018783a.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.05 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 23.94 ms Nach letzter Abfrage: 192.34 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.980 MB Zeilen zurückgegeben: 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM kasjos_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | Using where; filesort wurde genutzt |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 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 | 23.71 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 |
11 | PhocaGalleryRenderFront::renderAllCSS() | JROOT/components/com_phocagallery/views/categories/view.html.php:42 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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: 69.60 ms Nach letzter Abfrage: 84.64 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 13.465 MB Zeilen zurückgegeben: 11
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM kasjos_phocagallery_categories AS cc
LEFT JOIN kasjos_phocagallery AS a
ON a.catid = cc.id
and a.published = 1
LEFT JOIN kasjos_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN kasjos_users AS u
ON u.id = cc.owner_id
LEFT JOIN kasjos_phocagallery_votes_statistics AS r
ON r.catid = cc.id
WHERE cc.published = 1
AND cc.approved = 1
GROUP BY cc.id, cc.parent_id, cc.owner_id, cc.image_id, cc.title, cc.name, cc.alias, cc.image, cc.section, cc.image_position, cc.description, cc.date, cc.published, cc.approved, cc.checked_out, cc.checked_out_time, cc.editor, cc.ordering, cc.access, cc.count, cc.hits, cc.accessuserid, cc.deleteuserid, cc.uploaduserid, cc.userfolder, cc.latitude, cc.longitude, cc.zoom, cc.geotitle, cc.extid, cc.exta, cc.extu, cc.extauth, cc.extfbuid, cc.extfbcatid, cc.params, cc.metakey, cc.metadesc, cc.metadata, cc.language, a.catid, u.username, r.count, r.average, uc.avatar, uc.approved, uc.published
ORDER BY cc.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | uc | system | userid | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found; Using temporary; filesort wurde genutzt |
1 | SIMPLE | r | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found |
1 | SIMPLE | cc | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 11 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | d018783a.cc.owner_id | 1 | |
1 | SIMPLE | a | ref | catid | catid | 5 | d018783a.cc.id,const | 31 | |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.10 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 68.87 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.08 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocagallery/models/categories.php:49 |
12 | PhocagalleryModelCategories->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_phocagallery/views/categories/view.html.php:209 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.31 ms Nach letzter Abfrage: 229.02 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.205 MB Zeilen zurückgegeben: 0
SELECT id, title, module, position, content, showtitle, params
FROM kasjos_modules AS m
WHERE m.published = 1
AND m.id = 237
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-25 09:26:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-25 09:26:14')
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY position, ordering
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.07 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.00 ms |
Executing | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 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 |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/helix3/core/classes/menu.php:552 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:355 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:204 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:192 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:135 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:841 |
11 | Helix3::loadMegaMenu() | JROOT/templates/flex/features/menu.php:36 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:205 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:248 |
8 | Helix3::generatelayout() | JROOT/templates/flex/index.php:226 |
7 | require JROOT/templates/flex/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.97 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.049 MB Speichernutzung vor Abfrage: 16.377 MB Zeilen zurückgegeben: 45
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kasjos_modules AS m
LEFT JOIN kasjos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kasjos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-25 09:26:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-25 09:26:14')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 213 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 | 9 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | d018783a.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | d018783a.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.66 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | 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/Helper/ModuleHelper.php:441 |
14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
12 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
11 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/helix3/core/helix3.php:515 |
10 | Helix3::countModules() | JROOT/plugins/system/helix3/core/helix3.php:462 |
9 | Helix3::rowColumns() | JROOT/plugins/system/helix3/core/helix3.php:270 |
8 | Helix3::generatelayout() | JROOT/templates/flex/index.php:226 |
7 | require JROOT/templates/flex/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.26 ms Nach letzter Abfrage: 6.19 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 16.427 MB Zeilen zurückgegeben: 1
SELECT params
FROM kasjos_extensions
WHERE `type` = 'plugin'
AND `element` = 'jlsitemap_cron'
AND `folder` = 'system'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 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 |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:197 |
8 | PlgSystemJLSitemap_Cron->checkCacheTime() | JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:52 |
7 | PlgSystemJLSitemap_Cron->onBeforeRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1102 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 12.60 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 16.953 MB Zeilen zurückgegeben: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kasjos_assets`
WHERE `name` IN ('root.1','com_actionlogs','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_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jlsitemap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 45 | Using index condition |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.26 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
16 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:442 |
15 | ContentModelArticles->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:123 |
11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.074 MB Speichernutzung vor Abfrage: 17.037 MB Zeilen zurückgegeben: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM kasjos_content AS a
LEFT JOIN kasjos_categories AS c
ON c.id = a.catid
LEFT JOIN kasjos_users AS ua
ON ua.id = a.created_by
LEFT JOIN kasjos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kasjos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kasjos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (52,39,13,12,51,23,9,41,37)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-25 09:26:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-25 09:26:14')
ORDER BY a.publish_up DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | v | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 0 | Const row not found |
1 | SIMPLE | a | range | idx_access,idx_state,idx_catid,publish_up | publish_up | 5 | NULL | 388 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,idx_access,published | PRIMARY | 4 | d018783a.a.catid | 1 | Using index condition; Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | d018783a.a.created_by | 1 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | d018783a.a.modified_by | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | d018783a.c.parent_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.07 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.12 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 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 |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:123 |
11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.37 ms Nach letzter Abfrage: 1.04 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 17.241 MB Zeilen zurückgegeben: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `kasjos_categories` AS `s`
INNER JOIN `kasjos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 52
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range|filter | cat_idx,idx_access,idx_left_right,published | idx_left_right|cat_idx | 4|207 | NULL | 3 (50%) | Using index condition; Using where; Using rowid filter |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.09 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.05 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Derselbe Aufruf in der Zeile darunter. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_latest/helper.php:135 |
11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.21 ms Nach letzter Abfrage: 6.15 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.584 MB Zeilen zurückgegeben: 1
SELECT `alias`
FROM `kasjos_content`
WHERE id = '18'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | kasjos_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 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 |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
17 | ContentRouter->getArticleSegment() | Derselbe Aufruf in der Zeile darunter. |
16 | call_user_func_array() | JROOT/libraries/src/Component/Router/Rules/NomenuRules.php:124 |
15 | Joomla\CMS\Component\Router\Rules\NomenuRules->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
14 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kasjos_extensions`
1 × SELECT `data`
FROM `kasjos_session`
1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM kasjos_phocagallery_categories AS cc
LEFT JOIN kasjos_phocagallery AS a
ON a.catid = cc.id
and a.published = 1
LEFT JOIN kasjos_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN kasjos_users AS u
ON u.id = cc.owner_id
LEFT JOIN kasjos_phocagallery_votes_statistics AS r
ON r.catid = cc.id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `kasjos_categories` AS `s`
INNER JOIN `kasjos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM kasjos_content AS a
LEFT JOIN kasjos_categories AS c
ON c.id = a.catid
LEFT JOIN kasjos_users AS ua
ON ua.id = a.created_by
LEFT JOIN kasjos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kasjos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kasjos_content_rating AS v
ON a.id = v.content_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kasjos_assets`
1 × SELECT params
FROM kasjos_extensions
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kasjos_modules AS m
LEFT JOIN kasjos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kasjos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, title, module, position, content, showtitle, params
FROM kasjos_modules AS m
1 × SELECT id, home, template, s.params
FROM kasjos_template_styles as s
LEFT JOIN kasjos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM kasjos_phocagallery_styles AS a
1 × SELECT `session_id`
FROM `kasjos_session`
1 × SELECT *
FROM kasjos_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM kasjos_menu AS m
LEFT JOIN kasjos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM `kasjos_nextend2_section_storage`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kasjos_extensions
1 × SELECT b.id
FROM kasjos_usergroups AS a
LEFT JOIN kasjos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `kasjos_viewlevels
1 × SELECT `alias`
FROM `kasjos_content`