Forespørgsels tid: 1.04 ms Forespørgsels hukommelse: 0.020 MB hukommelse før forespørgsel: 1.365 MB Rækker returneret: 0
SELECT `session_id`
FROM `namjq_session`
WHERE `session_id` = X'6638366439323430643537373734343633343063623833396233663733373236'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.85 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.05 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Forespørgsels tid: 0.14 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.004 MB hukommelse før forespørgsel: 1.371 MB
INSERT INTO `namjq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6638366439323430643537373734343633343063623833396233663733373236', 1, 1732194095, 0, '', 0)
FORKLAR ikke mulig på forespørgsel: INSERT INTO `namjq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6638366439323430643537373734343633343063623833396233663733373236', 1, 1732194095, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| update | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Forespørgsels tid: 0.95 ms Efter sidste forespørgsel: 4.91 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.527 MB Rækker returneret: 3
SELECT id, rules
FROM `namjq_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_viewlevels | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 3 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.76 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.06 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.82 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.539 MB Rækker returneret: 1
SELECT b.id
FROM namjq_usergroups AS a
LEFT JOIN namjq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.58 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.09 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.75 ms Efter sidste forespørgsel: 5.49 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 1.912 MB Rækker returneret: 37
SELECT `path`
FROM namjq_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_ignored | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 37 | 19.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.48 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.06 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:56 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:41 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.09 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.921 MB Rækker returneret: 0
SELECT `file`
FROM namjq_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_hashes | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 167 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.54 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.27 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.19 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:63 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:41 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.68 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 1.926 MB Rækker returneret: 67
SELECT *
FROM namjq_rsfirewall_configuration
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_configuration | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 67 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.48 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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:71 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:41 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.24 ms Efter sidste forespørgsel: 3.61 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 2.174 MB Rækker returneret: 10
SHOW FULL COLUMNS
FROM `namjq_rsfirewall_logs`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `namjq_rsfirewall_logs`
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.46 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.35 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.07 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | 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:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:38 |
| 11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:31 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:84 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:63 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.07 ms Efter sidste forespørgsel: 10.90 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.627 MB Rækker returneret: 1
Dublet forespørgsler:
#10SELECT template
FROM namjq_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 8 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.74 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.14 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.16 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.634 MB Rækker returneret: 1
SELECT template
FROM namjq_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 8 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.92 ms Efter sidste forespørgsel: 2.87 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 2.818 MB Rækker returneret: 2
SELECT extension, file, type
FROM namjq_rokcommon_configs
ORDER BY priority
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rokcommon_configs | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 2 | 100.00 | Anvender filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.67 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.08 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.71 ms Efter sidste forespørgsel: 15.42 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 3.092 MB Rækker returneret: 18
SHOW FULL COLUMNS
FROM `namjq_extensions`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `namjq_extensions`
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.72 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.45 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.04 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 11 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
| 10 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 9 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.70 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.120 MB Rækker returneret: 1
SELECT `extension_id`
FROM `namjq_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 402 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.26 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.27 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.15 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.127 MB Rækker returneret: 1
Dublet forespørgsler:
#16SELECT *
FROM namjq_extensions
WHERE `extension_id` = '10103'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.16 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.131 MB Rækker returneret: 1
SELECT `extension_id`
FROM `namjq_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.14 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.137 MB Rækker returneret: 1
Dublet forespørgsler:
#14SELECT *
FROM namjq_extensions
WHERE `extension_id` = '10103'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.26 ms Efter sidste forespørgsel: 22.11 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 3.752 MB Rækker returneret: 8
SELECT `id`
FROM `namjq_usergroups`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_usergroups | NULL | index | NULL | PRIMARY | 4 | NULL | 8 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:28 |
| 10 | RSFirewallUsersHelper::getAdminGroups() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:46 |
| 9 | RSFirewallUsersHelper::getAdminUsers() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1009 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.61 ms Efter sidste forespørgsel: 0.12 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.765 MB Rækker returneret: 49
SELECT `id`,`name`,`rules`,`parent_id`
FROM `namjq_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_easybookreloaded','com_faqbookpro','com_fields','com_finder','com_gantry','com_gantry5','com_installer','com_jce','com_jm_deluxe_layer_slideshow','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_roksprocket','com_rsfirewall','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zhgooglemap','com_zhosmmap')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_assets | NULL | ALL | idx_asset_name | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 226 | 22.12 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.95 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.23 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.20 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 13 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 12 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 11 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:29 |
| 10 | RSFirewallUsersHelper::getAdminGroups() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:46 |
| 9 | RSFirewallUsersHelper::getAdminUsers() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1009 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.96 ms Efter sidste forespørgsel: 0.75 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.836 MB Rækker returneret: 0
SELECT DISTINCT(user_id)
FROM namjq_usergroups as ug1
INNER JOIN namjq_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN namjq_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='6'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ug1 | NULL | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
| 1 | SIMPLE | m | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 5 | 100.00 | Using index |
| 1 | SIMPLE | ug2 | NULL | eq_ref | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | stormchaser_dk_db2.m.group_id | 1 | 29.16 | Using where; Distinct |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.70 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.06 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:1029 |
| 10 | Joomla\CMS\Access\Access::getUsersByGroup() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:49 |
| 9 | RSFirewallUsersHelper::getAdminUsers() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1009 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.31 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.842 MB Rækker returneret: 1
SELECT DISTINCT(user_id)
FROM namjq_usergroups as ug1
INNER JOIN namjq_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN namjq_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ug1 | NULL | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
| 1 | SIMPLE | ug2 | NULL | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 33.33 | Using index condition |
| 1 | SIMPLE | m | NULL | index | PRIMARY | PRIMARY | 8 | NULL | 5 | 20.00 | Using where; Using index; Using join buffer (hash join) |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.05 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:1029 |
| 10 | Joomla\CMS\Access\Access::getUsersByGroup() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:49 |
| 9 | RSFirewallUsersHelper::getAdminUsers() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1009 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.98 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.846 MB Rækker returneret: 1
SELECT u.*
FROM namjq_users u
WHERE u.id IN (638)
ORDER BY u.username ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | u | NULL | system | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.60 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.24 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/users.php:61 |
| 9 | RSFirewallUsersHelper::getAdminUsers() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1009 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.48 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.854 MB Rækker returneret: 4
SELECT *
FROM namjq_rsfirewall_hashes
WHERE (`type`='3.10.12' OR `type`='protect')
AND (`flag`!='C' OR `flag` IS NULL)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_hashes | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 167 | 17.29 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.29 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1078 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.67 ms Efter sidste forespørgsel: 0.56 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.863 MB Rækker returneret: 0
SELECT *
FROM namjq_rsfirewall_snapshots
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.50 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.06 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49 |
| 9 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1101 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.73 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.869 MB Rækker returneret: 0
SELECT `ip`,`reason`
FROM namjq_rsfirewall_lists
WHERE (`ip`='3.16.76.102' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_lists | NULL | ref | published,type,ip | type | 1 | const | 2 | 36.69 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.49 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.10 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:172 |
| 10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:151 |
| 9 | plgSystemRsfirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1137 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.72 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.875 MB Rækker returneret: 0
SELECT `ip`,`reason`
FROM namjq_rsfirewall_lists
WHERE (`ip`='3.16.76.102' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_lists | NULL | ALL | published,type,ip | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 749 | 36.49 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.57 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:172 |
| 10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:141 |
| 9 | plgSystemRsfirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1141 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.05 ms Efter sidste forespørgsel: 3.54 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.969 MB Rækker returneret: 1
SELECT *
FROM namjq_rsfirewall_exceptions
WHERE `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_rsfirewall_exceptions | NULL | system | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.67 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.24 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:729 |
| 9 | plgSystemRsfirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1272 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 0.68 ms Forespørgsels hukommelse: 0.006 MB hukommelse før forespørgsel: 4.009 MB
UPDATE `namjq_extensions`
SET `params` = '{\"mediaversion\":\"fafc3926fb36b55de12cf77708a67590\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
FORKLAR ikke mulig på forespørgsel: UPDATE `namjq_extensions`
SET `params` = '{\"mediaversion\":\"fafc3926fb36b55de12cf77708a67590\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.00 ms |
| System lock | 0.07 ms |
| updating | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:374 |
| 8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.99 ms Efter sidste forespørgsel: 22.97 ms Forespørgsels hukommelse: 0.029 MB hukommelse før forespørgsel: 4.476 MB Rækker returneret: 17
SHOW FULL COLUMNS
FROM `namjq_users`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `namjq_users`
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.42 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.05 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.00 ms |
| closing tables | 0.06 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 20 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 |
| 19 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 18 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 17 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:877 |
| 16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:347 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.21 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.506 MB Rækker returneret: 1
SELECT *
FROM `namjq_users`
WHERE `id` = 638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_users | NULL | system | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
| 17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
| 16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:347 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 2.93 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.519 MB Rækker returneret: 1
SELECT `g`.`id`,`g`.`title`
FROM `namjq_usergroups` AS g
INNER JOIN `namjq_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.m.group_id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 18 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
| 17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
| 16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/views/itemlist/view.html.php:347 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.26 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 4.524 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.13 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/itemlist.php:512 |
| 13 | K2ModelItemlist->getUserProfile() | JROOT/components/com_k2/views/itemlist/view.html.php:355 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.12 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 4.532 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 14 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 13 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/views/itemlist/view.html.php:358 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 9.07 ms Efter sidste forespørgsel: 1.50 ms Forespørgsels hukommelse: 0.126 MB hukommelse før forespørgsel: 4.554 MB Rækker returneret: 10
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(30000) */ SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM namjq_k2_items AS i
INNER JOIN namjq_k2_categories AS c USE INDEX (idx_category)
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-21 13:01:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 13:01:35')
AND i.created_by=638
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 10, 10
FORKLAR ikke mulig på forespørgsel: /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(30000) */ SQL_CALC_FOUND_ROWS i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM namjq_k2_items AS i INNER JOIN namjq_k2_categories AS c USE INDEX (idx_category) ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-21 13:01:35') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 13:01:35') AND i.created_by=638 AND i.created_by_alias='' ORDER BY i.id DESC LIMIT 10, 10
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.81 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 6.21 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.81 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:352 |
| 13 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:568 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 4.673 MB Rækker returneret: 1
SELECT FOUND_ROWS();
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | No tables used |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 ms |
| init | 0.00 ms |
| optimizing | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/itemlist.php:365 |
| 13 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:568 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.90 ms Efter sidste forespørgsel: 1.64 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 4.687 MB Rækker returneret: 14
SHOW FULL COLUMNS
FROM `namjq_k2_categories`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `namjq_k2_categories`
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.39 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.04 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.07 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:34 |
| 14 | TableK2Category->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/views/itemlist/view.html.php:693 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.34 ms Efter sidste forespørgsel: 0.86 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.731 MB Rækker returneret: 1
SELECT *
FROM namjq_k2_categories
WHERE id = '11'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:61 |
| 17 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.22 ms Efter sidste forespørgsel: 0.12 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 4.747 MB Rækker returneret: 20
SELECT id, name, parent
FROM namjq_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
ORDER BY parent
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | range | category,published,access,trash,idx_category | category | 8 | NULL | 19 | 100.00 | Using index condition; Anvender filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:932 |
| 19 | K2ModelItemlist->getCategoriesTree() | JROOT/components/com_k2/helpers/route.php:261 |
| 18 | K2HelperRoute::findMenuItem() | JROOT/components/com_k2/helpers/route.php:56 |
| 17 | K2HelperRoute::getCategoryRoute() | JROOT/components/com_k2/models/item.php:68 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 2.04 ms Efter sidste forespørgsel: 0.39 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.833 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2622
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.72 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.15 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.37 ms Efter sidste forespørgsel: 0.31 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.844 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 4.853 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 4.42 ms Efter sidste forespørgsel: 4.84 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 4.990 MB Rækker returneret: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM namjq_fields AS a
LEFT JOIN `namjq_languages` AS l
ON l.lang_code = a.language
LEFT JOIN namjq_users AS uc
ON uc.id=a.checked_out
LEFT JOIN namjq_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN namjq_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN namjq_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `namjq_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (11,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Anvender filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | stormchaser_dk_db2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 3.35 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.72 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:667 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:704 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.34 ms Efter sidste forespørgsel: 6.25 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.127 MB Rækker returneret: 1
SELECT *
FROM namjq_k2_categories
WHERE id = '27'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:61 |
| 17 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 0.35 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.200 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2619
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.22 ms Efter sidste forespørgsel: 0.25 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.211 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.220 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.87 ms Efter sidste forespørgsel: 31.30 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 5.191 MB Rækker returneret: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM namjq_fields AS a
LEFT JOIN `namjq_languages` AS l
ON l.lang_code = a.language
LEFT JOIN namjq_users AS uc
ON uc.id=a.checked_out
LEFT JOIN namjq_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN namjq_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN namjq_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `namjq_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (27,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Anvender filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | stormchaser_dk_db2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.47 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.04 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:667 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:704 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.29 ms Efter sidste forespørgsel: 1.26 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.278 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2618
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 0.34 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.288 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.12 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.297 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.26 ms Efter sidste forespørgsel: 3.37 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.288 MB Rækker returneret: 1
SELECT *
FROM namjq_k2_categories
WHERE id = '28'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:61 |
| 17 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.23 ms Efter sidste forespørgsel: 0.42 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.361 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2617
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.16 ms Efter sidste forespørgsel: 0.27 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.371 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.380 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.89 ms Efter sidste forespørgsel: 24.69 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 5.351 MB Rækker returneret: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM namjq_fields AS a
LEFT JOIN `namjq_languages` AS l
ON l.lang_code = a.language
LEFT JOIN namjq_users AS uc
ON uc.id=a.checked_out
LEFT JOIN namjq_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN namjq_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN namjq_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `namjq_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (28,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Anvender filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | stormchaser_dk_db2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.47 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.04 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:667 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:704 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.27 ms Efter sidste forespørgsel: 1.73 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.440 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2615
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 0.32 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.449 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.11 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.458 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.34 ms Efter sidste forespørgsel: 26.04 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.505 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2614
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.11 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 0.30 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.515 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.13 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.524 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 2.89 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.575 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2613
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 0.39 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.585 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.15 ms Efter sidste forespørgsel: 0.05 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.594 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 24.36 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.582 MB Rækker returneret: 1
SELECT *
FROM namjq_k2_categories
WHERE id = '25'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 18 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:61 |
| 17 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.54 ms Efter sidste forespørgsel: 0.40 ms Forespørgsels hukommelse: 0.030 MB hukommelse før forespørgsel: 5.662 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2612
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.26 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.60 ms Efter sidste forespørgsel: 0.31 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.677 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.34 ms |
| System lock | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.14 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.686 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.93 ms Efter sidste forespørgsel: 22.89 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 5.659 MB Rækker returneret: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM namjq_fields AS a
LEFT JOIN `namjq_languages` AS l
ON l.lang_code = a.language
LEFT JOIN namjq_users AS uc
ON uc.id=a.checked_out
LEFT JOIN namjq_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN namjq_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN namjq_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `namjq_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (25,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Anvender filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | stormchaser_dk_db2.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.47 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.04 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.00 ms |
| closing tables | 0.07 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:667 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:704 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.29 ms Efter sidste forespørgsel: 1.39 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.748 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2611
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.18 ms Efter sidste forespørgsel: 0.30 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.758 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.10 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.767 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.84 ms Efter sidste forespørgsel: 26.07 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.813 MB Rækker returneret: 0
SELECT tag.*
FROM namjq_k2_tags AS tag
JOIN namjq_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 2610
ORDER BY xref.id ASC| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ref | tagID,itemID | itemID | 4 | const | 1 | 100.00 | Anvender filesort |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | stormchaser_dk_db2.xref.tagID | 1 | 85.71 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1201 |
| 17 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:111 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.16 ms Efter sidste forespørgsel: 0.28 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.823 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 18 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 17 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:211 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.10 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 5.832 MB Rækker returneret: 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM namjq_k2_users
WHERE userID=638
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1681 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:212 |
| 16 | K2ModelItem->prepareItem() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:695 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.23 ms Efter sidste forespørgsel: 2.35 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 5.804 MB Rækker returneret: 20
SELECT id
FROM namjq_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_k2_categories | NULL | range | category,published,access,trash,idx_category | category | 8 | NULL | 19 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:225 |
| 13 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/itemlist/view.html.php:752 |
| 12 | K2ViewItemlist->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:49 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 2.20 ms Efter sidste forespørgsel: 31.47 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 7.054 MB Rækker returneret: 2
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM namjq_modules AS m
LEFT JOIN namjq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN namjq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 13:01:35')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 13:01:35')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 2113 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 20 | 1.60 | Using index condition; Using where; Anvender filesort |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.m.id | 1 | 40.00 | Using where; Using index |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | stormchaser_dk_db2.m.module,const | 1 | 10.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.62 ms |
| init | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.21 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | Samme som kald i linjen nedenunder. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 13 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 12 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 10 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/libraries/gantry/core/gantry.class.php:804 |
| 9 | Gantry->getJoomlaModuleCount() | JROOT/libraries/gantry/core/gantry.class.php:757 |
| 8 | Gantry->countModules() | JROOT/templates/rt_chimera/index.php:59 |
| 7 | require JROOT/templates/rt_chimera/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 2.05 ms Efter sidste forespørgsel: 10.80 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 7.327 MB Rækker returneret: 0
SELECT ts.template
FROM namjq_template_styles AS ts
INNER JOIN namjq_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 2113
AND m.template_style_id != 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 1.31 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.31 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101 |
| 16 | RokNavMenu::getTemplates() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74 |
| 15 | RokNavMenu::loadCatalogs() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25 |
| 14 | RokNavMenu->__construct() | JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21 |
| 13 | include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 11 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/rt_chimera/features/dropdownmenu.php:56 |
| 10 | GantryFeatureDropdownMenu->render() | JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70 |
| 9 | GantryModulesRenderer::display() | JROOT/libraries/gantry/core/gantry.class.php:867 |
| 8 | Gantry->displayModules() | JROOT/templates/rt_chimera/index.php:63 |
| 7 | require JROOT/templates/rt_chimera/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.19 ms Efter sidste forespørgsel: 0.07 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 7.335 MB Rækker returneret: 1
SELECT template
FROM namjq_template_styles
WHERE home = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_template_styles | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 8 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116 |
| 16 | RokNavMenu::getTemplates() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74 |
| 15 | RokNavMenu::loadCatalogs() | JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25 |
| 14 | RokNavMenu->__construct() | JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21 |
| 13 | include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 11 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/rt_chimera/features/dropdownmenu.php:56 |
| 10 | GantryFeatureDropdownMenu->render() | JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70 |
| 9 | GantryModulesRenderer::display() | JROOT/libraries/gantry/core/gantry.class.php:867 |
| 8 | Gantry->displayModules() | JROOT/templates/rt_chimera/index.php:63 |
| 7 | require JROOT/templates/rt_chimera/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.02 ms Efter sidste forespørgsel: 6.87 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 7.597 MB Rækker returneret: 8
SHOW FULL COLUMNS
FROM `namjq_template_styles`
FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `namjq_template_styles`
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.42 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.04 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| waiting for handler commit | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 17 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_templates/tables/style.php:30 |
| 16 | TemplatesTableStyle->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 15 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/gantry/gantry.php:194 |
| 14 | plgSystemGantry->getTable() | JROOT/plugins/system/gantry/gantry.php:165 |
| 13 | plgSystemGantry->isGantryTemplate() | JROOT/plugins/system/gantry/gantry.php:234 |
| 12 | plgSystemGantry->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.35 ms Efter sidste forespørgsel: 0.23 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 7.618 MB Rækker returneret: 1
SELECT *
FROM namjq_template_styles
WHERE `id` = '24'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | namjq_template_styles | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Executing hook on transaction | 0.00 ms |
| starting | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.00 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Kalder | Fil og linjenummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 14 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/gantry/gantry.php:168 |
| 13 | plgSystemGantry->isGantryTemplate() | JROOT/plugins/system/gantry/gantry.php:234 |
| 12 | plgSystemGantry->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Home 
BLOG 
Fotogalleri 
WIKI 
Om mig 
Øverst : Temperatur og Dugpunktstemperatur hhv 1.5m og 9 meter i Fahrenheit - Nederst : Vindhastighed/Vindstød og vindretning i hhv. 2 meter og 10 meter. Tid er i UTC
Map Data ©2014 Google
Lake effect snow ved Buffalo d. 18/11-2014. Skystriben på ovenstående radarbillede eksisterede i over 24 timer.
Billede viser reflekteret nedbør og man kan tydeligt se den "krog"-lignende struktur som er nedbør der roterer om tornadoen. Der er noget der kunne ligne et "øje"som man kender det fra orkaner, men det er ikke tilfældet. Det er dog ikke ualmindeligt at der er et regnfrit område i nærheden af tornadoen, og det er det man kan se
Dette radarbillede viser Storm Relative Velocity, dvs hvordan vindende fordeler sig i supercellen. De grønne nuancer er vinde der bevæger sig i mod radaren, og de røde er vinde der bevæger sig væk fra radaren. Skalaen kan ses i venstre side.
Dette lidt specielle billede er Correlation Coefficient data, og viser kort fortalt om de ting radarstrålen rammer er ensartede i størrelse, dvs nedbør, eller om der er stor variation i form og størrelse, som ved tornado debris (bygningsdele, træer osv). Her ses et meget lokaliseret område med lav CC og dette indikerer forekomsten af en debris ball fra en tornado.
Foto : Beau Sorensen (Twitter : @sorrogrande)
Foto: storm chaser Greg Johnson @tornadogreg
Foto: storm chaser Greg Johnson @tornadogreg
Seneste prognosticerede track for Tropical Storm Bill fra National Hurricane Center, NHC (NOAA)