Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1780428002,
                "last": 1780428002,
                "now": 1780428002
            },
            "token": "RGFK7SsqM8c064qdnqfYSQHGE2C5rgGN"
        },
        "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
        },
        "com_rsfirewall": {
            "geoip": ""
        }
    }
}

Profile Information

Memory Usage

Database Queries

22 Queries Logged 19.63 ms

Query Time: 0.55 ms Query memory: 0.022 MB Memory before query: 2.636 MB Rows returned: 0

SELECT `data`

  FROM `prqkh_session`

  WHERE `session_id` = '833c1ec03752521517dad95a806b4575'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_session	const	PRIMARY	PRIMARY	766	const	1	100.00

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.52 ms After last query: 2.01 ms Query memory: 0.019 MB Memory before query: 2.762 MB Rows returned: 0

SELECT `session_id`

  FROM `prqkh_session`

  WHERE `session_id` = '833c1ec03752521517dad95a806b4575' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_session	const	PRIMARY	PRIMARY	766	const	1	100.00

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.12 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.70 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 2.766 MB

INSERT INTO `prqkh_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('833c1ec03752521517dad95a806b4575', 0, 1, '1780428002', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `prqkh_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('833c1ec03752521517dad95a806b4575', 0, 1, '1780428002', 0, '')

Profile

Status	Duration
Starting	0.05 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.02 ms
Update	0.06 ms
Waiting for query cache lock	0.01 ms
Update	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.06 ms
Query end	0.04 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 5.65 ms Query memory: 0.021 MB Memory before query: 3.220 MB Rows returned: 2

SELECT b.id

  FROM prqkh_usergroups AS a

  LEFT JOIN prqkh_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.52 ms Query memory: 0.021 MB Memory before query: 3.265 MB Rows returned: 4

SELECT id, rules

  FROM `prqkh_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 11.47 ms Query memory: 0.021 MB Memory before query: 4.628 MB Rows returned: 0

SELECT *

  FROM `prqkh_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_admintools_wafexceptions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:526
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:447
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:90
7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.12 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 4.670 MB Rows returned: 1

SELECT `value`

  FROM `prqkh_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_admintools_storage	const	PRIMARY	PRIMARY	402	const	1	100.00

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/models/storage.php:99
11	AdmintoolsModelStorage->load()	JROOT/administrator/components/com_admintools/models/storage.php:49
10	AdmintoolsModelStorage->getValue()	JROOT/plugins/system/admintools/feature/httpsizer.php:26
9	AtsystemFeatureHttpsizer->isEnabled()	JROOT/plugins/system/admintools/admintools/main.php:356
8	plgSystemAdmintools->loadFeatures()	JROOT/plugins/system/admintools/admintools/main.php:93
7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.13 ms After last query: 2.15 ms Query memory: 0.021 MB Memory before query: 4.865 MB Rows returned: 0

SELECT `path`

  FROM prqkh_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_ignored	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.11 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 4.872 MB Rows returned: 0

SELECT `file`

  FROM prqkh_rsfirewall_hashes

  WHERE `type`='protect'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:58
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.11 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 4.877 MB Rows returned: 46

SELECT *

  FROM prqkh_rsfirewall_configuration

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:66
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 3.46 ms Query memory: 0.024 MB Memory before query: 5.207 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `prqkh_rsfirewall_logs`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `prqkh_rsfirewall_logs`

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.28 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:46
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.37 ms After last query: 5.68 ms Query memory: 0.108 MB Memory before query: 5.474 MB Rows returned: 58

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 prqkh_menu AS m

  LEFT JOIN prqkh_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	165	62.42	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	armadaae_spatest.m.component_id	1	100.00	Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	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
Waiting for query cache lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.22 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.01 ms
Creating sort index	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.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.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.07 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
17	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
16	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
15	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
14	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
13	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
12	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
11	JApplicationSite->getTemplate()	JROOT/libraries/zauan/shortcodes/shortcodes.php:205
10	include_once JROOT/libraries/zauan/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
9	JLoader::import()	JROOT/libraries/loader.php:682
8	jimport()	JROOT/plugins/system/hg_assets/hg_assets.php:16
7	require_once JROOT/plugins/system/hg_assets/hg_assets.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.92 ms After last query: 11.85 ms Query memory: 0.022 MB Memory before query: 6.879 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
Starting	0.08 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.49 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 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	2.27 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:337
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:685
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:118
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 35.74 ms Query memory: 0.020 MB Memory before query: 7.508 MB Rows returned: 0

SELECT *

  FROM prqkh_rsfirewall_hashes

  WHERE (`type`='3.6.3' OR `type`='protect') 
  AND `flag`!='C'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:836
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 7.534 MB Rows returned: 0

SELECT *

  FROM prqkh_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_snapshots	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:859
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.16 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 7.539 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM prqkh_rsfirewall_lists

  WHERE (`ip`='216.73.217.69' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_lists	ref	published,type	type	1	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:164
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:143
9	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:876
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 7.547 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM prqkh_rsfirewall_lists

  WHERE (`ip`='216.73.217.69' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_lists	ALL	published,type	NO INDEX KEY COULD BE USED	NULL	NULL	548	100.00	Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:164
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:133
9	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:880
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.84 ms Query memory: 0.021 MB Memory before query: 7.590 MB Rows returned: 0

SELECT *

  FROM prqkh_rsfirewall_exceptions

  WHERE `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_rsfirewall_exceptions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:532
9	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:915
8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.00 ms After last query: 0.88 ms Query memory: 0.006 MB Memory before query: 7.615 MB

UPDATE `prqkh_extensions`

  SET `params` = '{\"mediaversion\":\"47b592dfe7cf6c574c832a39c6f37750\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prqkh_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.08 ms
Updating	0.07 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	5.38 ms
Query end	0.02 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.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:175
9	plgSystemMijoshopJquery->_checkUp()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:35
8	plgSystemMijoshopJquery->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.33 ms After last query: 3.96 ms Query memory: 0.023 MB Memory before query: 8.194 MB Rows returned: 8

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM prqkh_modules AS m

  LEFT JOIN prqkh_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN prqkh_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-06-02 19:20:02') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-02 19:20:02') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 187 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	95	36.84	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	armadaae_spatest.m.id	1	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	armadaae_spatest.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.06 ms
starting	0.01 ms
Checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.38 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.10 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
10	JModuleHelper::getModule()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:191
9	plgSystemMijoshopJquery->_checkUp()	JROOT/plugins/system/mijoshopjquery/mijoshopjquery.php:35
8	plgSystemMijoshopJquery->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.62 ms After last query: 12.98 ms Query memory: 0.024 MB Memory before query: 8.620 MB Rows returned: 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,COUNT(i.`id`) AS numitems

  FROM prqkh_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM prqkh_categories AS cat JOIN prqkh_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN prqkh_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `prqkh_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=7

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	22	59.09	Using where
1	PRIMARY	i	ref\|filter	idx_state,idx_catid	idx_catid\|idx_state	4\|1	armadaae_spatest.c.id	5 (56%)	56.18	Using where; Using rowid filter
1	PRIMARY	<derived2>	ref	key0	key0	5	armadaae_spatest.c.id	2	100.00	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	7	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	22	100.00	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.20 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.21 ms
Optimizing	0.06 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Statistics	0.16 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.60 ms
Creating sort index	0.05 ms
Removing tmp table	0.12 ms
Creating sort index	0.02 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
Removing tmp table	0.01 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.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.12 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/categories.php:115
13	ContentModelCategories->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/categories.php:55
11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.49 ms After last query: 2.56 ms Query memory: 0.023 MB Memory before query: 8.722 MB Rows returned: 1

SELECT params 
  FROM prqkh_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition

Profile

Status	Duration
Starting	0.08 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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.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.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `ip`,`reason` 
  FROM prqkh_rsfirewall_lists

1 × SELECT `data` 
  FROM `prqkh_session`

1 × 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 prqkh_menu AS m 
  LEFT JOIN prqkh_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM prqkh_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM prqkh_categories AS cat JOIN prqkh_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM prqkh_modules AS m 
  LEFT JOIN prqkh_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN prqkh_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM prqkh_rsfirewall_exceptions

1 × SELECT * 
  FROM prqkh_rsfirewall_snapshots

1 × SELECT * 
  FROM prqkh_rsfirewall_hashes

1 × SELECT * 
  FROM prqkh_rsfirewall_configuratio

1 × SELECT `session_id` 
  FROM `prqkh_session`

1 × SELECT `file` 
  FROM prqkh_rsfirewall_hashes

1 × SELECT `path` 
  FROM prqkh_rsfirewall_ignored

1 × SELECT `value` 
  FROM `prqkh_admintools_storage`

1 × SELECT * 
  FROM `prqkh_admintools_wafexceptions`

1 × SELECT id, rules 
  FROM `prqkh_viewlevels

1 × SELECT b.id 
  FROM prqkh_usergroups AS a 
  LEFT JOIN prqkh_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT params 
  FROM prqkh_extensions AS e

OTHER Tables:

1 × INSERT INTO `prqkh_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('833c1ec03752521517dad95a806b4575', 0, 1, '1780428002', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `prqkh_rsfirewall_logs

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `prqkh_extensions` 
  SET `params` = '{\"mediaversion\":\"47b592dfe7cf6c574c832a39c6f37750\"}'

Error

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

22 Queries Logged 19.63 ms

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: