
Businesscafe - HNB Group recorded a PAT of Rs 23.7 Bn growing by 26% YoY, while the Bank’s Profit After Tax increased by 34% YoY to Rs 22.2 Bn for the nine months ended September 2024.
Commenting on the performance, Mr. Nihal Jayawardene, Chairman of Hatton National Bank PLC, stated that “having experienced five years of extreme volatility and unprecedented challenges, Sri Lanka has witnessed macro-economic stability during the year.
We believe, that the completion of the external debt restructuring as announced, as well as progression in the reform agenda, will boost investor confidence, auguring well for the country and the banking sector”.
Mr. Damith Pallewatte, Acting Chief Executive Officer of Hatton National Bank PLC, added that “Sri Lanka’s key macro variables continued to move in the right trajectory during the first nine months of the year.
However, at bank level, these variables resulted in mixed financial outcomes.
The overall improvement in the operating environment created a conducive environment for businesses and individuals leading to better credit growth and debt serviceability by the borrowers.
However, steep drop in market rates impacted both yields from the loans and advances and investment portfolio negatively exerting pressure on interest margins.
While strengthening of the LKR against the USD resulted in improved economic activity on the imports front, this also resulted in bank having to recognize an exchange loss on the revaluation of foreign exchange reserves.
Nonetheless, in this backdrop, Bank’s core focus remained on sustainable growth through responsible lending, mobilization of low-cost deposits, growing non-interest income and improving asset quality”.
Decline in AWPLR by nearly 50% compared to last year and remaining at an average level of 10% for the first 9 months directly reflected in the loan yields as the loan book repriced at lower rates leading to a considerable 25% decline in Gross Interest Income for the period.
The Interest Expense also recorded a 29% drop in line, supported by the strong growth in CASA deposits.
The resultant NII for the period was recorded at Rs. 68.5 Bn, reflecting an 18% YoY contraction.
Bank’s efforts to minimize the impact of interest rate volatility, resulted in a 10% YoY growth in Net Fee and Commission income despite trade income being relatively lower compared to the previous year with the normalizing of the trade tariff to pre-crisis levels.
The growth in fee income was largely driven by higher cards and digital transactions in line with the efforts to drive a cashless economy,
The support extended to customers to revive their businesses, concerted efforts on collection and the overall improvement in economic activity enabled the Bank to record superior asset quality compared to the industry.
The net stage 3 ratio improved to 3.32% while the stage 3 provision coverage ratio improved to 60.50%, during the quarter, compared to 4.09% and 56.08% recorded in 1H 2024.
The total impairment charge for the nine months amounted to Rs 3.2 Bn, compared to Rs 32.4 Bn for the same period in 2023.
The impairment charge for the previous period included an amount of Rs 25 Bn on account of Bank’s investments in international sovereign bonds (ISBs).
With the agreement on the external debt restructuring, in line with the industry practice, the Bank maintained its provision cover of 52% on the investments in ISBs.
This together with the positive movement in stage-wise loans, led to a significant reduction in the impairment charge for the period.
As of 30th September 2024, the Bank’s gross loans and advances which saw a drop in the first quarter recorded a net growth of Rs 91.1 Bn since, reaching Rs 1.1 Tn.
The Bank’s deposit base continued to grow significantly, reaching Rs 1.62 Tn, driven by a remarkable increase of Rs 79.9 Bn in LKR CASA over the nine months of 2024.
This has elevated the LKR CASA ratio to 35.8% from 31.8% in December 2023.
HNB’s Tier I and Total Capital Adequacy Ratios stood at 15.51% and 20.01% against the minimum statutory requirements of 9.5% and 13.5% respectively.
The tier II ratio was further strengthened during the quarter, by the successful issuance of Basel III compliant subordinated debentures, amounting to Rs 12 Bn.
HNB continued to maintain a strong liquidity position with an all currency Liquidity Coverage Ratio of 297.39%, against the minimum statutory requirements 100%.
Outlining his vision for the Bank, Acting CEO stated that “Our goal is to continue building on our legacy of strength, stability and innovation.
By leveraging best in class customer service, emerging technologies, and unparalleled suite of products and services, we aim to partner the progress of our people, while exploring new market opportunities for expansion.
HNB is rated A (lka) by Fitch Ratings and was adjudged the “Sri Lanka's Best Bank” and “Sri Lanka's Best Bank for SMEs” by Euromoney Magazine in 2024.
In addition, HNB was also recognized as the “Best Retail Bank in Sri Lanka” for the 14th occasion and “Best Automobile Financing for Asia Pacific” by the Asian Banker.
HNB was ranked the Number 1 Company in Sri Lanka by Business Today in its Top 40 Businesses ranking for 2023-24.
HNB was recognized as one of the Top 25 Corporates at the LMD Awards which was held honouring 25 most awarded Sri Lankan Corporates.
Vega and Kuda, two specialist conservation dogs, transported by Emirates SkyCargo from London to Harare via Dubai in partnership with UK charity Dogs 4 Wildlife, have arrived safely and acclimatise
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1794061901,
"last": 1794061901,
"now": 1794061902
},
"client": {
"forwarded": "216.73.216.208"
},
"token": "kX43gxwOvt4x7gnQM6HEagX6HSzHAzma"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
SELECT id, rules
FROM `o4b37_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.07 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM o4b37_usergroups AS a
LEFT JOIN o4b37_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.23 ms |
| checking permissions | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `path`
FROM o4b37_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| executing | 0.04 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:56 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:42 |
| 7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `file`
FROM o4b37_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 255 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:63 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:42 |
| 7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM o4b37_rsfirewall_configuration
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_rsfirewall_configuration | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 71 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.13 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:71 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:42 |
| 7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `o4b37_rsfirewall_logs`
| Status | Duration |
|---|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.28 ms |
| init | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.04 ms |
| Sending data | 0.14 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| removing tmp table | 0.08 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:38 |
| 11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:31 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:84 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:61 |
| 7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `template`
FROM `o4b37_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_template_styles | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | 25.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.22 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.14 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.10 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:1326 |
| 12 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:206 |
| 11 | AddonParser::getAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:1460 |
| 10 | require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php | JROOT/components/com_sppagebuilder/builder/classes/addon.php:28 |
| 9 | require_once JROOT/components/com_sppagebuilder/builder/classes/addon.php | JROOT/components/com_sppagebuilder/helpers/autoload.php:42 |
| 8 | BuilderAutoload::loadClasses() | JROOT/plugins/system/sppagebuilder/sppagebuilder.php:34 |
| 7 | require_once JROOT/plugins/system/sppagebuilder/sppagebuilder.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `o4b37_categories` AS `s`
INNER JOIN `o4b37_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 16811
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.52 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| init | 0.14 ms |
| System lock | 0.03 ms |
| optimizing | 0.05 ms |
| statistics | 0.16 ms |
| executing | 0.08 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.18 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `alias`,`catid`
FROM `o4b37_content`
WHERE `id` = 16811
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
| 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM o4b37_rsfirewall_hashes
WHERE (`type`='3.10.12' OR `type`='protect')
AND (`flag`!='C' OR `flag` IS NULL)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_rsfirewall_hashes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 255 | 17.29 | Using where |
| Status | Duration |
|---|---|
| starting | 0.19 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.04 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.36 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1050 |
| 9 | plgSystemRsfirewall->runProtections() | JROOT/plugins/system/rsfirewall/rsfirewall.php:918 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM o4b37_rsfirewall_snapshots
WHERE `type`='protect'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49 |
| 10 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1073 |
| 9 | plgSystemRsfirewall->runProtections() | JROOT/plugins/system/rsfirewall/rsfirewall.php:918 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM o4b37_rsfirewall_lists
WHERE (`ip`='216.73.216.208' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.19 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:184 |
| 11 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:163 |
| 10 | plgSystemRsfirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1109 |
| 9 | plgSystemRsfirewall->runProtections() | JROOT/plugins/system/rsfirewall/rsfirewall.php:918 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM o4b37_rsfirewall_lists
WHERE (`ip`='216.73.216.208' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.18 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:184 |
| 11 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:153 |
| 10 | plgSystemRsfirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1113 |
| 9 | plgSystemRsfirewall->runProtections() | JROOT/plugins/system/rsfirewall/rsfirewall.php:918 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM o4b37_rsfirewall_exceptions
WHERE `published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| executing | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:698 |
| 10 | plgSystemRsfirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1261 |
| 9 | plgSystemRsfirewall->runProtections() | JROOT/plugins/system/rsfirewall/rsfirewall.php:918 |
| 8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `o4b37_template_styles`
WHERE `id` = 120
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_template_styles | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.18 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT/plugins/system/helixultimate/src/Platform/Helper.php:59 |
| 11 | HelixUltimate\Framework\Platform\Helper::getTemplateStyle() | JROOT/plugins/system/helixultimate/src/Platform/Helper.php:343 |
| 10 | HelixUltimate\Framework\Platform\Helper::loadTemplateData() | JROOT/plugins/system/helixultimate/helixultimate.php:278 |
| 9 | PlgSystemHelixultimate->attachWebAsset() | JROOT/plugins/system/helixultimate/helixultimate.php:307 |
| 8 | PlgSystemHelixultimate->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `o4b37_extensions`
SET `params` = '{\"mediaversion\":\"bd3860e6c80a43efc18ad2191b696333\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | o4b37_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.18 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.17 ms |
| updating | 0.16 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| end | 0.02 ms |
| query end | 4.37 ms |
| closing tables | 0.03 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 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:1137 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `o4b37_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_search','com_spauthorarchive','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | 100.00 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.24 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.24 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.32 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.60 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 16 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 15 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:78 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `o4b37_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o4b37_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 5900 | 25.71 | Using where |
| Status | Duration |
|---|---|
| starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 15.30 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 20 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 16 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 15 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:78 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM o4b37_content AS a
INNER JOIN o4b37_categories AS c
on c.id = a.catid
LEFT JOIN o4b37_users AS u
on u.id = a.created_by
LEFT JOIN o4b37_categories as parent
ON parent.id = c.parent_id
LEFT JOIN o4b37_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 16811
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-07 14:31:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-07 14:31:42')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.62 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.08 ms |
| init | 0.20 ms |
| System lock | 0.03 ms |
| optimizing | 0.06 ms |
| statistics | 0.33 ms |
| preparing | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.12 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.04 ms |
| freeing items | 0.18 ms |
| cleaning up | 0.06 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `o4b37_categories` AS `s`
INNER JOIN `o4b37_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 93
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 18 | 62.92 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.41 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.12 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.31 ms |
| preparing | 0.07 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.56 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.19 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|---|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `o4b37_contentitem_tag_map` AS m
INNER JOIN `o4b37_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 16811
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 88631 | 1.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | busin178.m.tag_id | 1 | 50.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.26 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.09 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.24 ms |
| preparing | 0.06 ms |
| executing | 0.02 ms |
| Sending data | 85.23 ms |
| end | 0.05 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 4.19 ms |
| cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM o4b37_fields AS a
LEFT JOIN `o4b37_languages` AS l
ON l.lang_code = a.language
LEFT JOIN o4b37_users AS uc
ON uc.id=a.checked_out
LEFT JOIN o4b37_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN o4b37_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN o4b37_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `o4b37_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 (93,0,91))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | busin178.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | busin178.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | busin178.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | busin178.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | busin178.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | busin178.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|---|
| starting | 0.49 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.10 ms |
| init | 0.16 ms |
| System lock | 0.03 ms |
| optimizing | 0.06 ms |
| statistics | 0.37 ms |
| preparing | 0.09 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.44 ms |
| Creating sort index | 0.10 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| removing tmp table | 0.11 ms |
| query end | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 12.32 ms |
| cleaning up | 0.07 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 14 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `ip`,`reason`
FROM o4b37_rsfirewall_lists
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `o4b37_assets`
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 `o4b37_categories` AS `s`
INNER JOIN `o4b37_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT id, rules
FROM `o4b37_viewlevels
1 × SELECT `m`.`tag_id`,`t`.*
FROM `o4b37_contentitem_tag_map` AS m
INNER JOIN `o4b37_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM o4b37_content AS a
INNER JOIN o4b37_categories AS c
on c.id = a.catid
LEFT JOIN o4b37_users AS u
on u.id = a.created_by
LEFT JOIN o4b37_categories as parent
ON parent.id = c.parent_id
LEFT JOIN o4b37_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM `o4b37_template_styles`
1 × SELECT *
FROM o4b37_rsfirewall_exceptions
1 × SELECT *
FROM o4b37_rsfirewall_hashes
1 × SELECT *
FROM o4b37_rsfirewall_snapshots
1 × SELECT b.id
FROM o4b37_usergroups AS a
LEFT JOIN o4b37_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `alias`,`catid`
FROM `o4b37_content`
1 × SELECT `template`
FROM `o4b37_template_styles`
1 × SELECT *
FROM o4b37_rsfirewall_configuratio
1 × SELECT `file`
FROM o4b37_rsfirewall_hashes
1 × SELECT `path`
FROM o4b37_rsfirewall_ignored
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM o4b37_fields AS a
LEFT JOIN `o4b37_languages` AS l
ON l.lang_code = a.language
LEFT JOIN o4b37_users AS uc
ON uc.id=a.checked_out
LEFT JOIN o4b37_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN o4b37_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN o4b37_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `o4b37_fields_categories` AS fc
ON fc.field_id = a.id
1 × SHOW FULL COLUMNS
FROM `o4b37_rsfirewall_logs
1 × UPDATE `o4b37_extensions`
SET `params` = '{\"mediaversion\":\"bd3860e6c80a43efc18ad2191b696333\"}'














