Neues aus
Sponsored by
Besucherzähler
Unser Königspaar
Daniel Döring
und
Tanja Döring
Terminvorschau
| Keine Termine |
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1702237444,
"last": 1702237444,
"now": 1702237444
},
"token": "0MBSPg2bXaWP7VUU6vxgtASM7xh6TUPE"
},
"registry": {
"jevents": {
"moduleid95": {
"shownEventIds": [],
"page": 0,
"firstEventDate": false
}
},
"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: 252.41 ms / 252.41 ms Speicher: 1.797 MB / 2.17 MB Application: afterLoad
Zeit: 394.80 ms / 647.22 ms Speicher: 3.932 MB / 6.10 MB Application: afterInitialise
Zeit: 176.44 ms / 823.66 ms Speicher: 1.265 MB / 7.36 MB Application: afterRoute
Zeit: 14.06 ms / 837.72 ms Speicher: 0.032 MB / 7.40 MB Application: beforeRenderComponent com_content
Zeit: 67.35 ms / 905.06 ms Speicher: 0.661 MB / 8.06 MB Application: Before Access::preloadComponents (all components)
Zeit: 2.85 ms / 907.92 ms Speicher: 0.065 MB / 8.12 MB Application: After Access::preloadComponents (all components)
Zeit: 0.07 ms / 907.99 ms Speicher: 0.000 MB / 8.12 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 4.98 ms / 912.97 ms Speicher: 0.026 MB / 8.14 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 394.03 ms / 1307.00 ms Speicher: 2.323 MB / 10.47 MB Application: afterRenderComponent com_content
Zeit: 8.81 ms / 1315.80 ms Speicher: 0.005 MB / 10.47 MB Application: afterDispatch
Zeit: 59.32 ms / 1375.12 ms Speicher: 0.177 MB / 10.65 MB Application: beforeRenderModule mod_custom (Unser Königspaar)
Zeit: 18.01 ms / 1393.13 ms Speicher: 0.057 MB / 10.71 MB Application: afterRenderModule mod_custom (Unser Königspaar)
Zeit: 0.08 ms / 1393.22 ms Speicher: 0.003 MB / 10.71 MB Application: beforeRenderModule mod_jevents_latest (Terminvorschau)
Zeit: 142.21 ms / 1535.43 ms Speicher: 1.199 MB / 11.91 MB Application: Before Access::getAssetRules (id:40 name:com_jevents)
Zeit: 0.06 ms / 1535.49 ms Speicher: 0.007 MB / 11.91 MB Application: After Access::getAssetRules (id:40 name:com_jevents)
Zeit: 162.72 ms / 1698.21 ms Speicher: 1.675 MB / 13.59 MB Application: afterRenderModule mod_jevents_latest (Terminvorschau)
Zeit: 0.11 ms / 1698.32 ms Speicher: 0.000 MB / 13.58 MB Application: beforeRenderModule mod_menu (Hauptmenü)
Zeit: 33.67 ms / 1731.99 ms Speicher: 0.063 MB / 13.65 MB Application: afterRenderModule mod_menu (Hauptmenü)
Zeit: 0.08 ms / 1732.07 ms Speicher: 0.000 MB / 13.64 MB Application: beforeRenderModule mod_banners (Neues aus)
Zeit: 53.00 ms / 1785.06 ms Speicher: 0.113 MB / 13.76 MB Application: afterRenderModule mod_banners (Neues aus)
Zeit: 0.07 ms / 1785.13 ms Speicher: 0.000 MB / 13.75 MB Application: beforeRenderModule mod_banners (Sponsored by)
Zeit: 13.80 ms / 1798.93 ms Speicher: 0.031 MB / 13.78 MB Application: afterRenderModule mod_banners (Sponsored by)
Zeit: 0.09 ms / 1799.01 ms Speicher: 0.000 MB / 13.78 MB Application: beforeRenderModule mod_visitorcounter (Besucherzähler)
Zeit: 27.87 ms / 1826.88 ms Speicher: 0.117 MB / 13.90 MB Application: afterRenderModule mod_visitorcounter (Besucherzähler)
Zeit: 0.14 ms / 1827.02 ms Speicher: 0.000 MB / 13.89 MB Application: beforeRenderModule mod_menu (Top Menu)
Zeit: 11.50 ms / 1838.51 ms Speicher: 0.031 MB / 13.92 MB Application: afterRenderModule mod_menu (Top Menu)
Zeit: 5.22 ms / 1843.74 ms Speicher: 0.069 MB / 13.99 MB Application: afterRender
Datenbankabfragen gesamt: 101.80 ms
14,65 MB (15.358.480 Bytes)
43 ausgeführte Abfragen 101.80 ms
- Abfragezeit: 2.00 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.851 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `y67wx_session`
WHERE `session_id` = 'bcreefadnli5h3loj0qm8bhfcq'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 2.81 ms Nach letzter Abfrage: 14.46 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.009 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `y67wx_session`
WHERE `session_id` = 'bcreefadnli5h3loj0qm8bhfcq'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 9.72 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.014 MB
INSERT INTO `y67wx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bcreefadnli5h3loj0qm8bhfcq', 1, 1702237444, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `y67wx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('bcreefadnli5h3loj0qm8bhfcq', 1, 1702237444, 0, '', 0)Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.14 ms end 0.01 ms query end 8.62 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 2.09 ms Nach letzter Abfrage: 34.78 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 4.229 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `y67wx_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_extensions NULL ref extension extension 82 const 40 1.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.25 ms Nach letzter Abfrage: 22.42 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.430 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `y67wx_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.73 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.441 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM y67wx_usergroups AS a
LEFT JOIN y67wx_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.52 ms Nach letzter Abfrage: 4.48 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.510 MB Zeilen zurückgegeben: 97
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM y67wx_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_extensions NULL ref extension extension 82 const 119 0.40 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.73 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 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:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.18 ms Nach letzter Abfrage: 152.78 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 6.343 MB Zeilen zurückgegeben: 36
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 y67wx_menu AS m
LEFT JOIN y67wx_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 40 10.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 DB1335806.m.component_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.03 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.76 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 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:64 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:491 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:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.24 ms Nach letzter Abfrage: 134.31 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 7.097 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `y67wx_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.02 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 8 plgSystemJCKtypography->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.35 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.090 MB
UPDATE `y67wx_extensions`
SET `params` = '{\"mediaversion\":\"8e49fdabb452ae3caa8a930d1e6d6d7d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE y67wx_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.06 ms updating 0.09 ms end 0.03 ms query end 2.22 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 8 plgSystemJCKtypography->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.68 ms Nach letzter Abfrage: 12.59 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 7.377 MB Zeilen zurückgegeben: 1
SELECT *
FROM y67wx_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_languages NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where; filesort wurde genutzt Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.84 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 7.391 MB Zeilen zurückgegeben: 6
SELECT id, home, template, s.params
FROM y67wx_template_styles as s
LEFT JOIN y67wx_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 9 11.11 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 DB1335806.s.template,const 1 4.44 Using index condition; Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.22 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.42 ms Nach letzter Abfrage: 77.03 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 8.061 MB Zeilen zurückgegeben: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `y67wx_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_allvideoshare','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_joomgallery','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_weblinks','com_wrapper','com_xcloner-backupandrestore')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_assets NULL range idx_asset_name idx_asset_name 202 NULL 41 100.00 Using index condition Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.11 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.22 ms preparing 0.02 ms executing 0.01 ms Sending data 0.64 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:44 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 5.63 ms Nach letzter Abfrage: 12.38 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 8.202 MB Zeilen zurückgegeben: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM y67wx_content AS a
INNER JOIN y67wx_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN y67wx_categories AS c
ON c.id = a.catid
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_by
LEFT JOIN y67wx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN y67wx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y67wx_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-10 19:44:04')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-10 19:44:04')
ORDER BY 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 10, 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fp NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 23 100.00 Using temporary; filesort wurde genutzt 1 SIMPLE a NULL eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 DB1335806.fp.content_id 1 10.74 Using where 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 DB1335806.a.catid 1 10.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 DB1335806.c.parent_id 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.id 1 100.00 Using where Status Duration starting 0.24 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 1.22 ms init 0.13 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.05 ms Creating tmp table 0.17 ms Sorting result 0.01 ms executing 0.01 ms Sending data 2.17 ms Creating sort index 0.25 ms end 0.01 ms query end 0.01 ms removing tmp table 0.11 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.82 ms Nach letzter Abfrage: 15.36 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 8.459 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 442
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 DB1335806.m.tag_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.44 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.07 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 8.476 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 441
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 DB1335806.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.37 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 8.495 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 433
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 DB1335806.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.86 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 8.512 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 432
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 DB1335806.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.12 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 8.529 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 431
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 DB1335806.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.96 ms Nach letzter Abfrage: 9.04 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 8.610 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM y67wx_content AS a
INNER JOIN y67wx_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN y67wx_categories AS c
ON c.id = a.catid
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_by
LEFT JOIN y67wx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN y67wx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y67wx_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-10 19:44:04')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-10 19:44:04')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fp NULL index PRIMARY PRIMARY 4 NULL 23 100.00 Using index 1 SIMPLE a NULL eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 DB1335806.fp.content_id 1 10.74 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 DB1335806.a.catid 1 10.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 DB1335806.c.parent_id 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.id 1 100.00 Using where; Using index Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.51 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.77 ms Nach letzter Abfrage: 99.30 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 9.306 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 `y67wx_categories` AS `s`
INNER JOIN `y67wx_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)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 59.18 Using index condition; Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.45 ms Nach letzter Abfrage: 3.87 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 9.352 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 y67wx_fields AS a
LEFT JOIN `y67wx_languages` AS l
ON l.lang_code = a.language
LEFT JOIN y67wx_users AS uc
ON uc.id=a.checked_out
LEFT JOIN y67wx_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN y67wx_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `y67wx_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 (8,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 DB1335806.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 DB1335806.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.42 ms init 0.07 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.33 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.10 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 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:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.52 ms Nach letzter Abfrage: 68.03 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 9.786 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `y67wx_categories` AS `s`
INNER JOIN `y67wx_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)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 4 59.18 Using index condition; Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.87 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 9.798 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 y67wx_fields AS a
LEFT JOIN `y67wx_languages` AS l
ON l.lang_code = a.language
LEFT JOIN y67wx_users AS uc
ON uc.id=a.checked_out
LEFT JOIN y67wx_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN y67wx_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `y67wx_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 (2,0,9))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 DB1335806.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 DB1335806.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.31 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 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:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.95 ms Nach letzter Abfrage: 217.12 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 10.614 MB Zeilen zurückgegeben: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM y67wx_modules AS m
LEFT JOIN y67wx_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN y67wx_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-12-10 19:44:04')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-10 19:44:04')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 19 2.56 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 DB1335806.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 DB1335806.m.id 2 40.00 Using where; Using index Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.49 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/siteground-j16-12/index.php:64 7 require JROOT/templates/siteground-j16-12/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.92 ms Nach letzter Abfrage: 287.08 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 13.295 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `y67wx_jev_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `y67wx_jev_users`Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.16 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.09 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 20 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:75 19 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1544 18 JEVHelper::getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:1399 17 JEVHelper::isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:61 16 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1205 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.17 ms Nach letzter Abfrage: 25.39 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 13.502 MB Zeilen zurückgegeben: 7
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 `y67wx_categories` AS `c`
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access cat_idx 207 NULL 7 100.00 Using index condition; filesort wurde genutzt Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 21 Joomla\CMS\Categories\Categories->_load() JROOT/components/com_jevents/helpers/category.php:53 20 JEventsCategories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/components/com_jevents/libraries/dbmodel.php:401 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1019 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1205 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.31 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 13.546 MB Zeilen zurückgegeben: 6
SELECT c.id
FROM y67wx_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('de-DE','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_language cat_idx 207 NULL 6 100.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.13 ms end 0.01 ms query end 0.05 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 19 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:514 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:1019 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:47 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:180 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:251 14 jevFilterProcessing::getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:1205 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.36 ms Nach letzter Abfrage: 7.11 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 13.576 MB Zeilen zurückgegeben: 5
SELECT c.id
FROM y67wx_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('de-DE','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=47
AND c.rgt<=48 ) OR (c.lft>=49
AND c.rgt<=50 ) OR (c.lft>=51
AND c.rgt<=52 ) OR (c.lft>=53
AND c.rgt<=54 ) OR (c.lft>=57
AND c.rgt<=58 ))
ORDER BY c.lft ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 6 44.30 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 15 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:514 14 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:1248 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.36 ms Nach letzter Abfrage: 3.84 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 13.603 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 y67wx_jevents_repetition as rpt
INNER JOIN y67wx_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN y67wx_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN y67wx_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN y67wx_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11,12,13,14,26)
AND rpt.endrepeat >= '2023-12-10 20:44:05'
AND rpt.startrepeat <= '2024-02-08 23:59:59'
AND (rpt.startrepeat >= '2023-12-10 00:00:00' OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 98.12 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 DB1335806.rpt.eventid 1 41.22 Using where 1 SIMPLE icsf NULL eq_ref PRIMARY,stateidx PRIMARY 4 DB1335806.ev.icsid 1 50.00 Using where 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 DB1335806.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 DB1335806.rpt.eventid 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.34 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.40 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:2933 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1727 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.75 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 13.613 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 y67wx_jevents_repetition as rpt
INNER JOIN y67wx_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN y67wx_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN y67wx_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN y67wx_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11,12,13,14,26)
AND rpt.endrepeat >= '2023-12-10 00:00:00'
AND rpt.startrepeat <= '2023-12-10 20:44:05'
AND (rpt.startrepeat >= '2023-12-10 00:00:00' OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 98.12 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 DB1335806.rpt.eventid 1 41.22 Using where 1 SIMPLE icsf NULL eq_ref PRIMARY,stateidx PRIMARY 4 DB1335806.ev.icsid 1 50.00 Using where 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 DB1335806.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 DB1335806.rpt.eventid 1 100.00 NULL Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.07 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.43 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:2933 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1770 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.96 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 13.622 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 y67wx_jevents_repetition as rpt
INNER JOIN y67wx_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN y67wx_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN y67wx_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN y67wx_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,11,12,13,14,26)
AND rpt.endrepeat >= '2023-12-10 00:00:00'
AND rpt.startrepeat <= '2023-12-10 20:44:05'
AND (rpt.startrepeat <= '2023-12-10 00:00:00'OR det.multiday=1)
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat asc
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt NULL range eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat endrepeat 5 NULL 4 98.12 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE ev NULL eq_ref PRIMARY,icsid,stateidx,evaccess PRIMARY 4 DB1335806.rpt.eventid 1 41.22 Using where 1 SIMPLE icsf NULL eq_ref PRIMARY,stateidx PRIMARY 4 DB1335806.ev.icsid 1 50.00 Using where 1 SIMPLE det NULL eq_ref PRIMARY,multiday PRIMARY 4 DB1335806.rpt.eventdetail_id 1 100.00 Using where 1 SIMPLE rr NULL ref eventid eventid 4 DB1335806.rpt.eventid 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.39 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:2933 15 JEventsDBModel->_cachedlistIcalEvents() JROOT/components/com_jevents/libraries/jevCache.php:74 14 jevCache->call() JROOT/components/com_jevents/libraries/dbmodel.php:1812 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600 12 DefaultModLatestView->getLatestEventsData() JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32 11 GeraintModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.52 ms Nach letzter Abfrage: 60.40 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 13.699 MB Zeilen zurückgegeben: 0Doppelte Abfragen: #36
SELECT *
FROM y67wx_banners
WHERE '2023-12-10 19:44:04' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.49 ms Nach letzter Abfrage: 10.75 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 13.758 MB Zeilen zurückgegeben: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM y67wx_banners as a
LEFT JOIN y67wx_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-10 19:44:04')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-10 19:44:04')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (50)
ORDER BY a.sticky DESC,a.ordering
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_banner_catid 4 const 2 20.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.cid 1 100.00 NULL Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_banners/models/banners.php:205 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.50 ms Nach letzter Abfrage: 2.03 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.770 MB
UPDATE y67wx_banners
SET impmade = (impmade + 1)
WHERE id IN (6)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE y67wx_banners NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.03 ms System lock 0.05 ms updating 0.09 ms end 0.01 ms query end 2.31 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:249 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:54 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.03 ms Nach letzter Abfrage: 8.28 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.774 MB Zeilen zurückgegeben: 0Doppelte Abfragen: #33
SELECT *
FROM y67wx_banners
WHERE '2023-12-10 19:44:04' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.24 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 13.785 MB Zeilen zurückgegeben: 2
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM y67wx_banners as a
LEFT JOIN y67wx_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-10 19:44:04')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-10 19:44:04')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (3)
ORDER BY a.sticky DESC,a.ordering
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_banner_catid 4 const 2 20.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 DB1335806.a.cid 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_banners/models/banners.php:205 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 4.09 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.799 MB
UPDATE y67wx_banners
SET impmade = (impmade + 1)
WHERE id IN (1,2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE y67wx_banners NULL range PRIMARY PRIMARY 4 const 2 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.04 ms updating 0.10 ms end 0.01 ms query end 2.74 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:249 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:54 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.16 ms Nach letzter Abfrage: 16.32 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.888 MB
CREATE TABLE IF NOT EXISTS `y67wx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(45) NOT NULL DEFAULT '0.0.0.0')
„EXPLAIN“ unmöglich für Abfrage: CREATE TABLE IF NOT EXISTS `y67wx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(45) NOT NULL DEFAULT '0.0.0.0')Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.21 ms After create 0.02 ms query end 1.97 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/modules/mod_visitorcounter/helper.php:60 11 ModVisitorcounterHelper->createSqlTables() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:52 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.92 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.894 MB
CREATE TABLE IF NOT EXISTS `y67wx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')
„EXPLAIN“ unmöglich für Abfrage: CREATE TABLE IF NOT EXISTS `y67wx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.13 ms After create 0.01 ms query end 0.95 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/modules/mod_visitorcounter/helper.php:65 11 ModVisitorcounterHelper->createSqlTables() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:52 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.91 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.900 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `y67wx_vcnt_pc`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_vcnt_pc NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 12 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:69 11 ModVisitorcounterHelper->createSqlTables() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:52 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.01 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.906 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `y67wx_vcnt`
WHERE `tm` < '1700694000'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 33.33 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 1.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 12 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:257 11 ModVisitorcounterHelper->cleanDatabase() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:58 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 5.91 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.914 MB Zeilen zurückgegeben: 6
SELECT count(*)
FROM `y67wx_vcnt` UNION ALL SELECT count(*)
FROM `y67wx_vcnt`
WHERE `tm` > '1702162800' UNION ALL SELECT count(*)
FROM `y67wx_vcnt`
WHERE `tm` > '1702076400'
AND `tm` < '1702162800' UNION ALL SELECT count(*)
FROM `y67wx_vcnt`
WHERE `tm` >= '1701644400' UNION ALL SELECT count(*)
FROM `y67wx_vcnt`
WHERE `tm` >= '1701385200' UNION ALL SELECT `cnt`
FROM `y67wx_vcnt_pc`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 100.00 NULL 2 UNION y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 33.33 Using where 3 UNION y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 11.11 Using where 4 UNION y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 33.33 Using where 5 UNION y67wx_vcnt NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 890 33.33 Using where 6 UNION y67wx_vcnt_pc NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.91 ms executing 0.01 ms Sending data 0.93 ms executing 0.01 ms Sending data 0.90 ms executing 0.01 ms Sending data 0.89 ms executing 0.01 ms Sending data 0.90 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1805 12 JDatabaseDriver->loadRowList() JROOT/modules/mod_visitorcounter/helper.php:218 11 ModVisitorcounterHelper->getData() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:72 10 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
5 × SELECT `m`.`tag_id`,`t`.*
FROM `y67wx_contentitem_tag_map` AS m
INNER JOIN `y67wx_tags` AS t
ON `m`.`tag_id` = `t`.`id`3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM y67wx_jevents_repetition as rpt
INNER JOIN y67wx_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
INNER JOIN y67wx_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
INNER JOIN y67wx_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN y67wx_jevents_rrule as rr
ON rr.eventid = rpt.eventid2 × 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 `y67wx_categories` AS `s`
INNER JOIN `y67wx_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `y67wx_extensions`2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM y67wx_banners as a
LEFT JOIN y67wx_banner_clients AS cl
ON cl.id = a.cid2 × SELECT *
FROM y67wx_banners2 × SELECT c.id
FROM y67wx_categories AS c2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM y67wx_fields AS a
LEFT JOIN `y67wx_languages` AS l
ON l.lang_code = a.language
LEFT JOIN y67wx_users AS uc
ON uc.id=a.checked_out
LEFT JOIN y67wx_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN y67wx_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `y67wx_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `y67wx_session`1 × SELECT count(*)
FROM `y67wx_vcnt`1 × SELECT count(*)
FROM `y67wx_vcnt_pc1 × 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 `y67wx_categories` AS `c`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM y67wx_modules AS m
LEFT JOIN y67wx_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN y67wx_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT COUNT(*)
FROM y67wx_content AS a
INNER JOIN y67wx_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN y67wx_categories AS c
ON c.id = a.catid
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_by
LEFT JOIN y67wx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN y67wx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y67wx_content_rating AS v
ON a.id = v.content_id1 × SELECT `session_id`
FROM `y67wx_session`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM y67wx_content AS a
INNER JOIN y67wx_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN y67wx_categories AS c
ON c.id = a.catid
LEFT JOIN y67wx_users AS ua
ON ua.id = a.created_by
LEFT JOIN y67wx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN y67wx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN y67wx_content_rating AS v
ON a.id = v.content_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `y67wx_assets`1 × SELECT id, home, template, s.params
FROM y67wx_template_styles as s
LEFT JOIN y67wx_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM y67wx_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM y67wx_menu AS m
LEFT JOIN y67wx_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 y67wx_extensions1 × SELECT b.id
FROM y67wx_usergroups AS a
LEFT JOIN y67wx_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `y67wx_viewlevels1 × SELECT count(*)
FROM `y67wx_vcnt` UNION ALL SELECT count(*)
FROM `y67wx_vcnt`
Andere Tabellen:
2 × UPDATE y67wx_banners
SET impmade = (impmade + 1)1 × INSERT INTO `y67wx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bcreefadnli5h3loj0qm8bhfcq', 1, 1702237444, 0, '', 01 × UPDATE `y67wx_extensions`
SET `params` = '{\"mediaversion\":\"8e49fdabb452ae3caa8a930d1e6d6d7d\"}'1 × SHOW FULL COLUMNS
FROM `y67wx_jev_users1 × CREATE TABLE IF NOT EXISTS `y67wx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(45) NOT NULL DEFAULT '0.0.0.0'
1 × CREATE TABLE IF NOT EXISTS `y67wx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0'