Forespørgsels tid: 0.59 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 1.238 MB Rækker returneret: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'73316b7662666b31316a636b6961337570336a62366867326b71'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Samme som kald i linjen nedenunder. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:832 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:392 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Forespørgsels tid: 0.46 ms Efter sidste forespørgsel: 1.32 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 1.316 MB Rækker returneret: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'73316b7662666b31316a636b6961337570336a62366867326b71'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:834 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:392 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Forespørgsels tid: 3.43 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.004 MB hukommelse før forespørgsel: 1.321 MB
INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'73316b7662666b31316a636b6961337570336a62366867326b71', 1, 1701824019, 0, '', 0)
FORKLAR ikke mulig på forespørgsel: INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'73316b7662666b31316a636b6961337570336a62366867326b71', 1, 1701824019, 0, '', 0)
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:834 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:392 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Forespørgsels tid: 0.84 ms Efter sidste forespørgsel: 2.40 ms Forespørgsels hukommelse: 0.045 MB hukommelse før forespørgsel: 1.356 MB Rækker returneret: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 45 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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}() | Samme som kald i linjen nedenunder. |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.39 ms Efter sidste forespørgsel: 1.61 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 1.417 MB Rækker returneret: 23
SELECT id, rules
FROM `jos_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_viewlevels | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 22 | |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.50 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 1.437 MB Rækker returneret: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.90 ms Efter sidste forespørgsel: 0.14 ms Forespørgsels hukommelse: 0.035 MB hukommelse før forespørgsel: 1.459 MB Rækker returneret: 115
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,4)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 181 | Using index condition; Using where; Anvender filesort |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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}() | Samme som kald i linjen nedenunder. |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.47 ms Efter sidste forespørgsel: 5.44 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 1.814 MB Rækker returneret: 0
SELECT `path`
FROM jos_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_rsfirewall_ignored | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:29 |
| 7 | plgSystemRsfirewall->__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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.46 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 1.821 MB Rækker returneret: 0
SELECT `file`
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_rsfirewall_hashes | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 160 | Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:29 |
| 7 | plgSystemRsfirewall->__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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.029 MB hukommelse før forespørgsel: 1.826 MB Rækker returneret: 67
SELECT *
FROM jos_rsfirewall_configuration
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_rsfirewall_configuration | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 57 | |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:29 |
| 7 | plgSystemRsfirewall->__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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.79 ms Efter sidste forespørgsel: 4.31 ms Forespørgsels hukommelse: 0.028 MB hukommelse før forespørgsel: 2.032 MB Rækker returneret: 10
SHOW FULL COLUMNS
FROM `jos_rsfirewall_logs`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `jos_rsfirewall_logs`
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 |
| 11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:24 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:78 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:56 |
| 7 | plgSystemRsfirewall->__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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.47 ms Efter sidste forespørgsel: 5.72 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 2.273 MB Rækker returneret: 2
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_languages | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 2 | Using where; Anvender filesort |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.283 MB Rækker returneret: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jos_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 4 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 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:673 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.53 ms Efter sidste forespørgsel: 5.28 ms Forespørgsels hukommelse: 0.028 MB hukommelse før forespørgsel: 2.339 MB Rækker returneret: 1
SELECT *
FROM jos_extensions
WHERE element='mailster'
AND folder='system'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/PluginUtils.php:193 |
| 10 | MstPluginUtils::getPlugin() | JROOT/plugins/system/mailster/mailster.php:59 |
| 9 | plgSystemMailster->initMailPlugin() | JROOT/plugins/system/mailster/mailster.php:75 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.52 ms Efter sidste forespørgsel: 1.55 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 2.647 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 15 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 14 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 13 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 12 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 11 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 10 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 9 | MstLog::debug() | JROOT/plugins/system/mailster/mailster.php:150 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.52 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 2.655 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/plugins/system/mailster/mailster.php:328 |
| 10 | plgSystemMailster->isMaintenanceRequired() | JROOT/plugins/system/mailster/mailster.php:195 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.51 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 2.666 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 16 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 15 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 14 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 13 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 12 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 11 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 10 | MstLog::debug() | JROOT/plugins/system/mailster/mailster.php:199 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.71 ms Efter sidste forespørgsel: 1.05 ms Forespørgsels hukommelse: 0.032 MB hukommelse før forespørgsel: 2.693 MB Rækker returneret: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_aktuarmember','com_aktuarpayment','com_aktuarsubscription','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventbooking','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailster','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 45 | Using index condition |
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_mailster/mailster/app/Authorization.php:46 |
| 15 | MstAuthorization::getActions() | JROOT/administrator/components/com_mailster/model_legacy.php:31 |
| 14 | MailsterModel->__construct() | JROOT/administrator/components/com_mailster/models/mails.php:46 |
| 13 | MailsterModelMails->__construct() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance() | JROOT/administrator/components/com_mailster/mailster/Factory.php:435 |
| 11 | MstFactory::getModel() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:168 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.05 ms Efter sidste forespørgsel: 4.34 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 2.842 MB Rækker returneret: 80
SHOW FULL COLUMNS
FROM jos_mailster_lists
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM jos_mailster_lists
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:445 |
| 13 | MstDBUtils::getTableColumns() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:386 |
| 12 | MstDBUtils::isColExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:181 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.82 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 2.848 MB Rækker returneret: 80
SHOW FULL COLUMNS
FROM jos_mailster_lists
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM jos_mailster_lists
Ingen VIS PROFIL (måske fordi der er mere en 100 forespørgsler)
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:453 |
| 13 | MstDBUtils::getTableColumns() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:386 |
| 12 | MstDBUtils::isColExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:181 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.58 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.854 MB Rækker returneret: 1
Dublet forespørgsler:
#37SHOW TABLES LIKE 'jos_mailster_servers'
FORKLAR ikke mulig på forespørgsel: SHOW TABLES LIKE 'jos_mailster_servers'
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| Checking permissions | 0.15 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:403 |
| 12 | MstDBUtils::isTableExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:181 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.95 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.071 MB hukommelse før forespørgsel: 2.861 MB Rækker returneret: 14
Dublet forespørgsler:
#38SELECT l.*, inbox.server_host AS mail_in_host, inbox.server_port AS mail_in_port, inbox.secure_protocol AS mail_in_use_secure, inbox.secure_authentication AS mail_in_use_sec_auth, inbox.protocol AS mail_in_protocol, inbox.connection_parameter AS mail_in_params, outbox.server_host AS mail_out_host, outbox.server_port AS mail_out_port, outbox.secure_protocol AS mail_out_use_secure, outbox.secure_authentication AS mail_out_use_sec_auth
FROM jos_mailster_lists l
LEFT JOIN jos_mailster_servers inbox
ON (l.server_inb_id = inbox.id)
LEFT JOIN jos_mailster_servers outbox
ON (l.server_out_id = outbox.id)
ORDER BY l.name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | l | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 14 | Anvender filesort |
| 1 | SIMPLE | inbox | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.l.server_inb_id | 1 | |
| 1 | SIMPLE | outbox | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.l.server_out_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.18 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:190 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:181 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.50 ms Efter sidste forespørgsel: 0.10 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 3.051 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 13 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 12 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:103 |
| 11 | MstConfiguration::getKeepBlockedEmailsForDays() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:182 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.44 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 3.058 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 13 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 12 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:112 |
| 11 | MstConfiguration::getKeepBouncedEmailsForDays() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:183 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.064 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:185 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.52 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.073 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:186 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.35 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.082 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:188 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.61 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 3.089 MB Rækker returneret: 0
SELECT m.id
FROM jos_mailster_mails AS m
WHERE m.receive_timestamp < DATE_SUB(CURDATE(), INTERVAL 30 DAY)
AND m.blocked_mail = '1'
LIMIT 0,100
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | blocked_mail,blocked_bounced | blocked_mail | 2 | const | 22 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.18 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_mailster/models/mails.php:376 |
| 11 | MailsterModelMails->getEmailsOlderThanDays() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:189 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.58 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 3.095 MB Rækker returneret: 0
SELECT m.id
FROM jos_mailster_mails AS m
WHERE m.receive_timestamp < DATE_SUB(CURDATE(), INTERVAL 30 DAY)
AND m.bounced_mail = '1'
LIMIT 0,100
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | bounced_mail | bounced_mail | 2 | const | 71 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_mailster/models/mails.php:376 |
| 11 | MailsterModelMails->getEmailsOlderThanDays() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:190 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.42 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.103 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:193 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.112 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:194 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.32 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.120 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:198 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.43 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.028 MB hukommelse før forespørgsel: 3.136 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:205 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.31 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.145 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:208 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.67 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 3.152 MB Rækker returneret: 80
SHOW FULL COLUMNS
FROM jos_mailster_lists
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM jos_mailster_lists
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Checking permissions | 0.00 ms |
| Closing tables | 0.01 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.11 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.06 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:445 |
| 13 | MstDBUtils::getTableColumns() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:386 |
| 12 | MstDBUtils::isColExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:209 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.64 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 3.158 MB Rækker returneret: 80
SHOW FULL COLUMNS
FROM jos_mailster_lists
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM jos_mailster_lists
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Checking permissions | 0.00 ms |
| Closing tables | 0.00 ms |
| Opening tables | 0.14 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.10 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.06 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:453 |
| 13 | MstDBUtils::getTableColumns() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:386 |
| 12 | MstDBUtils::isColExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:209 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.41 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 3.165 MB Rækker returneret: 1
Dublet forespørgsler:
#21SHOW TABLES LIKE 'jos_mailster_servers'
FORKLAR ikke mulig på forespørgsel: SHOW TABLES LIKE 'jos_mailster_servers'
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.00 ms |
| Checking permissions | 0.14 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:403 |
| 12 | MstDBUtils::isTableExisting() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:164 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:209 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.66 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.071 MB hukommelse før forespørgsel: 3.172 MB Rækker returneret: 14
Dublet forespørgsler:
#22SELECT l.*, inbox.server_host AS mail_in_host, inbox.server_port AS mail_in_port, inbox.secure_protocol AS mail_in_use_secure, inbox.secure_authentication AS mail_in_use_sec_auth, inbox.protocol AS mail_in_protocol, inbox.connection_parameter AS mail_in_params, outbox.server_host AS mail_out_host, outbox.server_port AS mail_out_port, outbox.secure_protocol AS mail_out_use_secure, outbox.secure_authentication AS mail_out_use_sec_auth
FROM jos_mailster_lists l
LEFT JOIN jos_mailster_servers inbox
ON (l.server_inb_id = inbox.id)
LEFT JOIN jos_mailster_servers outbox
ON (l.server_out_id = outbox.id)
ORDER BY l.name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | l | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 14 | Anvender filesort |
| 1 | SIMPLE | inbox | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.l.server_inb_id | 1 | |
| 1 | SIMPLE | outbox | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.l.server_out_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.16 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/mailster/mail/MailingListUtils.php:190 |
| 11 | MstMailingListUtils::getAllMailingLists() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:209 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.44 ms Efter sidste forespørgsel: 0.11 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.362 MB Rækker returneret: 1
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_mailster'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:46 |
| 17 | MstApplication::getComponent() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44 |
| 16 | MstConfiguration::getComponentParams() | JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:121 |
| 15 | MstConfiguration::getLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:186 |
| 14 | MstLog::getCurrentLoggingLevel() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:170 |
| 13 | MstLog::loggingLevelSufficient() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:52 |
| 12 | MstLog::log() | JROOT/administrator/components/com_mailster/mailster/app/Log.php:103 |
| 11 | MstLog::debug() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:227 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.12 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 3.369 MB Rækker returneret: 0
SELECT dig.id, dig.list_id, dig.user_id, dig.is_joomla_user, dig.digest_freq, dig.last_send_date, dig.next_send_date
FROM (SELECT *
FROM jos_mailster_digests
WHERE is_joomla_user = 1) dig
LEFT JOIN jos_users usr
ON (dig.user_id = usr.id)
WHERE usr.id IS NULL UNION SELECT dig.id, dig.list_id, dig.user_id, dig.is_joomla_user, dig.digest_freq, dig.last_send_date, dig.next_send_date
FROM (SELECT *
FROM jos_mailster_digests
WHERE is_joomla_user = 0
AND user_id != -1) dig
LEFT JOIN jos_mailster_users usr
ON (dig.user_id = usr.id)
WHERE usr.id IS NULL
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | jos_mailster_digests | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | Using where |
| 1 | PRIMARY | usr | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.jos_mailster_digests.user_id | 1 | Using where; Using index; Not exists |
| 3 | UNION | jos_mailster_digests | ALL | digest_user | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | Using where |
| 3 | UNION | usr | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.jos_mailster_digests.user_id | 1 | Using where; Using index; Not exists |
| NULL | UNION RESULT | <union1,3> | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.44 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.05 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.05 ms |
| Unlocking tables | 0.05 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/models/digest.php:447 |
| 11 | MailsterModelDigest->deleteDigestAndDigestQueueOfOrphanUsers() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:228 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.83 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 3.375 MB Rækker returneret: 0
SELECT gu.group_id, gu.user_id, gu.is_joomla_user
FROM (SELECT *
FROM jos_mailster_group_users
WHERE is_joomla_user = 1) gu
LEFT JOIN jos_users usr
ON (gu.user_id = usr.id)
WHERE usr.id IS NULL UNION SELECT gu.group_id, gu.user_id, gu.is_joomla_user
FROM (SELECT *
FROM jos_mailster_group_users
WHERE is_joomla_user = 0) gu
LEFT JOIN jos_mailster_users usr
ON (gu.user_id = usr.id)
WHERE usr.id IS NULL
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | jos_mailster_group_users | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | Using where |
| 1 | PRIMARY | usr | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.jos_mailster_group_users.user_id | 1 | Using where; Using index; Not exists |
| 3 | UNION | jos_mailster_group_users | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | Using where |
| 3 | UNION | usr | eq_ref | PRIMARY | PRIMARY | 4 | aktuar_dk_joomla.jos_mailster_group_users.user_id | 1 | Using where; Using index; Not exists |
| NULL | UNION RESULT | <union1,3> | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.21 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Sending data | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.04 ms |
| Unlocking tables | 0.05 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mailster/models/groupusers.php:415 |
| 11 | MailsterModelGroupUsers->deleteOrphanGroupUsers() | JROOT/administrator/components/com_mailster/mailster/app/Application.php:229 |
| 10 | MstApplication::performMaintenance() | JROOT/plugins/system/mailster/mailster.php:202 |
| 9 | plgSystemMailster->handleMaintenance() | JROOT/plugins/system/mailster/mailster.php:152 |
| 8 | plgSystemMailster->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:674 |
| 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:203 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.02 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 3.381 MB Rækker returneret: 0
