Forespørgsels tid: 1.74 ms Forespørgsels hukommelse: 0.020 MB hukommelse før forespørgsel: 1.363 MB Rækker returneret: 0
SELECT `session_id`
FROM `namjq_session`
WHERE `session_id` = X'3264643831356431303131353966356533666261363236653936663538656234'
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.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 1.25 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 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.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.37 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.004 MB hukommelse før forespørgsel: 1.369 MB
INSERT INTO `namjq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3264643831356431303131353966356533666261363236653936663538656234', 1, 1733637795, 0, '', 0)
FORKLAR ikke mulig på forespørgsel: INSERT INTO `namjq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3264643831356431303131353966356533666261363236653936663538656234', 1, 1733637795, 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.02 ms |
init | 0.00 ms |
System lock | 0.00 ms |
update | 0.04 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: 4.79 ms Efter sidste forespørgsel: 4.11 ms Forespørgsels hukommelse: 0.042 MB hukommelse før forespørgsel: 1.471 MB Rækker returneret: 49
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `namjq_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | namjq_extensions | NULL | ref | extension | extension | 82 | const | 58 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 1.51 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 2.87 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.18 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/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Samme som kald i linjen nedenunder. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 1.24 ms Efter sidste forespørgsel: 2.74 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.514 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.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.98 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.09 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: 1.08 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.526 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.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.80 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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 |
---|
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.61 ms Efter sidste forespørgsel: 0.97 ms Forespørgsels hukommelse: 0.031 MB hukommelse før forespørgsel: 1.551 MB Rækker returneret: 114
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM namjq_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | namjq_extensions | NULL | ref | extension | extension | 82 | const | 108 | 0.40 | Using where; 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.07 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.31 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:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Samme som kald i linjen nedenunder. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Forespørgsels tid: 0.89 ms Efter sidste forespørgsel: 5.19 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 1.904 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.67 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 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.23 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 1.914 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.59 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.28 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.25 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.82 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 1.920 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.57 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.02 ms |
executing | 0.06 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: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.33 ms Efter sidste forespørgsel: 2.83 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 2.168 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.04 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.42 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 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.08 ms Efter sidste forespørgsel: 11.45 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 2.619 MB Rækker returneret: 1
Dublet forespørgsler:
#12SELECT 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.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.66 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 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.20 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.17 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.626 MB Rækker returneret: 1
Dublet forespørgsler:
#11SELECT 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.03 ms |
preparing | 0.00 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: 1.07 ms Efter sidste forespørgsel: 2.66 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 2.811 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.02 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.73 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.19 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: 0.98 ms Efter sidste forespørgsel: 14.60 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 3.084 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.05 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.43 ms |
init | 0.01 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 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.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.29 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.112 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.03 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.07 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 |
---|
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.17 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.119 MB Rækker returneret: 1
Dublet forespørgsler:
#18SELECT *
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.02 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.18 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.125 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.01 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.17 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.131 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.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.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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: 2.72 ms Efter sidste forespørgsel: 9.78 ms Forespørgsels hukommelse: 0.068 MB hukommelse før forespørgsel: 3.372 MB Rækker returneret: 27
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM namjq_menu AS m
LEFT JOIN namjq_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 26 | 10.00 | Using index condition; Using where; Anvender filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.m.component_id | 1 | 100.00 | Using where |
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 |
Opening tables | 1.21 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.47 ms |
preparing | 0.02 ms |
executing | 0.40 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.42 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Samme som kald i linjen nedenunder. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
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.32 ms Efter sidste forespørgsel: 10.15 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.720 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.09 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.02 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.82 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 3.733 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.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 1.18 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.22 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.22 ms |
freeing items | 0.01 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: 1.18 ms Efter sidste forespørgsel: 0.50 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.804 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.03 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.89 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.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.30 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.810 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.03 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.01 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: 1.54 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.815 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.02 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.99 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.40 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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.50 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.822 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.08 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.28 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 |
---|
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.84 ms Efter sidste forespørgsel: 0.38 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.831 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.65 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.06 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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.87 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.838 MB Rækker returneret: 0
SELECT `ip`,`reason`
FROM namjq_rsfirewall_lists
WHERE (`ip`='18.97.9.172' 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.65 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.05 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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.78 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.843 MB Rækker returneret: 0
SELECT `ip`,`reason`
FROM namjq_rsfirewall_lists
WHERE (`ip`='18.97.9.172' 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.02 ms |
preparing | 0.01 ms |
executing | 0.63 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: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.01 ms Efter sidste forespørgsel: 2.51 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 3.937 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.02 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.65 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.22 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 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.38 ms Efter sidste forespørgsel: 0.22 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 3.941 MB Rækker returneret: 5
Dublet forespørgsler:
#42SELECT id, home, template, s.params
FROM namjq_template_styles as s
LEFT JOIN namjq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 4 | 1.25 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | stormchaser_dk_db2.e.element | 1 | 66.67 | Using index condition; 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.05 ms |
preparing | 0.01 ms |
executing | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/gantry5/gantry5.php:261 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:112 |
8 | plgSystemGantry5->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.27 ms Efter sidste forespørgsel: 1.25 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 4.007 MB Rækker returneret: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `namjq_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
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 | extension | 484 | const,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.06 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.06 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:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Samme som kald i linjen nedenunder. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
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.23 ms Efter sidste forespørgsel: 0.09 ms Forespørgsels hukommelse: 0.006 MB hukommelse før forespørgsel: 3.998 MB
UPDATE `namjq_extensions`
SET `params` = '{\"mediaversion\":\"9aa6152c90a6de0846182abcd902c014\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
FORKLAR ikke mulig på forespørgsel: UPDATE `namjq_extensions`
SET `params` = '{\"mediaversion\":\"9aa6152c90a6de0846182abcd902c014\"}'
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.01 ms |
init | 0.00 ms |
System lock | 0.06 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.00 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: 1.22 ms Efter sidste forespørgsel: 3.44 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 4.070 MB Rækker returneret: 1
SELECT *
FROM namjq_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | namjq_languages | NULL | system | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 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.73 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.34 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:248 |
10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:244 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:390 |
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: 1.08 ms Efter sidste forespørgsel: 3.22 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 4.183 MB Rækker returneret: 10
SELECT *
FROM namjq_rokcandy
WHERE published=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | namjq_rokcandy | NULL | ALL | NULL | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 10 | 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.65 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.26 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 |
13 | RokCandyHelper::getUserMacros() | Samme som kald i linjen nedenunder. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
10 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 |
9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
8 | plgSystemRokCandy->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: 11.18 ms Efter sidste forespørgsel: 19.11 ms Forespørgsels hukommelse: 0.075 MB hukommelse før forespørgsel: 4.354 MB Rækker returneret: 1
SELECT h.*, c.title as category
FROM namjq_zhosmmaps_maps as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
WHERE h.id=1
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | system | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
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 |
Opening tables | 8.70 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.24 ms |
preparing | 0.01 ms |
executing | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 1.93 ms |
freeing items | 0.02 ms |
cleaning up | 0.03 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_zhosmmap/models/zhosmmap.php:192 |
11 | ZhOSMMapModelZhOSMMap->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:26 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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: 10.23 ms Efter sidste forespørgsel: 0.13 ms Forespørgsels hukommelse: 0.436 MB hukommelse før forespørgsel: 4.384 MB Rækker returneret: 140
SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.disableautopan, bub.published infobubblepublished, bub.offsetx, bub.offsety
FROM namjq_zhosmmaps_markers as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
LEFT JOIN namjq_zhosmmaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN namjq_zhosmmaps_infobubbles as bub
ON h.tabid=bub.id
WHERE 1=1
and h.mapid=1
and h.published=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2024-12-08 06:03:15')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2024-12-08 06:03:15')
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bub | NULL | system | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | h | NULL | ALL | idx_mapid | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 140 | 1.58 | Using where; Anvender filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.catid | 1 | 100.00 | NULL |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.markergroup | 1 | 100.00 | Using where |
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 |
Opening tables | 6.79 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 1.61 ms |
end | 0.00 ms |
query end | 0.02 ms |
closing tables | 1.48 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:576 |
11 | ZhOSMMapModelZhOSMMap->getMarkers() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:44 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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.68 ms Efter sidste forespørgsel: 0.54 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 6.136 MB Rækker returneret: 10
SELECT h.*, c.title as category
FROM namjq_zhosmmaps_markergroups as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM namjq_zhosmmaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=1
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-08 06:03:15')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-08 06:03:15'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | ALL | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 10 | 100.00 | Anvender filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.catid | 1 | 100.00 | NULL |
1 | SIMPLE | <subquery2> | NULL | eq_ref | <auto_distinct_key> | <auto_distinct_key> | 4 | stormchaser_dk_db2.h.id | 1 | 100.00 | Using where |
2 | MATERIALIZED | m | NULL | ALL | idx_mapid,idx_markergroup | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 140 | 15.77 | Using where |
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 |
Opening tables | 0.18 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.21 ms |
end | 0.00 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:960 |
11 | ZhOSMMapModelZhOSMMap->getMarkerGroups() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:48 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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.56 ms Efter sidste forespørgsel: 0.04 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 6.159 MB Rækker returneret: 10
SELECT h.*, c.title as category, c.parent_id as catcatid
FROM namjq_zhosmmaps_markergroups as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM namjq_zhosmmaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=1
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-08 06:03:15')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-08 06:03:15'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | ALL | PRIMARY | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 10 | 100.00 | Anvender filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.catid | 1 | 100.00 | NULL |
1 | SIMPLE | <subquery2> | NULL | eq_ref | <auto_distinct_key> | <auto_distinct_key> | 4 | stormchaser_dk_db2.h.id | 1 | 100.00 | Using where |
2 | MATERIALIZED | m | NULL | ALL | idx_mapid,idx_markergroup | INGEN INDEX NØGLE KUNNE ANVENDES | NULL | NULL | 140 | 15.77 | 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 | 0.11 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.21 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:1598 |
11 | ZhOSMMapModelZhOSMMap->getMgrGroupsList() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:51 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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.07 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 6.181 MB Rækker returneret: 0
SELECT h.*, c.title as category
FROM namjq_zhosmmaps_routers as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=1
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.65 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.28 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:737 |
11 | ZhOSMMapModelZhOSMMap->getRouters() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:58 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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: 3.36 ms Efter sidste forespørgsel: 0.02 ms Forespørgsels hukommelse: 0.039 MB hukommelse før forespørgsel: 6.189 MB Rækker returneret: 0
SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety
FROM namjq_zhosmmaps_paths as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
LEFT JOIN namjq_zhosmmaps_markergroups as g
ON h.markergroup=g.id
WHERE h.published=1
and h.mapid=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | h | NULL | ref | idx_mapid | idx_mapid | 4 | const | 4 | 20.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.catid | 1 | 100.00 | NULL |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stormchaser_dk_db2.h.markergroup | 1 | 100.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 |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 1.90 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.26 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 1.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:1794 |
11 | ZhOSMMapModelZhOSMMap->getPaths() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:62 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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.46 ms Efter sidste forespørgsel: 0.03 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 6.194 MB Rækker returneret: 0
SELECT h.*, c.title as category
FROM namjq_zhosmmaps_maptypes as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
WHERE h.published=1
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.03 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.30 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Kalder | Fil og linjenummer |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhosmmap/models/zhosmmap.php:1820 |
11 | ZhOSMMapModelZhOSMMap->getMapTypes() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhosmmap/views/zhosmmap/view.html.php:72 |
9 | ZhOSMMapViewZhOSMMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhosmmap/zhosmmap.php:21 |
6 | require_once JROOT/components/com_zhosmmap/zhosmmap.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.55 ms Efter sidste forespørgsel: 46.25 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 6.905 MB Rækker returneret: 5
Dublet forespørgsler:
#30SELECT id, home, template, s.params
FROM namjq_template_styles as s
LEFT JOIN namjq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 4 | 1.25 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | stormchaser_dk_db2.e.element | 1 | 66.67 | 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 |
Opening tables | 0.16 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
executing | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.10 ms |
freeing items | 0.01 ms |
cleaning up | 0.02 ms |
# | Kalder | Fil og linjenummer |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry/core/gantrytemplate.class.php:638 |
18 | GantryTemplate::getAllTemplates() | JROOT/libraries/gantry/core/gantrytemplate.class.php:604 |
17 | GantryTemplate::getTemplateById() | JROOT/libraries/gantry/core/gantrytemplate.class.php:420 |
16 | GantryTemplate->loadParamsContent() | JROOT/libraries/gantry/core/gantrytemplate.class.php:365 |
15 | GantryTemplate->getXMLParams() | JROOT/libraries/gantry/core/gantrytemplate.class.php:205 |
14 | GantryTemplate->init() | JROOT/libraries/gantry/core/gantry.class.php:287 |
13 | Gantry->__construct() | JROOT/libraries/gantry/core/gantry.class.php:62 |
12 | Gantry::getInstance() | JROOT/libraries/gantry/core/utilities/gantrycache.class.php:156 |
11 | GantryCache->call() | JROOT/libraries/gantry/gantry.php:271 |
10 | gantry_setup() | JROOT/libraries/gantry/gantry.php:432 |
9 | include JROOT/libraries/gantry/gantry.php | JROOT/templates/rt_chimera/lib/gantry/gantry.php:21 |
8 | require_once JROOT/templates/rt_chimera/lib/gantry/gantry.php | JROOT/templates/rt_chimera/index.php:17 |
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: 3.90 ms Efter sidste forespørgsel: 25.60 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 7.590 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-12-08 06:03:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-08 06:03:15')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 394 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.07 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 | 2.71 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.68 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.20 ms |
freeing items | 0.02 ms |
cleaning up | 0.05 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: 0.33 ms Efter sidste forespørgsel: 6.35 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 7.779 MB Rækker returneret: 1
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 = 394
AND m.template_style_id != 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | ts | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
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.13 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.00 ms |
executing | 0.00 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 |
---|
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: 1.09 ms Efter sidste forespørgsel: 8.73 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 8.113 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.05 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.54 ms |
init | 0.00 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
executing | 0.06 ms |
checking permissions | 0.05 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.02 ms |
end | 0.00 ms |
query end | 0.02 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.06 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 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.24 ms Efter sidste forespørgsel: 0.06 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 8.134 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.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.01 ms |
statistics | 0.02 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 |
---|
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 |
2 × SELECT id, home, template, s.params
FROM namjq_template_styles as s
LEFT JOIN namjq_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
2 × SELECT *
FROM namjq_extensions
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `namjq_extensions`
2 × 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
2 × SELECT template
FROM namjq_template_styles as s
2 × SELECT `ip`,`reason`
FROM namjq_rsfirewall_lists
2 × SELECT `extension_id`
FROM `namjq_extensions`
1 × SELECT *
FROM namjq_languages
1 × SELECT *
FROM namjq_rokcandy
1 × SELECT h.*, c.title as category
FROM namjq_zhosmmaps_maps as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.disableautopan, bub.published infobubblepublished, bub.offsetx, bub.offsety
FROM namjq_zhosmmaps_markers as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
LEFT JOIN namjq_zhosmmaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN namjq_zhosmmaps_infobubbles as bub
ON h.tabid=bub.id
1 × SELECT `session_id`
FROM `namjq_session`
1 × SELECT h.*, c.title as category, c.parent_id as catcatid
FROM namjq_zhosmmaps_markergroups as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM namjq_zhosmmaps_routers as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety
FROM namjq_zhosmmaps_paths as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
LEFT JOIN namjq_zhosmmaps_markergroups as g
ON h.markergroup=g.id
1 × SELECT h.*, c.title as category
FROM namjq_zhosmmaps_maptypes as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
1 × 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
1 × SELECT ts.template
FROM namjq_template_styles AS ts
INNER JOIN namjq_menu AS m
ON ts.id=m.template_style_id
1 × SELECT h.*, c.title as category
FROM namjq_zhosmmaps_markergroups as h
LEFT JOIN namjq_categories as c
ON h.catid=c.id
1 × SELECT *
FROM namjq_rsfirewall_hashes
1 × SELECT *
FROM namjq_rsfirewall_exceptions
1 × SELECT *
FROM namjq_rsfirewall_snapshots
1 × SELECT u.*
FROM namjq_users u
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `namjq_assets`
1 × SELECT `id`
FROM `namjq_usergroups
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM namjq_menu AS m
LEFT JOIN namjq_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT extension, file, type
FROM namjq_rokcommon_configs
1 × SELECT *
FROM namjq_rsfirewall_configuratio
1 × SELECT `file`
FROM namjq_rsfirewall_hashes
1 × SELECT `path`
FROM namjq_rsfirewall_ignored
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM namjq_extensions
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
1 × SELECT id, rules
FROM `namjq_viewlevels
1 × SELECT *
FROM namjq_template_styles