Abfragezeit: 1.78 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.174 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `VCD_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_extensions | NULL | ref | extension | extension | 82 | const | 42 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.17 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.23 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.53 ms Nach letzter Abfrage: 2.47 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.415 MB Zeilen zurückgegeben: 10
SELECT id, rules
FROM `VCD_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 10 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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: 3.49 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.426 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM VCD_usergroups AS a
LEFT JOIN VCD_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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.62 ms Nach letzter Abfrage: 5.29 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 4.494 MB Zeilen zurückgegeben: 122
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM VCD_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_extensions | NULL | ref | extension | extension | 82 | const | 157 | 0.40 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.96 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.36 ms Nach letzter Abfrage: 32.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.307 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'smartslider'
AND `section` = 'settings'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 214 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 12 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 11 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 10 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17 |
| 9 | Nextend\SmartSlider3\Settings::getAll() | JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25 |
| 8 | Nextend\SmartSlider3\Settings::get() | JROOT/plugins/system/smartslider3/smartslider3.php:16 |
| 7 | require_once JROOT/plugins/system/smartslider3/smartslider3.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.00 ms Nach letzter Abfrage: 22.90 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.651 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `VCD_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:17 |
| 7 | plgSystemJomclassifiedsLocationManager->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 15.50 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.642 MB
UPDATE `VCD_extensions`
SET `params` = '{\"mediaversion\":\"dbad1917f8f99abb70846d2d89665e67\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | VCD_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.07 ms |
| updating | 0.13 ms |
| end | 0.02 ms |
| query end | 3.61 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:17 |
| 7 | plgSystemJomclassifiedsLocationManager->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.25 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.809 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.31 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431 |
| 8 | plgSystemJomclassifiedsLocationManager->getCfg() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18 |
| 7 | plgSystemJomclassifiedsLocationManager->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.42 ms Nach letzter Abfrage: 14.37 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 10.121 MB Zeilen zurückgegeben: 4
SELECT *
FROM VCD_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_languages | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 20.00 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:96 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 10.131 MB Zeilen zurückgegeben: 10
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `VCD_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_extensions | NULL | ref | extension | extension | 82 | const | 10 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.71 ms Nach letzter Abfrage: 8.82 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.601 MB
Update
VCD_contentbuilder_articles As articles,
VCD_content As content,
VCD_contentbuilder_forms As forms,
VCD_contentbuilder_registered_users As cbusers,
VCD_users As users
Set
content.state = 0
Where
articles.article_id = content.id
And
content.state = 1
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
(
(
users.id = cbusers.user_id
And
users.block = 1
)
)| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cbusers | NULL | index | user_id | user_id | 16 | NULL | 1 | 100.00 | Using index |
| 1 | SIMPLE | forms | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.cbusers.form_id | 1 | 33.33 | Using where |
| 1 | SIMPLE | users | NULL | eq_ref | PRIMARY,idx_block | PRIMARY | 4 | db715876307.cbusers.user_id | 1 | 11.98 | Using where |
| 1 | UPDATE | content | NULL | ref | PRIMARY,idx_state,idx_createdby | idx_createdby | 4 | db715876307.cbusers.user_id | 6 | 100.00 | Using where |
| 1 | SIMPLE | articles | NULL | ref | article_id | article_id | 4 | db715876307.content.id | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.08 ms |
| init | 0.03 ms |
| updating main table | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| updating reference tables | 0.00 ms |
| end | 0.01 ms |
| end | 0.00 ms |
| removing tmp table | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 10 | JDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
| 8 | plgSystemContentbuilder_system->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.50 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.606 MB
Update
VCD_contentbuilder_articles As articles,
VCD_content As content,
VCD_contentbuilder_forms As forms,
VCD_contentbuilder_records As records,
VCD_contentbuilder_registered_users As cbusers,
VCD_users As users
Set
content.state = forms.auto_publish
Where
articles.article_id = content.id
And
content.state = 0
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
users.id = cbusers.user_id
And
records.record_id = cbusers.record_id
And
records.`type` = forms.`type`
And
users.block = 0| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cbusers | NULL | index | user_id | user_id | 16 | NULL | 1 | 100.00 | Using index |
| 1 | SIMPLE | forms | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.cbusers.form_id | 1 | 33.33 | Using where |
| 1 | SIMPLE | users | NULL | eq_ref | PRIMARY,idx_block | PRIMARY | 4 | db715876307.cbusers.user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | records | NULL | ref | record_id,type,type_2,type_3,type_4,type_5,type_6,type_7 | record_id | 8 | db715876307.cbusers.record_id | 1 | 50.00 | Using where |
| 1 | UPDATE | content | NULL | ref | PRIMARY,idx_state,idx_createdby | idx_createdby | 4 | db715876307.cbusers.user_id | 6 | 6.75 | Using where |
| 1 | SIMPLE | articles | NULL | ref | article_id | article_id | 4 | db715876307.content.id | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| updating main table | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| updating reference tables | 0.01 ms |
| end | 0.01 ms |
| end | 0.01 ms |
| removing tmp table | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 10 | JDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
| 8 | plgSystemContentbuilder_system->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.80 ms Nach letzter Abfrage: 11.54 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.242 MB Zeilen zurückgegeben: 0
Select
form.id As form_id,
form.act_as_registration,
form.default_category,
form.registration_name_field,
form.registration_username_field,
form.registration_email_field,
form.registration_email_repeat_field,
form.`last_update`,
article.`article_id`,
form.`title_field`,
form.`create_articles`,
form.`name`,
form.`use_view_name_as_title`,
form.`protect_upload_directory`,
form.`reference_id`,
records.`record_id`,
form.`type`,
form.`published_only`,
form.`own_only`,
form.`own_only_fe`,
records.`last_update` As record_last_update,
article.`last_update` As article_last_update
From
VCD_contentbuilder_records As records
Left Join VCD_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join VCD_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join VCD_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
Where
form.`published` = 1
And
form.create_articles = 1
And
form.`type` = records.`type`
And
form.reference_id = records.reference_id
And
(
(
article.form_id = form.id
And
article.record_id = records.record_id
And
article.article_id = content.id
And
( content.state = 1 Or content.state = 0 )
And
(
form.`last_update` > article.`last_update`
Or
records.`last_update` > article.`last_update`
)
)
Or
(
form.id Is Not Null
And records.id Is Not Null
And content.id Is Null
And article.id Is Null
)
)
Limit 50| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | form | NULL | ALL | PRIMARY,reference_id | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 3 | 33.33 | Using where |
| 1 | SIMPLE | records | NULL | ref | PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7 | reference_id | 4 | db715876307.form.reference_id | 253 | 50.00 | Using where |
| 1 | SIMPLE | article | NULL | ref | record_id,record_id_2 | record_id | 12 | db715876307.records.record_id,db715876307.form.id | 1 | 60.00 | Using where |
| 1 | SIMPLE | content | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.article.article_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.16 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.09 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.65 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516 |
| 9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
| 8 | plgSystemContentbuilder_system->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.24 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 11.495 MB Zeilen zurückgegeben: 63
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM VCD_menu AS m
LEFT JOIN VCD_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 133 | 10.00 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Sorting result | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.76 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.92 ms Nach letzter Abfrage: 15.29 ms Abfragespeichernutzung: 0.068 MB Speichernutzung vor Abfrage: 12.548 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_template_styles`
WHERE `client_id` = 0
AND `id` = '11'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_template_styles | NULL | const | PRIMARY,idx_client_id,idx_client_id_home | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/plugins/system/helixultimate/src/Platform/Helper.php:58 |
| 10 | HelixUltimate\Framework\Platform\Helper::getTemplateStyle() | JROOT/plugins/system/helixultimate/helixultimate.php:215 |
| 9 | PlgSystemHelixultimate->attachWebAsset() | JROOT/plugins/system/helixultimate/helixultimate.php:245 |
| 8 | PlgSystemHelixultimate->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.576 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.27 ms |
| end | 0.01 ms |
| query end | 0.14 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431 |
| 9 | plgSystemJomclassifiedsLocationManager->getCfg() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:137 |
| 8 | plgSystemJomclassifiedsLocationManager->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 4.86 ms Nach letzter Abfrage: 1.86 ms Abfragespeichernutzung: 0.071 MB Speichernutzung vor Abfrage: 12.703 MB Zeilen zurückgegeben: 3
SELECT id, home, template, s.params
FROM VCD_template_styles as s
LEFT JOIN VCD_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 7 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | db715876307.e.element | 1 | 71.43 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.09 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 18 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 17 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 16 | Joomla\CMS\HTML\HTMLHelper::script() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 14 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 13 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
| 12 | JHtmlJquery::framework() | Derselbe Aufruf in der Zeile darunter. |
| 11 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 10 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 9 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:143 |
| 8 | plgSystemJomclassifiedsLocationManager->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 2.07 ms Nach letzter Abfrage: 1.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.754 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.41 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431 |
| 10 | plgSystemJomclassifiedsLocationManager->getCfg() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:112 |
| 9 | plgSystemJomclassifiedsLocationManager->JomclRegisterRedirect() | JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:151 |
| 8 | plgSystemJomclassifiedsLocationManager->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.88 ms Nach letzter Abfrage: 17.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.235 MB Zeilen zurückgegeben: 72
SELECT `keyname`,`value`
FROM VCD_jem_config
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jem_config | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 72 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jem/classes/config.class.php:108 |
| 10 | JemConfig->loadData() | JROOT/components/com_jem/classes/config.class.php:65 |
| 9 | JemConfig->__construct() | JROOT/components/com_jem/classes/config.class.php:49 |
| 8 | JemConfig::getInstance() | JROOT/components/com_jem/helpers/helper.php:77 |
| 7 | JemHelper::addFileLogger() | JROOT/components/com_jem/jem.php:32 |
| 6 | require_once JROOT/components/com_jem/jem.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: 18.57 ms Nach letzter Abfrage: 5.59 ms Abfragespeichernutzung: 0.131 MB Speichernutzung vor Abfrage: 15.643 MB Zeilen zurückgegeben: 1803
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.groupid,a.id AS multi
FROM VCD_jem_categories as c
LEFT JOIN VCD_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN VCD_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1))
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 10 | 10.00 | Using where; Using temporary |
| 1 | SIMPLE | rel | NULL | ref | category event relation,catid | category event relation | 4 | db715876307.c.id | 100 | 100.00 | Using where; Using index |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.rel.itemid | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 15.69 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| removing tmp table | 0.12 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/components/com_jem/models/event.php:384 |
| 12 | JemModelEvent->getCategories() | JROOT/components/com_jem/models/event.php:137 |
| 11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
| 9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
| 8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
| 6 | require_once JROOT/components/com_jem/jem.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.80 ms Nach letzter Abfrage: 1.01 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 15.649 MB Zeilen zurückgegeben: 1
SELECT a.id, a.id AS did, a.title, a.alias, a.dates, a.enddates, a.times, a.endtimes, a.access, a.attribs, a.metadata, a.custom1, a.custom2, a.custom3, a.custom4, a.custom5, a.custom6, a.custom7, a.custom8, a.custom9, a.custom10, a.created, a.created_by, a.published, a.registra, a.unregistra, a.unregistra_until,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.datimage, a.version, a.featured, a.meta_keywords, a.meta_description, a.created_by_alias, a.introtext, a.fulltext, a.maxplaces, a.waitinglist, a.hits, a.language, a.recurrence_type, a.recurrence_first_id,u.username AS author,con.id AS conid, con.name AS conname, con.telephone AS contelephone, con.email_to AS conemail,l.custom1 AS venue1, l.custom2 AS venue2, l.custom3 AS venue3, l.custom4 AS venue4, l.custom5 AS venue5, l.custom6 AS venue6, l.custom7 AS venue7, l.custom8 AS venue8, l.custom9 AS venue9, l.custom10 AS venue10, l.id AS locid, l.alias AS localias, l.venue, l.city, l.state, l.url, l.locdescription, l.locimage, l.postalCode, l.street, l.country, l.map, l.created_by AS venueowner, l.latitude, l.longitude, l.checked_out AS vChecked_out, l.checked_out_time AS vChecked_out_time, l.published as locpublished,(
SELECT MAX(contact.id) AS id
FROM VCD_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by
AND (contact.language in ('de-DE','*') OR contact.language IS NULL)) as contactid2
FROM VCD_jem_events AS a
LEFT JOIN VCD_users AS u
on u.id = a.created_by
LEFT JOIN VCD_contact_details AS con
ON con.id = a.contactid
LEFT JOIN VCD_jem_venues AS l
ON a.locid = l.id
LEFT JOIN VCD_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN VCD_jem_categories AS c
ON c.id = rel.catid
WHERE a.id = 1934
AND c.id IN (1,2,3,4,5,6,7,8,9,10)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | con | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| 1 | PRIMARY | l | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.rel.catid | 1 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | contact | NULL | ref | idx_state,idx_language | idx_state | 1 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.16 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.63 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/models/event.php:145 |
| 11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
| 9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
| 8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
| 6 | require_once JROOT/components/com_jem/jem.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.668 MB Zeilen zurückgegeben: 1
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.groupid,a.id AS multi
FROM VCD_jem_categories as c
LEFT JOIN VCD_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN VCD_jem_events AS a
ON a.id = rel.itemid
WHERE rel.itemid =1934
AND c.published = 1
AND (c.access IN (1,1))
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | rel | NULL | ref | category event relation,catid,itemid | itemid | 4 | const | 1 | 100.00 | Using where; Using temporary |
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.rel.catid | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jem/models/event.php:387 |
| 12 | JemModelEvent->getCategories() | JROOT/components/com_jem/models/event.php:165 |
| 11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
| 9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
| 8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
| 6 | require_once JROOT/components/com_jem/jem.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.671 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM VCD_jem_register
WHERE event = '1934'
AND waiting = 0
AND status = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jem_register | NULL | ref | idx_event,idx_event_status | idx_event | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.21 ms |
| init | 0.02 ms |
| System lock | 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 | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_jem/models/event.php:215 |
| 11 | JemModelEvent->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:48 |
| 9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
| 8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
| 6 | require_once JROOT/components/com_jem/jem.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.673 MB Zeilen zurückgegeben: 0
SELECT IF (status > 0, waiting + 1, status) AS status, id, comment
FROM VCD_jem_register
WHERE uid = '0'
AND event = '1934'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_jem/models/event.php:428 |
| 11 | JemModelEvent->getUserRegistration() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_jem/views/event/view.html.php:59 |
| 9 | JemViewEvent->display() | JROOT/components/com_jem/controller.php:104 |
| 8 | JemController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_jem/jem.php:45 |
| 6 | require_once JROOT/components/com_jem/jem.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.59 ms Nach letzter Abfrage: 1.58 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 15.732 MB Zeilen zurückgegeben: 1
SELECT language,id
FROM `VCD_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 134 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.27 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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: 5.86 ms Nach letzter Abfrage: 24.48 ms Abfragespeichernutzung: 0.258 MB Speichernutzung vor Abfrage: 17.953 MB Zeilen zurückgegeben: 23
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM VCD_modules AS m
LEFT JOIN VCD_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN VCD_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 <= '2025-12-13 16:18:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-13 16:18:18')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 150 OR mm.menuid <= 0)
AND m.language IN ('de-DE','*')
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 67 | 1.60 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | db715876307.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | db715876307.m.id | 3 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.05 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 3.15 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | Derselbe 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:441 |
| 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 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:601 |
| 12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:994 |
| 11 | HelixUltimate\Framework\Core\HelixUltimate->count_modules() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:728 |
| 10 | HelixUltimate\Framework\Core\HelixUltimate->get_current_row() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:630 |
| 9 | HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:596 |
| 8 | HelixUltimate\Framework\Core\HelixUltimate->render_layout() | JROOT/templates/h4/index.php:153 |
| 7 | require JROOT/templates/h4/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 |
Abfragezeit: 0.79 ms Nach letzter Abfrage: 6.98 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 18.350 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.29 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jomclassifieds/etc/utils.php:110 |
| 22 | JomclUtils::getCfg() | JROOT/components/com_jomclassifieds/router.php:72 |
| 21 | JomClassifiedsBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 20 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 19 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 18 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 15 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 14 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_menu/helper.php:139 |
| 13 | ModMenuHelper::getList() | JROOT/modules/mod_menu/mod_menu.php:15 |
| 12 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 11 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php:65 |
| 10 | include JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 9 | Joomla\CMS\Layout\FileLayout->render() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1634 |
| 8 | HelixUltimate\Framework\Core\HelixUltimate->getOffcanvasStyle() | JROOT/templates/h4/index.php:163 |
| 7 | require JROOT/templates/h4/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 |
Abfragezeit: 2.94 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 18.372 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.47 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jomclassifieds/etc/utils.php:110 |
| 22 | JomclUtils::getCfg() | JROOT/components/com_jomclassifieds/router.php:72 |
| 21 | JomClassifiedsBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 20 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 19 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 18 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 15 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 14 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_menu/helper.php:139 |
| 13 | ModMenuHelper::getList() | JROOT/modules/mod_menu/mod_menu.php:15 |
| 12 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 11 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php:65 |
| 10 | include JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
| 9 | Joomla\CMS\Layout\FileLayout->render() | JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1634 |
| 8 | HelixUltimate\Framework\Core\HelixUltimate->getOffcanvasStyle() | JROOT/templates/h4/index.php:163 |
| 7 | require JROOT/templates/h4/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 |
Abfragezeit: 0.78 ms Nach letzter Abfrage: 15.44 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 18.505 MB Zeilen zurückgegeben: 1
SELECT params
FROM VCD_extensions
WHERE `type` = 'plugin'
AND `element` = 'jlsitemap_cron'
AND `folder` = 'system'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 5.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:197 |
| 8 | PlgSystemJLSitemap_Cron->checkCacheTime() | JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:52 |
| 7 | PlgSystemJLSitemap_Cron->onBeforeRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1102 |
| 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 |
Abfragezeit: 2.27 ms Nach letzter Abfrage: 11.53 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 19.340 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 VCD_fields AS a
LEFT JOIN `VCD_languages` AS l
ON l.lang_code = a.language
LEFT JOIN VCD_users AS uc
ON uc.id=a.checked_out
LEFT JOIN VCD_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN VCD_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN VCD_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
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 ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_context | 766 | const | 1 | 8.51 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | db715876307.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db715876307.a.group_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.22 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.19 ms |
| preparing | 0.05 ms |
| Creating tmp table | 0.11 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.70 ms |
| Creating sort index | 0.07 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| removing tmp table | 0.20 ms |
| query end | 0.05 ms |
| closing tables | 0.03 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 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 |
Abfragezeit: 4.40 ms Nach letzter Abfrage: 3.11 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 19.409 MB Zeilen zurückgegeben: 175
SELECT name,value
FROM VCD_jomcl_options
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_jomcl_options | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 175 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.49 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jomclassifieds/etc/utils.php:110 |
| 20 | JomclUtils::getCfg() | JROOT/components/com_jomclassifieds/router.php:72 |
| 19 | JomClassifiedsBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 18 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_breadcrumbs/helper.php:61 |
| 11 | ModBreadCrumbsHelper::getList() | JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 |
| 10 | include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 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 |
Abfragezeit: 0.77 ms Nach letzter Abfrage: 7.08 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 19.891 MB Zeilen zurückgegeben: 15
SELECT `id`,`referencekey`,`value`,`isSystem`,`editable`
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'system'
AND `section` = 'global'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 214 | const,const | 15 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 33 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 32 | JDatabaseDriver->loadAssocList() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:180 |
| 31 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:87 |
| 30 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findAllByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/Section.php:76 |
| 29 | Nextend\Framework\Model\Section::getAll() | JROOT/libraries/smartslider3/src/Framework/Settings.php:30 |
| 28 | Nextend\Framework\Settings->__construct() | JROOT/libraries/smartslider3/src/Framework/Settings.php:67 |
| 27 | require JROOT/libraries/smartslider3/src/Framework/Settings.php | JROOT/libraries/smartslider3/src/Autoloader.php:194 |
| 26 | Nextend\Autoloader->requireFile() | JROOT/libraries/smartslider3/src/Autoloader.php:175 |
| 25 | Nextend\Autoloader->loadMappedFile() | JROOT/libraries/smartslider3/src/Autoloader.php:128 |
| 24 | Nextend\Autoloader->loadClass() | JROOT/libraries/smartslider3/src/Framework/ResourceTranslator/ResourceTranslator.php:26 |
| 23 | Nextend\Framework\ResourceTranslator\ResourceTranslator->init() | JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:16 |
| 22 | Nextend\Framework\ResourceTranslator\ResourceTranslator->__construct() | JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:12 |
| 21 | Nextend\Framework\ResourceTranslator\ResourceTranslator::getInstance() | JROOT/libraries/smartslider3/src/Framework/ResourceTranslator/ResourceTranslator.php:175 |
| 20 | require JROOT/libraries/smartslider3/src/Framework/ResourceTranslator/ResourceTranslator.php | JROOT/libraries/smartslider3/src/Autoloader.php:194 |
| 19 | Nextend\Autoloader->requireFile() | JROOT/libraries/smartslider3/src/Autoloader.php:175 |
| 18 | Nextend\Autoloader->loadMappedFile() | JROOT/libraries/smartslider3/src/Autoloader.php:128 |
| 17 | Nextend\Autoloader->loadClass() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:47 |
| 16 | Nextend\Framework\Application\AbstractApplicationType->__construct() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/ApplicationSmartSlider3.php:30 |
| 15 | Nextend\SmartSlider3\Application\ApplicationSmartSlider3->init() | JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:16 |
| 14 | Nextend\Framework\Application\AbstractApplication->__construct() | JROOT/libraries/smartslider3/src/Framework/Pattern/SingletonTrait.php:12 |
| 13 | Nextend\Framework\Application\AbstractApplication::getInstance() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:7 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 1.10 ms Nach letzter Abfrage: 5.62 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 20.524 MB Zeilen zurückgegeben: 0
SELECT `id`,`referencekey`,`value`,`isSystem`,`editable`
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'system'
AND `section` = 'fonts'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 214 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 31 | JDatabaseDriver->loadAssocList() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:180 |
| 30 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:87 |
| 29 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findAllByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/Section.php:76 |
| 28 | Nextend\Framework\Model\Section::getAll() | JROOT/libraries/smartslider3/src/Framework/Font/FontSettings.php:82 |
| 27 | Nextend\Framework\Font\FontSettings::load() | JROOT/libraries/smartslider3/src/Framework/Font/FontSettings.php:23 |
| 26 | Nextend\Framework\Font\FontSettings->__construct() | JROOT/libraries/smartslider3/src/Framework/Font/FontSettings.php:138 |
| 25 | require JROOT/libraries/smartslider3/src/Framework/Font/FontSettings.php | JROOT/libraries/smartslider3/src/Autoloader.php:194 |
| 24 | Nextend\Autoloader->requireFile() | JROOT/libraries/smartslider3/src/Autoloader.php:175 |
| 23 | Nextend\Autoloader->loadMappedFile() | JROOT/libraries/smartslider3/src/Autoloader.php:128 |
| 22 | Nextend\Autoloader->loadClass() | JROOT/libraries/smartslider3/src/Framework/Font/Sources/GoogleFonts/GoogleFonts.php:107 |
| 21 | Nextend\Framework\Font\Sources\GoogleFonts\GoogleFonts->onFontManagerLoad() | JROOT/libraries/smartslider3/src/Framework/Font/FontSources.php:44 |
| 20 | Nextend\Framework\Font\FontSources::onFontManagerLoad() | JROOT/libraries/smartslider3/src/Framework/Asset/Predefined.php:57 |
| 19 | Nextend\Framework\Asset\Predefined::frontend() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:125 |
| 18 | Nextend\Framework\Controller\AbstractController->initialize() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:50 |
| 17 | Nextend\Framework\Controller\AbstractController->__construct() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/ApplicationTypeFrontend.php:24 |
| 16 | Nextend\SmartSlider3\Application\Frontend\ApplicationTypeFrontend->getControllerSlider() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:104 |
| 14 | Nextend\Framework\Application\AbstractApplicationType->getController() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:86 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 0.52 ms Nach letzter Abfrage: 5.35 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 20.952 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'cache'
AND `section` = 'notweb/n2-ss-12'
AND `referencekey` = 'variations.manifest'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 366 | const,const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 26 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 25 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 24 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 23 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/Framework/Cache/Storage/Database.php:32 |
| 22 | Nextend\Framework\Cache\Storage\Database->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/AbstractCache.php:72 |
| 21 | Nextend\Framework\Cache\AbstractCache->exists() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:42 |
| 20 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:129 |
| 19 | Nextend\SmartSlider3\SliderManager\SliderManager->cacheSlider() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:114 |
| 18 | Nextend\SmartSlider3\SliderManager\SliderManager->render() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ViewDisplay.php:30 |
| 17 | Nextend\SmartSlider3\Application\Frontend\Slider\ViewDisplay->display() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ControllerSlider.php:18 |
| 16 | Nextend\SmartSlider3\Application\Frontend\Slider\ControllerSlider->actionDisplay() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:92 |
| 14 | Nextend\Framework\Controller\AbstractController->doAction() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:88 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 0.77 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 20.963 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'cache'
AND `section` = 'notweb/n2-ss-12'
AND `referencekey` = 'data.manifest'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 366 | const,const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 26 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 25 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 24 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 23 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/Framework/Cache/Storage/Database.php:32 |
| 22 | Nextend\Framework\Cache\Storage\Database->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/AbstractCache.php:72 |
| 21 | Nextend\Framework\Cache\AbstractCache->exists() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:47 |
| 20 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:129 |
| 19 | Nextend\SmartSlider3\SliderManager\SliderManager->cacheSlider() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:114 |
| 18 | Nextend\SmartSlider3\SliderManager\SliderManager->render() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ViewDisplay.php:30 |
| 17 | Nextend\SmartSlider3\Application\Frontend\Slider\ViewDisplay->display() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ControllerSlider.php:18 |
| 16 | Nextend\SmartSlider3\Application\Frontend\Slider\ControllerSlider->actionDisplay() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:92 |
| 14 | Nextend\Framework\Controller\AbstractController->doAction() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:88 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 20.974 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'cache'
AND `section` = 'notweb/n2-ss-12'
AND `referencekey` = 'sliderde-DE1.manifest'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 366 | const,const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 28 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 27 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 26 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 25 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/Framework/Cache/Storage/Database.php:32 |
| 24 | Nextend\Framework\Cache\Storage\Database->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/AbstractCache.php:72 |
| 23 | Nextend\Framework\Cache\AbstractCache->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:48 |
| 22 | Nextend\Framework\Cache\Manifest->isCached() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:28 |
| 21 | Nextend\Framework\Cache\Manifest->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:54 |
| 20 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:129 |
| 19 | Nextend\SmartSlider3\SliderManager\SliderManager->cacheSlider() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:114 |
| 18 | Nextend\SmartSlider3\SliderManager\SliderManager->render() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ViewDisplay.php:30 |
| 17 | Nextend\SmartSlider3\Application\Frontend\Slider\ViewDisplay->display() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ControllerSlider.php:18 |
| 16 | Nextend\SmartSlider3\Application\Frontend\Slider\ControllerSlider->actionDisplay() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:92 |
| 14 | Nextend\Framework\Controller\AbstractController->doAction() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:88 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 20.995 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'smartslider'
AND `section` = 'sliderChanged'
AND `referencekey` = 12
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 214 | const,const | 10 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 28 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 27 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 26 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 25 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Helper/HelperSliderChanged.php:36 |
| 24 | Nextend\SmartSlider3\Application\Helper\HelperSliderChanged->isSliderChanged() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:114 |
| 23 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->isCacheValid() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:52 |
| 22 | Nextend\Framework\Cache\Manifest->isCached() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:28 |
| 21 | Nextend\Framework\Cache\Manifest->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:54 |
| 20 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:129 |
| 19 | Nextend\SmartSlider3\SliderManager\SliderManager->cacheSlider() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:114 |
| 18 | Nextend\SmartSlider3\SliderManager\SliderManager->render() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ViewDisplay.php:30 |
| 17 | Nextend\SmartSlider3\Application\Frontend\Slider\ViewDisplay->display() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ControllerSlider.php:18 |
| 16 | Nextend\SmartSlider3\Application\Frontend\Slider\ControllerSlider->actionDisplay() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:92 |
| 14 | Nextend\Framework\Controller\AbstractController->doAction() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:88 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
Abfragezeit: 0.77 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.006 MB Zeilen zurückgegeben: 1
SELECT *
FROM `VCD_nextend2_section_storage`
WHERE `application` = 'cache'
AND `section` = 'notweb/n2-ss-12'
AND `referencekey` = 'sliderde-DE1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | VCD_nextend2_section_storage | NULL | ref | application,application_2 | application | 366 | const,const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 28 | JDatabaseDriver->loadAssoc() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 |
| 27 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() | JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 |
| 26 | Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() | JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 |
| 25 | Nextend\Framework\Model\ApplicationSection->get() | JROOT/libraries/smartslider3/src/Framework/Cache/Storage/Database.php:32 |
| 24 | Nextend\Framework\Cache\Storage\Database->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/AbstractCache.php:72 |
| 23 | Nextend\Framework\Cache\AbstractCache->exists() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:52 |
| 22 | Nextend\Framework\Cache\Manifest->isCached() | JROOT/libraries/smartslider3/src/Framework/Cache/Manifest.php:28 |
| 21 | Nextend\Framework\Cache\Manifest->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/Slider/Cache/CacheSlider.php:54 |
| 20 | Nextend\SmartSlider3\Slider\Cache\CacheSlider->makeCache() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:129 |
| 19 | Nextend\SmartSlider3\SliderManager\SliderManager->cacheSlider() | JROOT/libraries/smartslider3/src/SmartSlider3/SliderManager/SliderManager.php:114 |
| 18 | Nextend\SmartSlider3\SliderManager\SliderManager->render() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ViewDisplay.php:30 |
| 17 | Nextend\SmartSlider3\Application\Frontend\Slider\ViewDisplay->display() | JROOT/libraries/smartslider3/src/SmartSlider3/Application/Frontend/Slider/ControllerSlider.php:18 |
| 16 | Nextend\SmartSlider3\Application\Frontend\Slider\ControllerSlider->actionDisplay() | Derselbe Aufruf in der Zeile darunter. |
| 15 | call_user_func_array() | JROOT/libraries/smartslider3/src/Framework/Controller/AbstractController.php:92 |
| 14 | Nextend\Framework\Controller\AbstractController->doAction() | JROOT/libraries/smartslider3/src/Framework/Application/AbstractApplicationType.php:88 |
| 13 | Nextend\Framework\Application\AbstractApplicationType->process() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/compat.php:10 |
| 12 | nextend_smartslider3() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:179 |
| 11 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3::prepare() | Derselbe Aufruf in der Zeile darunter. |
| 10 | preg_replace_callback() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:89 |
| 9 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->displaySliders() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:118 |
| 8 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onNextendBeforeCompileHead() | JROOT/libraries/smartslider3/src/SmartSlider3/Platform/Joomla/Plugin/PluginSmartSlider3.php:130 |
| 7 | Nextend\SmartSlider3\Platform\Joomla\Plugin\PluginSmartSlider3->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
| 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 |
6 × SELECT *
FROM `VCD_nextend2_section_storage`
6 × SELECT name,value
FROM VCD_jomcl_option
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `VCD_extensions`
2 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.groupid,a.id AS multi
FROM VCD_jem_categories as c
LEFT JOIN VCD_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN VCD_jem_events AS a
ON a.id = rel.itemid
2 × SELECT `id`,`referencekey`,`value`,`isSystem`,`editable`
FROM `VCD_nextend2_section_storage`
1 × SELECT id, rules
FROM `VCD_viewlevels
1 × SELECT b.id
FROM VCD_usergroups AS a
LEFT JOIN VCD_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM VCD_extensions
1 × SELECT *
FROM VCD_languages
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `VCD_extensions`
1 × Select form.id As form_id, form.act_as_registration, form.default_category, form.registration_name_field, form.registration_username_field, form.registration_email_field, form.registration_email_repeat_field, form.`last_update`, article.`article_id`, form.`title_field`, form.`create_articles`, form.`name`, form.`use_view_name_as_title`, form.`protect_upload_directory`, form.`reference_id`, records.`record_id`, form.`type`, form.`published_only`, form.`own_only`, form.`own_only_fe`, records.`last_update` As record_last_update, article.`last_update` As article_last_update
From VCD_contentbuilder_records As records
Left Join VCD_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join VCD_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join VCD_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM VCD_menu AS m
LEFT JOIN VCD_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM `VCD_template_styles`
1 × SELECT id, home, template, s.params
FROM VCD_template_styles as s
LEFT JOIN VCD_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `keyname`,`value`
FROM VCD_jem_confi
1 × SELECT a.id, a.id AS did, a.title, a.alias, a.dates, a.enddates, a.times, a.endtimes, a.access, a.attribs, a.metadata, a.custom1, a.custom2, a.custom3, a.custom4, a.custom5, a.custom6, a.custom7, a.custom8, a.custom9, a.custom10, a.created, a.created_by, a.published, a.registra, a.unregistra, a.unregistra_until,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.datimage, a.version, a.featured, a.meta_keywords, a.meta_description, a.created_by_alias, a.introtext, a.fulltext, a.maxplaces, a.waitinglist, a.hits, a.language, a.recurrence_type, a.recurrence_first_id,u.username AS author,con.id AS conid, con.name AS conname, con.telephone AS contelephone, con.email_to AS conemail,l.custom1 AS venue1, l.custom2 AS venue2, l.custom3 AS venue3, l.custom4 AS venue4, l.custom5 AS venue5, l.custom6 AS venue6, l.custom7 AS venue7, l.custom8 AS venue8, l.custom9 AS venue9, l.custom10 AS venue10, l.id AS locid, l.alias AS localias, l.venue, l.city, l.state, l.url, l.locdescription, l.locimage, l.postalCode, l.street, l.country, l.map, l.created_by AS venueowner, l.latitude, l.longitude, l.checked_out AS vChecked_out, l.checked_out_time AS vChecked_out_time, l.published as locpublished,( SELECT MAX(contact.id) AS id
FROM VCD_contact_details AS contact
1 × SELECT COUNT(*)
FROM VCD_jem_register
1 × SELECT IF (status > 0, waiting + 1, status) AS status, id, comment
FROM VCD_jem_register
1 × SELECT language,id
FROM `VCD_menu`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM VCD_modules AS m
LEFT JOIN VCD_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN VCD_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT params
FROM VCD_extensions
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 VCD_fields AS a
LEFT JOIN `VCD_languages` AS l
ON l.lang_code = a.language
LEFT JOIN VCD_users AS uc
ON uc.id=a.checked_out
LEFT JOIN VCD_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN VCD_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN VCD_fields_groups AS g
ON g.id = a.group_id
