Laden...
Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1679926023,
"last": 1679926023,
"now": 1679926023
},
"token": "T0wwHmyQDDng0NVCCKX4h5VLXmeaKIJI"
},
"registry": {},
"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: 8.24 ms / 8.24 ms Speicher: 1.694 MB / 2.07 MB Application: afterLoad
Zeit: 59.95 ms / 68.19 ms Speicher: 5.580 MB / 7.65 MB Application: afterInitialise
Zeit: 6.79 ms / 74.97 ms Speicher: 0.886 MB / 8.54 MB Application: afterRoute
Zeit: 2.10 ms / 77.08 ms Speicher: 0.215 MB / 8.76 MB Application: beforeRenderComponent com_content
Zeit: 1.94 ms / 79.01 ms Speicher: 0.288 MB / 9.04 MB Application: Before Access::preloadComponents (all components)
Zeit: 0.66 ms / 79.67 ms Speicher: 0.057 MB / 9.10 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 79.69 ms Speicher: 0.000 MB / 9.10 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 0.67 ms / 80.36 ms Speicher: 0.143 MB / 9.24 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 80.37 ms Speicher: 0.000 MB / 9.23 MB Application: Before Access::getAssetRules (id:37 name:com_content.article.5)
Zeit: 0.40 ms / 80.77 ms Speicher: 0.026 MB / 9.25 MB Application: After Access::getAssetRules (id:37 name:com_content.article.5)
Zeit: 21.33 ms / 102.10 ms Speicher: 2.265 MB / 11.52 MB Application: afterRenderComponent com_content
Zeit: 2.07 ms / 104.18 ms Speicher: 0.333 MB / 11.85 MB Application: afterDispatch
Zeit: 2.90 ms / 107.08 ms Speicher: 0.269 MB / 12.12 MB Application: beforeRenderModule mod_menu (Statistik)
Zeit: 1.49 ms / 108.57 ms Speicher: 0.092 MB / 12.21 MB Application: afterRenderModule mod_menu (Statistik)
Zeit: 0.19 ms / 108.75 ms Speicher: 0.001 MB / 12.21 MB Application: beforeRenderModule mod_custom (Mannschaftsfoto_II)
Zeit: 0.34 ms / 109.09 ms Speicher: 0.006 MB / 12.22 MB Application: afterRenderModule mod_custom (Mannschaftsfoto_II)
Zeit: 0.20 ms / 109.29 ms Speicher: 0.007 MB / 12.23 MB Application: beforeRenderModule mod_flexi_customcode (Tabelle_II_topC)
Zeit: 1.56 ms / 110.85 ms Speicher: 0.045 MB / 12.27 MB Application: afterRenderModule mod_flexi_customcode (Tabelle_II_topC)
Zeit: 0.19 ms / 111.04 ms Speicher: 0.000 MB / 12.27 MB Application: beforeRenderModule mod_flexi_customcode (Kader_II)
Zeit: 0.19 ms / 111.22 ms Speicher: 0.005 MB / 12.28 MB Application: afterRenderModule mod_flexi_customcode (Kader_II)
Zeit: 0.10 ms / 111.32 ms Speicher: 0.000 MB / 12.26 MB Application: beforeRenderModule mod_je_facebookfanbox (Facebook)
Zeit: 0.21 ms / 111.53 ms Speicher: 0.009 MB / 12.26 MB Application: afterRenderModule mod_je_facebookfanbox (Facebook)
Zeit: 0.44 ms / 111.96 ms Speicher: 0.038 MB / 12.30 MB Application: beforeRenderModule mod_flexi_customcode (Spielplan_II_mainTop)
Zeit: 0.17 ms / 112.14 ms Speicher: 0.005 MB / 12.31 MB Application: afterRenderModule mod_flexi_customcode (Spielplan_II_mainTop)
Zeit: 2.10 ms / 114.24 ms Speicher: 0.102 MB / 12.41 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 1.65 ms / 115.89 ms Speicher: 0.069 MB / 12.48 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 5.73 ms / 121.63 ms Speicher: 0.221 MB / 12.70 MB Application: beforeRenderModule mod_visitorcounter (VCNT - Visitorcounter)
Zeit: 3.10 ms / 124.73 ms Speicher: 0.115 MB / 12.82 MB Application: afterRenderModule mod_visitorcounter (VCNT - Visitorcounter)
Zeit: 0.69 ms / 125.42 ms Speicher: 0.012 MB / 12.83 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)
Zeit: 1.38 ms / 126.81 ms Speicher: 0.005 MB / 12.83 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)
Zeit: 2.82 ms / 129.63 ms Speicher: 0.636 MB / 13.47 MB Application: afterRender
Datenbankabfragen gesamt: 10.56 ms
13,96 MB (14.640.952 Bytes)
29 ausgeführte Abfragen 10.56 ms
- Abfragezeit: 0.14 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.764 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `qswnp_session`
WHERE `session_id` = 'db22738c68e855228f7c0f308ae3bc7f'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Der selbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php: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:47 - Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.866 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `qswnp_session`
WHERE `session_id` = 'db22738c68e855228f7c0f308ae3bc7f'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.00 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php: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:47 - Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.871 MB
INSERT INTO `qswnp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('db22738c68e855228f7c0f308ae3bc7f', 1, 1679926023, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `qswnp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('db22738c68e855228f7c0f308ae3bc7f', 1, 1679926023, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.01 ms Update 0.03 ms Waiting for query cache lock 0.00 ms Update 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.04 ms Writing to binlog 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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:47 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 3.58 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.445 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `qswnp_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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:50 - Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.457 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM qswnp_usergroups AS a
LEFT JOIN qswnp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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:50 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 7.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.859 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #7
SELECT template
FROM qswnp_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.867 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #6
SELECT template
FROM qswnp_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_client_id,idx_client_id_home idx_client_id 1 const 3 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 1.89 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.097 MB Zeilen zurückgegeben: 2
SELECT extension, file, type
FROM qswnp_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_rokcommon_configs ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 filesort wurde genutzt Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.00 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.47 ms Nach letzter Abfrage: 7.93 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.044 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `qswnp_extensions`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `qswnp_extensions`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.18 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.05 ms closing tables 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.05 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:312 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.098 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `qswnp_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.104 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #13
SELECT *
FROM qswnp_extensions
WHERE `extension_id` = '10046'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.109 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `qswnp_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.115 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #11
SELECT *
FROM qswnp_extensions
WHERE `extension_id` = '10046'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 32.83 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.560 MB
UPDATE `qswnp_extensions`
SET `params` = '{\"mediaversion\":\"ff41bf424f08ccde6bbf0f7df81bc7fe\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `qswnp_extensions` SET `params` = '{\"mediaversion\":\"ff41bf424f08ccde6bbf0f7df81bc7fe\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.06 ms Updating 0.04 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.04 ms Writing to binlog 0.02 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1129 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Abfragezeit: 0.50 ms Nach letzter Abfrage: 3.43 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.048 MB Zeilen zurückgegeben: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qswnp_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','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_roksprocket','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_assets range idx_asset_name idx_asset_name 202 NULL 40 Using index condition Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.17 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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:50 - Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 9.097 MB Zeilen zurückgegeben: 132
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qswnp_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_assets ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 301 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.20 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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:50 - Abfragezeit: 0.50 ms Nach letzter Abfrage: 1.25 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 9.297 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `qswnp_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `qswnp_content`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.07 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.05 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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:50 - Abfragezeit: 0.31 ms Nach letzter Abfrage: 2.22 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 9.528 MB Zeilen zurückgegeben: 1
SELECT *
FROM qswnp_content
WHERE `id` = '5'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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:50 - Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 9.536 MB
UPDATE qswnp_content
SET `hits` = (`hits` + 1)
WHERE `id` = '5'„EXPLAIN“ unmöglich für Abfrage: UPDATE qswnp_content SET `hits` = (`hits` + 1) WHERE `id` = '5'Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.03 ms Updating 0.03 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.04 ms Writing to binlog 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:255 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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:50 - Abfragezeit: 0.40 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 9.696 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM qswnp_content AS a
INNER JOIN qswnp_categories AS c
on c.id = a.catid
LEFT JOIN qswnp_users AS u
on u.id = a.created_by
LEFT JOIN qswnp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN qswnp_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 5
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 14:07:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 14:07:03')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:50 - Abfragezeit: 0.36 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 9.848 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `qswnp_contentitem_tag_map` AS m
INNER JOIN `qswnp_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 5
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 d021f9d1.m.tag_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:50 - Abfragezeit: 0.47 ms Nach letzter Abfrage: 5.09 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 10.521 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 `qswnp_categories` AS `s`
INNER JOIN `qswnp_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 type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right idx_left_right|cat_idx 4|208 NULL 2 (53%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:50 - Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 10.566 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 qswnp_fields AS a
LEFT JOIN `qswnp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qswnp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qswnp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qswnp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qswnp_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))
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 type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 d021f9d1.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 d021f9d1.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 d021f9d1.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d021f9d1.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d021f9d1.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 d021f9d1.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:50 - Abfragezeit: 1.01 ms Nach letzter Abfrage: 10.87 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 12.075 MB Zeilen zurückgegeben: 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qswnp_modules AS m
LEFT JOIN qswnp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qswnp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-27 14:07:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 14:07:03')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 254 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 84 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 d021f9d1.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 d021f9d1.m.id 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.62 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Der selbe Aufruf in der Zeile darunter. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 11 Warp\Joomla\Helper\WidgetsHelper->count() JROOT/templates/jp-xtra/layouts/theme.config.php:28 10 include JROOT/templates/jp-xtra/layouts/theme.config.php JROOT/templates/jp-xtra/layouts/theme.php:10 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50 - Abfragezeit: 0.65 ms Nach letzter Abfrage: 3.09 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 12.278 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 qswnp_fields AS a
LEFT JOIN `qswnp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qswnp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qswnp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qswnp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qswnp_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (2,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 type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 d021f9d1.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 d021f9d1.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 d021f9d1.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d021f9d1.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d021f9d1.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 d021f9d1.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.07 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.16 ms Creating sort index 0.02 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 29 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 28 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 27 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 26 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 25 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 24 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 23 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 22 JHtmlContent::prepare() Der selbe Aufruf in der Zeile darunter. 21 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 20 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 19 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_flexi_customcode/tmpl/default.php:59 18 require JROOT/modules/mod_flexi_customcode/tmpl/default.php JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22 17 include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php JROOT/libraries/src/Helper/ModuleHelper.php:200 16 Joomla\CMS\Helper\ModuleHelper::renderModule() Der selbe Aufruf in der Zeile darunter. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:601 13 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 12 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 11 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/jp-xtra/layouts/theme.config.php:74 10 include JROOT/templates/jp-xtra/layouts/theme.config.php JROOT/templates/jp-xtra/layouts/theme.php:10 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50 - Abfragezeit: 0.41 ms Nach letzter Abfrage: 11.78 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.796 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `qswnp_vcnt`
WHERE `ip` = '3.238.134.157'
AND (`tm` + '3600') > '1679926023'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.20 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:105 17 ModVisitorcounterHelper->countRequest() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:32 16 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 13 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php:10 12 include JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 11 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 10 Warp\Joomla\Helper\WidgetsHelper->render() JROOT/templates/jp-xtra/layouts/theme.php:180 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50 - Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.807 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `qswnp_vcnt`
WHERE `tm` < '1676934000'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.20 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/modules/mod_visitorcounter/helper.php:220 17 ModVisitorcounterHelper->cleanDatabase() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:37 16 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 13 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php:10 12 include JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 11 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 10 Warp\Joomla\Helper\WidgetsHelper->render() JROOT/templates/jp-xtra/layouts/theme.php:180 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 12.816 MB Zeilen zurückgegeben: 2
SELECT `guest`, `client_id` , `username`, `userid`
FROM `qswnp_session`
WHERE `client_id` = 0
AND `time` > '1679925423'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_session range time,client_id_guest time 4 NULL 2 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.01 ms Reset for next command 0.03 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/modules/mod_visitorcounter/helper.php:250 17 ModVisitorcounterHelper->whoIsOnline() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:45 16 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 13 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php:10 12 include JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 11 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 10 Warp\Joomla\Helper\WidgetsHelper->render() JROOT/templates/jp-xtra/layouts/theme.php:180 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50 - Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 12.829 MB Zeilen zurückgegeben: 6
SELECT count(*)
FROM `qswnp_vcnt` UNION ALL SELECT count(*)
FROM `qswnp_vcnt`
WHERE `tm` > '1679868000' UNION ALL SELECT count(*)
FROM `qswnp_vcnt`
WHERE `tm` > '1679781600' && `tm` < '1679868000' UNION ALL SELECT count(*)
FROM `qswnp_vcnt`
WHERE `tm` >= '1679868000' UNION ALL SELECT count(*)
FROM `qswnp_vcnt`
WHERE `tm` >= '1677625200' UNION ALL SELECT `cnt`
FROM `qswnp_vcnt_pc`id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL Select tables optimized away 2 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where 3 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where 4 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where 5 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2257 Using where 6 UNION qswnp_vcnt_pc system NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.02 ms Optimizing 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.00 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.00 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.00 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.00 ms Executing 0.00 ms Sending data 0.20 ms Executing 0.00 ms Sending data 0.20 ms Executing 0.00 ms Sending data 0.19 ms Executing 0.00 ms Sending data 0.21 ms Executing 0.00 ms Sending data 0.00 ms Removing tmp table 0.00 ms Sending data 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 18 JDatabaseDriver->loadRowList() JROOT/modules/mod_visitorcounter/helper.php:181 17 ModVisitorcounterHelper->getData() JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:71 16 include JROOT/modules/mod_visitorcounter/mod_visitorcounter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 13 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php:10 12 include JROOT/templates/jp-xtra/warp/systems/joomla/layouts/widgets.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 11 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 10 Warp\Joomla\Helper\WidgetsHelper->render() JROOT/templates/jp-xtra/layouts/theme.php:180 9 include JROOT/templates/jp-xtra/layouts/theme.php JROOT/templates/jp-xtra/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/jp-xtra/index.php:16 7 require JROOT/templates/jp-xtra/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:50
23 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT count(*)
FROM `qswnp_vcnt`2 × SELECT template
FROM qswnp_template_styles as s2 × SELECT `extension_id`
FROM `qswnp_extensions`2 × SELECT *
FROM qswnp_extensions2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qswnp_assets`2 × 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 qswnp_fields AS a
LEFT JOIN `qswnp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qswnp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qswnp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qswnp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `qswnp_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `qswnp_session`1 × 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 `qswnp_categories` AS `s`
INNER JOIN `qswnp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `guest`, `client_id` , `username`, `userid`
FROM `qswnp_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qswnp_modules AS m
LEFT JOIN qswnp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qswnp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM qswnp_content1 × SELECT `m`.`tag_id`,`t`.*
FROM `qswnp_contentitem_tag_map` AS m
INNER JOIN `qswnp_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM qswnp_content AS a
INNER JOIN qswnp_categories AS c
on c.id = a.catid
LEFT JOIN qswnp_users AS u
on u.id = a.created_by
LEFT JOIN qswnp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN qswnp_content_rating AS v
ON a.id = v.content_id1 × SELECT `session_id`
FROM `qswnp_session`1 × SELECT extension, file, type
FROM qswnp_rokcommon_configs1 × SELECT b.id
FROM qswnp_usergroups AS a
LEFT JOIN qswnp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `qswnp_viewlevels1 × SELECT count(*)
FROM `qswnp_vcnt` UNION ALL SELECT count(*)
FROM `qswnp_vcnt`
Andere Tabellen:
1 × INSERT INTO `qswnp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('db22738c68e855228f7c0f308ae3bc7f', 1, 1679926023, 0, '', 01 × SHOW FULL COLUMNS
FROM `qswnp_extensions1 × UPDATE `qswnp_extensions`
SET `params` = '{\"mediaversion\":\"ff41bf424f08ccde6bbf0f7df81bc7fe\"}'1 × SHOW FULL COLUMNS
FROM `qswnp_content1 × UPDATE qswnp_content
SET `hits` = (`hits` + 1)