Events & Fun
Markus Herrmann
Zelglistrasse
4600 Olten
Telefon: 079 722 98 59
Im Verein seit
2009
Hobbys
EHCO, Kino, Fussball, Lacoste
Motto
«just do it»
Vereinsanlässe
No events
Termine
Cheftrainer
Urban Kohler
Ruttigerweg 4
4600 Olten
Mobile 079 323 30 22
Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Ausbildung
J+S Leiter (Trainer C)
Im Verein seit
2010
Hobbys
EHCO, Inline-Skating, Kino, Wandern, Aareschwömme
Ferienplan
10. April 2023
Frühlingsferien
Montag, 10. April 2023 – Dienstag, 25. April 2023
10. Juli 2023
Sommerferien
Montag, 10. Juli 2023 – Dienstag, 15. August 2023
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1680255289,
"last": 1680255289,
"now": 1680255289
},
"token": "84BoNQrgAAdPjf0K777hX9SLI1exMGLT"
},
"registry": {
"jevents": {
"moduleid135": {
"shownEventIds": [],
"page": 0,
"firstEventDate": false
},
"moduleid134": {
"shownEventIds": [
[
"68",
"69"
]
],
"page": 0,
"firstEventDate": "2023-04-10 08:00:00",
"lastEventDate": "2023-07-10 08: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
}
}
}
Zeit
Speicher
Zeit: 2.33 ms / 2.33 ms Speicher: 0.419 MB / 0.75 MB Application: afterLoad
Zeit: 14.85 ms / 17.19 ms Speicher: 0.876 MB / 1.63 MB Application: afterInitialise
Zeit: 10.86 ms / 28.05 ms Speicher: 1.160 MB / 2.79 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.05 ms / 29.09 ms Speicher: 0.059 MB / 2.85 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 29.12 ms Speicher: -0.002 MB / 2.84 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.13 ms / 29.24 ms Speicher: 0.008 MB / 2.85 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 0.03 ms / 29.28 ms Speicher: -0.020 MB / 2.83 MB Application: afterRoute
Zeit: 2.18 ms / 31.46 ms Speicher: 0.068 MB / 2.90 MB Application: beforeRenderComponent com_content
Zeit: 2.73 ms / 34.19 ms Speicher: 0.199 MB / 3.10 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.04 ms / 34.23 ms Speicher: 0.007 MB / 3.11 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 8.67 ms / 42.90 ms Speicher: 0.459 MB / 3.56 MB Application: beforeRenderModule mod_jevents_latest (JEvents - Latest Events Module (Anlässe))
Zeit: 24.86 ms / 67.76 ms Speicher: 0.171 MB / 3.74 MB Application: Before Access::getAssetRules (id:63 name:com_jevents)
Zeit: 0.02 ms / 67.78 ms Speicher: 0.002 MB / 3.74 MB Application: After Access::getAssetRules (id:63 name:com_jevents)
Zeit: 30.65 ms / 98.43 ms Speicher: 0.302 MB / 4.04 MB Application: afterRenderRawModule mod_jevents_latest (JEvents - Latest Events Module (Anlässe))
Zeit: 0.01 ms / 98.44 ms Speicher: -0.004 MB / 4.03 MB Application: beforeRenderModule mod_jevents_latest (JEvents - Latest Events Module (Anlässe))
Zeit: 0.79 ms / 99.23 ms Speicher: 0.051 MB / 4.09 MB Application: afterRenderModule mod_jevents_latest (JEvents - Latest Events Module (Anlässe))
Zeit: 0.62 ms / 99.86 ms Speicher: 0.009 MB / 4.09 MB Application: beforeRenderModule mod_jevents_latest (JEvents - Latest Events Module (Ferien))
Zeit: 20.92 ms / 120.78 ms Speicher: 0.207 MB / 4.30 MB Application: afterRenderRawModule mod_jevents_latest (JEvents - Latest Events Module (Ferien))
Zeit: 0.02 ms / 120.79 ms Speicher: -0.034 MB / 4.27 MB Application: beforeRenderModule mod_jevents_latest (JEvents - Latest Events Module (Ferien))
Zeit: 0.21 ms / 121.00 ms Speicher: 0.002 MB / 4.27 MB Application: afterRenderModule mod_jevents_latest (JEvents - Latest Events Module (Ferien))
Zeit: 3.74 ms / 124.74 ms Speicher: 0.006 MB / 4.28 MB Application: afterRenderComponent com_content
Zeit: 0.63 ms / 125.37 ms Speicher: 0.008 MB / 4.28 MB Application: afterDispatch
Zeit: 1.36 ms / 126.73 ms Speicher: 0.113 MB / 4.40 MB Application: beforeRenderModule mod_custom (Footer (rechts))
Zeit: 0.44 ms / 127.18 ms Speicher: 0.004 MB / 4.40 MB Application: afterRenderRawModule mod_custom (Footer (rechts))
Zeit: 0.01 ms / 127.19 ms Speicher: -0.001 MB / 4.40 MB Application: beforeRenderModule mod_custom (Footer (rechts))
Zeit: 0.18 ms / 127.37 ms Speicher: 0.002 MB / 4.40 MB Application: afterRenderModule mod_custom (Footer (rechts))
Zeit: 0.04 ms / 127.41 ms Speicher: 0.001 MB / 4.40 MB Application: beforeRenderModule mod_custom (Footer (links))
Zeit: 0.07 ms / 127.48 ms Speicher: 0.001 MB / 4.40 MB Application: afterRenderRawModule mod_custom (Footer (links))
Zeit: 0.01 ms / 127.48 ms Speicher: 0.001 MB / 4.40 MB Application: beforeRenderModule mod_custom (Footer (links))
Zeit: 0.14 ms / 127.63 ms Speicher: 0.002 MB / 4.41 MB Application: afterRenderModule mod_custom (Footer (links))
Zeit: 0.03 ms / 127.66 ms Speicher: 0.002 MB / 4.41 MB Application: beforeRenderModule mod_menu (Login)
Zeit: 0.80 ms / 128.46 ms Speicher: 0.017 MB / 4.43 MB Application: afterRenderRawModule mod_menu (Login)
Zeit: 0.01 ms / 128.47 ms Speicher: -0.002 MB / 4.42 MB Application: beforeRenderModule mod_menu (Login)
Zeit: 0.16 ms / 128.63 ms Speicher: 0.004 MB / 4.43 MB Application: afterRenderModule mod_menu (Login)
Zeit: 2.34 ms / 130.97 ms Speicher: 0.190 MB / 4.62 MB Application: afterRender
Datenbankabfragen gesamt: 23.06 ms
5,15 MB (5.400.304 Bytes)
35 ausgeführte Abfragen 23.06 ms
- Abfragezeit: 0.40 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.030 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jsmwh_session`
WHERE `session_id` = X'336c357463666e3375357063726a686e383667646e6834636f63333773736439'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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.29 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.045 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jsmwh_session`
WHERE `session_id` = X'336c357463666e3375357063726a686e383667646e6834636f63333773736439'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.050 MB
INSERT INTO `jsmwh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336c357463666e3375357063726a686e383667646e6834636f63333773736439', 1, 1680255289, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jsmwh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'336c357463666e3375357063726a686e383667646e6834636f63333773736439', 1, 1680255289, 0, '', 0)Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init for update 0.01 ms Update 0.06 ms Waiting for query cache lock 0.00 ms Update 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.081 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_extensions ref extension extension 82 const 40 Using index condition; Using where Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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.33 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.117 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jsmwh_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 Status Duration Starting 0.01 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.129 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jsmwh_usergroups AS a
LEFT JOIN jsmwh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.151 MB Zeilen zurückgegeben: 102
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jsmwh_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_extensions ref extension extension 82 const 124 Using index condition; Using where; filesort wurde genutzt Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.37 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.73 ms Nach letzter Abfrage: 6.03 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 1.654 MB Zeilen zurückgegeben: 43
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jsmwh_menu AS m
LEFT JOIN jsmwh_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 43 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.m.component_id 1 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.27 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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.62 ms Nach letzter Abfrage: 6.00 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.481 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM jsmwh_template_styles as s
LEFT JOIN jsmwh_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 ttcolte_jo35.s.template,const 1 Using index condition; Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:345 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.91 ms Nach letzter Abfrage: 3.25 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.790 MB Zeilen zurückgegeben: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jsmwh_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper','com_zoo')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_assets ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 395 Using where Status Duration Starting 0.03 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.44 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 14 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 13 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 12 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 11 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 10 Joomla\CMS\User\User->authorise() JROOT/plugins/system/sourcerer/helper.php:55 9 plgSystemSourcererHelper->__construct() JROOT/plugins/system/sourcerer/sourcerer.php:96 8 plgSystemSourcerer->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.850 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.841 MB
UPDATE `jsmwh_extensions`
SET `params` = '{\"mediaversion\":\"a998c3c782bb2288de362013c3d5eb71\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `jsmwh_extensions` SET `params` = '{\"mediaversion\":\"a998c3c782bb2288de362013c3d5eb71\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms Init for update 0.03 ms Updating 0.04 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 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.38 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.870 MB Zeilen zurückgegeben: 2
SELECT *
FROM jsmwh_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_languages ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 Using where; filesort wurde genutzt Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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.12 ms Nach letzter Abfrage: 3.78 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.136 MB Zeilen zurückgegeben: 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,fp.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
FROM jsmwh_content AS a
INNER JOIN jsmwh_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jsmwh_categories AS c
ON c.id = a.catid
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_by
LEFT JOIN jsmwh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jsmwh_categories as parent
ON parent.id = c.parent_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-31 09:34:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-31 09:34:49')
AND a.catid IN (36)
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 105id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; filesort wurde genutzt 1 SIMPLE a ref PRIMARY,idx_access,idx_state,idx_catid idx_catid 4 const 2 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE fp eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.id 1 Using where Status Duration Starting 0.11 ms Checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.22 ms Creating sort index 0.04 ms Removing tmp table 0.04 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425 11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->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.42 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.185 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jsmwh_contentitem_tag_map` AS m
INNER JOIN `jsmwh_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 59
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ttcolte_jo35.m.tag_id 1 Using where Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425 11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->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.38 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.203 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jsmwh_contentitem_tag_map` AS m
INNER JOIN `jsmwh_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 57
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ttcolte_jo35.m.tag_id 1 Using where Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425 11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->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.54 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.285 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM jsmwh_content AS a
INNER JOIN jsmwh_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jsmwh_categories AS c
ON c.id = a.catid
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_by
LEFT JOIN jsmwh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jsmwh_categories as parent
ON parent.id = c.parent_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-31 09:34:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-31 09:34:49')
AND a.catid IN (36)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref PRIMARY,idx_access,idx_state,idx_catid idx_catid 4 const 2 Using where 1 SIMPLE fp eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.id 1 Using where; Using index Status Duration Starting 0.04 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425 11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->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.54 ms Nach letzter Abfrage: 1.08 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.387 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 `jsmwh_categories` AS `s`
INNER JOIN `jsmwh_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 = 36
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 Using where; filesort wurde genutzt Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 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/featured/view.html.php:102 10 ContentViewFeatured->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.74 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.408 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jsmwh_fields AS a
LEFT JOIN `jsmwh_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jsmwh_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jsmwh_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jsmwh_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jsmwh_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 (36,0))
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 type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 ttcolte_jo35.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 ttcolte_jo35.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 ttcolte_jo35.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.14 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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/featured/view.html.php:102 10 ContentViewFeatured->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.66 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.534 MB Zeilen zurückgegeben: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jsmwh_modules AS m
LEFT JOIN jsmwh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jsmwh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-31 09:34:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-31 09:34:49')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 107 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 31 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE mm ref PRIMARY PRIMARY 4 ttcolte_jo35.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 ttcolte_jo35.m.module,const 1 Using index condition; Using where Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.21 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441 17 Joomla\CMS\Helper\_ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371 16 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:670 15 Joomla\CMS\Helper\_ModuleHelper::getModuleById() JROOT/plugins/content/loadmodule/loadmodule.php:237 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.05 ms Nach letzter Abfrage: 44.19 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 3.835 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `jsmwh_jev_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jsmwh_jev_users`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.13 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.32 ms After opening tables 0.01 ms Checking permissions 0.06 ms Closing tables 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Removing tmp table 0.04 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 28 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 27 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1615 26 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1470 25 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:61 24 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 23 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 22 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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: 2.57 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 3.883 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 `jsmwh_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 type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL cat_idx,idx_access ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 Using where; filesort wurde genutzt Status Duration Starting 0.05 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.08 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 28 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 27 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:411 26 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 25 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 24 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 23 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 22 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.13 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.922 MB Zeilen zurückgegeben: 5
SELECT c.id
FROM jsmwh_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'
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access,idx_language cat_idx 207 NULL 6 Using index condition; Using where; filesort wurde genutzt Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.14 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 27 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:542 26 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1020 25 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 24 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 23 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 22 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1255 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.39 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.945 MB Zeilen zurückgegeben: 1
SELECT c.id
FROM jsmwh_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>=17
AND c.rgt<=18 ))
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 6 Using index condition; Using where; filesort wurde genutzt Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 23 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:542 22 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:1300 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.03 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 3.972 MB Zeilen zurückgegeben: 0
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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11)
AND rpt.endrepeat >= '2023-03-31 11:34:49'
AND rpt.startrepeat <= '2024-05-04 23:59:59'
AND (rpt.startrepeat >= '2023-03-31 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 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.50 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.37 ms Preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.41 ms Creating sort index 0.03 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1868 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.92 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.047 MB Zeilen zurückgegeben: 0
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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11)
AND rpt.endrepeat >= '2023-03-31 00:00:00'
AND rpt.startrepeat <= '2023-03-31 11:34:49'
AND (rpt.startrepeat >= '2023-03-31 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 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1926 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.91 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.059 MB Zeilen zurückgegeben: 0
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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11)
AND rpt.endrepeat >= '2023-03-31 00:00:00'
AND rpt.startrepeat <= '2023-03-31 11:34:49'
AND (rpt.startrepeat <= '2023-03-31 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 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.16 ms Creating sort index 0.02 ms Removing tmp table 0.02 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1983 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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: 2.68 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.117 MB Zeilen zurückgegeben: 1
SELECT c.id
FROM jsmwh_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>=83
AND c.rgt<=84 ))
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref cat_idx,idx_access,idx_left_right,idx_language cat_idx 203 const,const 6 Using index condition; Using where; filesort wurde genutzt Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 23 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:542 22 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:1300 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.08 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 4.143 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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,32)
AND rpt.endrepeat >= '2023-03-31 11:34:49'
AND rpt.startrepeat <= '2025-06-08 23:59:59'
AND (rpt.startrepeat >= '2023-03-31 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 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.36 ms Creating sort index 0.05 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1868 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.67 ms Nach letzter Abfrage: 8.09 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.267 MB Zeilen zurückgegeben: 0Doppelte Abfragen: #33
SELECT *, summary as title, description as content
FROM jsmwh_jevents_translation
WHERE evdet_id IN(68,69)
AND language='de-DE'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_jevents_translation ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.18 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:736 24 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:3268 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1868 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.77 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.280 MB Zeilen zurückgegeben: 0
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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,32)
AND rpt.endrepeat >= '2023-03-31 00:00:00'
AND rpt.startrepeat <= '2023-03-31 11:34:49'
AND (rpt.startrepeat >= '2023-03-31 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 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.93 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1926 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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: 0.10 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 4.292 MB Zeilen zurückgegeben: 0
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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,32)
AND rpt.endrepeat >= '2023-03-31 00:00:00'
AND rpt.startrepeat <= '2023-03-31 11:34:49'
AND (rpt.startrepeat <= '2023-03-31 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 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE icsf ref PRIMARY,stateidx stateidx 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE rpt range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 Using index condition; Using where 1 SIMPLE rr ref eventid eventid 4 ttcolte_jo35.rpt.eventid 1 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 ttcolte_jo35.rpt.eventid 1 Using where 1 SIMPLE det eq_ref PRIMARY,multiday PRIMARY 4 ttcolte_jo35.rpt.eventdetail_id 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.01 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.16 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:3232 23 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 22 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1983 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.32 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.294 MB Zeilen zurückgegeben: 0Doppelte Abfragen: #30
SELECT *, summary as title, description as content
FROM jsmwh_jevents_translation
WHERE evdet_id IN(68,69)
AND language='de-DE'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jsmwh_jevents_translation ALL evdet_id,langdetail ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where Status Duration Starting 0.02 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:736 22 JEventsDBModel::translateEvents() JROOT/components/com_jevents/libraries/dbmodel.php:2053 21 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634 20 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35 19 ExtModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 18 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 17 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 16 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 15 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmodule/loadmodule.php:243 14 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 13 PlgContentLoadmodule->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/featured/view.html.php:102 10 ContentViewFeatured->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.35 ms Nach letzter Abfrage: 8.44 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.278 MB Zeilen zurückgegeben: 1
SELECT note,created_by_alias
FROM `jsmwh_content` AS `a`
WHERE `a`.`id` = 59id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/templates/purity_iii/html/com_content/featured/default.php:60 13 include JROOT/templates/purity_iii/html/com_content/featured/default.php JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 12 Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 11 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_content/views/featured/view.html.php:164 10 ContentViewFeatured->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.32 ms Nach letzter Abfrage: 0.92 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.290 MB Zeilen zurückgegeben: 1
SELECT note,created_by_alias
FROM `jsmwh_content` AS `a`
WHERE `a`.`id` = 57id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/templates/purity_iii/html/com_content/featured/default.php:60 13 include JROOT/templates/purity_iii/html/com_content/featured/default.php JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701 12 Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230 11 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_content/views/featured/view.html.php:164 10 ContentViewFeatured->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
24 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
6 × 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 jsmwh_jevents_repetition as rpt
INNER JOIN jsmwh_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN jsmwh_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN jsmwh_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jsmwh_jevents_rrule as rr
ON rr.eventid = rpt.eventid3 × SELECT c.id
FROM jsmwh_categories AS c2 × SELECT note,created_by_alias
FROM `jsmwh_content` AS `a`2 × SELECT `m`.`tag_id`,`t`.*
FROM `jsmwh_contentitem_tag_map` AS m
INNER JOIN `jsmwh_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsmwh_extensions`2 × SELECT *, summary as title, description as content
FROM jsmwh_jevents_translation1 × 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 `jsmwh_categories` AS `c`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jsmwh_modules AS m
LEFT JOIN jsmwh_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jsmwh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_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 jsmwh_fields AS a
LEFT JOIN `jsmwh_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jsmwh_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jsmwh_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jsmwh_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jsmwh_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 `jsmwh_categories` AS `s`
INNER JOIN `jsmwh_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT COUNT(*)
FROM jsmwh_content AS a
INNER JOIN jsmwh_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jsmwh_categories AS c
ON c.id = a.catid
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_by
LEFT JOIN jsmwh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jsmwh_categories as parent
ON parent.id = c.parent_id1 × SELECT `data`
FROM `jsmwh_session`1 × SELECT `session_id`
FROM `jsmwh_session`1 × SELECT *
FROM jsmwh_languages1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jsmwh_assets`1 × SELECT id, home, template, s.params
FROM jsmwh_template_styles as s
LEFT JOIN jsmwh_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jsmwh_menu AS m
LEFT JOIN jsmwh_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jsmwh_extensions1 × SELECT b.id
FROM jsmwh_usergroups AS a
LEFT JOIN jsmwh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jsmwh_viewlevels1 × 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,fp.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
FROM jsmwh_content AS a
INNER JOIN jsmwh_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jsmwh_categories AS c
ON c.id = a.catid
LEFT JOIN jsmwh_users AS ua
ON ua.id = a.created_by
LEFT JOIN jsmwh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jsmwh_categories as parent
ON parent.id = c.parent_id
Andere Tabellen:
1 × INSERT INTO `jsmwh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336c357463666e3375357063726a686e383667646e6834636f63333773736439', 1, 1680255289, 0, '', 01 × UPDATE `jsmwh_extensions`
SET `params` = '{\"mediaversion\":\"a998c3c782bb2288de362013c3d5eb71\"}'1 × SHOW FULL COLUMNS
FROM `jsmwh_jev_users