Deutsche Patientenliga Atemwegserkrankungen - DPLA e.V. 
|
Vielen Dank.
Mit diesen Formularen können Sie die Broschüren bei uns anfordern:
Mainzer Volksbank eG IBAN: DE37 5519 0000 0001 0320 10 BIC: MVBMDE55
|
|
|
|
|
 Atemwegserkrankungen Hilfe zur Selbsthilfe |
 Alternative Methoden, Naturheilverfahren, Schulmedizin Behandlungsmöglichkeiten von Asthma |
 Tabakentwöhnung bei COPD Patienten-Leitlinie der DGP |
Der Wegweiser für Patientinnen und Patienten mit Asthma und Bronchitis "Aufatmen in..." kann als Online-Version unter http://www.aufatmen-in-deutschland.de/ eingesehen werden. |
 COPD "Chronisch obstruktive Bronchitis und Lungenemphysem" - besser mit der Krankheit leben |
 Häusliches Training bei schwerer COPD |
 Asthma fängt an der Nase an |
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685734470,
"last": 1685734470,
"now": 1685734470
},
"token": "hGFPX0dC6pHG44ljbtzRl674ydlJefAb"
},
"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: 150.04 ms / 150.04 ms Speicher: 0.542 MB / 0.88 MB Application: afterLoad
Zeit: 311.66 ms / 461.70 ms Speicher: 1.033 MB / 1.91 MB Application: afterInitialise
Zeit: 76.22 ms / 537.92 ms Speicher: 0.427 MB / 2.34 MB Application: afterRoute
Zeit: 16.90 ms / 554.82 ms Speicher: 0.038 MB / 2.37 MB Application: beforeRenderComponent com_content
Zeit: 29.98 ms / 584.80 ms Speicher: 0.102 MB / 2.48 MB Application: Before Access::preloadComponents (all components)
Zeit: 2.87 ms / 587.68 ms Speicher: 0.057 MB / 2.53 MB Application: After Access::preloadComponents (all components)
Zeit: 0.04 ms / 587.72 ms Speicher: -0.003 MB / 2.53 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 2.20 ms / 589.92 ms Speicher: 0.100 MB / 2.63 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.03 ms / 589.95 ms Speicher: -0.007 MB / 2.62 MB Application: Before Access::getAssetRules (id:81 name:com_content.article.18)
Zeit: 5.00 ms / 594.95 ms Speicher: 0.071 MB / 2.69 MB Application: After Access::getAssetRules (id:81 name:com_content.article.18)
Zeit: 171.19 ms / 766.14 ms Speicher: 0.440 MB / 3.13 MB Application: afterRenderComponent com_content
Zeit: 4.71 ms / 770.85 ms Speicher: 0.008 MB / 3.14 MB Application: afterDispatch
Zeit: 33.22 ms / 804.08 ms Speicher: 0.100 MB / 3.24 MB Application: beforeRenderModule mod_search (Suchen)
Zeit: 6.08 ms / 810.16 ms Speicher: 0.019 MB / 3.26 MB Application: afterRenderModule mod_search (Suchen)
Zeit: 1.45 ms / 811.61 ms Speicher: 0.003 MB / 3.26 MB Application: beforeRenderModule mod_menu (DPLA e.V.)
Zeit: 8.26 ms / 819.87 ms Speicher: 0.080 MB / 3.34 MB Application: afterRenderModule mod_menu (DPLA e.V.)
Zeit: 0.57 ms / 820.44 ms Speicher: -0.004 MB / 3.34 MB Application: beforeRenderModule mod_menu (Atemwegserkrankungen)
Zeit: 1.07 ms / 821.51 ms Speicher: 0.041 MB / 3.38 MB Application: afterRenderModule mod_menu (Atemwegserkrankungen)
Zeit: 0.42 ms / 821.93 ms Speicher: -0.001 MB / 3.38 MB Application: beforeRenderModule mod_menu (Asthma)
Zeit: 1.02 ms / 822.95 ms Speicher: 0.040 MB / 3.42 MB Application: afterRenderModule mod_menu (Asthma)
Zeit: 1.99 ms / 824.94 ms Speicher: -0.002 MB / 3.42 MB Application: beforeRenderModule mod_menu (COPD)
Zeit: 3.61 ms / 828.55 ms Speicher: 0.066 MB / 3.48 MB Application: afterRenderModule mod_menu (COPD)
Zeit: 0.36 ms / 828.91 ms Speicher: 0.001 MB / 3.48 MB Application: beforeRenderModule mod_menu (Lungentransplantation )
Zeit: 0.69 ms / 829.60 ms Speicher: 0.009 MB / 3.49 MB Application: afterRenderModule mod_menu (Lungentransplantation )
Zeit: 0.52 ms / 830.12 ms Speicher: -0.003 MB / 3.49 MB Application: beforeRenderModule mod_menu (Verschiedenes)
Zeit: 0.81 ms / 830.93 ms Speicher: 0.015 MB / 3.51 MB Application: afterRenderModule mod_menu (Verschiedenes)
Zeit: 0.29 ms / 831.22 ms Speicher: -0.002 MB / 3.50 MB Application: beforeRenderModule mod_menu (Top )
Zeit: 0.85 ms / 832.07 ms Speicher: 0.033 MB / 3.54 MB Application: afterRenderModule mod_menu (Top )
Zeit: 0.41 ms / 832.48 ms Speicher: 0.000 MB / 3.54 MB Application: beforeRenderModule mod_fuofb (Find Us on Facebook)
Zeit: 2.82 ms / 835.30 ms Speicher: 0.010 MB / 3.55 MB Application: afterRenderModule mod_fuofb (Find Us on Facebook)
Zeit: 8.83 ms / 844.12 ms Speicher: 0.083 MB / 3.63 MB Application: afterRender
Datenbankabfragen gesamt: 31.94 ms
3,84 MB (4.024.608 Bytes)
15 ausgeführte Abfragen 31.94 ms
- Abfragezeit: 1.78 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.274 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `mjxst_session`
WHERE `session_id` = X'7465647630316b6a6f686175356e6e35676d6634363772686463'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mjxst_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.31 ms checking permissions 0.11 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.08 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.55 ms Nach letzter Abfrage: 6.79 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.286 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `mjxst_session`
WHERE `session_id` = X'7465647630316b6a6f686175356e6e35676d6634363772686463'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mjxst_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.17 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.04 ms End of update loop 0.01 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.06 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.97 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.291 MB
INSERT INTO `mjxst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'7465647630316b6a6f686175356e6e35676d6634363772686463', 1, 1685734470, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `mjxst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7465647630316b6a6f686175356e6e35676d6634363772686463', 1, 1685734470, 0, '', 0)Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.07 ms Waiting for query cache lock 0.03 ms Update 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.07 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.76 ms Nach letzter Abfrage: 51.06 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.414 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `mjxst_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mjxst_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.03 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.61 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.426 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM mjxst_usergroups AS a
LEFT JOIN mjxst_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.05 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.19 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.97 ms Nach letzter Abfrage: 209.78 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.339 MB
UPDATE `mjxst_extensions`
SET `params` = '{\"mediaversion\":\"61478a75482ece2e0290bf125d0126c9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `mjxst_extensions` SET `params` = '{\"mediaversion\":\"61478a75482ece2e0290bf125d0126c9\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.18 ms checking permissions 0.06 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.03 ms init for update 0.17 ms Updating 0.12 ms End of update loop 0.03 ms Waiting for query cache lock 0.01 ms End of update loop 0.06 ms Query end 0.01 ms Commit 0.12 ms closing tables 0.02 ms Unlocking tables 0.06 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.60 ms Nach letzter Abfrage: 40.59 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.480 MB Zeilen zurückgegeben: 34
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mjxst_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mjxst_assets ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 180 Using where Status Duration Starting 0.29 ms checking permissions 0.08 ms Opening tables 0.05 ms After opening tables 0.04 ms System lock 0.04 ms table lock 0.04 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.21 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.41 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.03 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.92 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.530 MB Zeilen zurückgegeben: 105
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mjxst_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 mjxst_assets ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 180 Using where Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.37 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.03 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.08 ms Reset for next command 0.03 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.41 ms Nach letzter Abfrage: 10.68 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.695 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `mjxst_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `mjxst_content`Status Duration Starting 0.11 ms checking permissions 0.02 ms closing tables 0.03 ms Opening tables 0.39 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.06 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms checking permissions 0.19 ms closing tables 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.13 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.08 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.87 ms Nach letzter Abfrage: 20.78 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.740 MB
UPDATE mjxst_content
SET `hits` = (`hits` + 1)
WHERE `id` = '18'„EXPLAIN“ unmöglich für Abfrage: UPDATE mjxst_content SET `hits` = (`hits` + 1) WHERE `id` = '18'Status Duration Starting 0.16 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init for update 0.15 ms Updating 0.16 ms End of update loop 0.03 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.14 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.03 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.03 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.10 ms Nach letzter Abfrage: 8.96 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 2.844 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mjxst_content AS a
INNER JOIN mjxst_categories AS c
on c.id = a.catid
LEFT JOIN mjxst_users AS u
on u.id = a.created_by
LEFT JOIN mjxst_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mjxst_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 18
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 19:34:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 19:34:31')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.34 ms checking permissions 0.04 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.17 ms Optimizing 0.09 ms Statistics 0.31 ms Preparing 0.03 ms Unlocking tables 0.06 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.09 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.60 ms Nach letzter Abfrage: 11.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.891 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mjxst_contentitem_tag_map` AS m
INNER JOIN `mjxst_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 18
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db118090001.m.tag_id 1 Using where Status Duration Starting 0.14 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.05 ms Statistics 0.19 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.55 ms Nach letzter Abfrage: 36.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.982 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 `mjxst_categories` AS `s`
INNER JOIN `mjxst_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table 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 10 Using where; filesort wurde genutzt Status Duration Starting 0.38 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.13 ms Optimizing 0.07 ms Statistics 0.26 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.19 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.08 ms Reset for next command 0.02 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:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.61 ms Nach letzter Abfrage: 3.49 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.999 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 mjxst_fields AS a
LEFT JOIN `mjxst_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mjxst_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mjxst_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mjxst_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mjxst_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mjxst_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 func 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 db118090001.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 db118090001.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 db118090001.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 db118090001.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 db118090001.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.30 ms checking permissions 0.03 ms Opening tables 0.20 ms After opening tables 0.07 ms System lock 0.02 ms table lock 0.02 ms init 0.15 ms Optimizing 0.09 ms Statistics 0.25 ms Preparing 0.11 ms Creating tmp table 0.14 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 0.61 ms Creating sort index 0.09 ms Removing tmp table 0.10 ms Creating sort index 0.05 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.08 ms Reset for next command 0.03 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:322 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:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.66 ms Nach letzter Abfrage: 93.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.195 MB Zeilen zurückgegeben: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mjxst_modules AS m
LEFT JOIN mjxst_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mjxst_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-06-02 19:34:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 19:34:31')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 126 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 13 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE mm ref PRIMARY PRIMARY 4 db118090001.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 db118090001.m.module,const 1 Using index condition; Using where Status Duration Starting 0.27 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.10 ms Optimizing 0.08 ms Statistics 0.22 ms Preparing 0.15 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.38 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.07 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/themza_j25_06/index.php:9 7 require JROOT/templates/themza_j25_06/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
14 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mjxst_assets`1 × SELECT `data`
FROM `mjxst_session`1 × SELECT `session_id`
FROM `mjxst_session`1 × SELECT id, rules
FROM `mjxst_viewlevels1 × SELECT b.id
FROM mjxst_usergroups AS a
LEFT JOIN mjxst_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mjxst_content AS a
INNER JOIN mjxst_categories AS c
on c.id = a.catid
LEFT JOIN mjxst_users AS u
on u.id = a.created_by
LEFT JOIN mjxst_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mjxst_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `mjxst_contentitem_tag_map` AS m
INNER JOIN `mjxst_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mjxst_categories` AS `s`
INNER JOIN `mjxst_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 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 mjxst_fields AS a
LEFT JOIN `mjxst_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mjxst_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mjxst_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mjxst_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mjxst_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mjxst_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mjxst_modules AS m
LEFT JOIN mjxst_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mjxst_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Andere Tabellen:
1 × INSERT INTO `mjxst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'7465647630316b6a6f686175356e6e35676d6634363772686463', 1, 1685734470, 0, '', 01 × UPDATE `mjxst_extensions`
SET `params` = '{\"mediaversion\":\"61478a75482ece2e0290bf125d0126c9\"}'1 × SHOW FULL COLUMNS
FROM `mjxst_content1 × UPDATE mjxst_content
SET `hits` = (`hits` + 1)
