Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1711671747, "last": 1711671747, "now": 1711671747 }, "token": "TpyxVPXRZjts7hxIgX0Fv6rYLYzxn1sR" }, "registry": { "jevents": { "moduleid104": { "shownEventIds": [ [ "6934", "6935", "6926", "6942" ] ], "page": 0, "firstEventDate": "2024-03-15 19:30:00", "lastEventDate": "2024-04-21 09:00:00" } }, "published_fv_ses": "0" }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } }, "__easycalccheckplus": { "redirectUrl": null, "eccLoaded": null } }
Zeit
Speicher
50 ausgeführte Abfragen 771.90 ms
- Abfragezeit: 0.80 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.155 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `mve3stable_session`
WHERE `session_id` = X'3131623665653461373137316335656263646461636131386133313834373966'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms executing 0.02 ms end 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.58 ms Nach letzter Abfrage: 1.43 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.250 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `mve3stable_session`
WHERE `session_id` = X'3131623665653461373137316335656263646461636131386133313834373966'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.03 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: 3.33 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.255 MB
INSERT INTO `mve3stable_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3131623665653461373137316335656263646461636131386133313834373966', 1, 1711671747, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `mve3stable_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3131623665653461373137316335656263646461636131386133313834373966', 1, 1711671747, 0, '', 0)Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms update 0.23 ms end 0.02 ms query end 2.65 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 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: 1.16 ms Nach letzter Abfrage: 1.90 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.444 MB Zeilen zurückgegeben: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mve3stable_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_extensions NULL ref extension extension 82 const 45 1.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.43 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Derselbe Aufruf in der Zeile darunter. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.94 ms Nach letzter Abfrage: 1.98 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.713 MB Zeilen zurückgegeben: 13
SELECT id, rules
FROM `mve3stable_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 100.00 NULL Status Duration starting 0.05 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.25 ms preparing 0.02 ms executing 0.01 ms Sending data 0.17 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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.93 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.728 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM mve3stable_usergroups AS a
LEFT JOIN mve3stable_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 5 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 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: 2.56 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.797 MB Zeilen zurückgegeben: 101
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM mve3stable_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_extensions NULL ref extension extension 82 const 149 0.60 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.81 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.85 ms Nach letzter Abfrage: 29.21 ms Abfragespeichernutzung: 0.096 MB Speichernutzung vor Abfrage: 7.839 MB Zeilen zurückgegeben: 69
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM mve3stable_menu AS m
LEFT JOIN mve3stable_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 87 10.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 db478489175.m.component_id 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.04 ms Sorting result 0.04 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.84 ms end 0.02 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.89 ms Nach letzter Abfrage: 10.47 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.912 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mve3stable_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.05 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.74 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.903 MB
UPDATE `mve3stable_extensions`
SET `params` = '{\"mediaversion\":\"7a59bf8af543ddbf865d9dd157ba9578\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE mve3stable_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.05 ms System lock 0.13 ms updating 0.16 ms end 0.02 ms query end 2.97 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.72 ms Nach letzter Abfrage: 1.83 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 9.087 MB Zeilen zurückgegeben: 2
SELECT *
FROM mve3stable_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_languages NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where; filesort wurde genutzt Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.07 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.102 MB Zeilen zurückgegeben: 5
SELECT id, home, template, s.params
FROM mve3stable_template_styles as s
LEFT JOIN mve3stable_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 7 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 db478489175.e.element 1 71.43 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms executing 0.01 ms Sending data 0.27 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.41 ms Nach letzter Abfrage: 6.93 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 9.888 MB Zeilen zurückgegeben: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mve3stable_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easybookreloaded','com_fields','com_finder','com_flippingbook','com_installer','com_jce','com_jevents','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_phocamaps','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper','com_youtubegallery')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_assets NULL range idx_asset_name idx_asset_name 202 NULL 44 100.00 Using index condition Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.25 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.43 ms preparing 0.03 ms executing 0.01 ms Sending data 1.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 7.12 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 9.942 MB Zeilen zurückgegeben: 237
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mve3stable_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3197 20.73 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.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 6.33 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 1.91 ms Nach letzter Abfrage: 1.85 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.282 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,( SELECT COUNT(i.`id`)
FROM `mve3stable_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_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.published = 1
AND s.id = 16
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 PRIMARY c NULL ALL cat_idx,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 55 17.19 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 db478489175.c.id 7 99.47 Using index condition; Using where Status Duration starting 0.26 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.11 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.24 ms preparing 0.05 ms Sorting result 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms Creating sort index 0.28 ms executing 0.01 ms Sending data 0.05 ms executing 0.01 ms Sending data 0.09 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.04 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 1.37 ms Nach letzter Abfrage: 2.81 ms Abfragespeichernutzung: 0.059 MB Speichernutzung vor Abfrage: 10.473 MB Zeilen zurückgegeben: 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM mve3stable_content AS a
LEFT JOIN mve3stable_categories AS c
ON c.id = a.catid
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_by
LEFT JOIN mve3stable_users AS uam
ON uam.id = a.modified_by
LEFT JOIN mve3stable_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mve3stable_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 16
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 00:22:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 00:22:27')
ORDER BY a.created DESC , a.created
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 3 15.91 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.id 1 100.00 Using where Status Duration starting 0.25 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 Opening tables 0.03 ms init 0.11 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.26 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.97 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.672 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mve3stable_contentitem_tag_map` AS m
INNER JOIN `mve3stable_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 185
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db478489175.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.62 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.691 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mve3stable_contentitem_tag_map` AS m
INNER JOIN `mve3stable_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 50
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db478489175.m.tag_id 1 100.00 Using where Status Duration starting 0.07 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.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.52 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.710 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mve3stable_contentitem_tag_map` AS m
INNER JOIN `mve3stable_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 51
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db478489175.m.tag_id 1 100.00 Using where Status Duration starting 0.06 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.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.78 ms Nach letzter Abfrage: 1.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.799 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM mve3stable_content AS a
LEFT JOIN mve3stable_categories AS c
ON c.id = a.catid
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_by
LEFT JOIN mve3stable_users AS uam
ON uam.id = a.modified_by
LEFT JOIN mve3stable_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mve3stable_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 16
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 00:22:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 00:22:27')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 3 15.91 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.id 1 100.00 Using where; Using index Status Duration starting 0.10 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 Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms executing 0.01 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.57 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.802 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mve3stable_contentitem_tag_map` AS m
INNER JOIN `mve3stable_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 16
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db478489175.m.tag_id 1 100.00 Using where Status Duration starting 0.06 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.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 1.55 ms Nach letzter Abfrage: 14.23 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.694 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 `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_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 = 16
ORDER BY c.lftid 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 55 17.85 Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.24 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.04 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 2.34 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.715 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 mve3stable_fields AS a
LEFT JOIN `mve3stable_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mve3stable_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mve3stable_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mve3stable_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mve3stable_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (16,0,14))
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 ASCid 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 50.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db478489175.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db478489175.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.15 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.27 ms preparing 0.07 ms Creating tmp table 0.10 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.52 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.14 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.03 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/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 2.05 ms Nach letzter Abfrage: 16.28 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 12.609 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 mve3stable_fields AS a
LEFT JOIN `mve3stable_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mve3stable_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mve3stable_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mve3stable_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
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 ASCid 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 50.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db478489175.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.group_id 1 100.00 Using where Status Duration starting 0.23 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 Opening tables 0.05 ms init 0.11 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.30 ms preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.46 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.15 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.08 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 1.91 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.622 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 mve3stable_fields AS a
LEFT JOIN `mve3stable_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mve3stable_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mve3stable_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mve3stable_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mve3stable_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (16,0,14))
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 ASCid 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 50.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db478489175.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db478489175.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.26 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 Opening tables 0.04 ms init 0.11 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.26 ms preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.42 ms Creating sort index 0.04 ms end 0.01 ms query end 0.02 ms removing tmp table 0.12 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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: 2.89 ms Nach letzter Abfrage: 11.25 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 13.648 MB Zeilen zurückgegeben: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mve3stable_modules AS m
LEFT JOIN mve3stable_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mve3stable_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-03-29 00:22:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 00:22:27')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 43 1.60 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 db478489175.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 db478489175.m.id 12 40.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.84 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/a4joomla-autumn3r/index.php:5 7 require JROOT/templates/a4joomla-autumn3r/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 8.26 ms Nach letzter Abfrage: 959.04 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 15.383 MB Zeilen zurückgegeben: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM mve3stable_content AS a
LEFT JOIN mve3stable_categories AS c
ON c.id = a.catid
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_by
LEFT JOIN mve3stable_users AS uam
ON uam.id = a.modified_by
LEFT JOIN mve3stable_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mve3stable_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (8,10,35,11,12,13,14,32)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 00:22:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 00:22:27')
ORDER BY a.publish_up DESC
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_state 1 const 189 8.92 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 db478489175.a.catid 1 9.64 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 db478489175.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 db478489175.c.parent_id 1 100.00 Using where 1 SIMPLE v NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.43 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.23 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.31 ms preparing 0.09 ms Creating tmp table 0.25 ms Sorting result 0.02 ms executing 0.01 ms Sending data 5.29 ms Creating sort index 0.47 ms end 0.02 ms query end 0.04 ms removing tmp table 0.31 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.55 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 15.477 MB Zeilen zurückgegeben: 11
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 `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_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 = 8
ORDER BY c.lftid 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 55 15.17 Using where Status Duration starting 0.24 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.09 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.25 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.34 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Derselbe Aufruf in der Zeile darunter. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.72 ms Nach letzter Abfrage: 34.44 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 17.705 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `mve3stable_jev_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `mve3stable_jev_users`Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.43 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.03 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.19 ms closing tables 0.15 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 19 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1599 18 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1454 17 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:61 16 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1227 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.18 ms Nach letzter Abfrage: 2.20 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 17.886 MB Zeilen zurückgegeben: 6
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 `mve3stable_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access cat_idx 207 NULL 8 100.00 Using index condition; filesort wurde genutzt Status Duration starting 0.27 ms checking permissions 0.06 ms Opening tables 0.03 ms init 0.11 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.17 ms Creating sort index 0.68 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 21 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 20 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:409 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1227 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 17.932 MB Zeilen zurückgegeben: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_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_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 52
ORDER BY c.lftid 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 range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 8 78.18 Using index condition; Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 21 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 20 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:428 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1227 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.72 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 17.942 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #33
SELECT c.id
FROM mve3stable_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('de-DE','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=80
AND c.rgt<=81 ))
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 6 8.48 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 19 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:522 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1227 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.977 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #32
SELECT c.id
FROM mve3stable_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('de-DE','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=80
AND c.rgt<=81 ))
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 6 8.48 Using index condition; Using where; filesort wurde genutzt 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.02 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:522 14 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:1270 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 8.08 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 18.011 MB Zeilen zurückgegeben: 2
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mve3stable_jevents_repetition as rpt
INNER JOIN mve3stable_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN mve3stable_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN mve3stable_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mve3stable_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,51)
AND rpt.endrepeat >= '2024-03-29 01:22:28'
AND rpt.startrepeat <= '2024-04-28 23:59:59'
AND (rpt.startrepeat >= '2024-02-28 00:00:00' OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 28 97.79 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 db478489175.rpt.eventid 1 19.95 Using where 1 SIMPLE icsf NULL range PRIMARY,stateidx stateidx 1 NULL 7 14.29 Using index condition; Using where; Using join buffer (Block Nested Loop) 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 db478489175.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 db478489175.rpt.eventid 1 100.00 NULL Status Duration starting 0.17 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 Opening tables 0.04 ms init 0.12 ms System lock 0.01 ms optimizing 0.03 ms statistics 2.82 ms preparing 0.11 ms Creating tmp table 0.92 ms Sorting result 0.02 ms executing 0.01 ms Sending data 1.57 ms Creating sort index 0.57 ms end 0.01 ms query end 0.01 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3083 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1786 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.65 ms Nach letzter Abfrage: 5.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.404 MB Zeilen zurückgegeben: 0
SELECT *, summary as title, description as content
FROM mve3stable_jevents_translation
WHERE evdet_id IN(1578,1594)
AND language='de-DE'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_jevents_translation NULL ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.04 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.03 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.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:716 16 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3118 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1786 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.59 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 18.413 MB Zeilen zurückgegeben: 3
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mve3stable_jevents_repetition as rpt
INNER JOIN mve3stable_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN mve3stable_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN mve3stable_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mve3stable_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,51)
AND rpt.endrepeat >= '2024-02-28 00:00:00'
AND rpt.startrepeat <= '2024-03-29 01:22:28'
AND (rpt.startrepeat >= '2024-02-28 00:00:00' OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 31 97.53 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 db478489175.rpt.eventid 1 19.95 Using where 1 SIMPLE icsf NULL range PRIMARY,stateidx stateidx 1 NULL 7 14.29 Using index condition; Using where; Using join buffer (Block Nested Loop) 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 db478489175.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 db478489175.rpt.eventid 1 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.39 ms Creating sort index 0.06 ms end 0.01 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.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3083 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1837 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.459 MB Zeilen zurückgegeben: 0
SELECT *, summary as title, description as content
FROM mve3stable_jevents_translation
WHERE evdet_id IN(1587,1586,1590)
AND language='de-DE'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_jevents_translation NULL ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 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.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:716 16 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3118 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1837 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.15 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 18.469 MB Zeilen zurückgegeben: 3
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mve3stable_jevents_repetition as rpt
INNER JOIN mve3stable_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN mve3stable_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN mve3stable_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mve3stable_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,51)
AND rpt.endrepeat >= '2024-02-28 00:00:00'
AND rpt.startrepeat <= '2024-03-29 01:22:28'
AND (rpt.startrepeat <= '2024-02-28 00:00:00'OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat asc
LIMIT 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 31 97.53 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 db478489175.rpt.eventid 1 19.95 Using where 1 SIMPLE icsf NULL range PRIMARY,stateidx stateidx 1 NULL 7 14.29 Using index condition; Using where; Using join buffer (Block Nested Loop) 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 db478489175.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 db478489175.rpt.eventid 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.33 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3083 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1887 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.515 MB Zeilen zurückgegeben: 0
SELECT *, summary as title, description as content
FROM mve3stable_jevents_translation
WHERE evdet_id IN(1590,1586,1587)
AND language='de-DE'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_jevents_translation NULL ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 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.01 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.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:716 16 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3118 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1887 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.482 MB Zeilen zurückgegeben: 0
SELECT *, summary as title, description as content
FROM mve3stable_jevents_translation
WHERE evdet_id IN(1578,1594,1590,1586,1587)
AND language='de-DE'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_jevents_translation NULL ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:716 14 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:1930 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:636 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.41 ms Nach letzter Abfrage: 2.18 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.606 MB Zeilen zurückgegeben: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `mve3stable_menu` AS `c`
INNER JOIN `mve3stable_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mve3stable_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mve3stable_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 140id 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.04 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.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 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.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 15 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 14 MenusHelper::getAssociations() JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292 13 jIcalEventRepeat->viewDetailLink() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:1329 12 DefaultModLatestView->processMatch() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:107 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.60 ms Nach letzter Abfrage: 3.21 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 18.853 MB Zeilen zurückgegeben: 23
SELECT c.*
FROM mve3stable_categories as c
WHERE extension='com_jevents'
order by c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref cat_idx cat_idx 202 const 23 100.00 Using index condition; filesort wurde genutzt Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/commonfunctions.php:191 14 JEV_CommonFunctions::getCategoryData() JROOT/components/com_jevents/libraries/commonfunctions.php:144 13 JEV_CommonFunctions::setColor() JROOT/components/com_jevents/libraries/jeventcal.php:598 12 jEventCal->bgcolor() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:111 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 89.49 ms Nach letzter Abfrage: 5.57 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.063 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `ip` = '54.144.81.21'
AND (`tm` + '3600') > '1711671748'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 89.15 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:105 11 ModVisitorcounterHelper->countRequest() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:32 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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.64 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 19.069 MB
INSERT INTO `mve3stable_vcnt` (`tm`, `ip`)
VALUES ('1711671748', '54.144.81.21')„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `mve3stable_vcnt` (`tm`, `ip`) VALUES ('1711671748', '54.144.81.21')Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.05 ms end 0.00 ms query end 2.31 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/modules/mod_visitorcounter/helper.php:111 11 ModVisitorcounterHelper->countRequest() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:32 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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: 71.77 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.075 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `tm` < '1708560000'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 33.33 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 71.42 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:220 11 ModVisitorcounterHelper->cleanDatabase() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:37 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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.98 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 19.081 MB Zeilen zurückgegeben: 77
SELECT `guest`, `client_id` , `username`, `userid`
FROM `mve3stable_session`
WHERE `client_id` = 0
AND `time` > '1711671148'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_session NULL ref time,client_id_guest client_id_guest 2 const 244 36.32 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.50 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_visitorcounter/helper.php:250 11 ModVisitorcounterHelper->whoIsOnline() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:45 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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: 522.22 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.090 MB Zeilen zurückgegeben: 6
SELECT count(*)
FROM `mve3stable_vcnt` UNION ALL SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `tm` > '1711670400' UNION ALL SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `tm` > '1711584000' && `tm` < '1711670400' UNION ALL SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `tm` >= '1711324800' UNION ALL SELECT count(*)
FROM `mve3stable_vcnt`
WHERE `tm` >= '1709251200' UNION ALL SELECT `cnt`
FROM `mve3stable_vcnt_pc`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 100.00 NULL 2 UNION mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 33.33 Using where 3 UNION mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 11.11 Using where 4 UNION mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 33.33 Using where 5 UNION mve3stable_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 161685 33.33 Using where 6 UNION mve3stable_vcnt_pc NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.01 ms optimizing 0.00 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 104.53 ms executing 0.03 ms Sending data 169.64 ms executing 0.03 ms Sending data 93.77 ms executing 0.02 ms Sending data 77.22 ms executing 0.02 ms Sending data 76.34 ms executing 0.03 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 12 JDatabaseDriver->loadRowList() JROOT/modules/mod_visitorcounter/helper.php:181 11 ModVisitorcounterHelper->getData() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:71 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.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.59 ms Nach letzter Abfrage: 19.90 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.907 MB Zeilen zurückgegeben: 1
SELECT `alias`
FROM `mve3stable_content`
WHERE id = '76'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_content 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.08 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.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 19.919 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 `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_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 = 93
ORDER BY c.lftid 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.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.925 MB Zeilen zurückgegeben: 1
SELECT alias
FROM mve3stable_content
WHERE id=76id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE mve3stable_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
33 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
4 × SELECT *, summary as title, description as content
FROM mve3stable_jevents_translation4 × 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 `mve3stable_categories` AS `s`
INNER JOIN `mve3stable_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)4 × SELECT `m`.`tag_id`,`t`.*
FROM `mve3stable_contentitem_tag_map` AS m
INNER JOIN `mve3stable_tags` AS t
ON `m`.`tag_id` = `t`.`id`3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mve3stable_jevents_repetition as rpt
INNER JOIN mve3stable_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN mve3stable_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN mve3stable_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mve3stable_jevents_rrule as rr
ON rr.eventid = rpt.eventid2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mve3stable_extensions`2 × SELECT count(*)
FROM `mve3stable_vcnt`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mve3stable_assets`2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM mve3stable_content AS a
LEFT JOIN mve3stable_categories AS c
ON c.id = a.catid
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_by
LEFT JOIN mve3stable_users AS uam
ON uam.id = a.modified_by
LEFT JOIN mve3stable_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mve3stable_content_rating AS v
ON a.id = v.content_id2 × SELECT c.id
FROM mve3stable_categories AS c2 × 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 mve3stable_fields AS a
LEFT JOIN `mve3stable_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mve3stable_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mve3stable_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mve3stable_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mve3stable_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 `mve3stable_categories` AS `c`1 × SELECT `alias`
FROM `mve3stable_content`1 × SELECT count(*)
FROM `mve3stable_vcnt` UNION ALL SELECT count(*)
FROM `mve3stable_vcnt`1 × SELECT `guest`, `client_id` , `username`, `userid`
FROM `mve3stable_session`1 × SELECT c.*
FROM mve3stable_categories as c1 × SELECT `c2`.`language`,`c2`.`id`
FROM `mve3stable_menu` AS `c`
INNER JOIN `mve3stable_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mve3stable_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mve3stable_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT `data`
FROM `mve3stable_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mve3stable_modules AS m
LEFT JOIN mve3stable_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mve3stable_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 mve3stable_fields AS a
LEFT JOIN `mve3stable_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mve3stable_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mve3stable_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mve3stable_fields_groups AS g
ON g.id = a.group_id1 × SELECT `session_id`
FROM `mve3stable_session`1 × SELECT COUNT(*)
FROM mve3stable_content AS a
LEFT JOIN mve3stable_categories AS c
ON c.id = a.catid
LEFT JOIN mve3stable_users AS ua
ON ua.id = a.created_by
LEFT JOIN mve3stable_users AS uam
ON uam.id = a.modified_by
LEFT JOIN mve3stable_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mve3stable_content_rating AS v
ON a.id = v.content_id1 × 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,( SELECT COUNT(i.`id`)
FROM `mve3stable_content` AS `i`1 × SELECT id, home, template, s.params
FROM mve3stable_template_styles as s
LEFT JOIN mve3stable_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM mve3stable_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM mve3stable_menu AS m
LEFT JOIN mve3stable_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM mve3stable_extensions1 × SELECT b.id
FROM mve3stable_usergroups AS a
LEFT JOIN mve3stable_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `mve3stable_viewlevels1 × SELECT alias
FROM mve3stable_content
Andere Tabellen:
1 × INSERT INTO `mve3stable_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3131623665653461373137316335656263646461636131386133313834373966', 1, 1711671747, 0, '', 01 × UPDATE `mve3stable_extensions`
SET `params` = '{\"mediaversion\":\"7a59bf8af543ddbf865d9dd157ba9578\"}'1 × SHOW FULL COLUMNS
FROM `mve3stable_jev_users1 × INSERT INTO `mve3stable_vcnt` (`tm`, `ip`)
VALUES ('1711671748', '54.144.81.21'
Jubiläum 2008
Im Jahre 2008 feierte der Musikverein sein 125 jähriges bestehen. Zu diesem Jubiläum wurde eine Festschrift erstellt und im Rahmen eines Jubiläumwochenende im April der "Geburtstag" gefeiert.
Die Gemeinde Ettenkirch
Ettenkirch stellt einen Ortsteil der Stadt Friedrichshafen dar und liegt mit seinen 2000 Einwohnern im Zentrum der Region Bodensee-Oberschwaben. Die in 20 Weiler unterteilte Gemeinde ist der nördlichste und flächengrößte Teilort von Friedrichshafen. Die typische Voralpenlandschaft wird hier von der bäuerlichen Landwirtschaft geprägt. Ettenkirch erweist sich als Sonderkulturgebiet, so dass neben der traditionellen Landwirtschaft überwiegend Obst- und Hopfenkulturen angebaut werden. Aufgrund der landschaftlichen Anreize gehört Ettenkirch zur Tourismusregion Bodensee. Ettenkirch bei Wikipedia
Der Musikverein
Der Musikverein Ettenkirch ist in der Gemeinde mit über 300 fördernden Mitgliedern der wichtigste Kulturträger. Die Musikkapelle umfasst 65 aktive Musiker, wobei zusätzlich ca. 30 Jugendliche in Ausbildung stehen.
Das musikalische Jahr beginnt mit närrischem Treiben. Den Auftakt zur Fasnet bildet der vom Musikverein ausgerichtete Elchball. Dieser ist mittlerweile weit über Ettenkirch hinaus bekannt und wird gerne von vielen, vor allem jungen Narren aus nah und fern besucht. Nach diesem Highlight der 5. Jahreszeit begleitet die Musikkapelle die hiesige Narrenzunft fast jedes Jahr zu einem auswärtigen Narrenumzug im schwäbisch-alemannischen Raum. Ein weiterer närrischer Höhepunkt der Ettenkircher Fasnet ist das Stellen des Narrenbaumes. Hier unterstützt und motiviert der Musikverein die Narren und Zimmerleute musikalisch beim Aufstellen des Narrenbaumes. Traditionell werden dann drei Tage später am Fasnetssonntag beim großen Narrensprung in Brochenzell die Galleyengeister begleitet. Das alljährliche Ende der Ettenkircher Fasnet wird mit einem prächtigen Funken gefeiert. Dazu trägt der Musikverein mit unterhaltsamen Stücken bei. Der Funken wird seit einigen Jahren von der Narrenzunft Ettenkirch in Lehorn gebaut und ist dank seiner tollen Lage schon von Weitem zu sehen.
Kurz nach der Fasnet findet dann die Alteisensammlung statt. Bei einer Straßensammlung können die Ettenkircher Bürger ihren Metallschrott los werden, der dann von den Musikern als auch von passiven Mitgliedern fach- und umweltgerecht entsorgt wird. Diese Alteisensammlung ist ein wesentlicher Beitrag für die Musikkasse. Am gleichen Tag wird dann bei der alljährlichen Generalversammlung Rückblick auf das vergangene Jahr gehalten, die Kassenlage durchleuchtet, sowie eventuell anstehende Wahlen der Vereinsvertreter durchgeführt. Ebenso wird der Blick auf das laufende Jahr und die weitere Zukunft gerichtet.
Im Frühjahr stehen traditionell eher die kirchlichen Feiertage im Vordergrund. Mit der musikalischen Begleitung der Palmprozession und der Erstkommunikanten, sowie der Mitgestaltung des Fronleichnamsgottesdienstes und der anschließenden Prozession, wird die Kirchengemeinde unterstützt.
Einen festen Platz im Terminplan hat auch die Feuerwehr mit ihrem traditionellen Frühschoppen am Pfingstmontag.
Im weiteren Frühjahr sowie im Sommer gibt die Musikkapelle bei befreundeten und benachbarten Kapellen bei deren Garten- bzw. Sommerfesten ihre musikalische Visitenkarte ab.
Beim Weilerturnier des Sportvereins messen sich dann die fußballbegeisterten Musikanten mit anderen sportlichen Größen des Ortsteiles Ettenkirch. Zuweilen gibt es auch fußballerisches Kräftemessen mit befreundeten Kapellen der Nachbarschaft (Kehlen, Taldorf...).
Der gesellschaftliche Höhepunkt in Ettenkirch ist das Sommerfest des Musikvereins. An drei Tagen finden jung und alt Unterhaltung für jeden Geschmack. So findet am Freitagabend das junge Publikum an der Open Air Disco, dem sogenannten „Pop Obst Fest“ größtes Gefallen.
Der Sonntag zieht mittlerweile nicht nur Musikliebhaber zum bekannten Ettenkircher Frühschoppen an, auch für die Fans von Oldtimern ist dieser Termin ein absolutes Muss, 2012 inzwischen zum 15. Mal. Für musikalische Unterhaltung ist vom Frühschoppen bis spät in den Abend mit dem Musikverein und seinen befreundeten Kapellen gesorgt.
Beim Ausklang des Festes am Montag mit dem traditionellen Feierabendhock, werden neben der Gemeindebevölkerung auch die ortsansässigen Gewerbebetriebe zum gemütlichen Festausklang eingeladen.
Nach dem anstrengenden Seehasenumzug kurz vor Ferienbeginn und weiteren Gastspielen bei benachbarten Vereinen bei Gartenund Weinfesten, gibt’s eine kurze 2 bis 3-wöchige Pause.
Kaum sind diese Feste und die Pause vorüber, da kündigt sich auch der Volkstrauertag schon an. Bei diesem spielt die Kapelle nach dem Gottesdienst auch bei kaltem und windigen Wetter zum Gedenken an die Toten der beiden Weltkriege vor dem Heldengrab.
Den musikalischen Höhepunkt setzt die Musikkapelle Ettenkirch immer am Samstag vor dem 2. Adventsonntag beim traditionellen Herbstkonzert. Hier präsentieren die Musikerinnen und Musiker von Jugendkapelle (seit 2000) und Gesamtkapelle der Gemeinde und auswärtigen Gästen ihr musikalisches Können.
Auf dem traditionellen Ettenkircher Weihnachtsmarkt unterhält eine kleine Abordnung des Musikvereins die Besucher bei Glühwein mit weihnachtlichen Klängen.
Der letzte musikalische Auftritt ist das Weihnachtsspielen am 23. Dezember, vier bis fünf Gruppen der Kapelle stimmen die Ettenkircher mit weihnachtlichen Weisen auf das große Fest ein.
So ist der Musikverein nicht wegzudenken aus der Geschichte und dem Gemeindeleben Ettenkirchs, er ist fester Bestandteil im Ortsgeschehen und Garant für gelungene Feste.
Jugendausbildung
Der Musikverein hat in den letzten Jahren seine Aktivitäten im Bereich der Jugendausbildung enorm ausgeweitet. Jugendarbeit und Jugendausbildung sind wichtige Beiträge zur gesellschaftlichen Integration. Qualität und Quantität der Jugendausbildung sind wesentliche Faktoren für einen dauerhaften Fortbestand der Musikkapelle. In den vergangenen Jahren wurde viel in die Jugendarbeit insbesondere im finanziellen Bereich investiert.
Die Ausbildung der Jugendlichen wird vom Musikverein organisiert, d. h. der Verein vermittelt einen entsprechenden Platz an einer Musikschule oder verpflichtet geeignete Privatlehrer. Hierbei wird besonderes mit der städt. Musikschule Friedrichshafen und der Musikschule Meckenbeuren zusammengearbeitet. In der Jugendkapelle spielen derzeit 27 Jugendliche im Alter zwischen 11 und 18 Jahren. Seit Dezember 2011 steht die Jugendkapelle unter der Leitung von Carina Wielath. Unterstützt wird sie durch Jugendleiter Tobias Wieland.
für weitere Informationen: Startseite Juka