- You are here:
- Home /
- Contact us
Get In Touch
BizDev360 Revenue Generation Leadership Forum
- 1-888-549-4877 (GTSS)
- [email protected]
BizDev360 Powered by:
Welcome to BizDev360.org Revenue Generation Leadership Forum.
We use cookies to improve your experience on our website. These cookies provide a better performance, enhance features and enable certain functionality.
By continuing to use our website you are agreeing to our use of cookies.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1732172881,
"last": 1732172881,
"now": 1732172881
},
"token": "Y0kTPwSPI0TdVg5RJMmTcnTkQfgt7jKK"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 268.80 ms / 268.80 ms Memory: 0.712 MB / 1.08 MB Application: afterLoad
Time: 1591.90 ms / 1860.70 ms Memory: 1.882 MB / 2.96 MB Application: afterInitialise
Time: 197.12 ms / 2057.82 ms Memory: 0.222 MB / 3.18 MB Application: afterRoute
Time: 154.03 ms / 2211.85 ms Memory: 0.046 MB / 3.23 MB Application: beforeRenderComponent com_content
Time: 84.69 ms / 2296.54 ms Memory: 0.115 MB / 3.35 MB Application: Before Access::preloadComponents (all components)
Time: 76.88 ms / 2373.42 ms Memory: 0.066 MB / 3.41 MB Application: After Access::preloadComponents (all components)
Time: 0.07 ms / 2373.49 ms Memory: 0.000 MB / 3.41 MB Application: Before Access::preloadPermissions (com_content)
Time: 11.56 ms / 2385.05 ms Memory: 0.258 MB / 3.67 MB Application: After Access::preloadPermissions (com_content)
Time: 0.08 ms / 2385.13 ms Memory: 0.000 MB / 3.65 MB Application: Before Access::getAssetRules (id:552 name:com_content.article.231)
Time: 11.88 ms / 2397.01 ms Memory: 0.010 MB / 3.66 MB Application: After Access::getAssetRules (id:552 name:com_content.article.231)
Time: 1059.10 ms / 3456.11 ms Memory: 0.592 MB / 4.26 MB Application: afterRenderComponent com_content
Time: 85.26 ms / 3541.37 ms Memory: 0.018 MB / 4.28 MB Application: afterDispatch
Time: 1191.30 ms / 4732.67 ms Memory: 2.014 MB / 6.29 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 128.38 ms / 4861.05 ms Memory: 0.011 MB / 6.30 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 7.57 ms / 4868.62 ms Memory: 0.017 MB / 6.32 MB Application: beforeRenderModule mod_custom (Contact image)
Time: 39.78 ms / 4908.40 ms Memory: 0.006 MB / 6.32 MB Application: afterRenderModule mod_custom (Contact image)
Time: 51.98 ms / 4960.37 ms Memory: 0.025 MB / 6.35 MB Application: beforeRenderModule mod_wrapper (CONTACT)
Time: 10.79 ms / 4971.16 ms Memory: 0.012 MB / 6.36 MB Application: afterRenderModule mod_wrapper (CONTACT)
Time: 105.73 ms / 5076.89 ms Memory: 0.000 MB / 5.51 MB Application: afterRender
Database queries total: 1321.17 ms
6.02 MB (6,314,312 Bytes)
21 Queries Logged 1321.17 ms
- Query Time: 130.16 ms Query memory: 0.007 MB Memory before query: 1.535 MB Rows returned: 0
SELECT `data`
FROM `pqcl3_session`
WHERE `session_id` = X'3736373930336461316539326338393563646465333661633732646666363461'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.32 ms checking permissions 0.03 ms Opening tables 103.80 ms After opening tables 0.10 ms System lock 0.08 ms table lock 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.07 ms Unlocking tables 0.01 ms closing tables 0.03 ms init 0.08 ms Optimizing 0.02 ms Statistics 19.49 ms Preparing 0.09 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.11 ms Updating status 0.03 ms Reset for next command 0.01 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 13.07 ms After last query: 49.83 ms Query memory: 0.004 MB Memory before query: 1.614 MB Rows returned: 0
SELECT `session_id`
FROM `pqcl3_session`
WHERE `session_id` = X'3736373930336461316539326338393563646465333661633732646666363461'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.23 ms checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.09 ms Updating status 0.03 ms Reset for next command 0.01 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 104.81 ms After last query: 0.32 ms Query memory: 0.004 MB Memory before query: 1.619 MB
INSERT INTO `pqcl3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3736373930336461316539326338393563646465333661633732646666363461', 1, 1732172881, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `pqcl3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3736373930336461316539326338393563646465333661633732646666363461', 1, 1732172881, 0, '', 0)Status Duration Starting 0.26 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.03 ms init for update 0.03 ms Update 44.94 ms Waiting for query cache lock 0.09 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.04 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.12 ms Updating status 56.79 ms Reset for next command 0.08 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 64.32 ms After last query: 234.19 ms Query memory: 0.005 MB Memory before query: 1.767 MB Rows returned: 3
SELECT id, rules
FROM `pqcl3_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Status Duration Starting 0.21 ms checking permissions 0.03 ms Opening tables 46.47 ms After opening tables 0.10 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.08 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.03 ms Starting cleanup 0.01 ms Freeing items 0.13 ms Updating status 0.05 ms Reset for next command 0.02 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 37.47 ms After last query: 0.30 ms Query memory: 0.005 MB Memory before query: 1.778 MB Rows returned: 1
SELECT b.id
FROM pqcl3_usergroups AS a
LEFT JOIN pqcl3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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; Using index Status Duration Starting 0.21 ms checking permissions 0.04 ms Opening tables 4.34 ms After opening tables 0.08 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.06 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 29.66 ms Preparing 0.10 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.04 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.13 ms Updating status 0.03 ms Reset for next command 0.01 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 127.67 ms After last query: 752.50 ms Query memory: 0.005 MB Memory before query: 3.187 MB
UPDATE `pqcl3_extensions`
SET `params` = '{\"mediaversion\":\"9d04e134e34374a4ddf40a483e4ecaba\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `pqcl3_extensions` SET `params` = '{\"mediaversion\":\"9d04e134e34374a4ddf40a483e4ecaba\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.24 ms checking permissions 0.04 ms Opening tables 54.01 ms After opening tables 0.10 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.09 ms Unlocking tables 0.02 ms closing tables 0.02 ms init for update 14.54 ms Updating 22.17 ms End of update loop 0.08 ms Waiting for query cache lock 0.01 ms End of update loop 0.02 ms Query end 0.01 ms Commit 26.17 ms Query end 2.46 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.13 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 76.17 ms After last query: 109.14 ms Query memory: 0.009 MB Memory before query: 3.350 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pqcl3_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_foxcontact','com_installer','com_jce','com_joomlaupdate','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_rsform','com_rstester','com_search','com_tags','com_templates','com_users','com_vertexupdate','com_visforms','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_assets range idx_asset_name idx_asset_name 202 NULL 42 Using index condition Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 54.81 ms After opening tables 0.07 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.06 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.12 ms Optimizing 0.03 ms Statistics 0.20 ms Preparing 0.06 ms Executing 0.01 ms Sending data 15.29 ms End of update loop 0.08 ms Query end 0.02 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.16 ms Updating status 0.04 ms Reset for next command 0.02 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:440 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:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 10.61 ms After last query: 0.54 ms Query memory: 0.009 MB Memory before query: 3.408 MB Rows returned: 248
SELECT `id`,`name`,`rules`,`parent_id`
FROM `pqcl3_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 584 Using where Status Duration Starting 0.28 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.22 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.79 ms End of update loop 0.05 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.13 ms Updating status 0.04 ms Reset for next command 0.02 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:440 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:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 39.07 ms After last query: 48.37 ms Query memory: 0.008 MB Memory before query: 3.669 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `pqcl3_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `pqcl3_content`Status Duration Starting 0.22 ms checking permissions 0.03 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.43 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 23.02 ms After opening tables 0.08 ms checking permissions 0.19 ms closing tables 0.02 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.19 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.03 ms Reset for next command 0.04 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:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 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:312 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:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 20.30 ms After last query: 88.35 ms Query memory: 0.006 MB Memory before query: 3.796 MB Rows returned: 1
SELECT *
FROM pqcl3_content
WHERE `id` = '231'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.28 ms checking permissions 0.04 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.10 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.08 ms Optimizing 0.03 ms Statistics 4.99 ms Preparing 0.09 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.14 ms Updating status 0.05 ms Reset for next command 0.03 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() 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:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 72.00 ms After last query: 0.36 ms Query memory: 0.005 MB Memory before query: 3.803 MB
UPDATE pqcl3_content
SET `hits` = (`hits` + 1)
WHERE `id` = '231'EXPLAIN not possible on query: UPDATE pqcl3_content SET `hits` = (`hits` + 1) WHERE `id` = '231'Status Duration Starting 5.57 ms checking permissions 0.10 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.06 ms table lock 0.02 ms init for update 0.14 ms Updating 0.22 ms End of update loop 0.03 ms Waiting for query cache lock 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 36.82 ms Query end 0.09 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:255 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 102.79 ms After last query: 45.16 ms Query memory: 0.007 MB Memory before query: 3.850 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 pqcl3_content AS a
INNER JOIN pqcl3_categories AS c
on c.id = a.catid
LEFT JOIN pqcl3_users AS u
on u.id = a.created_by
LEFT JOIN pqcl3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN pqcl3_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 231
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 07:08:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 07:08:03')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 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 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.39 ms checking permissions 0.04 ms Opening tables 84.58 ms After opening tables 0.08 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.15 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.25 ms Preparing 0.03 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.10 ms Updating status 0.03 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:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 73.81 ms After last query: 26.26 ms Query memory: 0.007 MB Memory before query: 3.961 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `pqcl3_contentitem_tag_map` AS m
INNER JOIN `pqcl3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 231
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 m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gtssgyxs_bizdev.m.tag_id 1 Using where Status Duration Starting 0.28 ms checking permissions 0.03 ms Opening tables 50.66 ms After opening tables 0.12 ms System lock 0.02 ms table lock 0.03 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.12 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.11 ms Optimizing 0.06 ms Statistics 5.82 ms Preparing 0.12 ms Executing 0.02 ms Sending data 0.15 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.15 ms Updating status 0.04 ms Reset for next command 0.02 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:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 29.73 ms After last query: 109.92 ms Query memory: 0.010 MB Memory before query: 4.083 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 `pqcl3_categories` AS `s`
INNER JOIN `pqcl3_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) 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 = 8
ORDER BY c.lftid 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 range|filter cat_idx,idx_access,idx_left_right,idx_language idx_left_right|cat_idx 4|207 NULL 9 (44%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.28 ms checking permissions 0.04 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.14 ms Optimizing 0.07 ms Statistics 26.36 ms Preparing 0.09 ms Unlocking tables 0.02 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.14 ms Updating status 5.38 ms Reset for next command 0.11 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 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:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 142.55 ms After last query: 3.09 ms Query memory: 0.009 MB Memory before query: 4.106 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 pqcl3_fields AS a
LEFT JOIN `pqcl3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pqcl3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pqcl3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pqcl3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pqcl3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pqcl3_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 (8,0))
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)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 gtssgyxs_bizdev.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 gtssgyxs_bizdev.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gtssgyxs_bizdev.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 gtssgyxs_bizdev.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 gtssgyxs_bizdev.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.30 ms checking permissions 0.04 ms Opening tables 66.50 ms After opening tables 0.10 ms System lock 0.03 ms table lock 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.17 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.13 ms Optimizing 0.26 ms Statistics 69.03 ms Preparing 0.19 ms Creating tmp table 0.18 ms Sorting result 0.08 ms Executing 0.02 ms Sending data 0.82 ms Creating sort index 0.12 ms Removing tmp table 0.12 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.07 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.03 ms Starting cleanup 0.01 ms Freeing items 0.12 ms Updating status 0.04 ms Reset for next command 0.01 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:308 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:187 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:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 12.44 ms After last query: 375.98 ms Query memory: 0.006 MB Memory before query: 4.306 MB Rows returned: 1
SELECT *
FROM pqcl3_template_styles
WHERE template = 'risen_hope';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_template_styles ref idx_template idx_template 202 const 1 Using index condition Status Duration Starting 0.26 ms checking permissions 0.04 ms Opening tables 1.59 ms After opening tables 0.06 ms System lock 0.01 ms table lock 0.03 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.06 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.06 ms Optimizing 0.03 ms Statistics 1.44 ms Preparing 0.09 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.12 ms Updating status 0.04 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/templates/risen_hope/vertex/parameters.php:20 9 getTemplateName() JROOT/templates/risen_hope/vertex/parameters.php:169 8 require_once JROOT/templates/risen_hope/vertex/parameters.php JROOT/templates/risen_hope/index.php:21 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 58.59 ms After last query: 0.30 ms Query memory: 0.006 MB Memory before query: 4.315 MB Rows returned: 0
SELECT *
FROM pqcl3_menu
WHERE template_style_id IN (19)
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 243 Using where Status Duration Starting 0.20 ms checking permissions 0.04 ms Opening tables 30.98 ms After opening tables 0.08 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.81 ms Unlocking tables 0.02 ms closing tables 0.03 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 21.57 ms End of update loop 0.07 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.06 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.10 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/templates/risen_hope/vertex/parameters.php:45 9 getTemplateName() JROOT/templates/risen_hope/vertex/parameters.php:169 8 require_once JROOT/templates/risen_hope/vertex/parameters.php JROOT/templates/risen_hope/index.php:21 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.97 ms After last query: 49.21 ms Query memory: 0.006 MB Memory before query: 4.420 MB Rows returned: 1
SELECT title
FROM pqcl3_content
WHERE id=231id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.25 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/templates/risen_hope/vertex/module_calcs.php:30 8 require_once JROOT/templates/risen_hope/vertex/module_calcs.php JROOT/templates/risen_hope/index.php:23 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 167.97 ms After last query: 49.42 ms Query memory: 0.008 MB Memory before query: 4.453 MB Rows returned: 24
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pqcl3_modules AS m
LEFT JOIN pqcl3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pqcl3_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 07:08:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 07:08:03')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 384 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid 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 294 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 gtssgyxs_bizdev.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 gtssgyxs_bizdev.m.id 1 Using where; Using index Status Duration Starting 0.32 ms checking permissions 0.04 ms Opening tables 72.71 ms After opening tables 0.09 ms System lock 0.02 ms table lock 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.08 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.11 ms Optimizing 0.07 ms Statistics 32.50 ms Preparing 0.14 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 51.40 ms End of update loop 0.11 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.14 ms Updating status 0.03 ms Reset for next command 0.02 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:432 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 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:591 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/risen_hope/vertex/module_calcs.php:41 8 require_once JROOT/templates/risen_hope/vertex/module_calcs.php JROOT/templates/risen_hope/index.php:23 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 22.04 ms After last query: 293.20 ms Query memory: 0.007 MB Memory before query: 4.835 MB Rows returned: 0Duplicate queries: #21
SELECT menutype
FROM pqcl3_menu
WHERE language = 'en-GB'
AND home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_menu ref idx_language idx_language 28 const 1 Using index condition; Using where Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 16.34 ms Preparing 0.16 ms Executing 1.47 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.14 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/templates/risen_hope/vertex/responsive/responsive_mobile_menu.php:284 10 include JROOT/templates/risen_hope/vertex/responsive/responsive_mobile_menu.php JROOT/templates/risen_hope/vertex/responsive/responsive_mobile_top_bar.php:169 9 require JROOT/templates/risen_hope/vertex/responsive/responsive_mobile_top_bar.php JROOT/templates/risen_hope/vertex/includes/vertex_includes_top.php:12 8 require_once JROOT/templates/risen_hope/vertex/includes/vertex_includes_top.php JROOT/templates/risen_hope/index.php:174 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 10.63 ms After last query: 118.56 ms Query memory: 0.006 MB Memory before query: 4.892 MB Rows returned: 0Duplicate queries: #20
SELECT menutype
FROM pqcl3_menu
WHERE language = 'en-GB'
AND home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pqcl3_menu ref idx_language idx_language 28 const 1 Using index condition; Using where Status Duration Starting 0.29 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/templates/risen_hope/vertex/s5flex_menu/default.php:89 8 include JROOT/templates/risen_hope/vertex/s5flex_menu/default.php JROOT/templates/risen_hope/index.php:204 7 require JROOT/templates/risen_hope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT menutype
FROM pqcl3_menu2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `pqcl3_assets`1 × SELECT `data`
FROM `pqcl3_session`1 × SELECT `session_id`
FROM `pqcl3_session`1 × SELECT id, rules
FROM `pqcl3_viewlevels1 × SELECT b.id
FROM pqcl3_usergroups AS a
LEFT JOIN pqcl3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM pqcl3_content1 × 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 pqcl3_content AS a
INNER JOIN pqcl3_categories AS c
on c.id = a.catid
LEFT JOIN pqcl3_users AS u
on u.id = a.created_by
LEFT JOIN pqcl3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN pqcl3_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `pqcl3_contentitem_tag_map` AS m
INNER JOIN `pqcl3_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × 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 `pqcl3_categories` AS `s`
INNER JOIN `pqcl3_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)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 pqcl3_fields AS a
LEFT JOIN `pqcl3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN pqcl3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN pqcl3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN pqcl3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN pqcl3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `pqcl3_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM pqcl3_template_styles1 × SELECT *
FROM pqcl3_menu1 × SELECT title
FROM pqcl3_content1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pqcl3_modules AS m
LEFT JOIN pqcl3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pqcl3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
OTHER Tables:
1 × INSERT INTO `pqcl3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3736373930336461316539326338393563646465333661633732646666363461', 1, 1732172881, 0, '', 01 × UPDATE `pqcl3_extensions`
SET `params` = '{\"mediaversion\":\"9d04e134e34374a4ddf40a483e4ecaba\"}'1 × SHOW FULL COLUMNS
FROM `pqcl3_content1 × UPDATE pqcl3_content
SET `hits` = (`hits` + 1)