Query Time: 0.47 ms Query memory: 0.007 MB Memory before query: 0.990 MB Rows returned: 0
SELECT `data`
FROM `ux026_session`
WHERE `session_id` = X'3435346466633461363632653861323861333461383863396534373561623139'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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.39 ms After last query: 0.28 ms Query memory: 0.004 MB Memory before query: 1.004 MB Rows returned: 0
SELECT `session_id`
FROM `ux026_session`
WHERE `session_id` = X'3435346466633461363632653861323861333461383863396534373561623139'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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.33 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 1.009 MB
INSERT INTO `ux026_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3435346466633461363632653861323861333461383863396534373561623139', 1, 1732199288, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ux026_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3435346466633461363632653861323861333461383863396534373561623139', 1, 1732199288, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init for update | 0.01 ms |
| Update | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Update | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | 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: 0.36 ms After last query: 0.76 ms Query memory: 0.005 MB Memory before query: 1.099 MB Rows returned: 3
SELECT id, rules
FROM `ux026_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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.39 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 1.111 MB Rows returned: 1
SELECT b.id
FROM ux026_usergroups AS a
LEFT JOIN ux026_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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: 0.70 ms After last query: 10.08 ms Query memory: 0.006 MB Memory before query: 2.377 MB Rows returned: 0
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 `ux026_categories` AS `s`
INNER JOIN `ux026_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-CA','*')) 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)
AND c.published = 1
AND s.id = 238
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.07 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 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.35 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 2.382 MB Rows returned: 1
SELECT `alias`,`catid`
FROM `ux026_content`
WHERE `id` = 238
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 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.46 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 2.389 MB
UPDATE `ux026_extensions`
SET `params` = '{\"mediaversion\":\"19fa3416e7299007cfd20aefeb099aa6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `ux026_extensions`
SET `params` = '{\"mediaversion\":\"19fa3416e7299007cfd20aefeb099aa6\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.13 ms |
| Updating | 0.09 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:374 |
| 8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.79 ms After last query: 2.26 ms Query memory: 0.009 MB Memory before query: 2.603 MB Rows returned: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ux026_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_vertexupdate','com_weblinks','com_wrapper','com_zhgooglemap')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 40 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.33 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 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: 0.83 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 2.660 MB Rows returned: 481
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ux026_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 622 | Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.35 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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: 0.68 ms After last query: 0.70 ms Query memory: 0.007 MB Memory before query: 3.113 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `ux026_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ux026_content`
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.09 ms |
| closing tables | 0.01 ms |
| checking permissions | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.05 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | 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: 0.35 ms After last query: 0.47 ms Query memory: 0.005 MB Memory before query: 3.182 MB
UPDATE ux026_content
SET `hits` = (`hits` + 1)
WHERE `id` = '238'
EXPLAIN not possible on query: UPDATE ux026_content
SET `hits` = (`hits` + 1)
WHERE `id` = '238'
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.04 ms |
| Updating | 0.07 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | 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: 0.62 ms After last query: 0.66 ms Query memory: 0.007 MB Memory before query: 3.229 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 ux026_content AS a
INNER JOIN ux026_categories AS c
on c.id = a.catid
LEFT JOIN ux026_users AS u
on u.id = a.created_by
LEFT JOIN ux026_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ux026_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 238
AND c.published > 0
AND a.language in ('en-CA','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 14:28:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 14:28:08')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid,idx_language | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.09 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 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.57 ms After last query: 0.58 ms Query memory: 0.011 MB Memory before query: 3.325 MB Rows returned: 4
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 `ux026_categories` AS `s`
INNER JOIN `ux026_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-CA','*')) 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)
AND c.published = 1
AND s.id = 41
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 65 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.10 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.08 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 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.29 ms After last query: 0.31 ms Query memory: 0.007 MB Memory before query: 3.359 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `ux026_contentitem_tag_map` AS m
INNER JOIN `ux026_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 238
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 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.86 ms After last query: 0.61 ms Query memory: 0.009 MB Memory before query: 3.418 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 ux026_fields AS a
LEFT JOIN `ux026_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ux026_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ux026_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ux026_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ux026_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ux026_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 (41,0,40,23))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-CA')
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_language,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | petitsv_jooMont.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | petitsv_jooMont.a.checked_out | 1 | |
| 1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | petitsv_jooMont.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | petitsv_jooMont.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | petitsv_jooMont.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.11 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.21 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 14 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 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.44 ms After last query: 1.64 ms Query memory: 0.005 MB Memory before query: 3.511 MB Rows returned: 3
SELECT language,id
FROM `ux026_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 154 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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.24 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 3.521 MB Rows returned: 1
SELECT `alias`
FROM `ux026_content`
WHERE id = '238'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 18 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 17 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/languagefilter/languagefilter.php:763 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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.20 ms After last query: 0.05 ms Query memory: 0.008 MB Memory before query: 3.529 MB Rows returned: 1
SELECT alias
FROM ux026_content
WHERE id=238
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 15 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 14 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
| 13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
| 12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/languagefilter/languagefilter.php:763 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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.47 ms After last query: 0.23 ms Query memory: 0.005 MB Memory before query: 3.545 MB Rows returned: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `ux026_content` AS `c`
INNER JOIN `ux026_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `ux026_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `ux026_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `ux026_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 238
AND c2.access IN (1,1)
AND c2.language != 'en-CA'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-11-21 14:28:08')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-11-21 14:28:08')
AND c2.state = 1| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/components/com_content/helpers/association.php:76 |
| 8 | ContentHelperAssociation::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:783 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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.29 ms After last query: 0.85 ms Query memory: 0.006 MB Memory before query: 3.587 MB Rows returned: 1
SELECT *
FROM ux026_template_styles
WHERE template = 'oasis';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_template_styles | ref | idx_template | idx_template | 202 | const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/templates/oasis/vertex/parameters.php:20 |
| 9 | getTemplateName() | JROOT/templates/oasis/vertex/parameters.php:169 |
| 8 | require_once JROOT/templates/oasis/vertex/parameters.php | JROOT/templates/oasis/index.php:33 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.28 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 3.595 MB Rows returned: 0
SELECT *
FROM ux026_menu
WHERE template_style_id IN (13)
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 154 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/templates/oasis/vertex/parameters.php:45 |
| 9 | getTemplateName() | JROOT/templates/oasis/vertex/parameters.php:169 |
| 8 | require_once JROOT/templates/oasis/vertex/parameters.php | JROOT/templates/oasis/index.php:33 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.51 ms After last query: 2.11 ms Query memory: 0.006 MB Memory before query: 3.692 MB Rows returned: 1
SELECT title
FROM ux026_content
WHERE id=238
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 9 | JDatabaseDriver->loadResult() | JROOT/templates/oasis/vertex/module_calcs.php:30 |
| 8 | require_once JROOT/templates/oasis/vertex/module_calcs.php | JROOT/templates/oasis/index.php:35 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.94 ms After last query: 0.35 ms Query memory: 0.008 MB Memory before query: 3.725 MB Rows returned: 17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ux026_modules AS m
LEFT JOIN ux026_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ux026_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 14:28:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 14:28:08')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 379 OR mm.menuid <= 0)
AND m.language IN ('en-CA','*')
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 118 | Using where; Using filesort |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | petitsv_jooMont.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | petitsv_jooMont.m.id | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.62 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.90 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/oasis/vertex/module_calcs.php:41 |
| 8 | require_once JROOT/templates/oasis/vertex/module_calcs.php | JROOT/templates/oasis/index.php:35 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.80 ms After last query: 1.02 ms Query memory: 0.007 MB Memory before query: 3.743 MB Rows returned: 1
SELECT menutype
FROM ux026_menu
WHERE language = 'en-CA'
AND home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_menu | ref | idx_language | idx_language | 28 | const | 12 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.14 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 11 | JDatabaseDriver->loadResult() | JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:284 |
| 10 | include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php | JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:169 |
| 9 | require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php | JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12 |
| 8 | require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php | JROOT/templates/oasis/index.php:276 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.60 ms After last query: 3.55 ms Query memory: 0.006 MB Memory before query: 3.967 MB Rows returned: 1
SELECT menutype
FROM ux026_menu
WHERE language = 'en-CA'
AND home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ux026_menu | ref | idx_language | idx_language | 28 | const | 12 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 9 | JDatabaseDriver->loadResult() | JROOT/templates/oasis/vertex/s5flex_menu/default.php:89 |
| 8 | include JROOT/templates/oasis/vertex/s5flex_menu/default.php | JROOT/templates/oasis/index.php:300 |
| 7 | require JROOT/templates/oasis/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT menutype
FROM ux026_menu
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 `ux026_categories` AS `s`
INNER JOIN `ux026_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-CA','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ux026_assets`
1 × SELECT `alias`
FROM `ux026_content`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ux026_modules AS m
LEFT JOIN ux026_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ux026_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT title
FROM ux026_content
1 × SELECT *
FROM ux026_menu
1 × SELECT *
FROM ux026_template_styles
1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `ux026_content` AS `c`
INNER JOIN `ux026_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `ux026_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `ux026_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `ux026_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT alias
FROM ux026_content
1 × SELECT `data`
FROM `ux026_session`
1 × SELECT language,id
FROM `ux026_menu`
1 × SELECT `session_id`
FROM `ux026_session`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `ux026_contentitem_tag_map` AS m
INNER JOIN `ux026_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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 ux026_content AS a
INNER JOIN ux026_categories AS c
on c.id = a.catid
LEFT JOIN ux026_users AS u
on u.id = a.created_by
LEFT JOIN ux026_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ux026_content_rating AS v
ON a.id = v.content_id
1 × SELECT `alias`,`catid`
FROM `ux026_content`
1 × SELECT b.id
FROM ux026_usergroups AS a
LEFT JOIN ux026_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `ux026_viewlevels
1 × 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 ux026_fields AS a
LEFT JOIN `ux026_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ux026_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ux026_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ux026_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ux026_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ux026_fields_categories` AS fc
ON fc.field_id = a.id
Heather Niderost was born in Montreal, Canada, received her B.A. from McGill University, Dip. Ed from Aberdeen University (Scotland), and later her M.A. in Religious Studies from McGill. As a long-time member of the Baha’i Faith, her life has been devoted to the spiritual education of children, youth and adults. Her three books, ‘The Light World’, ‘A Pilgrim’s Song’, and finally ‘The Quest of the Light Knights’ illustrate this personal quest. Sharing her profound belief in the Baha’i view of humanity’s noble future has been her constant source of inspiration.