Main Menu
Media
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1774220755,
"last": 1774220755,
"now": 1774220755
},
"client": {
"forwarded": "216.73.216.112"
},
"token": "hcMGqqhSwfjJnTiP5COyEbgQZHwoa0Mi"
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9pbmZvLmlnYWRwb3J0YWwub3JnL21lZGlhcy85MC1tZWRpYT8%3D"
},
"current_theme": null,
"current_direction": "ltr",
"current_key_sufix": "__ltr"
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"com_mailto": {
"links": {
"c1e4dd4a4080e2e05df0b6e26f4a6da6c3d953cd": {
"link": "https:\/\/info.igadportal.org\/medias",
"expiry": 1774220755
}
}
}
}
}
Time
Memory
Time: 14.47 ms / 14.47 ms Memory: 0.494 MB / 0.87 MB Application: afterLoad
Time: 141.00 ms / 155.47 ms Memory: 1.664 MB / 2.53 MB Application: afterInitialise
Time: 25.81 ms / 181.28 ms Memory: 0.365 MB / 2.89 MB Application: afterRoute
Time: 17.89 ms / 199.17 ms Memory: 0.075 MB / 2.97 MB Application: beforeRenderComponent com_content
Time: 4.31 ms / 203.48 ms Memory: 0.234 MB / 3.20 MB Application: Before Access::preloadComponents (all components)
Time: 4.65 ms / 208.13 ms Memory: 0.059 MB / 3.26 MB Application: After Access::preloadComponents (all components)
Time: 0.12 ms / 208.25 ms Memory: 0.000 MB / 3.26 MB Application: Before Access::preloadPermissions (com_content)
Time: 4.40 ms / 212.65 ms Memory: 0.167 MB / 3.43 MB Application: After Access::preloadPermissions (com_content)
Time: 0.07 ms / 212.72 ms Memory: 0.000 MB / 3.42 MB Application: Before Access::getAssetRules (id:1132 name:com_content.category.90)
Time: 0.46 ms / 213.17 ms Memory: 0.011 MB / 3.43 MB Application: After Access::getAssetRules (id:1132 name:com_content.category.90)
Time: 4.07 ms / 217.25 ms Memory: 0.034 MB / 3.46 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.14 ms / 217.38 ms Memory: 0.002 MB / 3.46 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 32.38 ms / 249.77 ms Memory: 0.334 MB / 3.80 MB Application: Before Access::getAssetRules (id:1133 name:com_content.article.129)
Time: 0.04 ms / 249.81 ms Memory: 0.002 MB / 3.80 MB Application: After Access::getAssetRules (id:1133 name:com_content.article.129)
Time: 0.72 ms / 250.53 ms Memory: 0.018 MB / 3.82 MB Application: Before Access::getAssetRules (id:1117 name:com_attachments)
Time: 0.06 ms / 250.58 ms Memory: 0.009 MB / 3.83 MB Application: After Access::getAssetRules (id:1117 name:com_attachments)
Time: 0.03 ms / 250.61 ms Memory: 0.001 MB / 3.83 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.01 ms / 250.62 ms Memory: 0.003 MB / 3.83 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 12.10 ms / 262.72 ms Memory: 0.106 MB / 3.93 MB Application: afterRenderComponent com_content
Time: 2.91 ms / 265.63 ms Memory: 0.120 MB / 4.06 MB Application: afterDispatch
Time: 19.10 ms / 284.73 ms Memory: 0.462 MB / 4.52 MB Application: beforeRenderModule mod_footer (Footer)
Time: 2.10 ms / 286.84 ms Memory: 0.008 MB / 4.52 MB Application: afterRenderModule mod_footer (Footer)
Time: 0.09 ms / 286.93 ms Memory: 0.000 MB / 4.52 MB Application: beforeRenderModule mod_custom (Newsletter Signup)
Time: 0.84 ms / 287.77 ms Memory: 0.005 MB / 4.53 MB Application: afterRenderModule mod_custom (Newsletter Signup)
Time: 0.06 ms / 287.83 ms Memory: 0.000 MB / 4.53 MB Application: beforeRenderModule mod_custom (Social Channels)
Time: 0.12 ms / 287.95 ms Memory: 0.003 MB / 4.53 MB Application: afterRenderModule mod_custom (Social Channels)
Time: 0.04 ms / 287.99 ms Memory: 0.000 MB / 4.53 MB Application: beforeRenderModule mod_custom (Contact Info)
Time: 0.07 ms / 288.06 ms Memory: 0.003 MB / 4.53 MB Application: afterRenderModule mod_custom (Contact Info)
Time: 0.03 ms / 288.09 ms Memory: 0.000 MB / 4.53 MB Application: beforeRenderModule mod_custom (About Igad Info)
Time: 0.07 ms / 288.16 ms Memory: 0.003 MB / 4.53 MB Application: afterRenderModule mod_custom (About Igad Info)
Time: 0.18 ms / 288.34 ms Memory: 0.000 MB / 4.53 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.30 ms / 289.64 ms Memory: 0.012 MB / 4.55 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.10 ms / 289.74 ms Memory: 0.001 MB / 4.55 MB Application: beforeRenderModule mod_articles_category (Latest Publications)
Time: 8.58 ms / 298.33 ms Memory: 0.142 MB / 4.69 MB Application: afterRenderModule mod_articles_category (Latest Publications)
Time: 0.13 ms / 298.46 ms Memory: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_menu (User menu)
Time: 1.52 ms / 299.98 ms Memory: 0.019 MB / 4.62 MB Application: afterRenderModule mod_menu (User menu)
Time: 7.01 ms / 306.99 ms Memory: 0.150 MB / 4.77 MB Application: afterRender
Database queries total: 127.12 ms
5.25 MB (5,500,832 Bytes)
31 Queries Logged 127.12 ms
- Query Time: 20.77 ms Query memory: 0.023 MB Memory before query: 1.162 MB Rows returned: 0
SELECT `data`
FROM `b4xfb_session`
WHERE `session_id` = 'krgjelkb86be1u1o0m8c2me3ji'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 0.22 ms checking permissions 0.03 ms Opening tables 0.18 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.12 ms Optimizing 0.02 ms Statistics 19.26 ms Preparing 0.04 ms Executing 0.03 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.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 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:755 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 3.45 ms After last query: 1.01 ms Query memory: 0.020 MB Memory before query: 1.178 MB Rows returned: 0Duplicate queries: #30
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'krgjelkb86be1u1o0m8c2me3ji'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 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.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.02 ms Commit 0.01 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.00 ms Updating status 1.40 ms Reset for next command 0.02 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 24.00 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 1.184 MB
INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('krgjelkb86be1u1o0m8c2me3ji', 1, '1774220755', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('krgjelkb86be1u1o0m8c2me3ji', 1, '1774220755', 0, '', 0)Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.00 ms init for update 0.02 ms Update 0.20 ms End of update loop 0.00 ms Query end 0.00 ms Commit 23.18 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.13 ms Reset for next command 0.01 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:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.57 ms After last query: 1.24 ms Query memory: 0.024 MB Memory before query: 1.281 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref extension extension 82 const 40 Using index condition Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.06 ms System lock 0.20 ms table lock 0.02 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.13 ms Executing 0.00 ms Sending data 0.39 ms End of update loop 0.01 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.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:423 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:431 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:497 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:596 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 1.312 MB Rows returned: 4
SELECT id, rules
FROM `b4xfb_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.44 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 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.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 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:1496 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:310 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.323 MB Rows returned: 1
SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_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.09 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.01 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 Commit 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.03 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.31 ms After last query: 0.28 ms Query memory: 0.030 MB Memory before query: 1.345 MB Rows returned: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM b4xfb_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 239 Using where; Using filesort 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.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.66 ms End of update loop 0.01 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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 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:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:348 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.74 ms After last query: 10.55 ms Query memory: 0.020 MB Memory before query: 1.695 MB Rows returned: 1
SELECT `enabled`
FROM `b4xfb_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 1.02 ms checking permissions 0.01 ms Opening tables 1.04 ms After opening tables 0.10 ms System lock 0.01 ms table lock 0.01 ms init 0.34 ms Optimizing 0.03 ms Statistics 0.15 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.03 ms Query end 0.01 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.01 ms Updating status 1.13 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:79 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.48 ms After last query: 33.35 ms Query memory: 0.005 MB Memory before query: 2.387 MB
UPDATE b4xfb_extensions
SET enabled=1
WHERE `type`='plugin'
AND `element`='jacontenttype'
AND `folder`='ajax'EXPLAIN not possible on query: UPDATE b4xfb_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'Status Duration Starting 0.11 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 for update 0.17 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/jacontenttype/jacontenttype.php:61 8 PlgSystemJacontenttype->_check() JROOT/plugins/system/jacontenttype/jacontenttype.php:43 7 PlgSystemJacontenttype->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.40 ms After last query: 17.63 ms Query memory: 0.048 MB Memory before query: 2.561 MB Rows returned: 20
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b4xfb_menu AS m
LEFT JOIN b4xfb_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 21 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 info.m.component_id 1 Using where Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.14 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.75 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 1.75 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:374 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:488 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1070 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.28 ms After last query: 7.15 ms Query memory: 0.023 MB Memory before query: 2.787 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 `b4xfb_categories` AS `s`
INNER JOIN `b4xfb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1)
AND c.published = 1
AND s.id = 90
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 cat_idx,idx_access,idx_left_right cat_idx 208 NULL 7 Using index condition; Using where; Using filesort Status Duration Starting 0.21 ms checking permissions 0.01 ms Opening tables 0.31 ms After opening tables 0.10 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Statistics 0.41 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.61 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.47 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:312 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:437 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:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.95 ms After last query: 1.05 ms Query memory: 0.022 MB Memory before query: 2.807 MB Rows returned: 9
SELECT id, home, template, s.params
FROM b4xfb_template_styles as s
LEFT JOIN b4xfb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 9 Using index condition; Using where 1 SIMPLE s ref idx_template idx_template 202 info.e.element 1 Using index condition; Using where Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.56 ms Preparing 0.06 ms Executing 0.00 ms Sending data 0.17 ms End of update loop 0.01 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.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:320 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->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:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.57 ms After last query: 5.70 ms Query memory: 0.022 MB Memory before query: 2.914 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.05 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.20 ms Statistics 1.10 ms Preparing 0.15 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 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:1113 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 9.10 ms After last query: 1.01 ms Query memory: 0.005 MB Memory before query: 2.904 MB
UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"2b7eb35179a54c9ee40ec7168d36df62\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"2b7eb35179a54c9ee40ec7168d36df62\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.24 ms Updating 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 7.83 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.42 ms Reset for next command 0.01 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:1113 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.80 ms After last query: 1.73 ms Query memory: 0.019 MB Memory before query: 2.937 MB Rows returned: 1
SELECT *
FROM b4xfb_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.01 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.16 ms After last query: 5.66 ms Query memory: 0.028 MB Memory before query: 3.208 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `b4xfb_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_booklibrary','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_fields','com_finder','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_populate','com_postinstall','com_projectlog','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_assets range idx_asset_name idx_asset_name 202 NULL 41 Using index condition Status Duration Starting 0.21 ms checking permissions 0.01 ms Opening tables 0.76 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.02 ms Statistics 0.54 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.54 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.98 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.40 ms After last query: 0.80 ms Query memory: 0.040 MB Memory before query: 3.262 MB Rows returned: 158
SELECT `id`,`name`,`rules`,`parent_id`
FROM `b4xfb_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 b4xfb_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 289 Using where Status Duration Starting 0.19 ms checking permissions 0.04 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.43 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.25 ms Reset for next command 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.32 ms After last query: 1.56 ms Query memory: 0.025 MB Memory before query: 3.429 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `b4xfb_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `b4xfb_categories` AS `s`
INNER JOIN `b4xfb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 90
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c range cat_idx,idx_left_right cat_idx 203 NULL 7 Using index condition; Using where; Using filesort 2 DEPENDENT SUBQUERY i ref|filter idx_state,idx_catid idx_catid|idx_state 4|1 info.c.id 2 (25%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.23 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.16 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Optimizing 0.01 ms Statistics 0.12 ms Preparing 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.09 ms Creating sort index 0.15 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.19 ms Unlocking tables 0.01 ms closing tables 0.13 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:312 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.81 ms After last query: 1.90 ms Query memory: 0.025 MB Memory before query: 3.462 MB Rows returned: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM b4xfb_content AS a
LEFT JOIN b4xfb_categories AS c
ON c.id = a.catid
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_by
LEFT JOIN b4xfb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b4xfb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b4xfb_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1)
AND c.access IN (1)
AND c.published = 1
AND a.state = 1
AND a.catid = 90
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-22 23:05:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-22 23:05:55')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.createdid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 1 Using where; Using filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 info.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 info.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 info.a.id 1 Using where Status Duration Starting 0.34 ms checking permissions 0.01 ms Opening tables 0.57 ms After opening tables 0.04 ms System lock 0.01 ms table lock 0.02 ms init 0.37 ms Optimizing 0.06 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.35 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.07 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.62 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:559 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.92 ms After last query: 1.09 ms Query memory: 0.024 MB Memory before query: 3.496 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b4xfb_contentitem_tag_map` AS m
INNER JOIN `b4xfb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 129
AND `t`.`published` = 1
AND t.access IN (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 info.m.tag_id 1 Using where Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.49 ms After opening tables 0.17 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.02 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:689 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.56 ms After last query: 1.86 ms Query memory: 0.024 MB Memory before query: 3.575 MB Rows returned: 1
SELECT COUNT(*)
FROM b4xfb_content AS a
LEFT JOIN b4xfb_categories AS c
ON c.id = a.catid
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_by
LEFT JOIN b4xfb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b4xfb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b4xfb_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1)
AND c.access IN (1)
AND c.published = 1
AND a.state = 1
AND a.catid = 90
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-22 23:05:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-22 23:05:55')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_catid 4 const 1 Using where Status Duration Starting 0.30 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.06 ms Statistics 0.28 ms Preparing 0.08 ms Unlocking tables 0.01 ms Preparing 0.06 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.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.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.56 ms After last query: 0.93 ms Query memory: 0.022 MB Memory before query: 3.578 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b4xfb_contentitem_tag_map` AS m
INNER JOIN `b4xfb_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 90
AND `t`.`published` = 1
AND t.access IN (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 info.m.tag_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.04 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.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.56 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.39 ms After last query: 3.83 ms Query memory: 0.025 MB Memory before query: 3.622 MB Rows returned: 0
SELECT 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
FROM b4xfb_fields AS a
LEFT JOIN `b4xfb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b4xfb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b4xfb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b4xfb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `b4xfb_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 (90,0))
AND a.access IN (1)
AND (a.group_id = 0 OR g.access IN (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 filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 info.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 info.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 info.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 info.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 info.a.id 1 Using where; Using index Status Duration Starting 0.38 ms checking permissions 0.02 ms Opening tables 0.45 ms After opening tables 0.17 ms System lock 0.02 ms table lock 0.02 ms init 0.18 ms Optimizing 0.09 ms Statistics 0.28 ms Preparing 0.09 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 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.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:479 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:108 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.73 ms After last query: 7.05 ms Query memory: 0.023 MB Memory before query: 3.781 MB Rows returned: 0
SELECT id
FROM b4xfb_categories
WHERE id = 129
LIMIT 1id 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.11 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.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Executing 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.01 ms Updating status 0.05 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 13 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:108 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.88 ms After last query: 0.78 ms Query memory: 0.023 MB Memory before query: 3.789 MB Rows returned: 1
SELECT created_by, catid
FROM b4xfb_content
WHERE id = 129id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.02 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 1.46 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:319 13 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:116 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.00 ms After last query: 1.87 ms Query memory: 0.025 MB Memory before query: 3.828 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM b4xfb_attachments AS a
LEFT JOIN b4xfb_users AS u
ON u.id = a.created_by
WHERE a.parent_id=129
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 info.a.created_by 1 Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.19 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:325 13 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:116 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 8.25 ms After last query: 20.68 ms Query memory: 0.028 MB Memory before query: 4.511 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM b4xfb_modules AS m
LEFT JOIN b4xfb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN b4xfb_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 <= '2026-03-22 23:05:55')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-22 23:05:55')
AND m.access IN (1)
AND m.client_id = 0
AND (mm.menuid = 1049 OR mm.menuid <= 0)
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 NO INDEX KEY COULD BE USED NULL NULL 61 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 info.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 info.m.id 2 Using where; Using index Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 4.96 ms After opening tables 0.06 ms System lock 0.01 ms table lock 0.02 ms init 0.08 ms Optimizing 0.08 ms Statistics 0.22 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 1.89 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.23 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:645 12 T3Template->countModules() JROOT/templates/ja_charity/tpls/blocks/topbar.php:24 11 include JROOT/templates/ja_charity/tpls/blocks/topbar.php JROOT/plugins/system/t3/includes/core/template.php:195 10 T3Template->loadBlock() JROOT/templates/ja_charity/tpls/default.php:33 9 include JROOT/templates/ja_charity/tpls/default.php JROOT/plugins/system/t3/includes/core/template.php:221 8 T3Template->loadLayout() JROOT/templates/ja_charity/index.php:33 7 require JROOT/templates/ja_charity/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.77 ms After last query: 9.17 ms Query memory: 0.044 MB Memory before query: 4.614 MB Rows returned: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM b4xfb_content AS a
LEFT JOIN b4xfb_categories AS c
ON c.id = a.catid
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_by
LEFT JOIN b4xfb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b4xfb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b4xfb_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1)
AND c.access IN (1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (87)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-22 23:05:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-22 23:05:55')
ORDER BY a.title ASC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 1 Using intersect(idx_catid,idx_state); Using where; Using filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 info.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 info.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 info.a.id 1 Using where Status Duration Starting 0.28 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.04 ms init 0.11 ms Optimizing 0.06 ms Statistics 0.27 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.10 ms Creating sort index 2.23 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:559 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:225 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.27 ms After last query: 0.89 ms Query memory: 0.028 MB Memory before query: 4.706 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 `b4xfb_categories` AS `s`
INNER JOIN `b4xfb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1)
AND c.published = 1
AND s.id = 87
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 cat_idx,idx_access,idx_left_right cat_idx 208 NULL 7 Using index condition; Using where; Using filesort Status Duration Starting 0.17 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.06 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.24 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:312 25 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 24 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 23 ContentRouter->getCategorySegment() Same as call in the line below. 22 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 21 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 20 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 19 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:670 18 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:261 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.40 ms After last query: 3.94 ms Query memory: 0.025 MB Memory before query: 4.683 MB Rows returned: 1Duplicate queries: #2
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'krgjelkb86be1u1o0m8c2me3ji'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index 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.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 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.01 ms Starting cleanup 0.13 ms Freeing items 0.01 ms Updating status 0.60 ms Reset for next command 0.05 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 17 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 16 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 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:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/megamenu.php:166 8 T3MenuMegamenu->__construct() JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84 7 JDocumentRendererMegamenuRender->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.49 ms After last query: 2.04 ms Query memory: 0.021 MB Memory before query: 4.720 MB Rows returned: 1
SELECT sleep_until < '2026-03-22 23:05:55'
FROM b4xfb_scheduler_metadata
WHERE type = 'metadata'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_scheduler_metadata const unique_type unique_type 98 const 1 Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 9 JDatabaseDriver->loadResult() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 8 PlgSystemJoomlatoolsscheduler->onAfterRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 6 PlgSystemJoomlatoolsscheduler->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/CMSApplication.php:1047 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `b4xfb_assets`2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM b4xfb_content AS a
LEFT JOIN b4xfb_categories AS c
ON c.id = a.catid
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_by
LEFT JOIN b4xfb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b4xfb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b4xfb_content_rating AS v
ON a.id = v.content_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`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 `b4xfb_categories` AS `s`
INNER JOIN `b4xfb_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `m`.`tag_id`,`t`.*
FROM `b4xfb_contentitem_tag_map` AS m
INNER JOIN `b4xfb_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `session_id`
FROM `b4xfb_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM b4xfb_modules AS m
LEFT JOIN b4xfb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN b4xfb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.*, u.name as creator_name
FROM b4xfb_attachments AS a
LEFT JOIN b4xfb_users AS u
ON u.id = a.created_by1 × SELECT created_by, catid
FROM b4xfb_content1 × SELECT id
FROM b4xfb_categories1 × SELECT 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
FROM b4xfb_fields AS a
LEFT JOIN `b4xfb_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b4xfb_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b4xfb_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b4xfb_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `b4xfb_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT COUNT(*)
FROM b4xfb_content AS a
LEFT JOIN b4xfb_categories AS c
ON c.id = a.catid
LEFT JOIN b4xfb_users AS ua
ON ua.id = a.created_by
LEFT JOIN b4xfb_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b4xfb_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b4xfb_content_rating AS v
ON a.id = v.content_id1 × SELECT `data`
FROM `b4xfb_session`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,( SELECT COUNT(i.`id`)
FROM `b4xfb_content` AS `i`1 × SELECT *
FROM b4xfb_languages1 × SELECT id, home, template, s.params
FROM b4xfb_template_styles as s
LEFT JOIN b4xfb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b4xfb_menu AS m
LEFT JOIN b4xfb_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `enabled`
FROM `b4xfb_extensions`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM b4xfb_extensions1 × SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `b4xfb_viewlevels1 × SELECT sleep_until < '2026-03-22 23:05:55'
FROM b4xfb_scheduler_metadata
OTHER Tables:
1 × INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('krgjelkb86be1u1o0m8c2me3ji', 1, '1774220755', 0, '', 01 × UPDATE b4xfb_extensions
SET enabled=11 × UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"2b7eb35179a54c9ee40ec7168d36df62\"}'