Standards

List of articles in category IOI Quality Standards
Title	Modified Date	Hits
Develop a Strategy	11 July 2023	Hits: 2256
Design an Organisation	03 November 2021	Hits: 1121

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695610067,
                "last": 1695610067,
                "now": 1695610067
            },
            "token": "Ub3rMC1b7rwIClgou0wluqYhL1vAuJZ5"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__com_easysocial": {
        "easysocial": {
            "before_registration": "L2luZGV4LnBocC9hYm91dC11cy9zdGFuZGFyZHM="
        }
    }
}

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

#	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

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

#	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

EXPLAIN not possible on query: INSERT INTO `tisw7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3461393734353934353465643763353864666666353032306462356439393666', 1, 1695610067, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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')

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `tisw7_komento_configs`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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')

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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&nbsp;\r\n\r\n\r\n\r\n\r\n&nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n\r\n\r\nStrategic Intent &amp; 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&nbsp;
  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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n\r\n\r\nMonitor &amp; 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&nbsp;\r\nDefine the purpose of your organisation.\r\nStrategy Development: Phase 1: Standard 1.1\r\n(1.1.1) The statement of purpose&nbsp;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&nbsp;\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&nbsp;\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&nbsp;\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&nbsp;regarding the strategic direction that the organisation should take.\r\n&nbsp;\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&nbsp;\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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(1.6.2.1) Process efficiency strategy - when sponsorship is high 
  and competition (entropy) is low.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; (1.6.2.2) Competitive strategy - when competition is high 
  and industry processes are internalized.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; (1.6.2.3) Disruptive innovation (blue ocean) strategy - when the only option is to make your competitor irrelevant.&nbsp;\r\n&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.1) V1 – ultimate dream (long-term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.2) V2 – Nine years 
  from commencement of strategy (long-medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.3) V3 - Six years 
  from commencement of strategy (medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.4) V4 - Three years 
  from commencement of strategy (short-medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp;\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&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.1) List of activities.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.2) Classification code for each activity (C-Key).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.3) Dependency flow (predecessors to activities).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.4) Estimated duration for each activity (use the critical path or PERT method).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.5) Name of the responsible person (not roles) to each activity.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.6) Resource weight of each activity (cost of the activity as a percentage of the budget).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp;\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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(1.10.4.1) % Strategic cost to % operational cost.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;(1.10.4.2) % Strategic programs cost to overall cost of strategy.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;(1.10.4.3) % Project cost to overall program cost.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(1.10.4.4) % Operational systems cost to overall operational cost.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;(1.10.4.5) % Process cost to operational systems cost.\r\n&nbsp;\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&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.1.1) A statement of purpose / mission.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.1.2) A statement of intent / vision.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.1.3) A statement of organisational 
  values.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.2.1) A summary of the process construct showing its core systems.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.2.2) A list of the process construct\'s core targets.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.3.1) A summary of the ROET analysis with its proposed strategic focus areas.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.3.2) A 5V model.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.12.3.4)&nbsp; 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&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.13.1.1) A scorecard that shows how well the strategic programs are executed.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp;\r\n&nbsp;') 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&nbsp;\r\n\r\n\r\n\r\n\r\n&nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n\r\n\r\nStrategic Intent &amp; 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&nbsp;
  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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n\r\n\r\nMonitor &amp; 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&nbsp;\r\nDefine the purpose of your organisation.\r\nStrategy Development: Phase 1: Standard 1.1\r\n(1.1.1) The statement of purpose&nbsp;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&nbsp;\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&nbsp;\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&nbsp;\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&nbsp;regarding the strategic direction that the organisation should take.\r\n&nbsp;\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&nbsp;\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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(1.6.2.1) Process efficiency strategy - when sponsorship is high 
  and competition (entropy) is low.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; (1.6.2.2) Competitive strategy - when competition is high 
  and industry processes are internalized.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; (1.6.2.3) Disruptive innovation (blue ocean) strategy - when the only option is to make your competitor irrelevant.&nbsp;\r\n&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.1) V1 – ultimate dream (long-term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.2) V2 – Nine years 
  from commencement of strategy (long-medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.3) V3 - Six years 
  from commencement of strategy (medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.7.1.4) V4 - Three years 
  from commencement of strategy (short-medium term vision)\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp;\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&nbsp;\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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.1) List of activities.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.2) Classification code for each activity (C-Key).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (1.9.3.3) Dependency flow (predecessors to activities).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.4) Estimated duration for each activity (use the critical path or PERT method).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.5) Name of the responsible person (not roles) to each activity.\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(1.9.3.6) Resource weight of each activity (cost of the activity as a percentage of the budget).\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(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&nbsp;\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

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

191 Queries Logged 532.30 ms

63 duplicate found!

IOI Quality Standards

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

191 Queries Logged 532.30 ms

63 duplicate found!