Query Time: 0.65 ms Query memory: 0.023 MB Memory before query: 1.356 MB Rows returned: 0
SELECT `data`
FROM `tisw7_session`
WHERE `session_id` = X'6361313435636664356164326437346466326464396663343837313638303665'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.48 ms After last query: 17.89 ms Query memory: 0.020 MB Memory before query: 1.371 MB Rows returned: 0
SELECT `session_id`
FROM `tisw7_session`
WHERE `session_id` = X'6361313435636664356164326437346466326464396663343837313638303665'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.91 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 1.376 MB
INSERT INTO `tisw7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6361313435636664356164326437346466326464396663343837313638303665', 1, 1695609190, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `tisw7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6361313435636664356164326437346466326464396663343837313638303665', 1, 1695609190, 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.30 ms After last query: 25.87 ms Query memory: 0.042 MB Memory before query: 1.471 MB Rows returned: 56
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tisw7_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_extensions | NULL | ref | extension | extension | 82 | const | 56 | 1.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.53 ms After last query: 19.89 ms Query memory: 0.021 MB Memory before query: 1.525 MB Rows returned: 5
SELECT id, rules
FROM `tisw7_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 1.537 MB Rows returned: 2
SELECT b.id
FROM tisw7_usergroups AS a
LEFT JOIN tisw7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.78 ms After last query: 2.47 ms Query memory: 0.064 MB Memory before query: 1.558 MB Rows returned: 309
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM tisw7_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_extensions | NULL | ref | extension | extension | 82 | const | 354 | 0.60 | Using index condition; Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 162.13 ms Query memory: 0.062 MB Memory before query: 2.616 MB Rows returned: 1
SELECT *
FROM `tisw7_social_config`
WHERE `type` = 'site'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_social_config | NULL | ref | type | type | 767 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46 |
14 | SocialDBHelper->__call() | JROOT/administrator/components/com_easysocial/includes/db/db.php:303 |
13 | SocialDb->__call() | JROOT/administrator/components/com_easysocial/models/config.php:43 |
12 | EasySocialModelConfig->getConfig() | JROOT/administrator/components/com_easysocial/includes/config/config.php:103 |
11 | SocialConfig->load() | JROOT/administrator/components/com_easysocial/includes/config/config.php:25 |
10 | SocialConfig->__construct() | JROOT/administrator/components/com_easysocial/includes/config/config.php:40 |
9 | SocialConfig::getInstance() | JROOT/administrator/components/com_easysocial/includes/easysocial.php:503 |
8 | ES::config() | JROOT/administrator/components/com_easysocial/includes/plugins.php:37 |
7 | EasySocialPlugins->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 142.51 ms Query memory: 0.025 MB Memory before query: 3.131 MB Rows returned: 49
SELECT *
FROM `tisw7_payplans_config`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_payplans_config | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 49 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
12 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
11 | PPDb->__call() | JROOT/administrator/components/com_payplans/models/config.php:33 |
10 | PayplansModelConfig->getConfig() | JROOT/administrator/components/com_payplans/includes/payplans.php:666 |
9 | PP::config() | JROOT/administrator/components/com_payplans/includes/plugins.php:33 |
8 | PPPlugins->__construct() | JROOT/plugins/system/payplans/payplans.php:47 |
7 | plgSystemPayplans->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 89.25 ms Query memory: 0.022 MB Memory before query: 4.452 MB Rows returned: 1
SELECT *
FROM tisw7_ea_configs
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_ea_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
12 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:88 |
11 | EA::config() | JROOT/administrator/components/com_easyarticles/includes/utils.php:69 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.54 ms After last query: 3.89 ms Query memory: 0.025 MB Memory before query: 4.474 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tisw7_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
19 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
16 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
15 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
14 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_easyarticles/includes/utils.php:72 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.04 ms After last query: 0.22 ms Query memory: 0.007 MB Memory before query: 4.467 MB
UPDATE `tisw7_extensions`
SET `params` = '{\"mediaversion\":\"6e875e065fb87e319b4f1be5018378e6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | tisw7_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_easyarticles/includes/utils.php:72 |
10 | EasyArticles->__construct() | JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23 |
9 | EAAcl->__construct() | JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:60 |
8 | EA::acl() | JROOT/plugins/system/easyarticles/easyarticles.php:40 |
7 | PlgSystemEasyArticles->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.42 ms After last query: 184.90 ms Query memory: 0.069 MB Memory before query: 4.936 MB Rows returned: 36
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM tisw7_menu AS m
LEFT JOIN tisw7_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 140 | 3.33 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.m.component_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
20 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
17 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
16 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
15 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
14 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
13 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
12 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
11 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
10 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
9 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
8 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jmap/jmap.php:1168 |
7 | plgSystemJMap->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.63 ms After last query: 107.59 ms Query memory: 0.026 MB Memory before query: 5.242 MB Rows returned: 3
SELECT tbl.*
FROM tisw7_payplans_app AS tbl
WHERE `tbl`.`published` ='1'
ORDER BY app_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | index | idx_published,idx_publish_order | PRIMARY | 4 | NULL | 3 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
21 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
20 | PPDb->__call() | JROOT/administrator/components/com_payplans/includes/model.php:526 |
19 | PayPlansModel->loadRecords() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:131 |
18 | PPHelperApp::loadApps() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:313 |
17 | PPHelperApp::getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:123 |
16 | PPPlugins->getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:102 |
15 | PPPlugins->getAppHelper() | JROOT/plugins/payplans/sobipro/sobipro.php:31 |
14 | plgPayplansSobipro->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:82 |
11 | PPDispatcher->loadPlugins() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:40 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 7.75 ms Query memory: 0.029 MB Memory before query: 5.279 MB Rows returned: 0
SELECT app_id,plan_id
FROM tisw7_payplans_planapp AS tbl
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
31 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
30 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
29 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
28 | PPDb->__call() | JROOT/administrator/components/com_payplans/models/planapp.php:38 |
27 | PayplansModelPlanapp->_loadCache() | JROOT/administrator/components/com_payplans/models/planapp.php:78 |
26 | PayplansModelPlanapp->getAppPlans() | JROOT/administrator/components/com_payplans/includes/app/app.php:427 |
25 | PPApp->afterBind() | JROOT/administrator/components/com_payplans/includes/abstract.php:413 |
24 | PPAbstract->bind() | JROOT/administrator/components/com_payplans/includes/app/app.php:444 |
23 | PPApp->bind() | JROOT/administrator/components/com_payplans/includes/abstract.php:47 |
22 | PPAbstract->__construct() | JROOT/administrator/components/com_payplans/includes/app/app.php:42 |
21 | PPApp->__construct() | JROOT/administrator/components/com_payplans/includes/app/abstract/payment.php:23 |
20 | PPAppPayment->__construct() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:112 |
19 | PPHelperApp::loadApp() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:137 |
18 | PPHelperApp::loadApps() | JROOT/administrator/components/com_payplans/includes/helpers/app.php:313 |
17 | PPHelperApp::getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:123 |
16 | PPPlugins->getAvailableApps() | JROOT/administrator/components/com_payplans/includes/plugins.php:102 |
15 | PPPlugins->getAppHelper() | JROOT/plugins/payplans/sobipro/sobipro.php:31 |
14 | plgPayplansSobipro->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:82 |
11 | PPDispatcher->loadPlugins() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:40 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.58 ms After last query: 271.08 ms Query memory: 0.030 MB Memory before query: 5.927 MB Rows returned: 56
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tisw7_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_activitystream','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_easyarticles','com_easyblog','com_easydiscuss','com_easysocial','com_extplorer','com_fields','com_finder','com_gantry5','com_hierarchy','com_installer','com_jce','com_jlike','com_jmap','com_joomlaupdate','com_jticketing','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_payplans','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_seoglossary','com_tags','com_templates','com_tjfields','com_tjnotifications','com_tjprivacy','com_tjreports','com_users','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 550 | 10.36 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
16 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_payplans/includes/user/user.php:922 |
15 | PPUser->isSiteAdmin() | JROOT/administrator/components/com_payplans/includes/user/user.php:965 |
14 | PPUser->isAdmin() | JROOT/plugins/payplans/menuaccess/menuaccess.php:36 |
13 | plgPayplansMenuAccess->onPayplansSystemStart() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:43 |
10 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
9 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:250 |
8 | plgSystemPayplans->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.86 ms After last query: 396.63 ms Query memory: 0.024 MB Memory before query: 6.601 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `tisw7_komento_configs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `tisw7_komento_configs`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:585 |
11 | Joomla\CMS\Table\Table->reset() | JROOT/libraries/src/Table/Table.php:724 |
10 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_komento/includes/komento.php:399 |
9 | KT::config() | JROOT/components/com_komento/bootstrap.php:39 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:14 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.78 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 6.615 MB Rows returned: 1
SELECT *
FROM tisw7_komento_configs
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_komento_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 25.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_komento/includes/komento.php:399 |
9 | KT::config() | JROOT/components/com_komento/bootstrap.php:39 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:14 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 86.48 ms Query memory: 0.025 MB Memory before query: 7.224 MB Rows returned: 0
SELECT tbl.*
FROM tisw7_payplans_subscription AS tbl
WHERE `tbl`.`user_id` = 0
AND `tbl`.`status` ='1601'
ORDER BY subscription_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tbl | NULL | ref | idx_userid,idx_user_subs | idx_userid | 4 | const | 1 | 16.67 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_payplans/includes/db/helpers/base.php:38 |
18 | PPDbBase->__call() | JROOT/administrator/components/com_payplans/includes/db/db.php:257 |
17 | PPDb->__call() | JROOT/administrator/components/com_payplans/includes/model.php:526 |
16 | PayPlansModel->loadRecords() | JROOT/administrator/components/com_payplans/includes/user/user.php:665 |
15 | PPUser->getPlans() | JROOT/plugins/payplans/sobipro/sobipro.php:48 |
14 | plgPayplansSobipro->onPayplansAccessCheck() | JROOT/libraries/joomla/event/event.php:70 |
13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/dispatcher/dispatcher.php:43 |
11 | PPDispatcher->trigger() | JROOT/administrator/components/com_payplans/includes/event/event.php:113 |
10 | PPEvent::trigger() | JROOT/plugins/system/payplans/payplans.php:322 |
9 | plgSystemPayplans->checkAccess() | JROOT/plugins/system/payplans/payplans.php:88 |
8 | plgSystemPayplans->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.01 ms After last query: 9.29 ms Query memory: 0.022 MB Memory before query: 7.312 MB Rows returned: 6
SELECT id, home, template, s.params
FROM tisw7_template_styles as s
LEFT JOIN tisw7_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | orgtology2018_derekh1sit277406.e.element | 1 | 75.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/gantry5/gantry5.php:257 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
8 | plgSystemGantry5->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.91 ms After last query: 378.32 ms Query memory: 0.023 MB Memory before query: 7.821 MB Rows returned: 4
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM tisw7_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_isotope'
ORDER BY s.id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | index | idx_template,idx_client_id,idx_client_id_home | PRIMARY | 4 | NULL | 8 | 37.50 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 |
14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 |
13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 |
12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 |
11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 |
10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:315 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
8 | plgSystemGantry5->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.82 ms After last query: 115.25 ms Query memory: 0.019 MB Memory before query: 7.929 MB Rows returned: 1
SELECT *
FROM tisw7_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 28.76 ms Query memory: 0.033 MB Memory before query: 7.988 MB Rows returned: 79
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tisw7_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 550 | 23.20 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.56 ms After last query: 4.31 ms Query memory: 0.031 MB Memory before query: 8.148 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `tisw7_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `tisw7_content`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:328 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.86 ms After last query: 13.35 ms Query memory: 0.005 MB Memory before query: 8.206 MB
UPDATE tisw7_content
SET `hits` = (`hits` + 1)
WHERE `id` = '29'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | tisw7_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.10 ms After last query: 7.49 ms Query memory: 0.062 MB Memory before query: 8.231 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM tisw7_content AS a
INNER JOIN tisw7_categories AS c
on c.id = a.catid
LEFT JOIN tisw7_users AS u
on u.id = a.created_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.id = 29
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 02:33:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 02:33:12')
AND (a.state = 1 OR a.state =2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.37 ms After last query: 8.98 ms Query memory: 0.022 MB Memory before query: 8.370 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.article'
AND `m`.`content_item_id` = 29
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 2278 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | orgtology2018_derekh1sit277406.m.tag_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.09 ms After last query: 82.57 ms Query memory: 0.026 MB Memory before query: 8.551 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 = 18
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 25 | 51.68 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.23 ms After last query: 1.96 ms Query memory: 0.025 MB Memory before query: 8.574 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 (18,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | orgtology2018_derekh1sit277406.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | orgtology2018_derekh1sit277406.a.id | 1 | 100.00 | Using where; Using index; Distinct |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 98.63 ms After last query: 61.35 ms Query memory: 0.137 MB Memory before query: 8.822 MB Rows returned: 42
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\nContents…\r\n\r\n\r\n\r\n\r\n\r\nAbout the workshopbout the workshop\r\n\r\n\r\nThe program\r\n\r\n\r\nWho should enrol?\r\n\r\n\r\nDelivery method\r\n\r\n\r\nAssessment
and certification\r\n\r\n\r\nAccreditation\r\n\r\n\r\nCost
and dates\r\n\r\n\r\nContact us \r\n\r\n\r\nEnrol for the OCP\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n\r\n1. About the Workshop:\r\nThe task of an executive team is to ensure performance
and secure relevance. That is the bulk of their work. The word “orgtology” joins “organisation” with the Greek word “logy”. The science of organisation. It is a holistic way that helps us to drive relevant performance. This is one thing that business schools often lack to teach. The program is highly suitable for senior managers, directors,
and executives.\r\nThe OCP has four parts. They are: organisational science, organisational design, strategy, management
and leadership. This is an advanced program. To enrol, you must hold a bachelor’s degree with three years of work experience.
On completion, you can enrol as an Orgtologist with the International Orgtology Institute (IOI).\r\n \r\n\r\n\r\n\r\n\r\n\"In orgtology we study an organisation as a dual entity. In so, we see organisations as
having both scientific
and abstract parts. Also, they run
on different rules. Operations must efficiently cycle production, delivery,
and performance. This is the scientific part. It is about resources, activity,
and outputs. Strategy must be effective in its intent
and outcomes. This is the abstract part. It is about vision
and ideas. Future leaders must know this difference. If not, they will become pawns to those who do.\"\r\n– Derek Hendrikz (Originator of Orgtology)\r\n\r\n\r\n\r\n\r\n \r\nOrgtology gives an in-depth understanding of…\r\n\r\nOrganisational design that aligns with the fourth industrial revolution.\r\nHow to drive relevant performance – power strategy.\r\nWhy the ROET analysis is a safer choice than SWOT.\r\nThe difference between operational
and strategic risk.\r\nCost control beyond the organigram.\r\nEffective performance assessment without using KPI’s.\r\nHow to improve employee
and stakeholder relations
and value.\r\nNext generation leadership skills for executives.\r\n\r\n \r\n\r\n To Top\r\n\r\n2. The Program:\r\n{loadposition myposition4}\r\n To Top\r\n\r\n3. Who should enrol? \r\n\r\n\r\n\r\n\r\n\r\n\r\nAny person who seeks a deeper understanding
on running
and transforming organisations.\r\n\r\n\r\nIt will be hugely beneficial for EXCO teams
and Board members to attend. The content of this program, to a substantial extent, encapsulates the work of executives
and senior managers.\r\n\r\n\r\nFor the same reason, it will be highly beneficial for managers
from all levels to undergo the training.\r\n\r\n\r\nHR Practitioners, project managers, OD consultants, strategy managers, process engineers, etc., are all positions that will greatly benefit
from this program.\r\n\r\n\r\nAny person who holds a recognised bachelor’s degree (or similar)
and who has an interest to understand organisations.\r\n\r\n\r\nThe programme is highly suitable for applicants who hold MBA degrees, yet this is not a requirement.\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\nTo Top\r\n \r\n\r\n4. Delivery Method:\r\nWe use live contact sessions (Zoom, MS Teams, etc.)
and Facebook social learning groups for online learning.\r\n \r\nLive sessions\r\n\r\nWe will run 25 live online discussions with tutor.\r\nEach study
group will jointly decide
on the times
and dates for the discussion groups.\r\nThere will be live discussions for the modules as well as sessions for discussing the practical examination.\r\nThere must be 60% attendance for certification.\r\n\r\n \r\nOnline Learning through FaceBook Social learning groups:\r\nWe use the FaceBook Social Learning groups platform since it gives a range of learning options whilst eradicating a registrations process. We control the access
and learners can maximise their learning through advanced
group interaction.\r\n \r\nIn the FB platform, each module will have the following contents:\r\n\r\nMicro learning units.\r\nOpen forum
group discussions with questions
and answers platform.\r\nExplanatory video clips.\r\nExtra reading material.\r\nMultiple choice quiz questions.\r\n\r\n To Top\r\n\r\n5. Assessment
and Certification:\r\nTo complete the Orgtology Certification Programme, a learner must:\r\n\r\nWork through all the learning units.\r\nAchieve 100% for all the learning unit quiz questions.\r\nAttend 60% of the online sessions.\r\nSubmit four practical exam essays & reports according to the
set criteria.\r\n\r\n \r\n\r\n\r\n\r\n\r\n Module: \r\n\r\n\r\nPractical Exam: \r\n\r\n\r\nCriteria:\r\n\r\n\r\n\r\n1. \r\nOrganisational Science & theory.\r\n\r\nStudents must show comprehension of the philosophy
and core hypothesis of orgtology. This will necessitate a good understanding of Hypothesis 2x
and the theories that emanate
from it. Each student will submit an essay which will be published by the International Orgtology Institute.\r\n\r\n\r\n\r\n2.\r\nOrganisational design
and construct.\r\n\r\nStudents must show comprehension of what an organisation is,
and how its basic construct works. Students will be divided into teams
and then linked with a SME or start-up company. They will then use the IOI Quality Standards for \"Organisational Design\" to guide the SME in setting up their companies. Sutend will submit a team exam report, which will give them access to Module 3.\r\n\r\n\r\n\r\n3.\r\nOrganisational strategy.\r\n\r\nStudents must show comprehension of organisational strategy
and how to develop it
from an orgtology perspective. Students who have experience
and training in strategy development often find this part of the OCP as “eye opening”. It is dissimilar to traditional methods since it presents a more scientific approach. As with Module 2, students will be divided into teams
and then linked with a SME or start-up company. They will then use the IOI Quality Standards for \"Strategy Development\" to guide the SME in setting up their companies. Sutend will submit a team exam report, which will give them access to Module 3.\r\n\r\n\r\n\r\n4.\r\nExecutive Leadership.\r\n\r\nStudents must show comprehension of leadership
from an orgtology perspective.
From this perspective, we relate leadership to relevance, whilst we relate management to performance. The approach is thus quite distinct
from traditional leadership teachings. Each student will engage a manager in a coaching assignment
and submit a guided exam report
on completion of the coaching project. Through this Module students will conplete the OCP.\r\n\r\n\r\n\r\n\r\n \r\nOn completion, Orgtelligence Solutions will issue the successful candidate with a certificate of achievement. Students can use this certificate to register as an Orgtologist with the International Orgtology Institute.\r\n To Top\r\n\r\n6. Accreditation:\r\n\r\n\r\n\r\n\r\nThe Orgtologist Certification Programme is a pre-requisite to register as an Orgtologist with the International Orgtology Institute (IOI).\r\nThe IOI fully accredits this course
and recognises the OCP as a post-graduate programme.\r\n\r\n\r\n\r\n\r\nRegistered Orgtologist will receive the following membership benefits:\r\n\r\nLicence to practice as an Orgtologist.\r\nUse of the professional title “Orgtologist”.\r\nFree listing
and regular referrals through the Orgtologist Directory.\r\nAccess to international consulting opportunities.\r\nFree online magazine - “Orgtology Talk”.\r\nAccess to interactive discussion platform
where members can discuss orgtology applications.\r\nFree access to all IOI CPD accredited webinars\r\nReduced fees for IOI approved workshops.\r\nReduced fees for the annual International Orgtology Congress.\r\nEthics Committee advice
and resolution of issues\r\nInternational networking activities & opportunities.\r\n\r\n\r\n \r\n\r\n\r\n\r\n To Top\r\n\r\n7. Cost
and Dates:\r\n\r\n\r\nCost of the full 12-month online program (valid until June 2023):\r\n\r\nSADC students: 19 550 ZAR\r\nInternational students: 2000 USD\r\n\r\n\r\n\r\n\r\nEach intake can register a maximum of 20 students.\r\n\r\n \r\n\r\n\r\n\r\nIntake: \r\nStarting:\r\nEnding:\r\nStatus:\r\n\r\n\r\n OCP 1/2021\r\n 01 March 2021\r\n 15 February 2022\r\nClosed\r\n\r\n\r\n OCP 2/2021\r\n 01 May 2021\r\n 15 April 2022\r\nClosed\r\n\r\n\r\n OCP 3/2021\r\n 01 July 2021\r\n 15 June 2022\r\nClosed\r\n\r\n\r\n OCP 4/2021\r\n 01 November 2021\r\n 15 November 2022\r\nOpen\r\n\r\n\r\n OCP 5/2022\r\n 01 March 2022\r\n 15 March 2023\r\nClosed\r\n\r\n\r\n OCP 6/2022\r\n 15 September 2022\r\n 15 September 2023\r\nOpen\r\n\r\n\r\n\r\n To Top\r\n\r\n8. Contact Us:\r\n{loadposition myposition5}\r\n \r\n\r\n9. Book your seat
on the OCP:\r\nTo enrol for the OCP, please click
on the link below
and complete the enrolment form.\r\nEnrol for the OCP\r\n \r\n \r\n To Top ') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '\r\nContents…\r\n\r\n\r\n\r\n\r\n\r\nAbout the workshopbout the workshop\r\n\r\n\r\nThe program\r\n\r\n\r\nWho should enrol?\r\n\r\n\r\nDelivery method\r\n\r\n\r\nAssessment
and certification\r\n\r\n\r\nAccreditation\r\n\r\n\r\nCost
and dates\r\n\r\n\r\nContact us \r\n\r\n\r\nEnrol for the OCP\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n\r\n1. About the Workshop:\r\nThe task of an executive team is to ensure performance
and secure relevance. That is the bulk of their work. The word “orgtology” joins “organisation” with the Greek word “logy”. The science of organisation. It is a holistic way that helps us to drive relevant performance. This is one thing that business schools often lack to teach. The program is highly suitable for senior managers, directors,
and executives.\r\nThe OCP has four parts. They are: organisational science, organisational design, strategy, management
and leadership. This is an advanced program. To enrol, you must hold a bachelor’s degree with three years of work experience.
On completion, you can enrol as an Orgtologist with the International Orgtology Institute (IOI).\r\n \r\n\r\n\r\n\r\n\r\n\"In orgtology we study an organisation as a dual entity. In so, we see organisations as
having both scientific
and abstract parts. Also, they run
on different rules. Operations must efficiently cycle production, delivery,
and performance. This is the scientific part. It is about resources, activity,
and outputs. Strategy must be effective in its intent
and outcomes. This is the abstract part. It is about vision
and ideas. Future leaders must know this difference. If not, they will become pawns to those who do.\"\r\n– Derek Hendrikz (Originator of Orgtology)\r\n\r\n\r\n\r\n\r\n \r\nOrgtology gives an in-depth understanding of…\r\n\r\nOrganisational design that aligns with the fourth industrial revolution.\r\nHow to drive relevant performance – power strategy.\r\nWhy the ROET analysis is a safer choice than SWOT.\r\nThe difference between operational
and strategic risk.\r\nCost control beyond the organigram.\r\nEffective performance assessment without using KPI’s.\r\nHow to improve employee
and stakeholder relations
and value.\r\nNext generation leadership skills for executives.\r\n\r\n \r\n\r\n To Top\r\n\r\n2. The Program:\r\n{loadposition myposition4}\r\n To Top\r\n\r\n3. Who should enrol? \r\n\r\n\r\n\r\n\r\n\r\n\r\nAny person who seeks a deeper understanding
on running
and transforming organisations.\r\n\r\n\r\nIt will be hugely beneficial for EXCO teams
and Board members to attend. The content of this program, to a substantial extent, encapsulates the work of executives
and senior managers.\r\n\r\n\r\nFor the same reason, it will be highly beneficial for managers
from all levels to undergo the training.\r\n\r\n\r\nHR Practitioners, project managers, OD consultants, strategy managers, process engineers, etc., are all positions that will greatly benefit
from this program.\r\n\r\n\r\nAny person who holds a recognised bachelor’s degree (or similar)
and who has an interest to understand organisations.\r\n\r\n\r\nThe programme is highly suitable for applicants who hold MBA degrees, yet this is not a requirement.\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\nTo Top\r\n \r\n\r\n4. Delivery Method:\r\nWe use live contact sessions (Zoom, MS Teams, etc.)
and Facebook social learning groups for online learning.\r\n \r\nLive sessions\r\n\r\nWe will run 25 live online discussions with tutor.\r\nEach study
group will jointly decide
on the times
and dates for the discussion groups.\r\nThere will be live discussions for the modules as well as sessions for discussing the practical examination.\r\nThere must be 60% attendance for certification.\r\n\r\n \r\nOnline Learning through FaceBook Social learning groups:\r\nWe use the FaceBook Social Learning groups platform since it gives a range of learning options whilst eradicating a registrations process. We control the access
and learners can maximise their learning through advanced
group interaction.\r\n \r\nIn the FB platform, each module will have the following contents:\r\n\r\nMicro learning units.\r\nOpen forum
group discussions with questions
and answers platform.\r\nExplanatory video clips.\r\nExtra reading material.\r\nMultiple choice quiz questions.\r\n\r\n To Top\r\n\r\n5. Assessment
and Certification:\r\nTo complete the Orgtology Certification Programme, a learner must:\r\n\r\nWork through all the learning units.\r\nAchieve 100% for all the learning unit quiz questions.\r\nAttend 60% of the online sessions.\r\nSubmit four practical exam essays & reports according to the
set criteria.\r\n\r\n \r\n\r\n\r\n\r\n\r\n Module: \r\n\r\n\r\nPractical Exam: \r\n\r\n\r\nCriteria:\r\n\r\n\r\n\r\n1. \r\nOrganisational Science & theory.\r\n\r\nStudents must show comprehension of the philosophy
and core hypothesis of orgtology. This will necessitate a good understanding of Hypothesis 2x
and the theories that emanate
from it. Each student will submit an essay which will be published by the International Orgtology Institute.\r\n\r\n\r\n\r\n2.\r\nOrganisational design
and construct.\r\n\r\nStudents must show comprehension of what an organisation is,
and how its basic construct works. Students will be divided into teams
and then linked with a SME or start-up company. They will then use the IOI Quality Standards for \"Organisational Design\" to guide the SME in setting up their companies. Sutend will submit a team exam report, which will give them access to Module 3.\r\n\r\n\r\n\r\n3.\r\nOrganisational strategy.\r\n\r\nStudents must show comprehension of organisational strategy
and how to develop it
from an orgtology perspective. Students who have experience
and training in strategy development often find this part of the OCP as “eye opening”. It is dissimilar to traditional methods since it presents a more scientific approach. As with Module 2, students will be divided into teams
and then linked with a SME or start-up company. They will then use the IOI Quality Standards for \"Strategy Development\" to guide the SME in setting up their companies. Sutend will submit a team exam report, which will give them access to Module 3.\r\n\r\n\r\n\r\n4.\r\nExecutive Leadership.\r\n\r\nStudents must show comprehension of leadership
from an orgtology perspective.
From this perspective, we relate leadership to relevance, whilst we relate management to performance. The approach is thus quite distinct
from traditional leadership teachings. Each student will engage a manager in a coaching assignment
and submit a guided exam report
on completion of the coaching project. Through this Module students will conplete the OCP.\r\n\r\n\r\n\r\n\r\n \r\nOn completion, Orgtelligence Solutions will issue the successful candidate with a certificate of achievement. Students can use this certificate to register as an Orgtologist with the International Orgtology Institute.\r\n To Top\r\n\r\n6. Accreditation:\r\n\r\n\r\n\r\n\r\nThe Orgtologist Certification Programme is a pre-requisite to register as an Orgtologist with the International Orgtology Institute (IOI).\r\nThe IOI fully accredits this course
and recognises the OCP as a post-graduate programme.\r\n\r\n\r\n\r\n\r\nRegistered Orgtologist will receive the following membership benefits:\r\n\r\nLicence to practice as an Orgtologist.\r\nUse of the professional title “Orgtologist”.\r\nFree listing
and regular referrals through the Orgtologist Directory.\r\nAccess to international consulting opportunities.\r\nFree online magazine - “Orgtology Talk”.\r\nAccess to interactive discussion platform
where members can discuss orgtology applications.\r\nFree access to all IOI CPD accredited webinars\r\nReduced fees for IOI approved workshops.\r\nReduced fees for the annual International Orgtology Congress.\r\nEthics Committee advice
and resolution of issues\r\nInternational networking activities & opportunities.\r\n\r\n\r\n \r\n\r\n\r\n\r\n To Top\r\n\r\n7. Cost
and Dates:\r\n\r\n\r\nCost of the full 12-month online program (valid until June 2023):\r\n\r\nSADC students: 19 550 ZAR\r\nInternational students: 2000 USD\r\n\r\n\r\n\r\n\r\nEach intake can register a maximum of 20 students.\r\n\r\n \r\n\r\n\r\n\r\nIntake: \r\nStarting:\r\nEnding:\r\nStatus:\r\n\r\n\r\n OCP 1/2021\r\n 01 March 2021\r\n 15 February 2022\r\nClosed\r\n\r\n\r\n OCP 2/2021\r\n 01 May 2021\r\n 15 April 2022\r\nClosed\r\n\r\n\r\n OCP 3/2021\r\n 01 July 2021\r\n 15 June 2022\r\nClosed\r\n\r\n\r\n OCP 4/2021\r\n 01 November 2021\r\n 15 November 2022\r\nOpen\r\n\r\n\r\n OCP 5/2022\r\n 01 March 2022\r\n 15 March 2023\r\nClosed\r\n\r\n\r\n OCP 6/2022\r\n 15 September 2022\r\n 15 September 2023\r\nOpen\r\n\r\n\r\n\r\n To Top\r\n\r\n8. Contact Us:\r\n{loadposition myposition5}\r\n \r\n\r\n9. Book your seat
on the OCP:\r\nTo enrol for the OCP, please click
on the link below
and complete the enrolment form.\r\nEnrol for the OCP\r\n \r\n \r\n To Top ' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND g.language IN ('en-GB','*')
AND (t.publish_up = '0000-00-00 00:00:00' OR t.publish_up <= '2023-09-25 02:33:12')
AND ((t.publish_down = '0000-00-00 00:00:00' OR t.publish_down >= '2023-09-25 02:33:12'))
AND NOT FIND_IN_SET('com_content.article',g.disable_context)
AND NOT FIND_IN_SET(1984,g.disable_menu)
AND NOT FIND_IN_SET('com_content',g.disable_component)
AND NOT FIND_IN_SET(18,g.disable_category)
ORDER BY t.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 167 | 0.60 | Using where; Using join buffer (Block Nested Loop) |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:398 |
13 | plgContentSeoglossary->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/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.55 ms After last query: 0.37 ms Query memory: 0.027 MB Memory before query: 8.993 MB Rows returned: 1
SELECT *
FROM tisw7_seoglossary
WHERE id = '2';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_seoglossary | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
23 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
22 | SeoglossaryBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
21 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_seoglossary/helpers/seoglossary.php:1306 |
14 | SeoglossaryHelper::getUrlLink() | JROOT/plugins/content/seoglossary/seoglossary.php:419 |
13 | plgContentSeoglossary->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/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.73 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 9.008 MB Rows returned: 1
SELECT id
FROM tisw7_menu
WHERE published = 1
AND (link = 'index.php?option=com_seoglossary&view=glossaries&catid=1' OR link LIKE 'index.php?option=com_seoglossary&view=glossaries&catid=1&%' )
LIMIT 0,1;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_menu | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | 2.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:63 |
22 | SeoglossaryBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
21 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_seoglossary/helpers/seoglossary.php:1306 |
14 | SeoglossaryHelper::getUrlLink() | JROOT/plugins/content/seoglossary/seoglossary.php:419 |
13 | plgContentSeoglossary->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/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.58 ms After last query: 2.81 ms Query memory: 0.028 MB Memory before query: 9.046 MB Rows returned: 1
SELECT *
FROM tisw7_seoglossary
WHERE id = '13';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_seoglossary | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
23 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
22 | SeoglossaryBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
21 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_seoglossary/helpers/seoglossary.php:1306 |
14 | SeoglossaryHelper::getUrlLink() | JROOT/plugins/content/seoglossary/seoglossary.php:419 |
13 | plgContentSeoglossary->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/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 9.062 MB Rows returned: 1
SELECT id
FROM tisw7_menu
WHERE published = 1
AND (link = 'index.php?option=com_seoglossary&view=glossaries&catid=1' OR link LIKE 'index.php?option=com_seoglossary&view=glossaries&catid=1&%' )
LIMIT 0,1;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | tisw7_menu | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | 2.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:63 |
22 | SeoglossaryBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
21 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
20 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
19 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/components/com_seoglossary/helpers/seoglossary.php:1306 |
14 | SeoglossaryHelper::getUrlLink() | JROOT/plugins/content/seoglossary/seoglossary.php:419 |
13 | plgContentSeoglossary->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/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.80 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 9.071 MB Rows returned: 1