Abfragezeit: 0.18 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.427 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `ssvh_session`
WHERE `session_id` = '5ecc3ab7ac847660358762b80a2c27b4'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
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:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.653 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `ssvh_session`
WHERE `session_id` = '5ecc3ab7ac847660358762b80a2c27b4'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.659 MB
INSERT INTO `ssvh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('5ecc3ab7ac847660358762b80a2c27b4', 1, 1660372364, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `ssvh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('5ecc3ab7ac847660358762b80a2c27b4', 1, 1660372364, 0, '', 0)
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
update | 0.06 ms |
end | 0.00 ms |
query end | 0.12 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.189 MB Zeilen zurückgegeben: 6
SELECT id, rules
FROM `ssvh_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.201 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM ssvh_usergroups AS a
LEFT JOIN ssvh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 4.43 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 6.390 MB Zeilen zurückgegeben: 1
SELECT `enabled`
FROM `ssvh_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.13 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:36 |
7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 14.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.597 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM ssvh_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.16 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/sunfw/includes/utils.php:81 |
12 | SunFwUtils::checkSH404SEF() | JROOT/plugins/system/sunfw/includes/overwrite/overwrite.php:84 |
11 | SunFwOverwrite::initialize() | JROOT/plugins/system/sunfw/includes/site.php:114 |
10 | SunFwSite->__construct() | JROOT/plugins/system/sunfw/includes/site.php:234 |
9 | SunFwSite::getInstance() | JROOT/plugins/system/sunfw/sunfw.php:383 |
8 | PlgSystemSunFw->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:1122 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 9.820 MB
UPDATE `ssvh_extensions`
SET `params` = '{\"mediaversion\":\"7a9085f8fceea86b4d5af5cb988637f2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | ssvh_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.15 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/sunfw/includes/site.php:120 |
10 | SunFwSite->__construct() | JROOT/plugins/system/sunfw/includes/site.php:234 |
9 | SunFwSite::getInstance() | JROOT/plugins/system/sunfw/sunfw.php:383 |
8 | PlgSystemSunFw->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:1122 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.069 MB Speichernutzung vor Abfrage: 10.057 MB Zeilen zurückgegeben: 1
SELECT ss.*
FROM ssvh_sunfw_styles AS ss
INNER JOIN ssvh_template_styles AS ts
ON ts.id = ss.style_id
WHERE ts.id = 14
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ss | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | ts | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
12 | JDatabaseDriver->loadObject() | JROOT/plugins/system/sunfw/includes/helper.php:253 |
11 | SunFwHelper::getSunFwStyle() | JROOT/plugins/system/sunfw/includes/site.php:133 |
10 | SunFwSite->__construct() | JROOT/plugins/system/sunfw/includes/site.php:234 |
9 | SunFwSite::getInstance() | JROOT/plugins/system/sunfw/sunfw.php:383 |
8 | PlgSystemSunFw->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:1122 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 19.34 ms Nach letzter Abfrage: 7.83 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 16.262 MB Zeilen zurückgegeben: 1
SELECT *
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 19.06 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
9 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/helpers/helper.php:39 |
8 | JemHelper::config() | JROOT/components/com_jem/helpers/helper.php:111 |
7 | JemHelper::cleanup() | JROOT/components/com_jem/jem.php:31 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 1.69 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.330 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
11 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
10 | JemHelper::globalattribs() | JROOT/components/com_jem/views/category/view.html.php:134 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 2.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.385 MB Zeilen zurückgegeben: 1
SELECT css
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:93 |
11 | JemHelper::retrieveCss() | JROOT/components/com_jem/helpers/helper.php:1107 |
10 | JemHelper::loadCss() | JROOT/components/com_jem/views/category/view.html.php:149 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.393 MB Zeilen zurückgegeben: 1
SELECT css
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:93 |
11 | JemHelper::retrieveCss() | JROOT/components/com_jem/helpers/helper.php:1191 |
10 | JemHelper::loadCustomCss() | JROOT/components/com_jem/views/category/view.html.php:150 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.404 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
17 | JemHelper::globalattribs() | JROOT/components/com_jem/models/eventslist.php:216 |
16 | JemModelEventslist->getListQuery() | JROOT/components/com_jem/models/category.php:261 |
15 | JemModelCategory->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:457 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.425 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
19 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
18 | JemHelper::globalattribs() | JROOT/components/com_jem/models/eventslist.php:541 |
17 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:370 |
16 | JemModelEventslist->getListQuery() | JROOT/components/com_jem/models/category.php:261 |
15 | JemModelCategory->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:457 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 62.63 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 16.441 MB Zeilen zurückgegeben: 25
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM ssvh_jem_categories as c
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN ssvh_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1))
AND c.id = 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
1 | SIMPLE | rel | NULL | ref | category event relation,catid | category event relation | 4 | const | 24 | 100.00 | Using index |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 90716m70415_1.rel.itemid | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 62.25 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
18 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/models/eventslist.php:661 |
17 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:370 |
16 | JemModelEventslist->getListQuery() | JROOT/components/com_jem/models/category.php:261 |
15 | JemModelCategory->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:457 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 13.38 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 16.441 MB Zeilen zurückgegeben: 1
SELECT a.access,a.alias,a.attribs,a.author_ip,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,l.alias AS l_alias,l.author_ip AS l_authorip,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM ssvh_jem_events as a
LEFT JOIN ssvh_jem_venues AS l
ON l.id = a.locid
LEFT JOIN ssvh_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN ssvh_jem_categories AS c
ON c.id = rel.catid
WHERE a.access IN (1,1)
AND a.published = 1
AND a.dates IS NOT NULL
AND c.id IN (3)
ORDER BY a.dates ASC,a.times ASC
LIMIT 10
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; filesort wurde genutzt |
1 | SIMPLE | a | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 32 | 3.12 | Using where |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 90716m70415_1.a.locid | 1 | 100.00 | NULL |
1 | SIMPLE | rel | NULL | eq_ref | category event relation,catid,itemid | category event relation | 8 | const,90716m70415_1.a.id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | ct | NULL | ref | iso2 | iso2 | 8 | 90716m70415_1.l.country | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 12.72 ms |
init | 0.10 ms |
System lock | 0.01 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.05 ms |
Creating sort index | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:457 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.466 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
14 | JemHelper::globalattribs() | JROOT/components/com_jem/models/eventslist.php:541 |
13 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:506 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.481 MB Zeilen zurückgegeben: 1
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM ssvh_jem_categories as c
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN ssvh_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =28
AND c.published = 1
AND (c.access IN (1,1))
AND c.id = 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | rel | NULL | const | category event relation,catid,itemid | category event relation | 8 | const,const | 1 | 100.00 | Using index |
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/eventslist.php:665 |
13 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:506 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 5.52 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.480 MB Zeilen zurückgegeben: 0
SELECT COUNT(id) as total, SUM(waiting) as waitinglist, event
FROM ssvh_jem_register
WHERE event IN (28)
GROUP BY event
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 5.40 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/helpers/helper.php:790 |
13 | JemHelper::getAttendeesNumbers() | JROOT/components/com_jem/models/eventslist.php:515 |
12 | JemModelEventslist->getItems() | JROOT/components/com_jem/models/category.php:181 |
11 | JemModelCategory->getItems() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:161 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 12.82 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.489 MB Zeilen zurückgegeben: 0
SELECT gr.id
FROM ssvh_jem_groups AS gr
LEFT JOIN ssvh_jem_groupmembers AS g
ON g.group_id = gr.id
WHERE g.member = 0
AND g.member NOT LIKE 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 12.69 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
14 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/classes/categories.class.php:174 |
13 | JEMCategories->_load() | JROOT/components/com_jem/classes/categories.class.php:113 |
12 | JEMCategories->get() | JROOT/components/com_jem/models/category.php:216 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.33 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.499 MB Zeilen zurückgegeben: 2
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.id) AS numitems
FROM ssvh_jem_categories as c
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN ssvh_jem_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ssvh_jem_categories AS cat JOIN ssvh_jem_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN ssvh_jem_events AS i
ON rel.itemid = i.id
AND i.published IN (1)
WHERE c.published = 1
AND (c.access IN (1,1))
AND s.id=3
AND badcats.id is null
GROUP BY c.id
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | s | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
1 | PRIMARY | c | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where |
1 | PRIMARY | rel | NULL | ref | category event relation,catid | category event relation | 4 | 90716m70415_1.c.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | 90716m70415_1.c.id | 2 | 100.00 | Using where; Not exists; Using index |
1 | PRIMARY | i | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 90716m70415_1.rel.itemid | 1 | 100.00 | Using where |
2 | DERIVED | parent | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 80.00 | Using where; Using temporary; filesort wurde genutzt |
2 | DERIVED | cat | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.13 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.01 ms |
Sorting result | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.61 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/classes/categories.class.php:249 |
13 | JEMCategories->_load() | JROOT/components/com_jem/classes/categories.class.php:113 |
12 | JEMCategories->get() | JROOT/components/com_jem/models/category.php:216 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 16.516 MB Zeilen zurückgegeben: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ssvh_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aimysitemap','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_djimageslider','com_fields','com_finder','com_installer','com_jce','com_jem','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nova','com_phocadownload','com_phocagallery','com_phocaguestbook','com_pjinstaller','com_pjmvi','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_assets | NULL | ALL | idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 182 | 26.37 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jem/models/category.php:225 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.577 MB Zeilen zurückgegeben: 2
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ssvh_assets`
WHERE `name` LIKE 'com_jem.%' OR `name` = 'com_jem' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_assets | NULL | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 182 | 22.64 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jem/models/category.php:225 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 16.609 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `ssvh_assets`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `ssvh_assets`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.02 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 |
16 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 |
15 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jem/models/category.php:225 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.633 MB Zeilen zurückgegeben: 0
SELECT *
FROM ssvh_assets
WHERE `name` = 'com_jem.category.3'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
17 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
16 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
15 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jem/models/category.php:225 |
11 | JemModelCategory->getCategory() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:162 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.657 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM ssvh_jem_events as a
LEFT JOIN ssvh_jem_venues AS l
ON l.id = a.locid
LEFT JOIN ssvh_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN ssvh_jem_categories AS c
ON c.id = rel.catid
WHERE a.access IN (1,1)
AND a.published = 1
AND a.dates IS NOT NULL
AND c.id IN (3)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | a | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 32 | 3.12 | Using where |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 90716m70415_1.a.locid | 1 | 100.00 | NULL |
1 | SIMPLE | rel | NULL | eq_ref | category event relation,catid,itemid | category event relation | 8 | const,90716m70415_1.a.id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | ct | NULL | ref | iso2 | iso2 | 8 | 90716m70415_1.l.country | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
12 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
11 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421 |
10 | JViewLegacy->get() | JROOT/components/com_jem/views/category/view.html.php:165 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.665 MB Zeilen zurückgegeben: 1
SELECT parent_id
FROM ssvh_jem_categories
WHERE id = 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/classes/categories.class.php:486 |
11 | JEMCategories::buildParentCats() | JROOT/components/com_jem/classes/categories.class.php:558 |
10 | JEMCategories->getParentlist() | JROOT/components/com_jem/views/category/view.html.php:233 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.673 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
11 | JemHelper::globalattribs() | JROOT/components/com_jem/helpers/route.php:74 |
10 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/category/view.html.php:261 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.687 MB Zeilen zurückgegeben: 1
SELECT id, parent_id, catname,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM ssvh_jem_categories
WHERE id = 3
AND published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/classes/categories.class.php:453 |
11 | JEMCategories->getPath() | JROOT/components/com_jem/helpers/route.php:89 |
10 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/category/view.html.php:261 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.694 MB Zeilen zurückgegeben: 1
SELECT id, parent_id, catname,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM ssvh_jem_categories
WHERE id = 1
AND published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/classes/categories.class.php:453 |
11 | JEMCategories->getPath() | JROOT/components/com_jem/helpers/route.php:89 |
10 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/category/view.html.php:261 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 16.692 MB Zeilen zurückgegeben: 0
SELECT gr.id
FROM ssvh_jem_groups AS gr
LEFT JOIN ssvh_jem_groupmembers AS g
ON g.group_id = gr.id
WHERE g.member = 0
AND `gr`.`addevent` = 1
AND g.member NOT LIKE 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
11 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/classes/user.class.php:130 |
10 | JEMUser::ismaintainer() | JROOT/components/com_jem/views/category/view.html.php:281 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.730 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
14 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:115 |
13 | JEMOutput::archivebutton() | JROOT/components/com_jem/views/category/tmpl/default.php:17 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.739 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
14 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:336 |
13 | JEMOutput::mailbutton() | JROOT/components/com_jem/views/category/tmpl/default.php:18 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.755 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
14 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:290 |
13 | JEMOutput::printbutton() | JROOT/components/com_jem/views/category/tmpl/default.php:19 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.783 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
17 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:846 |
16 | JEMOutput::formatDateTime() | JROOT/components/com_jem/classes/output.class.php:976 |
15 | JEMOutput::formatShortDateTime() | JROOT/components/com_jem/common/views/tmpl/default_events_table.php:126 |
14 | include JROOT/components/com_jem/common/views/tmpl/default_events_table.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
13 | JViewLegacy->loadTemplate() | JROOT/components/com_jem/views/category/tmpl/default.php:82 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.793 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
17 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
16 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:981 |
15 | JEMOutput::formatSchemaOrgDateTime() | JROOT/components/com_jem/common/views/tmpl/default_events_table.php:128 |
14 | include JROOT/components/com_jem/common/views/tmpl/default_events_table.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
13 | JViewLegacy->loadTemplate() | JROOT/components/com_jem/views/category/tmpl/default.php:82 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.802 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
17 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
16 | JemHelper::globalattribs() | JROOT/components/com_jem/helpers/route.php:111 |
15 | JEMHelperRoute::getEventRoute() | JROOT/components/com_jem/common/views/tmpl/default_events_table.php:134 |
14 | include JROOT/components/com_jem/common/views/tmpl/default_events_table.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
13 | JViewLegacy->loadTemplate() | JROOT/components/com_jem/views/category/tmpl/default.php:82 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.812 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
17 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
16 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:691 |
15 | JEMOutput::recurrenceicon() | JROOT/components/com_jem/common/views/tmpl/default_events_table.php:135 |
14 | include JROOT/components/com_jem/common/views/tmpl/default_events_table.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
13 | JViewLegacy->loadTemplate() | JROOT/components/com_jem/views/category/tmpl/default.php:82 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.807 MB Zeilen zurückgegeben: 1
SELECT globalattribs
FROM ssvh_jem_settings
WHERE id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_jem_settings | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/helpers/helper.php:67 |
14 | JemHelper::globalattribs() | JROOT/components/com_jem/classes/output.class.php:378 |
13 | JEMOutput::icalbutton() | JROOT/components/com_jem/views/category/tmpl/default.php:98 |
12 | include JROOT/components/com_jem/views/category/tmpl/default.php | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693 |
11 | JViewLegacy->loadTemplate() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226 |
10 | JViewLegacy->display() | JROOT/components/com_jem/views/category/view.html.php:330 |
9 | JemViewCategory->display() | JROOT/components/com_jem/controller.php:101 |
8 | JEMController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:41 |
6 | require_once JROOT/components/com_jem/jem.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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.793 MB Zeilen zurückgegeben: 1
SELECT params
FROM ssvh_extensions AS e
WHERE e.element='com_widgetkit'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_widgetkit/helpers/system.php:278 |
13 | SystemWidgetkitHelper->_getParams() | JROOT/administrator/components/com_widgetkit/helpers/system.php:54 |
12 | SystemWidgetkitHelper->__construct() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 |
11 | Widgetkit->loadHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 |
10 | Widgetkit->getHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 |
9 | Widgetkit->offsetGet() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 16.801 MB Zeilen zurückgegeben: 1
SELECT id,template
FROM ssvh_template_styles
WHERE client_id=0
AND home=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_template_styles | NULL | ALL | idx_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 8 | 12.50 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 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 | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
10 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/helpers/system.php:78 |
9 | SystemWidgetkitHelper->init() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 6.94 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.711 MB Zeilen zurückgegeben: 1
SELECT params
FROM ssvh_extensions
WHERE type = 'template'
AND element = 'jsn_escape2_pro'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
14 | JDatabaseDriver->loadResult() | JROOT/plugins/system/sunfw/includes/helper.php:1407 |
13 | SunFwHelper::getTemplateParams() | JROOT/plugins/system/sunfw/includes/site/helper.php:525 |
12 | SunFwSiteHelper->_autoLoadCustomCssFile() | JROOT/plugins/system/sunfw/includes/site/helper.php:455 |
11 | SunFwSiteHelper->_prepareHead() | JROOT/plugins/system/sunfw/includes/site/helper.php:240 |
10 | SunFwSiteHelper->_prepare() | JROOT/plugins/system/sunfw/includes/site/helper.php:105 |
9 | SunFwSiteHelper::prepare() | JROOT/plugins/system/sunfw/includes/site.php:263 |
8 | SunFwSite->render() | JROOT/templates/jsn_escape2_pro/index.php:20 |
7 | require JROOT/templates/jsn_escape2_pro/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.719 MB Zeilen zurückgegeben: 1
SELECT manifest_cache
FROM ssvh_extensions
WHERE type = 'template'
AND element = 'jsn_escape2_pro'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
12 | JDatabaseDriver->loadResult() | JROOT/plugins/system/sunfw/includes/helper.php:77 |
11 | SunFwHelper::getManifestCache() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:29 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:459 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:274 |
8 | SunFwSite->render() | JROOT/templates/jsn_escape2_pro/index.php:20 |
7 | require JROOT/templates/jsn_escape2_pro/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.26 ms Nach letzter Abfrage: 3.20 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 19.948 MB Zeilen zurückgegeben: 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access
FROM ssvh_modules AS m
LEFT JOIN ssvh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ssvh_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 <= '2022-08-13 06:32:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-13 06:32:45')
AND m.id=296
AND m.client_id= 0
AND m.access IN (1, 1)
AND (mm.menuid = 213 OR mm.menuid <= 0)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
24 | JDatabaseDriver->loadObject() | JROOT/plugins/system/sunfw/includes/module.php:62 |
23 | SunFwModule::render() | JROOT/plugins/system/sunfw/includes/site/components/items/joomla-module.php:49 |
22 | include JROOT/plugins/system/sunfw/includes/site/components/items/joomla-module.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
21 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:554 |
20 | SunFwSite::renderItem() | JROOT/plugins/system/sunfw/includes/site/components/column.php:25 |
19 | include JROOT/plugins/system/sunfw/includes/site/components/column.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
18 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:539 |
17 | SunFwSite::renderColumn() | JROOT/plugins/system/sunfw/includes/site/components/row.php:36 |
16 | include JROOT/plugins/system/sunfw/includes/site/components/row.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
15 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:527 |
14 | SunFwSite::renderRow() | JROOT/plugins/system/sunfw/includes/site/components/section.php:26 |
13 | include JROOT/plugins/system/sunfw/includes/site/components/section.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
12 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:515 |
11 | SunFwSite::renderSection() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:193 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:459 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:274 |
8 | SunFwSite->render() | JROOT/templates/jsn_escape2_pro/index.php:20 |
7 | require JROOT/templates/jsn_escape2_pro/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 19.953 MB Zeilen zurückgegeben: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ssvh_modules AS m
LEFT JOIN ssvh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ssvh_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 <= '2022-08-13 06:32:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-13 06:32:45')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 213 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | PRIMARY,published,newsfeeds | published | 1 | const | 39 | 0.85 | Using index condition; Using where; filesort wurde genutzt |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | 90716m70415_1.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | 90716m70415_1.m.id | 2 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.42 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
26 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:495 |
25 | JModuleHelper::getModuleList() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:434 |
24 | JModuleHelper::load() | JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:88 |
23 | JModuleHelper::getModules() | JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php:37 |
22 | include JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
21 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:554 |
20 | SunFwSite::renderItem() | JROOT/plugins/system/sunfw/includes/site/components/column.php:25 |
19 | include JROOT/plugins/system/sunfw/includes/site/components/column.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
18 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:539 |
17 | SunFwSite::renderColumn() | JROOT/plugins/system/sunfw/includes/site/components/row.php:36 |
16 | include JROOT/plugins/system/sunfw/includes/site/components/row.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
15 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:527 |
14 | SunFwSite::renderRow() | JROOT/plugins/system/sunfw/includes/site/components/section.php:26 |
13 | include JROOT/plugins/system/sunfw/includes/site/components/section.php | JROOT/plugins/system/sunfw/includes/site.php:502 |
12 | SunFwSite->renderComponent() | JROOT/plugins/system/sunfw/includes/site.php:515 |
11 | SunFwSite::renderSection() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:193 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:459 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:274 |
8 | SunFwSite->render() | JROOT/templates/jsn_escape2_pro/index.php:20 |
7 | require JROOT/templates/jsn_escape2_pro/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.27 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.910 MB Zeilen zurückgegeben: 1
SELECT params
FROM ssvh_extensions
WHERE type = 'plugin'
AND element = 'sunfw'
AND folder = 'system'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ssvh_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 804 | const,const | 2 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/sunfw/includes/helper.php:1105 |
12 | SunFwHelper::getExtensionParams() | JROOT/plugins/system/sunfw/includes/site.php:621 |
11 | SunFwSite::renderBrandingLink() | JROOT/plugins/system/sunfw/includes/site/pages/index.php:264 |
10 | include JROOT/plugins/system/sunfw/includes/site/pages/index.php | JROOT/plugins/system/sunfw/includes/site.php:459 |
9 | SunFwSite->renderLayout() | JROOT/plugins/system/sunfw/includes/site.php:274 |
8 | SunFwSite->render() | JROOT/templates/jsn_escape2_pro/index.php:20 |
7 | require JROOT/templates/jsn_escape2_pro/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
13 × SELECT globalattribs
FROM ssvh_jem_settings
2 × SELECT gr.id
FROM ssvh_jem_groups AS gr
LEFT JOIN ssvh_jem_groupmembers AS g
ON g.group_id = gr.id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ssvh_assets`
2 × SELECT params
FROM ssvh_extensions
2 × SELECT id, parent_id, catname,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM ssvh_jem_categories
2 × SELECT css
FROM ssvh_jem_settings
2 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM ssvh_jem_categories as c
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN ssvh_jem_events AS a
ON a.id = rel.itemid
1 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access
FROM ssvh_modules AS m
LEFT JOIN ssvh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ssvh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT manifest_cache
FROM ssvh_extensions
1 × SELECT id,template
FROM ssvh_template_styles
1 × SELECT params
FROM ssvh_extensions AS e
1 × SELECT parent_id
FROM ssvh_jem_categories
1 × SELECT COUNT(*)
FROM ssvh_jem_events as a
LEFT JOIN ssvh_jem_venues AS l
ON l.id = a.locid
LEFT JOIN ssvh_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN ssvh_jem_categories AS c
ON c.id = rel.catid
1 × SELECT *
FROM ssvh_assets
1 × SELECT `data`
FROM `ssvh_session`
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.id) AS numitems
FROM ssvh_jem_categories as c
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN ssvh_jem_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ssvh_jem_categories AS cat JOIN ssvh_jem_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `session_id`
FROM `ssvh_session`
1 × SELECT COUNT(id) as total, SUM(waiting) as waitinglist, event
FROM ssvh_jem_register
1 × SELECT a.access,a.alias,a.attribs,a.author_ip,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,l.alias AS l_alias,l.author_ip AS l_authorip,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM ssvh_jem_events as a
LEFT JOIN ssvh_jem_venues AS l
ON l.id = a.locid
LEFT JOIN ssvh_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN ssvh_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN ssvh_jem_categories AS c
ON c.id = rel.catid
1 × SELECT *
FROM ssvh_jem_settings
1 × SELECT ss.*
FROM ssvh_sunfw_styles AS ss
INNER JOIN ssvh_template_styles AS ts
ON ts.id = ss.style_id
1 × SELECT COUNT(*)
FROM ssvh_extensions
1 × SELECT `enabled`
FROM `ssvh_extensions`
1 × SELECT b.id
FROM ssvh_usergroups AS a
LEFT JOIN ssvh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `ssvh_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ssvh_modules AS m
LEFT JOIN ssvh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ssvh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id