Query Time: 0.50 ms Query memory: 0.023 MB Memory before query: 1.356 MB Rows returned: 0
SELECT `data`
FROM `tisw7_session`
WHERE `session_id` = X'3461393734353934353465643763353864666666353032306462356439393666'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.46 ms After last query: 16.61 ms Query memory: 0.020 MB Memory before query: 1.370 MB Rows returned: 0
SELECT `session_id`
FROM `tisw7_session`
WHERE `session_id` = X'3461393734353934353465643763353864666666353032306462356439393666'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 0.79 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 1.375 MB
INSERT INTO `tisw7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3461393734353934353465643763353864666666353032306462356439393666', 1, 1695610067, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `tisw7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3461393734353934353465643763353864666666353032306462356439393666', 1, 1695610067, 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 1.31 ms After last query: 29.46 ms Query memory: 0.042 MB Memory before query: 1.470 MB Rows returned: 56
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tisw7_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 | tisw7_extensions | NULL | ref | extension | extension | 82 | const | 56 | 1.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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 |
Query Time: 0.82 ms After last query: 22.77 ms Query memory: 0.021 MB Memory before query: 1.524 MB Rows returned: 5
SELECT id, rules
FROM `tisw7_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.536 MB Rows returned: 2
SELECT b.id
FROM tisw7_usergroups AS a
LEFT JOIN tisw7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
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; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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 |
Query Time: 1.74 ms After last query: 3.94 ms Query memory: 0.064 MB Memory before query: 1.558 MB Rows returned: 309
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM tisw7_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_extensions | NULL | ref | extension | extension | 82 | const | 354 | 0.60 | Using index condition; Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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}() | Same as call in the line below. |
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 |
Query Time: 0.70 ms After last query: 341.47 ms Query memory: 0.062 MB Memory before query: 2.615 MB Rows returned: 1
SELECT *
FROM `tisw7_social_config`
WHERE `type` = 'site'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_social_config | NULL | ref | type | type | 767 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46 |
14 | SocialDBHelper->__call() | JROOT/administrator/components/com_easysocial/includes/db/db.php:303 |
13 | SocialDb->__call() | JROOT/administrator/components/com_easysocial/models/config.php:43 |
12 | EasySocialModelConfig->getConfig() | JROOT/administrator/components/com_easysocial/includes/config/config.php:103 |
11 | SocialConfig->load() | JROOT/administrator/components/com_easysocial/includes/config/config.php:25 |
10 | SocialConfig->__construct() | JROOT/administrator/components/com_easysocial/includes/config/config.php:40 |
9 | SocialConfig::getInstance() | JROOT/administrator/components/com_easysocial/includes/easysocial.php:503 |
8 | ES::config() | JROOT/administrator/components/com_easysocial/includes/plugins.php:37 |
7 | EasySocialPlugins->__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 |
Query Time: 0.54 ms After last query: 300.35 ms Query memory: 0.025 MB Memory before query: 3.130 MB Rows returned: 49
SELECT *
FROM `tisw7_payplans_config`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_payplans_config | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 49 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
12 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
11 | PPDb->__call() | JROOT/administrator/components/com_payplans/models/config.php:33 |
10 | PayplansModelConfig->getConfig() | JROOT/administrator/components/com_payplans/includes/payplans.php:666 |
9 | PP::config() | JROOT/administrator/components/com_payplans/includes/plugins.php:33 |
8 | PPPlugins->__construct() | JROOT/plugins/system/payplans/payplans.php:47 |
7 | plgSystemPayplans->__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 |
Query Time: 1.31 ms After last query: 189.56 ms Query memory: 0.022 MB Memory before query: 4.452 MB Rows returned: 1
SELECT *
FROM tisw7_ea_configs
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_ea_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
12 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:88 |
11 | EA::config() | JROOT/administrator/components/com_easyarticles/includes/utils.php:69 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__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 |
Query Time: 0.50 ms After last query: 8.37 ms Query memory: 0.025 MB Memory before query: 4.473 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tisw7_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
19 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
16 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
15 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
14 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_easyarticles/includes/utils.php:72 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__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 |
Query Time: 1.58 ms After last query: 0.16 ms Query memory: 0.007 MB Memory before query: 4.467 MB
UPDATE `tisw7_extensions`
SET `params` = '{\"mediaversion\":\"8fbc5088f70d529232351c5274ec9d7e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | tisw7_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_easyarticles/includes/utils.php:72 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__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 |
Query Time: 1.54 ms After last query: 341.95 ms Query memory: 0.069 MB Memory before query: 4.935 MB Rows returned: 36
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 tisw7_menu AS m
LEFT JOIN tisw7_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 | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 140 | 3.33 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.m.component_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
20 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
17 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
16 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
15 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
14 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
13 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
12 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
11 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
10 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
9 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
8 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jmap/jmap.php:1168 |
7 | plgSystemJMap->__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 |
Query Time: 2.78 ms After last query: 243.08 ms Query memory: 0.026 MB Memory before query: 5.242 MB Rows returned: 3
SELECT tbl.*
FROM tisw7_payplans_app AS tbl
WHERE `tbl`.`published` ='1'
ORDER BY app_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | index | idx_published,idx_publish_order | PRIMARY | 4 | NULL | 3 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
21 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
20 | PPDb->__call() | JROOT/administrator/components/com_payplans/includes/model.php:526 |
19 | PayPlansModel->loadRecords() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:131 |
18 | PPHelperApp::loadApps() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:313 |
17 | PPHelperApp::getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:123 |
16 | PPPlugins->getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:102 |
15 | PPPlugins->getAppHelper() | JROOT/plugins/payplans/sobipro/sobipro.php:31 |
14 | plgPayplansSobipro->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:82 |
11 | PPDispatcher->loadPlugins() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:40 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->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 |
Query Time: 2.23 ms After last query: 16.61 ms Query memory: 0.029 MB Memory before query: 5.278 MB Rows returned: 0
SELECT app_id,plan_id
FROM tisw7_payplans_planapp AS tbl
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
30 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
29 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
28 | PPDb->__call() | JROOT/administrator/components/com_payplans/models/planapp.php:38 |
27 | PayplansModelPlanapp->_loadCache() | JROOT/administrator/components/com_payplans/models/planapp.php:78 |
26 | PayplansModelPlanapp->getAppPlans() | JROOT/administrator/components/com_payplans/includes/app/app.php:427 |
25 | PPApp->afterBind() | JROOT/administrator/components/com_payplans/includes/abstract.php:413 |
24 | PPAbstract->bind() | JROOT/administrator/components/com_payplans/includes/app/app.php:444 |
23 | PPApp->bind() | JROOT/administrator/components/com_payplans/includes/abstract.php:47 |
22 | PPAbstract->__construct() | JROOT/administrator/components/com_payplans/includes/app/app.php:42 |
21 | PPApp->__construct() | JROOT/administrator/components/com_payplans/includes/app/abstract/payment.php:23 |
20 | PPAppPayment->__construct() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:112 |
19 | PPHelperApp::loadApp() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:137 |
18 | PPHelperApp::loadApps() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:313 |
17 | PPHelperApp::getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:123 |
16 | PPPlugins->getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:102 |
15 | PPPlugins->getAppHelper() | JROOT/plugins/payplans/sobipro/sobipro.php:31 |
14 | plgPayplansSobipro->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:82 |
11 | PPDispatcher->loadPlugins() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:40 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->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 |
Query Time: 4.25 ms After last query: 925.44 ms Query memory: 0.030 MB Memory before query: 5.927 MB Rows returned: 56
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tisw7_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_activitystream','com_acymailing','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_convertforms','com_cpanel','com_easyarticles','com_easyblog','com_easydiscuss','com_easysocial','com_extplorer','com_fields','com_finder','com_gantry5','com_hierarchy','com_installer','com_jce','com_jlike','com_jmap','com_joomlaupdate','com_jticketing','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_payplans','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_seoglossary','com_tags','com_templates','com_tjfields','com_tjnotifications','com_tjprivacy','com_tjreports','com_users','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 550 | 10.36 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_payplans/includes/user/user.php:922 |
15 | PPUser->isSiteAdmin() | JROOT/administrator/components/com_payplans/includes/user/user.php:965 |
14 | PPUser->isAdmin() | JROOT/plugins/payplans/menuaccess/menuaccess.php:36 |
13 | plgPayplansMenuAccess->onPayplansSystemStart() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:43 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->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 |
Query Time: 1.09 ms After last query: 425.56 ms Query memory: 0.024 MB Memory before query: 6.601 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `tisw7_komento_configs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `tisw7_komento_configs`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:585 |
11 | Joomla\CMS\Table\Table->reset() | JROOT/libraries/src/Table/Table.php:724 |
10 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_komento/includes/komento.php:399 |
9 | KT::config() | JROOT/components/com_komento/bootstrap.php:39 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:14 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
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 |
Query Time: 1.07 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 6.615 MB Rows returned: 1
SELECT *
FROM tisw7_komento_configs
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_komento_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 25.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_komento/includes/komento.php:399 |
9 | KT::config() | JROOT/components/com_komento/bootstrap.php:39 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:14 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
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 |
Query Time: 0.92 ms After last query: 146.08 ms Query memory: 0.025 MB Memory before query: 7.224 MB Rows returned: 0
SELECT tbl.*
FROM tisw7_payplans_subscription AS tbl
WHERE `tbl`.`user_id` = 0
AND `tbl`.`status` ='1601'
ORDER BY subscription_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | ref | idx_userid,idx_user_subs | idx_userid | 4 | const | 1 | 16.67 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
18 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
17 | PPDb->__call() | JROOT/administrator/components/com_payplans/includes/model.php:526 |
16 | PayPlansModel->loadRecords() | JROOT/administrator/components/com_payplans/includes/user/user.php:665 |
15 | PPUser->getPlans() | JROOT/plugins/payplans/sobipro/sobipro.php:48 |
14 | plgPayplansSobipro->onPayplansAccessCheck() | JROOT/libraries/joomla/event/event.php:70 |
13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:43 |
11 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
10 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:322 |
9 | plgSystemPayplans->checkAccess() | JROOT/plugins/system/payplans/payplans.php:88 |
8 | plgSystemPayplans->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 |
Query Time: 0.75 ms After last query: 10.66 ms Query memory: 0.022 MB Memory before query: 7.312 MB Rows returned: 6
SELECT id, home, template, s.params
FROM tisw7_template_styles as s
LEFT JOIN tisw7_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 | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | orgtology2018_derekh1sit277406.e.element | 1 | 75.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
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:257 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
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 |
Query Time: 0.87 ms After last query: 424.64 ms Query memory: 0.023 MB Memory before query: 7.820 MB Rows returned: 4
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM tisw7_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_isotope'
ORDER BY s.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | index | idx_template,idx_client_id,idx_client_id_home | PRIMARY | 4 | NULL | 8 | 37.50 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 |
14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 |
13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 |
12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 |
11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 |
10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:315 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
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 |
Query Time: 0.83 ms After last query: 122.79 ms Query memory: 0.019 MB Memory before query: 7.929 MB Rows returned: 1
SELECT *
FROM tisw7_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 | tisw7_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
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 |
Query Time: 2.60 ms After last query: 94.03 ms Query memory: 0.034 MB Memory before query: 8.096 MB Rows returned: 79
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tisw7_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 550 | 23.20 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.18 ms After last query: 19.36 ms Query memory: 0.025 MB Memory before query: 8.190 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `tisw7_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `tisw7_categories` AS `s`
INNER JOIN `tisw7_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 33
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | c | NULL | ALL | cat_idx,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 25 | 52.80 | Using where |
2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | orgtology2018_derekh1sit277406.c.id | 3 | 50.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.44 ms After last query: 21.70 ms Query memory: 0.073 MB Memory before query: 8.233 MB Rows returned: 2
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tisw7_content AS a
LEFT JOIN tisw7_categories AS c
ON c.id = a.catid
LEFT JOIN tisw7_users AS ua
ON ua.id = a.created_by
LEFT JOIN tisw7_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tisw7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tisw7_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 33
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 02:47:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 02:47:51')
ORDER BY c.path,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 2 | 8.00 | Using index condition; Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.28 ms After last query: 14.94 ms Query memory: 0.024 MB Memory before query: 8.321 MB Rows returned: 1
SELECT COUNT(*)
FROM tisw7_content AS a
LEFT JOIN tisw7_categories AS c
ON c.id = a.catid
LEFT JOIN tisw7_users AS ua
ON ua.id = a.created_by
LEFT JOIN tisw7_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tisw7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tisw7_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 33
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 02:47:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 02:47:51')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 2 | 8.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.created_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.id | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.78 ms After last query: 8.37 ms Query memory: 0.022 MB Memory before query: 8.394 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `tisw7_contentitem_tag_map` AS m
INNER JOIN `tisw7_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 33
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 2278 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | orgtology2018_derekh1sit277406.m.tag_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 165.51 ms Query memory: 0.026 MB Memory before query: 8.573 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `tisw7_categories` AS `s`
INNER JOIN `tisw7_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 33
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 25 | 59.84 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 8.591 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM tisw7_fields AS a
LEFT JOIN `tisw7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tisw7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tisw7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tisw7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tisw7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tisw7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (33,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | orgtology2018_derekh1sit277406.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.id | 1 | 100.00 | Using where; Using index; Distinct |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 170.79 ms After last query: 85.30 ms Query memory: 0.156 MB Memory before query: 8.878 MB Rows returned: 51
SELECT t.*
FROM tisw7_seoglossary as t
LEFT JOIN tisw7_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('\r\n\r\n\r\nStrategy is a plan that Org creates to become or stay a Relevant
and Performing Organisation (RPO).\r\n\r\n\r\nStrategy development is the development of such a plan.\r\n\r\n\r\nThe aim of these standards is to help Orgtologists to create
and develop a strategy, or to train others to do so according to orgtology theories
and principles.\r\n\r\n\r\nClick
on any of the standards in the table below to go directly to its specifications.\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\nPhase:\r\n\r\n\r\nIOI Standard:\r\n\r\n\r\nIOI Standard Nr:\r\n\r\n\r\n\r\n1.\r\n\r\nInitiate a strategy development project.\r\n\r\n\r\n\r\n\r\nUnderstand the strategy development needs.\r\n\r\n\r\nDraft a project plan
and brief for the strategy development process.\r\n\r\n\r\nDraft a project inception report.\r\n\r\n\r\nDraft milestone completion reports fr al completed milestones.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.1\r\n\r\n\r\n2.2\r\n\r\n\r\n2.3\r\n\r\n\r\n2.4\r\n\r\n\r\n\r\n\r\n\r\n\r\n2. \r\n\r\n\r\nOrg Identity
and Definition.\r\n\r\n\r\n\r\n\r\nDefine the purpose of the organisation.\r\n\r\n\r\nDefine the organisational intent.\r\n\r\n\r\nDevelop organisational
values.\r\n\r\n\r\nDevelop behavioural rules around these
values.\r\n\r\n\r\nDevelop a business canvas that depicts the core modus operandi (way of doing things).\r\n\r\n\r\nDevelop a business model for the organisation.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.5\r\n\r\n\r\n2.6\r\n\r\n\r\n2.7\r\n\r\n\r\n2.8\r\n\r\n\r\n2.9\r\n\r\n\r\n2.10\r\n\r\n\r\n\r\n\r\n\r\n\r\n3. \r\n\r\n\r\nCurrent reality analysis.\r\n\r\n\r\n\r\n\r\nDo a REET analysis.\r\n\r\n\r\nAnalyse REET data.\r\n\r\n\r\nDraft
and submit a REET Report with reccommendations.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.11\r\n\r\n\r\n2.12\r\n\r\n\r\n2.13\r\n\r\n\r\n\r\n\r\n\r\n4.\r\n\r\nOperational Performance Analysis\r\n\r\n\r\n\r\n\r\nDo a Level Zero process analysis.\r\n\r\n\r\nDraft core business processes
and cross map with Level Zero.\r\n\r\n\r\nDevelop Level Zero targets.\r\n\r\n\r\nAssess
and list top ten operational risks.\r\n\r\n\r\n\r\n\r\n\r\n\r\n 2.14\r\n\r\n\r\n2.15\r\n\r\n\r\n2.16\r\n\r\n\r\n2.17\r\n\r\n\r\n\r\n\r\n\r\n\r\n5. \r\n\r\n\r\nStrategic Intent & Direction.\r\n\r\n\r\n\r\n\r\nAssess
and decide
on the best strategy type for the Org.\r\n\r\n\r\nDevelop strategic intent through the 5V Model.\r\n\r\nUse the 5V model, the REET analysis,
and the operational performance analysis to determine the change needed.\r\n\r\nDefine strategic objectives
and programs.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.18\r\n\r\n\r\n2.19\r\n\r\n\r\n2.20\r\n\r\n\r\n2.21\r\n\r\n\r\n\r\n\r\n\r\n\r\n6. \r\n\r\n\r\nImplementation Plan.\r\n\r\n\r\n\r\nIdentify strategic projects
and link to the strategic programs.\r\n\r\nCreate a work breakdown structure for each project.\r\n\r\n\r\nCalculate the cost of strategy.\r\n\r\n\r\nAssess the strategic risk.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.22\r\n\r\n\r\n2.23\r\n\r\n\r\n2.24\r\n\r\n\r\n2.25\r\n\r\n\r\n\r\n\r\n\r\n\r\n7. \r\n\r\n\r\nMonitor & Lead.\r\n\r\n\r\n\r\n\r\nWrite the strategy document.\r\n\r\n\r\nDevelop strategy monitoring tools.\r\n\r\nEnsure strategic accountability
and responsibility.\r\n\r\n\r\n\r\n\r\n\r\n2.26\r\n\r\n\r\n2.27\r\n\r\n\r\n2.28\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\nDefine the purpose of your organisation.\r\nStrategy Development: Phase 1: Standard 1.1\r\n(1.1.1) The statement of purpose defines the organisations reason for existance.\r\n(1.1.2) The statement of purpose is distinct
from the statement of intent.\r\n(1.1.3) The statement of purpose is written in present tense. E.g., “We ensure price
and financial stability for the country.” Do not describe a future state, e.g., “To ensure price
and financial stability for the country.”\r\n \r\nDevelop organisational
values.\r\nStrategy Development: Phase 1: Standard 1.2\r\n(1.2.1) There is a narrative that describes the desired behavior of the organisation.\r\n(1.2.2) The strategy holds a list of
values that defines deisred behaviour.\r\n(1.2.3) Each value has a description.\r\n(1.2.4) Each value has a
set of behavioural rules.\r\n(1.2.5) Behavioural rules are part of the organisational performance asessment system.\r\n \r\nDevelop a business model for your organisation.\r\nStrategy Development: Phase 1: Standard 1.3\r\n(1.3.1) The business model has clearly identified value drivers. In orgtology the generic value drivers are process efficiency, strategic effectiveness, meaningful relationships, focused intelligence,
and productive resources.\r\n(1.3.2) The business model is linked to core critical success factors (CSF) for the organisation to perform
and stay relevant. These are high level CSF’s
and as rule of thumb, they must not exceed ten. The CSF’s for performance
and relevance must be listed separately (E.g., five for performance
and five for relevane).\r\n(1.3.3) The business model is decribed through a business canvas. The description must include partners, key activities, key resources, value propositions, customer relationships, distribution channels, customer segments, cost structure,
and revenue streams.\r\n(1.3.4) Depict the “value flow” of your business model. This is a model, value chain, or diagram that shows the interdependence of the organisational activity. The core value drivers must be depicted.\r\n \r\nDo a ROET analysis (Relationships, Opportunities, Effciency,
and Threats).\r\nStrategy Development: Phase 2: Standard 1.4\r\n(1.4.1) Duringstrategy development there was a clear method of ROET assessment. ROET assessment methods can include (but not limied to) a workshop or meeting
where dialogue is facilitated around ROET; a questionnaire to employees
and other stakeholders; interviews
and/or meetings with stakeholders.\r\n(1.4.2) The ROET generated sufficient data to make reasonable assumptions about relationships, opportunities, efficiency,
and threats.\r\n(1.4.3) The ROET analysis is reduced to a concise report.\r\n(1.4.4) The ROET report has clear recommendations regarding the strategic direction that the organisation should take.\r\n \r\nExtract operational systems, core targets,
and top ten risks
from the process construct.\r\nStrategy Development: Phase 2: Standard 1.5\r\n(1.5.1) The organisational process construct is divided into core operational systems.\r\n(1.5.2) Each operational system holds at least one core target that shows the health of that system. Each target must include a qualification, quantification, measure, evidence,
and weighting. This \"super target\", must summarize all other targets within that system.\r\n(1.5.3) The strategy clearly depicts the top ten operational risks.\r\n \r\nAssess the strategic position of your organisation.\r\nStrategy Development: Phase 3: Standard 1.6\r\n(1.6.1) There is a method to assess the organisations rank/position in its industry.\r\n(1.6.2) Org knows what rank it wants within its industry.\r\n(1.6.3) There is a method to assess the relatioship between sponsorship (Org has the resources to do its work)
and entropy (compeditors). This method should give guidance
on which predominant strategic approach Org must follow:\r\n (1.6.2.1) Process efficiency strategy - when sponsorship is high
and competition (entropy) is low.\r\n (1.6.2.2) Competitive strategy - when competition is high
and industry processes are internalized.\r\n (1.6.2.3) Disruptive innovation (blue ocean) strategy - when the only option is to make your competitor irrelevant. \r\n \r\nDevelop strategic intent through the 5V model.\r\nStrategy Development: Phase 3: Standard 1.7\r\n(1.7.1) The 5V Model is fully designed. This implies five vision statements (5V) that imply the following strategic periods:\r\n (1.7.1.1) V1 – ultimate dream (long-term vision)\r\n (1.7.1.2) V2 – Nine years
from commencement of strategy (long-medium term vision)\r\n (1.7.1.3) V3 - Six years
from commencement of strategy (medium term vision)\r\n (1.7.1.4) V4 - Three years
from commencement of strategy (short-medium term vision)\r\n (1.7.1.5) V5 - One year
from commencement of strategy (short term vision)\r\n(1.7.2) The V1 statement defines the ultimate dream of Org. This is a non-quantifiable idea of the ultimate state for your organisation. It is a dream,
and therefore Org can define it in any way it wants.\r\n(1.7.3) The strategic period of Org is in line with the V4 target date.\r\n(1.7.4) Statements V2, V3,
and V4 (also nown as the 3-6-9 vision) have both quantifyable
and qualifyable vision statements.\r\n(1.7.5) The V5 statement is up to date (it changes
on an annual basis).\r\n \r\nDefine strategic objectives.\r\nStrategy Development: Phase 3: Standard 1.8\r\n(1.8.1) Strategic objectives are derived
from the ROET
and operational analysis.\r\n(1.8.2) Strategic objectives define the change that Org must make to close the gap between its current reality
and its \"3-6-9\" position. It is good practice to have between two
and five strategic objectives. More than that becomes hard to manage.\r\n(1.8.3) Each strategic objective begins with a verb.\r\n \r\nCreate a work breakdown structure for the strategic programs.\r\nStrategy Development: Phase 4: Standard 1.9\r\n(1.9.1) Each strategic objective is turned into a strategic program. The objective becomes the aim of the program.\r\n(1.9.2) Each strategic program is linked to one or more strategic projects. We execute strategic programs through project management method, which means that child projects make up the activity of a strategic program.\r\n(1.9.3) Each strategic project has a clear work breakdown structure that includes the following items:\r\n (1.9.3.1) List of activities.\r\n (1.9.3.2) Classification code for each activity (C-Key).\r\n (1.9.3.3) Dependency flow (predecessors to activities).\r\n (1.9.3.4) Estimated duration for each activity (use the critical path or PERT method).\r\n (1.9.3.5) Name of the responsible person (not roles) to each activity.\r\n (1.9.3.6) Resource weight of each activity (cost of the activity as a percentage of the budget).\r\n (1.9.3.7) Target date for completion of the activity.\r\n(1.9.4) There is a project brief
and/or plan for each project.\r\n \r\nCalculate the cost of strategy.\r\nStrategy Development: Phase 4: Standard 1.10\r\n(1.10.1) There is a cost calculation for the strategy. Jointly, the cost of all the strategic programs is the cost of strategy. The cost of strategic programs is the sum of all its strategic project cost.\r\n(1.10.2) There is a cost calculation for operations. To relate cost of strategy to the organisational budget, we must know the cost of operations. The process construct of Org create its operational cost. Therefore, the cost of all process activity is also the operational cost of Org.\r\n(1.10.3) There is an overall organisational cost calculation. The sum of strategic
and operational cost is the total cost of running
and changing Org. Therefore, strategy
and operations have an inverse relationship, meaning increase of one demands a decrease
from the other.\r\n(1.10.4) Relate cost to 100 points (%). This will put expenses in perspective. It is good practice to relate cost as follows:\r\n (1.10.4.1) % Strategic cost to % operational cost.\r\n (1.10.4.2) % Strategic programs cost to overall cost of strategy.\r\n (1.10.4.3) % Project cost to overall program cost.\r\n (1.10.4.4) % Operational systems cost to overall operational cost.\r\n (1.10.4.5) % Process cost to operational systems cost.\r\n \r\nAssess the strategic risk.\r\nStrategy Development: Phase 4: Standard 1.11\r\n(1.11.1) There are critical success factors (CSF\'s) for each project in terms of efficiency, completion,
and effect.\r\n(1.11.2) The risk register contains these CSF\'s.\r\n(1.11.3) There is a method to calculate the Risk Exposure Value [risk value (probability * impact) - control value (mitigation * business continuety) = exposure].\r\n(1.11.4) The risk register enables Org to extract it strategic risks
and also to extract the risks for each strategi program.\r\n(1.11.5) The top ten strategic risks are listed.\r\n \r\nDevelop the strategy document.\r\nStrategy Development: Phase 5: Standard 1.12\r\n(1.12.1) The strategy document has a clear statement of organisational definition
and identity. This statement should include the following items (
order not important):\r\n (1.12.1.1) A statement of purpose / mission.\r\n (1.12.1.2) A statement of intent / vision.\r\n (1.12.1.3) A statement of organisational
values.\r\n (1.12.1.4) A organisational business model.\r\n(1.12.2) The strategy document has a clear statement of operational efficiency. This statement should include the following items:\r\n (1.12.2.1) A summary of the process construct showing its core systems.\r\n (1.12.2.2) A list of the process construct\'s core targets.\r\n (1.12.2.3) A list the top ten operational risks.\r\n(1.12.3) The strategy document has a clear statement of strategic effectiveness. This statement should include the following items:\r\n (1.12.3.1) A summary of the ROET analysis with its proposed strategic focus areas.\r\n (1.12.3.2) A 5V model.\r\n (1.12.3.3) A list of the strategic objectives, the program director,
and a target date,
and associated projects with their project leaders.\r\n (1.12.3.4) A list of the top ten strategic risks.\r\n(1.12.4) The document holds a section
on how the organisation will monitor
and execute its strategy.\r\n(1.12.5) There is an executive summary that explains the context
and process used to devise this strategy as well as why a specific strategic choice was taken. It should also have a summarized version of what the strategy entails.\r\n \r\nMonitor the execution of strategy.\r\nStrategy Development: Phase 5: Standard 1.13\r\n(1.13.1) There is a strategic scorecard that quantifies the following:\r\n (1.13.1.1) A scorecard that shows how well the strategic programs are executed.\r\n (1.13.1.2) A scorecard that shows how well our process construct is running.\r\n(1.13.2) There is a feedback system that will keep the CEO informed.\r\n(1.13.3) The executive or management team has a generic agenda that gives specific time to discuss their \"3-6-9\" vision.\r\n(1.13.4) Strategy teams meet regularly
and they follow project management method.\r\n(1.13.5) Program directors are senior people who can give direct feedback to the CEO.\r\n \r\n ') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '\r\n\r\n\r\nStrategy is a plan that Org creates to become or stay a Relevant
and Performing Organisation (RPO).\r\n\r\n\r\nStrategy development is the development of such a plan.\r\n\r\n\r\nThe aim of these standards is to help Orgtologists to create
and develop a strategy, or to train others to do so according to orgtology theories
and principles.\r\n\r\n\r\nClick
on any of the standards in the table below to go directly to its specifications.\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\nPhase:\r\n\r\n\r\nIOI Standard:\r\n\r\n\r\nIOI Standard Nr:\r\n\r\n\r\n\r\n1.\r\n\r\nInitiate a strategy development project.\r\n\r\n\r\n\r\n\r\nUnderstand the strategy development needs.\r\n\r\n\r\nDraft a project plan
and brief for the strategy development process.\r\n\r\n\r\nDraft a project inception report.\r\n\r\n\r\nDraft milestone completion reports fr al completed milestones.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.1\r\n\r\n\r\n2.2\r\n\r\n\r\n2.3\r\n\r\n\r\n2.4\r\n\r\n\r\n\r\n\r\n\r\n\r\n2. \r\n\r\n\r\nOrg Identity
and Definition.\r\n\r\n\r\n\r\n\r\nDefine the purpose of the organisation.\r\n\r\n\r\nDefine the organisational intent.\r\n\r\n\r\nDevelop organisational
values.\r\n\r\n\r\nDevelop behavioural rules around these
values.\r\n\r\n\r\nDevelop a business canvas that depicts the core modus operandi (way of doing things).\r\n\r\n\r\nDevelop a business model for the organisation.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.5\r\n\r\n\r\n2.6\r\n\r\n\r\n2.7\r\n\r\n\r\n2.8\r\n\r\n\r\n2.9\r\n\r\n\r\n2.10\r\n\r\n\r\n\r\n\r\n\r\n\r\n3. \r\n\r\n\r\nCurrent reality analysis.\r\n\r\n\r\n\r\n\r\nDo a REET analysis.\r\n\r\n\r\nAnalyse REET data.\r\n\r\n\r\nDraft
and submit a REET Report with reccommendations.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.11\r\n\r\n\r\n2.12\r\n\r\n\r\n2.13\r\n\r\n\r\n\r\n\r\n\r\n4.\r\n\r\nOperational Performance Analysis\r\n\r\n\r\n\r\n\r\nDo a Level Zero process analysis.\r\n\r\n\r\nDraft core business processes
and cross map with Level Zero.\r\n\r\n\r\nDevelop Level Zero targets.\r\n\r\n\r\nAssess
and list top ten operational risks.\r\n\r\n\r\n\r\n\r\n\r\n\r\n 2.14\r\n\r\n\r\n2.15\r\n\r\n\r\n2.16\r\n\r\n\r\n2.17\r\n\r\n\r\n\r\n\r\n\r\n\r\n5. \r\n\r\n\r\nStrategic Intent & Direction.\r\n\r\n\r\n\r\n\r\nAssess
and decide
on the best strategy type for the Org.\r\n\r\n\r\nDevelop strategic intent through the 5V Model.\r\n\r\nUse the 5V model, the REET analysis,
and the operational performance analysis to determine the change needed.\r\n\r\nDefine strategic objectives
and programs.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.18\r\n\r\n\r\n2.19\r\n\r\n\r\n2.20\r\n\r\n\r\n2.21\r\n\r\n\r\n\r\n\r\n\r\n\r\n6. \r\n\r\n\r\nImplementation Plan.\r\n\r\n\r\n\r\nIdentify strategic projects
and link to the strategic programs.\r\n\r\nCreate a work breakdown structure for each project.\r\n\r\n\r\nCalculate the cost of strategy.\r\n\r\n\r\nAssess the strategic risk.\r\n\r\n\r\n\r\n\r\n\r\n\r\n2.22\r\n\r\n\r\n2.23\r\n\r\n\r\n2.24\r\n\r\n\r\n2.25\r\n\r\n\r\n\r\n\r\n\r\n\r\n7. \r\n\r\n\r\nMonitor & Lead.\r\n\r\n\r\n\r\n\r\nWrite the strategy document.\r\n\r\n\r\nDevelop strategy monitoring tools.\r\n\r\nEnsure strategic accountability
and responsibility.\r\n\r\n\r\n\r\n\r\n\r\n2.26\r\n\r\n\r\n2.27\r\n\r\n\r\n2.28\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\nDefine the purpose of your organisation.\r\nStrategy Development: Phase 1: Standard 1.1\r\n(1.1.1) The statement of purpose defines the organisations reason for existance.\r\n(1.1.2) The statement of purpose is distinct
from the statement of intent.\r\n(1.1.3) The statement of purpose is written in present tense. E.g., “We ensure price
and financial stability for the country.” Do not describe a future state, e.g., “To ensure price
and financial stability for the country.”\r\n \r\nDevelop organisational
values.\r\nStrategy Development: Phase 1: Standard 1.2\r\n(1.2.1) There is a narrative that describes the desired behavior of the organisation.\r\n(1.2.2) The strategy holds a list of
values that defines deisred behaviour.\r\n(1.2.3) Each value has a description.\r\n(1.2.4) Each value has a
set of behavioural rules.\r\n(1.2.5) Behavioural rules are part of the organisational performance asessment system.\r\n \r\nDevelop a business model for your organisation.\r\nStrategy Development: Phase 1: Standard 1.3\r\n(1.3.1) The business model has clearly identified value drivers. In orgtology the generic value drivers are process efficiency, strategic effectiveness, meaningful relationships, focused intelligence,
and productive resources.\r\n(1.3.2) The business model is linked to core critical success factors (CSF) for the organisation to perform
and stay relevant. These are high level CSF’s
and as rule of thumb, they must not exceed ten. The CSF’s for performance
and relevance must be listed separately (E.g., five for performance
and five for relevane).\r\n(1.3.3) The business model is decribed through a business canvas. The description must include partners, key activities, key resources, value propositions, customer relationships, distribution channels, customer segments, cost structure,
and revenue streams.\r\n(1.3.4) Depict the “value flow” of your business model. This is a model, value chain, or diagram that shows the interdependence of the organisational activity. The core value drivers must be depicted.\r\n \r\nDo a ROET analysis (Relationships, Opportunities, Effciency,
and Threats).\r\nStrategy Development: Phase 2: Standard 1.4\r\n(1.4.1) Duringstrategy development there was a clear method of ROET assessment. ROET assessment methods can include (but not limied to) a workshop or meeting
where dialogue is facilitated around ROET; a questionnaire to employees
and other stakeholders; interviews
and/or meetings with stakeholders.\r\n(1.4.2) The ROET generated sufficient data to make reasonable assumptions about relationships, opportunities, efficiency,
and threats.\r\n(1.4.3) The ROET analysis is reduced to a concise report.\r\n(1.4.4) The ROET report has clear recommendations regarding the strategic direction that the organisation should take.\r\n \r\nExtract operational systems, core targets,
and top ten risks
from the process construct.\r\nStrategy Development: Phase 2: Standard 1.5\r\n(1.5.1) The organisational process construct is divided into core operational systems.\r\n(1.5.2) Each operational system holds at least one core target that shows the health of that system. Each target must include a qualification, quantification, measure, evidence,
and weighting. This \"super target\", must summarize all other targets within that system.\r\n(1.5.3) The strategy clearly depicts the top ten operational risks.\r\n \r\nAssess the strategic position of your organisation.\r\nStrategy Development: Phase 3: Standard 1.6\r\n(1.6.1) There is a method to assess the organisations rank/position in its industry.\r\n(1.6.2) Org knows what rank it wants within its industry.\r\n(1.6.3) There is a method to assess the relatioship between sponsorship (Org has the resources to do its work)
and entropy (compeditors). This method should give guidance
on which predominant strategic approach Org must follow:\r\n (1.6.2.1) Process efficiency strategy - when sponsorship is high
and competition (entropy) is low.\r\n (1.6.2.2) Competitive strategy - when competition is high
and industry processes are internalized.\r\n (1.6.2.3) Disruptive innovation (blue ocean) strategy - when the only option is to make your competitor irrelevant. \r\n \r\nDevelop strategic intent through the 5V model.\r\nStrategy Development: Phase 3: Standard 1.7\r\n(1.7.1) The 5V Model is fully designed. This implies five vision statements (5V) that imply the following strategic periods:\r\n (1.7.1.1) V1 – ultimate dream (long-term vision)\r\n (1.7.1.2) V2 – Nine years
from commencement of strategy (long-medium term vision)\r\n (1.7.1.3) V3 - Six years
from commencement of strategy (medium term vision)\r\n (1.7.1.4) V4 - Three years
from commencement of strategy (short-medium term vision)\r\n (1.7.1.5) V5 - One year
from commencement of strategy (short term vision)\r\n(1.7.2) The V1 statement defines the ultimate dream of Org. This is a non-quantifiable idea of the ultimate state for your organisation. It is a dream,
and therefore Org can define it in any way it wants.\r\n(1.7.3) The strategic period of Org is in line with the V4 target date.\r\n(1.7.4) Statements V2, V3,
and V4 (also nown as the 3-6-9 vision) have both quantifyable
and qualifyable vision statements.\r\n(1.7.5) The V5 statement is up to date (it changes
on an annual basis).\r\n \r\nDefine strategic objectives.\r\nStrategy Development: Phase 3: Standard 1.8\r\n(1.8.1) Strategic objectives are derived
from the ROET
and operational analysis.\r\n(1.8.2) Strategic objectives define the change that Org must make to close the gap between its current reality
and its \"3-6-9\" position. It is good practice to have between two
and five strategic objectives. More than that becomes hard to manage.\r\n(1.8.3) Each strategic objective begins with a verb.\r\n \r\nCreate a work breakdown structure for the strategic programs.\r\nStrategy Development: Phase 4: Standard 1.9\r\n(1.9.1) Each strategic objective is turned into a strategic program. The objective becomes the aim of the program.\r\n(1.9.2) Each strategic program is linked to one or more strategic projects. We execute strategic programs through project management method, which means that child projects make up the activity of a strategic program.\r\n(1.9.3) Each strategic project has a clear work breakdown structure that includes the following items:\r\n (1.9.3.1) List of activities.\r\n (1.9.3.2) Classification code for each activity (C-Key).\r\n (1.9.3.3) Dependency flow (predecessors to activities).\r\n (1.9.3.4) Estimated duration for each activity (use the critical path or PERT method).\r\n (1.9.3.5) Name of the responsible person (not roles) to each activity.\r\n (1.9.3.6) Resource weight of each activity (cost of the activity as a percentage of the budget).\r\n (1.9.3.7) Target date for completion of the activity.\r\n(1.9.4) There is a project brief
and/or plan for each project.\r\n \r\nCalculate the cost of strategy.\r\nStrategy Development: Phase 4: Standard 1.10\r\n(1.10.1) There is a cost calculation for the strategy. Jointly, the cost of all the strategic programs is the cost of strategy. The cost of strategic programs is the sum of all its strategic project cost.\r\n(1.10.2) There is a cost calculation for operations. To relate cost of strategy to the organisational budget, we must know the cost of operations. The process construct of Org create its operational cost. Therefore, the cost of all process activity is also the operational cost of Org.\r\n(1.10.3) There is an overall organisational cost calculation. The sum of strategic
and operational cost is the total cost of runn