Abfragezeit: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.191 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jos331_session`
WHERE `session_id` = X'3766356239616535303162346238643535323064653963313234313161333537'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Der selbe Aufruf in der Zeile darunter. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.286 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jos331_session`
WHERE `session_id` = X'3766356239616535303162346238643535323064653963313234313161333537'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
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.02 ms |
executing | 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.291 MB
INSERT INTO `jos331_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3766356239616535303162346238643535323064653963313234313161333537', 1, 1734605949, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos331_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3766356239616535303162346238643535323064653963313234313161333537', 1, 1734605949, 0, '', 0)
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
update | 0.06 ms |
Waiting for query cache lock | 0.00 ms |
update | 0.00 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.24 ms Nach letzter Abfrage: 5.33 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.911 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jos331_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 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.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.01 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.923 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
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 | 2 | 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.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.49 ms Nach letzter Abfrage: 10.17 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.385 MB Zeilen zurückgegeben: 2
SHOW FULL COLUMNS
FROM `jos331_gsd_config`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_gsd_config`
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.01 ms |
System lock | 0.01 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.03 ms |
checking permissions | 0.01 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.03 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
11 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_gsd/tables/config.php:26 |
10 | GSDTableConfig->__construct() | JROOT/libraries/src/Table/Table.php:328 |
9 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_gsd/GSD/Helper.php:401 |
8 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:61 |
7 | plgSystemGSD->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.412 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_gsd_config
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_gsd_config | NULL | system | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
9 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_gsd/GSD/Helper.php:402 |
8 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:61 |
7 | plgSystemGSD->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.52 ms Nach letzter Abfrage: 55.60 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.384 MB
UPDATE `jos331_extensions`
SET `params` = '{\"mediaversion\":\"f6f6fe33c81c85ff2739501ccc8da379\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | jos331_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.10 ms |
updating | 0.08 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/seole/seole.php:159 |
8 | plgSystemSEOle->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 3.38 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.368 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos331_redirect_links`
WHERE (`old_url` = 'https://gsv-schwimmen.de/kalender/event/2093-2018-weihnachtskriterium-marburg' OR `old_url` = '/kalender/event/2093-2018-weihnachtskriterium-marburg' OR `old_url` = 'https://gsv-schwimmen.de/kalender/event/2093-2018-weihnachtskriterium-marburg' OR `old_url` = '/kalender/event/2093-2018-weihnachtskriterium-marburg')
AND published=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_redirect_links | NULL | ALL | idx_old_url | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/seole/class/seo.class.php:543 |
9 | redim_seo_class::check_redirects() | JROOT/plugins/system/seole/seole.php:171 |
8 | plgSystemSEOle->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 1.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.404 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '516'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 1 | 30.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:33 |
9 | plgSystemAutoArchive->kat2kat() | JROOT/plugins/system/autoarchive/autoarchive.php:22 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.409 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '521'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 1 | 30.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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:33 |
9 | plgSystemAutoArchive->kat2kat() | JROOT/plugins/system/autoarchive/autoarchive.php:22 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.415 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '518'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 1 | 30.00 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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.07 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:33 |
9 | plgSystemAutoArchive->kat2kat() | JROOT/plugins/system/autoarchive/autoarchive.php:22 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.420 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '523'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 1 | 30.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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:33 |
9 | plgSystemAutoArchive->kat2kat() | JROOT/plugins/system/autoarchive/autoarchive.php:22 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.426 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 2 | 30.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.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:23 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.431 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 2 | 30.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.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:24 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.437 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-12-19 10:59:09'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_catid | idx_catid | 4 | const | 2 | 30.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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:25 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.17 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.062 MB Speichernutzung vor Abfrage: 12.739 MB Zeilen zurückgegeben: 1
select version, dir_online, value
from `jos331_jvld_settings`
where id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jvld_settings | NULL | const | PRIMARY | PRIMARY | 2 | const | 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.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jvldframework/library/class.cfg.php:33 |
12 | JvldCfg->loadData() | JROOT/plugins/system/jvldframework/library/class.cfg.php:24 |
11 | JvldCfg->__construct() | JROOT/plugins/system/jvldframework/library/class.cfg.php:48 |
10 | JvldCfg::getInstance() | JROOT/plugins/system/jvldframework/jvldframework.php:101 |
9 | plgSystemJvldframework->initializeDirectory() | JROOT/plugins/system/jvldframework/jvldframework.php:47 |
8 | plgSystemJvldframework->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.802 MB Zeilen zurückgegeben: 1
select id
from jos331_menu
where link = 'index.php?option=com_jvld&view=jvld'
and published = 1
and client_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 68 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 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.14 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jvldframework/library/class.db.php:53 |
10 | JvldDb::getRow() | JROOT/plugins/system/jvldframework/jvldframework.php:106 |
9 | plgSystemJvldframework->initializeDirectory() | JROOT/plugins/system/jvldframework/jvldframework.php:47 |
8 | plgSystemJvldframework->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.809 MB Zeilen zurückgegeben: 1
select sparams
from `jos331_jvld_styles`
where stylename = 'default'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jvld_styles | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 33.33 | Using where |
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.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jvldframework/library/class.cfg.php:90 |
10 | JvldCfg->overrideWithStyleParams() | JROOT/plugins/system/jvldframework/jvldframework.php:123 |
9 | plgSystemJvldframework->initializeDirectory() | JROOT/plugins/system/jvldframework/jvldframework.php:47 |
8 | plgSystemJvldframework->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.32 ms Nach letzter Abfrage: 11.91 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.210 MB Zeilen zurückgegeben: 1
select email
from jos331_users
where id=706
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/bfstop/helpers/db.php:307 |
12 | BFStopDBHelper->getUserEmailWhere() | JROOT/plugins/system/bfstop/helpers/db.php:320 |
11 | BFStopDBHelper->getUserEmailByID() | JROOT/plugins/system/bfstop/helpers/notify.php:23 |
10 | BFStopNotifier->__construct() | JROOT/plugins/system/bfstop/bfstop.php:197 |
9 | plgSystembfstop->init() | JROOT/plugins/system/bfstop/bfstop.php:369 |
8 | plgSystembfstop->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.217 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE (ipaddress='13.59.85.151'
AND LOCATE('/', ipaddress) = 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 noticed after reading const tables |
Status | Duration |
---|
starting | 0.04 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.02 ms |
preparing | 0.01 ms |
executing | 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/bfstop/helpers/db.php:188 |
10 | BFStopDBHelper->checkForEntries() | JROOT/plugins/system/bfstop/helpers/db.php:224 |
9 | BFStopDBHelper->isIPOnAllowList() | JROOT/plugins/system/bfstop/bfstop.php:388 |
8 | plgSystembfstop->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.223 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('13.59.85.151') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
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 noticed after reading const tables |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/bfstop/helpers/db.php:188 |
10 | BFStopDBHelper->checkForEntries() | JROOT/plugins/system/bfstop/helpers/db.php:225 |
9 | BFStopDBHelper->isIPOnAllowList() | JROOT/plugins/system/bfstop/bfstop.php:388 |
8 | plgSystembfstop->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.230 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE (ipaddress='13.59.85.151'
AND LOCATE('/', ipaddress) = 0)
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-12-19 11:59:09')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | b | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 47 | 10.00 | Using where |
2 | DEPENDENT SUBQUERY | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.b.id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/bfstop/helpers/db.php:188 |
10 | BFStopDBHelper->checkForEntries() | JROOT/plugins/system/bfstop/helpers/db.php:214 |
9 | BFStopDBHelper->isIPBlocked() | JROOT/plugins/system/bfstop/bfstop.php:392 |
8 | plgSystembfstop->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.236 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('13.59.85.151') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-12-19 11:59:09')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | b | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 47 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.b.id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/bfstop/helpers/db.php:188 |
10 | BFStopDBHelper->checkForEntries() | JROOT/plugins/system/bfstop/helpers/db.php:215 |
9 | BFStopDBHelper->isIPBlocked() | JROOT/plugins/system/bfstop/bfstop.php:392 |
8 | plgSystembfstop->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.37 ms Nach letzter Abfrage: 11.48 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.056 MB Zeilen zurückgegeben: 4
select id, title, alias
from jos331_jumi
where published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jumi | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1811 |
12 | JDatabaseDriver->loadRowList() | JROOT/plugins/system/jumirouter/jumirouter.php:57 |
11 | parseJumiRouter() | Der selbe Aufruf in der Zeile darunter. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.34 ms Nach letzter Abfrage: 4.84 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.376 MB Zeilen zurückgegeben: 1
SELECT s.*
FROM jos331_template_styles as s
WHERE s.client_id = 0
AND s.id =67
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_client_id,idx_client_id_home | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 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.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/phocaupgrade/phocaupgrade.php:216 |
8 | plgSystemPhocaUpgrade->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.72 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.413 MB Zeilen zurückgegeben: 4
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_obrss | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 16.67 | Using where; filesort wurde genutzt |
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.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.05 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/obrss/obrss.php:40 |
8 | plgSystemobrss->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.33 ms Nach letzter Abfrage: 19.42 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 17.419 MB Zeilen zurückgegeben: 80
SELECT `keyname`,`value`
FROM jos331_jem_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jem_config | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 80 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 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.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
11 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jem/classes/config.class.php:108 |
10 | JemConfig->loadData() | JROOT/components/com_jem/classes/config.class.php:65 |
9 | JemConfig->__construct() | JROOT/components/com_jem/classes/config.class.php:49 |
8 | JemConfig::getInstance() | JROOT/components/com_jem/helpers/helper.php:77 |
7 | JemHelper::addFileLogger() | JROOT/components/com_jem/jem.php:32 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 9.80 ms Nach letzter Abfrage: 5.10 ms Abfragespeichernutzung: 0.456 MB Speichernutzung vor Abfrage: 17.886 MB Zeilen zurückgegeben: 2306
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,c.groupid,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1,5))
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 14 | 7.14 | Using where; Using temporary |
1 | SIMPLE | rel | NULL | ref | category event relation,catid | category event relation | 4 | usr_web689_1.c.id | 23 | 100.00 | Using where; Using index |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.itemid | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
executing | 0.00 ms |
Sending data | 9.31 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
13 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/models/event.php:384 |
12 | JemModelEvent->getCategories() | JROOT/components/com_jem/models/event.php:137 |
11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.94 ms Nach letzter Abfrage: 2.12 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 17.892 MB Zeilen zurückgegeben: 1
SELECT a.id, a.id AS did, a.title, a.alias, a.dates, a.enddates, a.times, a.endtimes, a.access, a.attribs, a.metadata, a.custom1, a.custom2, a.custom3, a.custom4, a.custom5, a.custom6, a.custom7, a.custom8, a.custom9, a.custom10, a.created, a.created_by, a.published, a.registra, a.unregistra, a.unregistra_until,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.datimage, a.version, a.featured, a.meta_keywords, a.meta_description, a.created_by_alias, a.introtext, a.fulltext, a.maxplaces, a.waitinglist, a.hits, a.language, a.recurrence_type, a.recurrence_first_id,u.name AS author,con.id AS conid, con.name AS conname, con.telephone AS contelephone, con.email_to AS conemail,l.custom1 AS venue1, l.custom2 AS venue2, l.custom3 AS venue3, l.custom4 AS venue4, l.custom5 AS venue5, l.custom6 AS venue6, l.custom7 AS venue7, l.custom8 AS venue8, l.custom9 AS venue9, l.custom10 AS venue10, l.id AS locid, l.alias AS localias, l.venue, l.city, l.state, l.url, l.locdescription, l.locimage, l.postalCode, l.street, l.country, l.map, l.created_by AS venueowner, l.latitude, l.longitude, l.checked_out AS vChecked_out, l.checked_out_time AS vChecked_out_time, l.published as locpublished,(
SELECT MAX(contact.id) AS id
FROM jos331_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid2
FROM jos331_jem_events AS a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_contact_details AS con
ON con.id = a.contactid
LEFT JOIN jos331_jem_venues AS l
ON a.locid = l.id
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid
WHERE a.id = 2093
AND c.id IN (1,2,3,4,5,6,7,8,9,10,12,13,14)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | con | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | l | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 100.00 | Using where; Using index |
2 | DEPENDENT SUBQUERY | contact | NULL | ref | idx_state | idx_state | 1 | const | 3 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.21 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 |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.12 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/models/event.php:145 |
11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
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: 17.913 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,c.groupid,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =2093
AND c.published = 1
AND (c.access IN (1,1,5))
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 1 | 100.00 | Using where; Using temporary |
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 7.14 | Using index condition; Using where |
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.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
Creating tmp table | 0.03 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/event.php:387 |
12 | JemModelEvent->getCategories() | JROOT/components/com_jem/models/event.php:165 |
11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 17.914 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM jos331_jem_register
WHERE event = '2093'
AND waiting = 0
AND status = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jem_register | NULL | ref | idx_event,idx_event_status | idx_event | 4 | const | 1 | 16.67 | 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.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/models/event.php:215 |
11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 17.936 MB Zeilen zurückgegeben: 68
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_adminmenumanager','com_ajax','com_akeeba','com_alfcontact','com_articlegenerator','com_associations','com_asurveys','com_attachments','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativeimageslider','com_customproperties','com_dbreplacer','com_docindexer','com_fields','com_finder','com_flexicontactplus','com_googlesearch_cse','com_gsd','com_installer','com_instantfblogin','com_jce','com_jcomments','com_jem','com_jextranet','com_jmap','com_joomlaupdate','com_jsocialfeed','com_jumi','com_jvld','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_nextend2','com_obrss','com_offlajn_installer','com_phocadownload','com_phocagallery','com_phocamaps','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_redirect','com_responsivizer','com_search','com_spambotcheck','com_tags','com_templateck','com_templates','com_userextranet','com_users','com_weblinks','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 69 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.06 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.20 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.53 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
15 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
14 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
13 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
12 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
11 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jem/models/event.php:476 |
10 | JemModelEvent->getRegisters() | JROOT/components/com_jem/views/event/view.html.php:58 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.042 MB Zeilen zurückgegeben: 0
SELECT IF (status > 0, waiting + 1, status) AS status, id, comment
FROM jos331_jem_register
WHERE uid = '0'
AND event = '2093'
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.00 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/models/event.php:428 |
11 | JemModelEvent->getUserRegistration() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:59 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.87 ms Nach letzter Abfrage: 29.84 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 20.759 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_jem.event'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | usr_web689_1.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.group_id | 1 | 100.00 | Using where |
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 |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.18 ms |
Creating sort index | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.06 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
15 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
13 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
12 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 12.52 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 21.880 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `jos331_content`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_content`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.09 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.03 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/plugins/system/articlesanywhere/helpers/process.php:41 |
17 | plgSystemArticlesAnywhereHelperProcess->__construct() | JROOT/plugins/system/articlesanywhere/helpers/helpers.php:51 |
16 | plgSystemArticlesAnywhereHelpers->get() | JROOT/plugins/system/articlesanywhere/helper.php:118 |
15 | plgSystemArticlesAnywhereHelper->processArticles() | JROOT/plugins/system/nnframework/helpers/helper.php:78 |
14 | NNFrameworkHelper::processArticle() | JROOT/plugins/system/articlesanywhere/helper.php:55 |
13 | plgSystemArticlesAnywhereHelper->onContentPrepare() | JROOT/plugins/system/articlesanywhere/articlesanywhere.php:40 |
12 | plgSystemArticlesAnywhere->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.43 ms Nach letzter Abfrage: 8.23 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.553 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
WHERE a.id = 732
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 | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 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.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/content/phocadownload/phocadownload.php:366 |
12 | plgContentPhocaDownload->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.21 ms Nach letzter Abfrage: 1.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.628 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
WHERE a.id = 753
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 | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/content/phocadownload/phocadownload.php:366 |
12 | plgContentPhocaDownload->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.636 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
WHERE a.id = 754
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 | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/content/phocadownload/phocadownload.php:366 |
12 | plgContentPhocaDownload->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.648 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
WHERE a.id = 755
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 | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/content/phocadownload/phocadownload.php:366 |
12 | plgContentPhocaDownload->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.656 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
WHERE a.id = 756
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 | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/content/phocadownload/phocadownload.php:366 |
12 | plgContentPhocaDownload->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:155 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 6.50 ms Nach letzter Abfrage: 2.62 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.798 MB Zeilen zurückgegeben: 1
SELECT SUM(hits), COUNT(hits)
FROM jos331_content
WHERE state = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_content | NULL | ref | idx_state | idx_state | 1 | const | 4112 | 100.00 | NULL |
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 | 6.19 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1773 |
13 | JDatabaseDriver->loadRow() | JROOT/plugins/content/poparttags/poparttags.php:109 |
12 | plgContentpoparttags->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_jem/views/event/view.html.php:161 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 22.806 MB
UPDATE jos331_jem_events
SET hits = hits + 1
WHERE id = 2093
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | jos331_jem_events | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.03 ms |
updating | 0.05 ms |
end | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/components/com_jem/models/event.php:243 |
10 | JemModelEvent->hit() | JROOT/components/com_jem/views/event/view.html.php:177 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 4.49 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 23.123 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 jos331_jem_categories
WHERE id = 3
AND published = 1
AND access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jem_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 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.03 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.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/classes/categories.class.php:456 |
14 | JemCategories->getPath() | JROOT/components/com_jem/helpers/route.php:89 |
13 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/event/tmpl/default.php:103 |
12 | include JROOT/components/com_jem/views/event/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jem/views/event/view.html.php:333 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 23.132 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 jos331_jem_categories
WHERE id = 7
AND published = 1
AND access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/classes/categories.class.php:456 |
14 | JemCategories->getPath() | JROOT/components/com_jem/helpers/route.php:89 |
13 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/event/tmpl/default.php:103 |
12 | include JROOT/components/com_jem/views/event/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jem/views/event/view.html.php:333 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 23.139 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 jos331_jem_categories
WHERE id = 1
AND published = 1
AND access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_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.00 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/classes/categories.class.php:456 |
14 | JemCategories->getPath() | JROOT/components/com_jem/helpers/route.php:89 |
13 | JEMHelperRoute::getCategoryRoute() | JROOT/components/com_jem/views/event/tmpl/default.php:103 |
12 | include JROOT/components/com_jem/views/event/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jem/views/event/view.html.php:333 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 23.148 MB Zeilen zurückgegeben: 1
SELECT `alias`
FROM `jos331_contact_details`
WHERE id = '11'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_contact_details | NULL | const | PRIMARY | PRIMARY | 4 | const | 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.04 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/components/com_contact/router.php:121 |
22 | ContactRouter->getContactSegment() | Der selbe Aufruf in der Zeile darunter. |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jem/views/event/tmpl/default.php:219 |
12 | include JROOT/components/com_jem/views/event/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jem/views/event/view.html.php:333 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 23.165 MB Zeilen zurückgegeben: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 11
ORDER BY c.lft
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.08 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
24 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
23 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_contact/router.php:68 |
22 | ContactRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
21 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:124 |
20 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
19 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
18 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
17 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
14 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
13 | Joomla\CMS\Router\Route::_() | JROOT/components/com_jem/views/event/tmpl/default.php:219 |
12 | include JROOT/components/com_jem/views/event/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
11 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
10 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_jem/views/event/view.html.php:333 |
9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.30 ms Nach letzter Abfrage: 2.48 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 23.186 MB Zeilen zurückgegeben: 1
SELECT a.id,a.params
FROM jos331_users AS a
WHERE a.name='706' or a.id='706'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | index_merge | PRIMARY,idx_name | idx_name,PRIMARY | 402,4 | NULL | 2 | 100.00 | Using sort_union(idx_name,PRIMARY); 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.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
9 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:78 |
8 | plgSystemJGoogleAuthor->_get_googleauthorlink() | JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:55 |
7 | plgSystemJGoogleAuthor->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 7.38 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 23.689 MB Zeilen zurückgegeben: 1
SELECT a.*
FROM jos331_gsd a
WHERE a.state = 1
AND a.plugin = 'menus'
ORDER BY a.id desc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | state,plugin | plugin | 152 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_gsd/models/items.php:167 |
15 | GSDModelItems->getItems() | JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 |
14 | GSD\PluginBase->getSnippets() | JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 |
13 | GSD\PluginBase->onGSDBeforeRender() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
10 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/administrator/components/com_gsd/GSD/Helper.php:439 |
9 | GSD\Helper::event() | JROOT/plugins/system/gsd/gsd.php:122 |
8 | plgSystemGSD->init() | JROOT/plugins/system/gsd/gsd.php:77 |
7 | plgSystemGSD->onBeforeRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1102 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.29 ms Nach letzter Abfrage: 4.93 ms Abfragespeichernutzung: 0.134 MB Speichernutzung vor Abfrage: 24.089 MB Zeilen zurückgegeben: 609
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 jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 14 | 7.14 | Using where; Using temporary |
1 | SIMPLE | rel | NULL | ref | category event relation,catid | category event relation | 4 | usr_web689_1.c.id | 23 | 100.00 | Using where; Using index |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.itemid | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
Creating tmp table | 0.03 ms |
executing | 0.00 ms |
Sending data | 2.94 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.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
17 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/models/eventslist.php:658 |
16 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:375 |
15 | JemModelEventslist->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:483 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.61 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 24.097 MB Zeilen zurückgegeben: 3
SELECT a.access,a.alias,a.attribs,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,u.name AS author,l.alias AS l_alias,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 AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS 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 jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid
WHERE a.access IN (1,1,5)
AND ((`a`.published = 1))
AND DATEDIFF(IF (a.enddates IS NOT NULL, a.enddates, a.dates), '2024-12-01') >= 0
AND DATEDIFF(a.dates, '2024-12-31') <= 0
AND a.dates IS NOT NULL
AND c.id IN (2,3,4,5,9,10)
GROUP BY a.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | PRIMARY,idx_access,idx_pubstate | idx_pubstate | 1 | const | 13 | 89.96 | Using index condition; Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.a.locid | 1 | 100.00 | NULL |
1 | SIMPLE | ct | NULL | ref | iso2 | iso2 | 8 | usr_web689_1.l.country | 1 | 100.00 | NULL |
1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | usr_web689_1.a.id | 1 | 100.00 | Using index condition |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.21 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 |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.12 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
Creating tmp table | 0.09 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.62 ms |
Creating sort index | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jem/models/eventslist.php:483 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.145 MB Zeilen zurückgegeben: 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 jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =3197
AND c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 2 | 100.00 | Using where; Using temporary |
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 7.14 | Using index condition; Using where |
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.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/eventslist.php:662 |
13 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:508 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.156 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 jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =3324
AND c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 2 | 100.00 | Using where; Using temporary |
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 7.14 | Using index condition; Using where |
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.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/eventslist.php:662 |
13 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:508 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.166 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 jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =3388
AND c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 2 | 100.00 | Using where; Using temporary |
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.rel.catid | 1 | 7.14 | Using index condition; Using where |
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.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/eventslist.php:662 |
13 | JemModelEventslist->getCategories() | JROOT/components/com_jem/models/eventslist.php:508 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.171 MB Zeilen zurückgegeben: 0
SELECT COUNT(id) as total, COUNT(IF(status = 1
AND waiting <= 0, 1, null)) AS registered, COUNT(IF(status = 1
AND waiting > 0, 1, null)) AS waiting, COUNT(IF(status = -1, 1, null)) AS unregistered, COUNT(IF(status = 0, 1, null)) AS invited, event
FROM jos331_jem_register
WHERE event IN (3197,3324,3388)
GROUP BY event
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jem_register | NULL | ALL | idx_user_event,idx_event,idx_event_status | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | 50.00 | Using where; Using temporary; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/helpers/helper.php:880 |
13 | JemHelper::getAttendeesNumbers() | JROOT/components/com_jem/models/eventslist.php:521 |
12 | JemModelEventslist->getItems() | JROOT/modules/mod_jem_cal/helper.php:154 |
11 | ModJemCalHelper::getDays() | JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 |
10 | include JROOT/modules/mod_jem_cal/mod_jem_cal.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.01 ms Nach letzter Abfrage: 7.95 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 24.815 MB Zeilen zurückgegeben: 384
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 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 |
checking permissions | 1.46 ms |
Sending data | 0.18 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
16 | JDatabaseDriverMysqli->getTableList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:552 |
15 | acymailing_getTableList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:18 |
14 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:523 |
13 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:840 |
12 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:25 |
11 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/modules/mod_acymailing/mod_acymailing.php:13 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 24.863 MB Zeilen zurückgegeben: 182
SELECT *
FROM jos331_acymailing_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_acymailing_config | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 182 | 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.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:478 |
15 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:23 |
14 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:523 |
13 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:840 |
12 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:25 |
11 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/modules/mod_acymailing/mod_acymailing.php:13 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.26 ms Nach letzter Abfrage: 6.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 25.610 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_acymailing_list | NULL | system | typeorderingindex,typeuseridindex | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 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.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:478 |
12 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/list.php:30 |
11 | listClass->getLists() | JROOT/modules/mod_acymailing/mod_acymailing.php:149 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.51 ms Nach letzter Abfrage: 19.37 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 28.764 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields` as a
WHERE a.`published` = 1
AND (a.access = 'all' OR a.access LIKE ('%,9,%'))
ORDER BY a.`ordering` ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | orderingindex | orderingindex | 1 | const | 2 | 55.56 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.04 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:478 |
12 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/fields.php:85 |
11 | fieldsClass->getFields() | JROOT/modules/mod_acymailing/mod_acymailing.php:245 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 28.776 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_acymailing_fields | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:478 |
12 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/fields.php:100 |
11 | fieldsClass->getFields() | JROOT/modules/mod_acymailing/mod_acymailing.php:245 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.45 ms Nach letzter Abfrage: 3.75 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 28.889 MB Zeilen zurückgegeben: 71
SELECT
c.id AS CID
FROM
jos331_categories AS c
LEFT JOIN
jos331_content AS content
ON
c.id = content.catid
WHERE
( c.id = 521 OR c.id = 516 OR c.id = 522 OR c.id = 517 OR c.id = 524 OR c.id = 519 )
AND
c.extension = 'com_content'
AND
c.published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | range | PRIMARY,cat_idx | PRIMARY | 4 | NULL | 6 | 43.27 | Using where |
1 | SIMPLE | content | NULL | ref | idx_catid | idx_catid | 4 | usr_web689_1.c.id | 99 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.09 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:64 |
12 | NH_GK5_Joomla_Source::getSources() | JROOT/modules/mod_highlighter_gk5/helper.php:91 |
11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.75 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 28.897 MB Zeilen zurückgegeben: 20
SELECT
content.id AS iid,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.language AS language,
content.featured AS frontpage
FROM
jos331_content AS content
WHERE
content.state = 1
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-12-19 10:59:09' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-12-19 10:59:09' )
AND ( content.catid = 517 OR content.catid = 522 )
ORDER BY
content.created DESC
LIMIT
0,20;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | idx_access,idx_state,idx_catid | idx_catid | 4 | NULL | 71 | 16.00 | Using index condition; Using where; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.47 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:189 |
12 | NH_GK5_Joomla_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:93 |
11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 28.933 MB Zeilen zurückgegeben: 20
SELECT
content.id AS iid,
content.access AS access,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
jos331_content AS content
LEFT JOIN
jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN
jos331_users AS users
ON users.id = content.created_by
LEFT JOIN
jos331_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE
content.id = 60464 OR content.id = 60448 OR content.id = 60447 OR content.id = 60439 OR content.id = 60431 OR content.id = 60374 OR content.id = 60307 OR content.id = 60275 OR content.id = 59763 OR content.id = 59755 OR content.id = 59725 OR content.id = 59722 OR content.id = 59680 OR content.id = 59668 OR content.id = 59657 OR content.id = 59650 OR content.id = 59638 OR content.id = 59614 OR content.id = 59603 OR content.id = 59599
ORDER BY
content.created DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | content | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 20 | 100.00 | Using where; filesort wurde genutzt |
1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.content.catid | 1 | 100.00 | Using where |
1 | SIMPLE | users | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.content.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | content_rating | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usr_web689_1.content.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.21 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:238 |
12 | NH_GK5_Joomla_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:93 |
11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 28.977 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 522
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | filesort wurde genutzt |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 104 | 26.63 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.14 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_highlighter_gk5/helper.php:152 |
11 | NH_GK5_Helper->renderLayout() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.54 ms Nach letzter Abfrage: 4.86 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 29.173 MB Zeilen zurückgegeben: 1
SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp
WHERE sp.published = '1'
AND sp.id = '1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | sp | NULL | system | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.08 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.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/components/com_creativeimageslider/helpers/helper.php:174 |
13 | CreativeimagesliderHelper->get_slider_data() | JROOT/components/com_creativeimageslider/helpers/helper.php:236 |
12 | CreativeimagesliderHelper->render_slider() | JROOT/components/com_creativeimageslider/helpers/helper.php:608 |
11 | CreativeimagesliderHelper->render_html() | JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 |
10 | include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 29.189 MB Zeilen zurückgegeben: 13
SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa
WHERE sa.published = '1'
AND sa.id_slider = '1'
ORDER BY sa.ordering,sa.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | sa | NULL | ref | id_slider | id_slider | 4 | const | 14 | 10.00 | Using index condition; Using where; filesort wurde genutzt |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.15 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
14 | JDatabaseDriver->loadAssocList() | JROOT/components/com_creativeimageslider/helpers/helper.php:221 |
13 | CreativeimagesliderHelper->get_slider_items() | JROOT/components/com_creativeimageslider/helpers/helper.php:239 |
12 | CreativeimagesliderHelper->render_slider() | JROOT/components/com_creativeimageslider/helpers/helper.php:608 |
11 | CreativeimagesliderHelper->render_html() | JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 |
10 | include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 29.241 MB Zeilen zurückgegeben: 1
SELECT
COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 221992343 & mask
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_cleantalk_sfw | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 13 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.04 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:41 |
15 | CleantalkSFW->unversal_query() | JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:88 |
14 | CleantalkSFW->check_ip() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 |
13 | plgSystemAntispambycleantalk->sfw_check() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 |
12 | plgSystemAntispambycleantalk->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 29.248 MB Zeilen zurückgegeben: 1
SELECT
COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 221992343 & mask
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_cleantalk_sfw | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 13 | 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.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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
16 | JDatabaseDriver->loadAssoc() | JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:49 |
15 | CleantalkSFW->unversal_fetch() | JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:89 |
14 | CleantalkSFW->check_ip() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 |
13 | plgSystemAntispambycleantalk->sfw_check() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 |
12 | plgSystemAntispambycleantalk->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 29.248 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_metainfo
WHERE `linkurl` = 'https://gsv-schwimmen.de/kalender/event/2093-2018-weihnachtskriterium-marburg'
AND `published` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jmap_metainfo | NULL | ALL | published | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 40 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.02 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.08 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:426 |
12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 29.254 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_canonicals
WHERE `linkurl` = 'https://gsv-schwimmen.de/kalender/event/2093-2018-weihnachtskriterium-marburg'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jmap_canonicals | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where |
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.00 ms |
statistics | 0.01 ms |
preparing | 0.00 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.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:504 |
12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.27 ms Nach letzter Abfrage: 12.77 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 29.606 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_headings
WHERE `linkurl` = 'https://gsv-schwimmen.de/kalender/event/2093-2018-weihnachtskriterium-marburg'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | jos331_jmap_headings | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
8 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:813 |
7 | plgSystemJMap->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
7 × SELECT c.id
FROM jos331_content AS c
5 × SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug
FROM jos331_phocadownload AS a
LEFT JOIN jos331_phocadownload_categories AS c
ON a.catid = c.id
4 × 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 jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
3 × SELECT id, parent_id, catname,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM jos331_jem_categories
2 × SELECT id, ipaddress
from jos331_bfstop_allowlist
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
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,c.groupid,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
2 × SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
2 × SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
1 × SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM jos331_content AS content
LEFT JOIN jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN jos331_users AS users
ON users.id = content.created_by
LEFT JOIN jos331_content_rating AS content_rating
ON content_rating.content_id = content.id
1 × SELECT *
FROM jos331_jmap_canonicals
1 × SELECT a.id,a.params
FROM jos331_users AS a
1 × SELECT a.*
FROM jos331_gsd a
1 × SELECT *
FROM jos331_jmap_metainfo
1 × SELECT a.access,a.alias,a.attribs,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,u.name AS author,l.alias AS l_alias,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 AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS 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 jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid
1 × SELECT COUNT(id) as total, COUNT(IF(status = 1
AND waiting <= 0, 1, null)) AS registered, COUNT(IF(status = 1
AND waiting > 0, 1, null)) AS waiting, COUNT(IF(status = -1, 1, null)) AS unregistered, COUNT(IF(status = 0, 1, null)) AS invited, event
FROM jos331_jem_register
1 × SELECT *
FROM jos331_acymailing_confi
1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM jos331_content AS content
1 × SELECT *
FROM jos331_acymailing_list
1 × SELECT *
FROM `jos331_acymailing_fields` as a
1 × SELECT *
FROM `jos331_acymailing_fields
1 × SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa
1 × SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp
1 × SELECT c.id AS CID
FROM jos331_categories AS c
LEFT JOIN jos331_content AS content
ON c.id = content.catid
1 × SELECT `alias`
FROM `jos331_contact_details`
1 × SELECT `data`
FROM `jos331_session`
1 × SELECT SUM(hits), COUNT(hits)
FROM jos331_content
1 × select email
from jos331_users
1 × SELECT id, rules
FROM `jos331_viewlevels
1 × SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM jos331_gsd_config
1 × SELECT *
FROM `jos331_redirect_links`
1 × select version, dir_online, value
from `jos331_jvld_settings`
1 × select id
from jos331_menu
1 × select sparams
from `jos331_jvld_styles`
1 × select id, title, alias
from jos331_jumi
1 × SELECT `session_id`
FROM `jos331_session`
1 × SELECT s.*
FROM jos331_template_styles as s
1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`
1 × SELECT `keyname`,`value`
FROM jos331_jem_confi
1 × SELECT a.id, a.id AS did, a.title, a.alias, a.dates, a.enddates, a.times, a.endtimes, a.access, a.attribs, a.metadata, a.custom1, a.custom2, a.custom3, a.custom4, a.custom5, a.custom6, a.custom7, a.custom8, a.custom9, a.custom10, a.created, a.created_by, a.published, a.registra, a.unregistra, a.unregistra_until,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.datimage, a.version, a.featured, a.meta_keywords, a.meta_description, a.created_by_alias, a.introtext, a.fulltext, a.maxplaces, a.waitinglist, a.hits, a.language, a.recurrence_type, a.recurrence_first_id,u.name AS author,con.id AS conid, con.name AS conname, con.telephone AS contelephone, con.email_to AS conemail,l.custom1 AS venue1, l.custom2 AS venue2, l.custom3 AS venue3, l.custom4 AS venue4, l.custom5 AS venue5, l.custom6 AS venue6, l.custom7 AS venue7, l.custom8 AS venue8, l.custom9 AS venue9, l.custom10 AS venue10, l.id AS locid, l.alias AS localias, l.venue, l.city, l.state, l.url, l.locdescription, l.locimage, l.postalCode, l.street, l.country, l.map, l.created_by AS venueowner, l.latitude, l.longitude, l.checked_out AS vChecked_out, l.checked_out_time AS vChecked_out_time, l.published as locpublished,( SELECT MAX(contact.id) AS id
FROM jos331_contact_details AS contact
1 × SELECT COUNT(*)
FROM jos331_jem_register
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
1 × SELECT IF (status > 0, waiting + 1, status) AS status, id, comment
FROM jos331_jem_register
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
1 × SELECT *
FROM jos331_jmap_headings