Kickers verlieren in der Schlussphase
Am 6. Spieltag waren die Kickers zu Gast bei der Vertretung des NK Dinamo München. Urlaubsbedingt mussten die Kickers gleich auf 8 Akteure verzichten.
- Home
- Aktuelles
Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentDirectPHP has a deprecated constructor in /www/htdocs/w0132d2f/joomla2/plugins/content/DirectPHP/DirectPHP.php on line 23
Notice: Undefined variable: baseurl in /www/htdocs/w0132d2f/joomla2/plugins/content/responsive-tables/responsive-tables.php on line 17
Trainingsbetrieb
Verfasst von Super User am .
Wir freuen uns euch mitteilen zu können, dass wir den Trainingsbetrieb zum 01.08.2016 aufnehmen können.
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": 1679927629,
"last": 1679927629,
"now": 1679927629
},
"token": "s9lMfa7txKi9ejHQiXAFsgMNCXwDMczR"
},
"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: 33.58 ms / 33.58 ms Speicher: 1.694 MB / 2.07 MB Application: afterLoad
Zeit: 79.62 ms / 113.20 ms Speicher: 5.576 MB / 7.65 MB Application: afterInitialise
Zeit: 9.73 ms / 122.93 ms Speicher: 0.886 MB / 8.54 MB Application: afterRoute
Zeit: 2.52 ms / 125.45 ms Speicher: 0.215 MB / 8.75 MB Application: beforeRenderComponent com_content
Zeit: 4.26 ms / 129.71 ms Speicher: 0.552 MB / 9.30 MB Application: Before Access::preloadComponents (all components)
Zeit: 0.64 ms / 130.35 ms Speicher: 0.058 MB / 9.36 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 130.37 ms Speicher: 0.000 MB / 9.36 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 0.60 ms / 130.97 ms Speicher: 0.146 MB / 9.50 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 130.99 ms Speicher: 0.000 MB / 9.49 MB Application: Before Access::getAssetRules (id:169 name:com_content.category.14)
Zeit: 0.39 ms / 131.37 ms Speicher: 0.026 MB / 9.52 MB Application: After Access::getAssetRules (id:169 name:com_content.category.14)
Zeit: 2.52 ms / 133.90 ms Speicher: 0.220 MB / 9.74 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.01 ms / 133.91 ms Speicher: 0.002 MB / 9.74 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 17.03 ms / 150.94 ms Speicher: 1.892 MB / 11.63 MB Application: afterRenderComponent com_content
Zeit: 2.30 ms / 153.24 ms Speicher: 0.333 MB / 11.97 MB Application: afterDispatch
Zeit: 2.98 ms / 156.21 ms Speicher: 0.246 MB / 12.21 MB Application: beforeRenderModule mod_je_facebookfanbox (Facebook)
Zeit: 0.36 ms / 156.57 ms Speicher: 0.028 MB / 12.24 MB Application: afterRenderModule mod_je_facebookfanbox (Facebook)
Zeit: 2.44 ms / 159.01 ms Speicher: 0.145 MB / 12.39 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 2.45 ms / 161.46 ms Speicher: 0.134 MB / 12.52 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 3.38 ms / 164.85 ms Speicher: 0.225 MB / 12.74 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.64 ms / 165.49 ms Speicher: 0.020 MB / 12.76 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.40 ms / 165.90 ms Speicher: 0.003 MB / 12.77 MB Application: beforeRenderModule mod_slidesocialconnect (Social Media)
Zeit: 1.21 ms / 167.11 ms Speicher: 0.701 MB / 13.47 MB Application: afterRenderModule mod_slidesocialconnect (Social Media)
Zeit: 0.14 ms / 167.25 ms Speicher: 0.002 MB / 13.47 MB Application: beforeRenderModule mod_flexi_customcode (Tabelle_sidebar)
Zeit: 2.11 ms / 169.35 ms Speicher: 0.046 MB / 13.52 MB Application: afterRenderModule mod_flexi_customcode (Tabelle_sidebar)
Zeit: 0.34 ms / 169.69 ms Speicher: 0.001 MB / 13.52 MB Application: beforeRenderModule mod_flexi_customcode (Tabelle_sidebar_II)
Zeit: 0.21 ms / 169.91 ms Speicher: 0.006 MB / 13.52 MB Application: afterRenderModule mod_flexi_customcode (Tabelle_sidebar_II)
Zeit: 0.17 ms / 170.07 ms Speicher: 0.000 MB / 13.52 MB Application: beforeRenderModule mod_custom (Facebook Home)
Zeit: 0.40 ms / 170.47 ms Speicher: 0.007 MB / 13.53 MB Application: afterRenderModule mod_custom (Facebook Home)
Zeit: 0.16 ms / 170.63 ms Speicher: 0.000 MB / 13.53 MB Application: beforeRenderModule mod_custom (Instagram Home)
Zeit: 0.25 ms / 170.88 ms Speicher: 0.003 MB / 13.53 MB Application: afterRenderModule mod_custom (Instagram Home)
Zeit: 1.41 ms / 172.29 ms Speicher: 0.000 MB / 13.52 MB Application: beforeRenderModule mod_visitorcounter (VCNT - Visitorcounter)
Zeit: 3.10 ms / 175.38 ms Speicher: 0.115 MB / 13.63 MB Application: afterRenderModule mod_visitorcounter (VCNT - Visitorcounter)
Zeit: 0.68 ms / 176.06 ms Speicher: 0.011 MB / 13.65 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)
Zeit: 1.34 ms / 177.40 ms Speicher: 0.008 MB / 13.65 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)
Zeit: 3.17 ms / 180.57 ms Speicher: 0.103 MB / 13.76 MB Application: afterRender
Datenbankabfragen gesamt: 10.97 ms
14,27 MB (14.959.432 Bytes)
29 ausgeführte Abfragen 10.97 ms
- Abfragezeit: 0.23 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.763 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `qswnp_session`
WHERE `session_id` = '680b88204d72e124235f4435a5f1d3c5'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.03 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.02 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.19 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.866 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `qswnp_session`
WHERE `session_id` = '680b88204d72e124235f4435a5f1d3c5'
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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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 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.25 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.871 MB
INSERT INTO `qswnp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('680b88204d72e124235f4435a5f1d3c5', 1, 1679927629, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `qswnp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('680b88204d72e124235f4435a5f1d3c5', 1, 1679927629, 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.01 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.19 ms Nach letzter Abfrage: 4.15 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.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.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.20 ms Nach letzter Abfrage: 0.05 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.49 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.527 MB Zeilen zurückgegeben: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qswnp_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qswnp_extensions ALL extension ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 229 Using where; filesort wurde genutzt 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.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.24 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:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Der selbe 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:50 - Abfragezeit: 0.28 ms Nach letzter Abfrage: 6.99 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.857 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #8
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.04 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.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.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.17 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.864 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.03 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.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.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.19 ms Nach letzter Abfrage: 1.91 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.095 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.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.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.48 ms Nach letzter Abfrage: 8.07 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 7.041 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.14 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 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.01 ms Executing 0.00 ms Sending data 0.04 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.06 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.21 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.095 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.04 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.02 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.15 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.101 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #14
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.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.00 ms Unlocking tables 0.00 ms Preparing 0.00 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: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.14 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.106 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.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.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: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.09 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.112 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #12
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.00 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 Unlocking tables 0.00 ms Preparing 0.00 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: 46.59 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.557 MB
UPDATE `qswnp_extensions`
SET `params` = '{\"mediaversion\":\"3c361f69096fe7a818876c0bb3362530\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `qswnp_extensions` SET `params` = '{\"mediaversion\":\"3c361f69096fe7a818876c0bb3362530\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 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 for update 0.07 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.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.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: 6.04 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 9.309 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.04 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.03 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.18 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.40 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 9.361 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.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.15 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 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/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.53 ms Nach letzter Abfrage: 1.29 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 9.574 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,( SELECT COUNT(i.`id`)
FROM `qswnp_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
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.published = 1
AND s.id = 14
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 15 Using where; filesort wurde genutzt 2 DEPENDENT SUBQUERY i ref|filter idx_state,idx_catid idx_catid|idx_state 4|1 d021f9d1.c.id 7 (27%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.07 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.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 0.04 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 Removing tmp table 0.00 ms Freeing items 0.01 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/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 14 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.54 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 9.740 MB Zeilen zurückgegeben: 2
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,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 qswnp_content AS a
LEFT JOIN qswnp_categories AS c
ON c.id = a.catid
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_by
LEFT JOIN qswnp_users AS uam
ON uam.id = a.modified_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.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 14
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 14:33:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 14:33:49')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 13id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_state,idx_catid 1,4 NULL 18 Using intersect(idx_state,idx_catid); Using where; filesort wurde genutzt 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d021f9d1.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 d021f9d1.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 d021f9d1.a.id 1 Using where Status Duration Starting 0.10 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.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.10 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() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.32 ms Nach letzter Abfrage: 0.79 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.900 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM qswnp_content AS a
LEFT JOIN qswnp_categories AS c
ON c.id = a.catid
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_by
LEFT JOIN qswnp_users AS uam
ON uam.id = a.modified_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.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 14
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 14:33:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 14:33:49')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_state,idx_catid 1,4 NULL 18 Using intersect(idx_state,idx_catid); Using where 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 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 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.02 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/libraries/src/MVC/Model/BaseDatabaseModel.php:340 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 16 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 15 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.21 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 10.087 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.category'
AND `m`.`content_item_id` = 14
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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->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.37 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 10.615 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 = 14
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 15 Using where; filesort wurde genutzt Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.05 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.01 ms Creating sort index 0.05 ms End of update loop 0.02 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 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/category/view.html.php:113 11 ContentViewCategory->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.60 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 10.632 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 (14,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.16 ms Creating sort index 0.01 ms Removing tmp table 0.04 ms Creating sort index 0.01 ms End of update loop 0.02 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/category/view.html.php:113 11 ContentViewCategory->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.04 ms Nach letzter Abfrage: 13.02 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 12.181 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:33:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 14:33:49')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 205 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.74 ms Nach letzter Abfrage: 12.03 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 13.519 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 (14,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.09 ms checking permissions 0.00 ms Opening tables 0.04 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.08 ms Preparing 0.03 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.02 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 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 32 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 31 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 30 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 29 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 28 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 27 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 26 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 25 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 24 JHtmlContent::prepare() Der selbe Aufruf in der Zeile darunter. 23 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 22 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 21 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_flexi_customcode/tmpl/default.php:59 20 require JROOT/modules/mod_flexi_customcode/tmpl/default.php JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22 19 include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php JROOT/libraries/src/Helper/ModuleHelper.php:200 18 Joomla\CMS\Helper\ModuleHelper::renderModule() 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:601 15 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:143 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.46 ms Nach letzter Abfrage: 4.33 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.616 MB Zeilen zurückgegeben: 1
SELECT count(*)
FROM `qswnp_vcnt`
WHERE `ip` = '3.238.134.157'
AND (`tm` + '3600') > '1679927629'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 2258 Using where Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.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.34 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.626 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 2258 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.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.27 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 13.636 MB Zeilen zurückgegeben: 2
SELECT `guest`, `client_id` , `username`, `userid`
FROM `qswnp_session`
WHERE `client_id` = 0
AND `time` > '1679927029'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.02 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: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: 13.649 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 2258 Using where 3 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2258 Using where 4 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2258 Using where 5 UNION qswnp_vcnt ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2258 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.19 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 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.id2 × SELECT `extension_id`
FROM `qswnp_extensions`2 × SELECT *
FROM qswnp_extensions2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `qswnp_assets`1 × SELECT `data`
FROM `qswnp_session`1 × 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 `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 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 c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `qswnp_content` AS `i`1 × SELECT COUNT(*)
FROM qswnp_content AS a
LEFT JOIN qswnp_categories AS c
ON c.id = a.catid
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_by
LEFT JOIN qswnp_users AS uam
ON uam.id = a.modified_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 a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM qswnp_content AS a
LEFT JOIN qswnp_categories AS c
ON c.id = a.catid
LEFT JOIN qswnp_users AS ua
ON ua.id = a.created_by
LEFT JOIN qswnp_users AS uam
ON uam.id = a.modified_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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qswnp_extensions1 × 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 ('680b88204d72e124235f4435a5f1d3c5', 1, 1679927629, 0, '', 01 × SHOW FULL COLUMNS
FROM `qswnp_extensions1 × UPDATE `qswnp_extensions`
SET `params` = '{\"mediaversion\":\"3c361f69096fe7a818876c0bb3362530\"}'