Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1720853657,
                "last": 1720853657,
                "now": 1720853657
            },
            "client": {
                "forwarded": "3.16.130.155"
            },
            "token": "0A0JNvlmqTswsUGcQdmVsEyFctWnFcSO"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                }
            }
        },
        "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
        },
        "jomsocial_userip": "3.16.130.155"
    }
}

Profile Information

Memory Usage

Database Queries

58 Queries Logged 78.79 ms

2 duplicate found!

2 duplicates: #37 #38

Query Time: 1.08 ms Query memory: 0.020 MB Memory before query: 4.105 MB Rows returned: 0

SELECT `session_id`

  FROM `joom_session`

  WHERE `session_id` = 'nc39oqn8astufrrlfu8ck3roqb' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
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:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

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

Query Time: 3.04 ms After last query: 0.06 ms Query memory: 0.003 MB Memory before query: 4.172 MB

INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('nc39oqn8astufrrlfu8ck3roqb', 1, '1720853657', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('nc39oqn8astufrrlfu8ck3roqb', 1, '1720853657', 0, '')

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	2.12 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
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:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

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

Query Time: 1.38 ms After last query: 1.68 ms Query memory: 0.045 MB Memory before query: 4.344 MB Rows returned: 80

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `joom_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	80	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:598
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.86 ms After last query: 25.25 ms Query memory: 0.021 MB Memory before query: 4.554 MB Rows returned: 7

SELECT id, rules

  FROM `joom_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1062
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.79 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.566 MB Rows returned: 1

SELECT b.id

  FROM joom_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:979
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1094
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.34 ms After last query: 4.06 ms Query memory: 0.046 MB Memory before query: 4.628 MB Rows returned: 142

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM joom_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	277	0.40	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
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:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.20 ms After last query: 71.01 ms Query memory: 0.024 MB Memory before query: 5.536 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `joom_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
15	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__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:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 5.50 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 5.528 MB

UPDATE `joom_extensions`

  SET `params` = '{\"mediaversion\":\"244e2ae6c1a8d8aa10fec862e7eda709\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	joom_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.09 ms
updating	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	4.46 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__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:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.91 ms After last query: 153.67 ms Query memory: 0.029 MB Memory before query: 8.021 MB Rows returned: 19

SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	10.00	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:99
7	PlgSystemLanguageFilter->__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:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.73 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 8.088 MB Rows returned: 1

SELECT * 
  FROM axs_domains 
  WHERE domain = 'k8s.intg.tovuti.io'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:155
8	AxsLanguage::getSubdomainDefault()	JROOT/plugins/system/languagefilter/languagefilter.php:103
7	PlgSystemLanguageFilter->__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:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.31 ms After last query: 0.08 ms Query memory: 0.030 MB Memory before query: 8.096 MB Rows returned: 94

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `joom_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	98	1.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:113
7	PlgSystemLanguageFilter->__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:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.71 ms After last query: 0.96 ms Query memory: 0.022 MB Memory before query: 8.228 MB Rows returned: 1

SELECT * 
  FROM `axs_brands` 
  WHERE language = 'en-GB' 
  AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_brands	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:290
11	AxsBrands::getData()	JROOT/libraries/axslibs/brands.php:355
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.69 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.250 MB Rows returned: 19

SELECT * 
  FROM joom_languages 
  WHERE published = 1 
  ORDER BY `title`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	10.00	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/language.php:314
12	AxsLanguage::getPublishedLanguages()	JROOT/libraries/axslibs/language.php:223
11	AxsLanguage::getCurrentLanguage()	JROOT/libraries/axslibs/brands.php:371
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.70 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 8.274 MB Rows returned: 1

SELECT * 
  FROM `axs_homepage_templates` 
  WHERE id='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_homepage_templates	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:388
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.00 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 8.315 MB Rows returned: 1

SELECT * 
  FROM `axs_dashboard_templates` 
  WHERE id='2'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_dashboard_templates	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:406
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.69 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 8.335 MB Rows returned: 1

SELECT *

  FROM axs_email_settings

  WHERE id = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_email_settings	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:632
11	AxsBrands::getEmailSettingsById()	JROOT/libraries/axslibs/brands.php:409
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.67 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.344 MB Rows returned: 1

SELECT *

  FROM axs_payment_gateways

  WHERE id = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_payment_gateways	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:582
11	AxsBrands::getPaymentGatewayById()	JROOT/libraries/axslibs/brands.php:412
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.67 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.357 MB Rows returned: 1

SELECT *

  FROM axs_integrations

  WHERE id = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_integrations	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaned up	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:659
11	AxsBrands::getIntegrationById()	JROOT/libraries/axslibs/brands.php:418
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.18 ms After last query: 70.76 ms Query memory: 0.101 MB Memory before query: 9.913 MB Rows returned: 88

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

  LEFT JOIN joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	128	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.93 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:500
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:277
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:605
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:134
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.46 ms After last query: 87.16 ms Query memory: 0.028 MB Memory before query: 11.435 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `joom_users`

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
15	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
13	JUser::getTable()	JROOT/libraries/joomla/user/user.php:782
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.73 ms After last query: 0.44 ms Query memory: 0.022 MB Memory before query: 11.479 MB Rows returned: 1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_usergroups	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:152
13	JTableUser->bind()	JROOT/libraries/joomla/user/user.php:784
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.89 ms After last query: 43.14 ms Query memory: 0.025 MB Memory before query: 11.844 MB Rows returned: 1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_configuration	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
18	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
17	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
16	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
15	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
14	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:716
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	Same as call in the line below.
11	spl_autoload_call()	JROOT/components/com_kunena/router.php:301
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.99 ms After last query: 62.53 ms Query memory: 0.022 MB Memory before query: 12.006 MB Rows returned: 1

SELECT * 
  FROM joom_kunena_aliases 
  WHERE alias LIKE 'welcome-mat%'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_aliases	NULL	range	alias	alias	572	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.06 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:450
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:316
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.76 ms After last query: 25.99 ms Query memory: 0.019 MB Memory before query: 12.523 MB Rows returned: 0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
6	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:666
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:35
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:377
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.77 ms After last query: 2.17 ms Query memory: 0.019 MB Memory before query: 12.850 MB Rows returned: 0

SELECT *

  FROM `joom_users`

  WHERE `id` = 0

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:381
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.19 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 12.859 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	root_db.s.template,const	1	4.07	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:490
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.28 ms After last query: 71.48 ms Query memory: 0.025 MB Memory before query: 13.115 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 6.54 ms After last query: 161.91 ms Query memory: 0.035 MB Memory before query: 13.905 MB Rows returned: 51

SHOW FULL COLUMNS 
  FROM `joom_kunena_users`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
19	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
18	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:311
17	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:252
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
11	JLoader::_load()	JROOT/libraries/loader.php:671
10	JLoader::_autoload()	Same as call in the line below.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.36 ms After last query: 30.15 ms Query memory: 0.025 MB Memory before query: 14.001 MB Rows returned: 0

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (0)

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
15	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
14	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:63
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
11	JLoader::_load()	JROOT/libraries/loader.php:671
10	JLoader::_autoload()	Same as call in the line below.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.89 ms After last query: 135.98 ms Query memory: 0.023 MB Memory before query: 14.998 MB Rows returned: 0

SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
			
  FROM joom_kunena_categories AS c
			
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid
			
  WHERE c.published=1 
  AND g.approved=1 
  AND g.permissions='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	category_access,published_pubaccess_id	category_access	62	const	1	100.00	Using where
1	SIMPLE	g	NULL	ref	PRIMARY,groupid	PRIMARY	4	root_db.c.access	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/access.php:136
13	KunenaAccessCommunity->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.77 ms After last query: 0.12 ms Query memory: 0.030 MB Memory before query: 15.017 MB Rows returned: 63

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `joom_assets`

  WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	264	54.55	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:530
15	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.74 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 15.115 MB Rows returned: 5

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	74	33.33	Using where; Using index
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.10 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 15.131 MB Rows returned: 23

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (32,20)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	NULL	2	100.00	Using where; Using temporary
1	SIMPLE	ug2	NULL	ALL	PRIMARY,idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	82	11.11	Range checked for each record (index map: 0x9)
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.71 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 15.148 MB Rows returned: 0

SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories 
  WHERE role IN (1,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_user_categories	NULL	range	role	role	1	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.90 ms After last query: 88.89 ms Query memory: 0.028 MB Memory before query: 16.112 MB Rows returned: 3

SELECT * 
  FROM joom_kunena_categories 
  ORDER BY ordering, name

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_categories	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using filesort

Profile

Status	Duration
starting	0.03 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.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
17	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
16	JLoader::_load()	JROOT/libraries/loader.php:671
15	JLoader::_autoload()	Same as call in the line below.
14	spl_autoload_call()	JROOT/components/com_kunena/controller/category/topics/display.php:71
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.82 ms After last query: 14.76 ms Query memory: 0.026 MB Memory before query: 16.383 MB Rows returned: 0

SELECT groupid

  FROM joom_community_groups_members

  WHERE approved = 1 
  AND memberid = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_community_groups_members	NULL	ref	idx_memberid	idx_memberid	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 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.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:881
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
17	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
16	JLoader::_load()	JROOT/libraries/loader.php:671
15	JLoader::_autoload()	Same as call in the line below.
14	spl_autoload_call()	JROOT/components/com_kunena/controller/category/topics/display.php:71
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.89 ms After last query: 12.77 ms Query memory: 0.023 MB Memory before query: 16.450 MB Rows returned: 1

Duplicate queries: #38

SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tt	NULL	ref	category_id,hold	category_id	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
sending cached result to clien	0.05 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
15	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:99
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.79 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 16.458 MB Rows returned: 1

Duplicate queries: #37

SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tt	NULL	ref	category_id,hold	category_id	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
17	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:307
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:362
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:134
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.21 ms After last query: 111.49 ms Query memory: 0.036 MB Memory before query: 16.851 MB Rows returned: 39

SHOW FULL COLUMNS 
  FROM `joom_kunena_categories`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
23	JTable->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
22	TableKunenaCategories->__construct()	JROOT/libraries/joomla/table/table.php:311
21	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
20	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
19	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1031
18	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
17	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
16	JHtmlKunenaForum::categorylist()	JROOT/libraries/cms/html/html.php:233
15	JHtml::call()	JROOT/libraries/cms/html/html.php:140
14	JHtml::_()	JROOT/components/com_kunena/controller/category/index/display.php:61
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.22 ms After last query: 57.89 ms Query memory: 0.032 MB Memory before query: 17.129 MB Rows returned: 21

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

  FROM joom_modules AS m

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

  LEFT JOIN joom_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-13 06:54:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-13 06:54:18') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 871 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,idx_language,newsfeeds,published	published	5	NULL	58	1.56	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	root_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	root_db.m.id	3	40.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.78 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
25	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
24	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
23	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
22	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
21	JDocumentHtml->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
20	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:13
19	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
16	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:29
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.88 ms After last query: 13.54 ms Query memory: 0.030 MB Memory before query: 17.836 MB Rows returned: 66

SELECT code, location 
  FROM joom_kunena_smileys

Explain

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

Profile

Status	Duration
starting	0.03 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.04 ms
cleaned up	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1030
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:44
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:77
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:112
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:334
16	KunenaForumCategory->displayField()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:47
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.82 ms After last query: 6.21 ms Query memory: 0.026 MB Memory before query: 17.876 MB Rows returned: 0

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_topics	NULL	ref	category_id	category_id	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
18	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
17	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
16	KunenaForumCategory->isSection()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:54
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.35 ms After last query: 109.43 ms Query memory: 0.029 MB Memory before query: 18.126 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `joom_community_config`

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
25	JTable->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
24	CommunityTableConfiguration->__construct()	JROOT/libraries/joomla/table/table.php:311
23	JTable::getInstance()	JROOT/components/com_community/libraries/core.php:1057
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.79 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 18.145 MB Rows returned: 1

SELECT *

  FROM joom_community_config

  WHERE `name` = 'config'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_community_config	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
23	JTable->load()	JROOT/components/com_community/libraries/core.php:1058
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.93 ms After last query: 30.92 ms Query memory: 0.028 MB Memory before query: 18.338 MB Rows returned: 1

SELECT * 
  FROM joom_extensions 
  WHERE name='com_media'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	653	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.81 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
25	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/images.php:66
24	AxsImages::setSession()	JROOT/libraries/axslibs/images.php:15
23	AxsImages::getImagesPath()	JROOT/components/com_community/libraries/core.php:1092
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.82 ms After last query: 4.74 ms Query memory: 0.027 MB Memory before query: 18.362 MB Rows returned: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=register%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	257	0.39	Using where

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
21	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.74 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 18.374 MB Rows returned: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` = 'index.php?option=com_community&view=frontpage' 
  AND `published`='1' 
  AND `type`='component' 
  AND (`language` = 'en-GB' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_language	idx_language	28	const	1	5.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
21	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.71 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 18.385 MB Rows returned: 27

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community%' 
  AND `published`='1' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	257	0.39	Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1440
21	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 5.05 ms After last query: 70.95 ms Query memory: 0.025 MB Memory before query: 18.848 MB Rows returned: 1

SELECT special_characters 
  FROM joom_languages 
  WHERE sef = 'en' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_sef	idx_sef	202	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 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.04 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
18	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:280
17	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:26
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:408
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.28 ms After last query: 18.51 ms Query memory: 0.023 MB Memory before query: 18.863 MB Rows returned: 0

SELECT *

  FROM joom_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-07-13 06:54:18') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-07-13 06:54:18')

  ORDER BY id DESC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_announcement	NULL	index	NULL	PRIMARY	4	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.05 ms
optimizing	0.06 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:35
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.91 ms After last query: 52.16 ms Query memory: 0.021 MB Memory before query: 18.919 MB Rows returned: 1

SELECT language,id

  FROM `joom_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	104	1.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:729
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 3.80 ms After last query: 39.34 ms Query memory: 0.022 MB Memory before query: 19.258 MB Rows returned: 1

SELECT *

  FROM `currency`

  WHERE `base_currency`=1 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	currency	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	136	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/currency.php:84
10	AxsCurrency->getBaseCurrency()	JROOT/libraries/axslibs/currency.php:22
9	AxsCurrency->__construct()	JROOT/templates/axs/home.php:20
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.77 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 19.265 MB Rows returned: 10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_fonts	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/fonts.php:34
9	AxsFonts::getFonts()	JROOT/templates/axs/home.php:93
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.77 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 19.301 MB Rows returned: 0

SELECT *

  FROM accessibility_images

  WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
  AND enabled= 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/accessibility.php:42
10	AxsAccessibility::query()	JROOT/libraries/axslibs/accessibility.php:49
9	AxsAccessibility::image()	JROOT/templates/axs/home.php:806
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.16 ms After last query: 1.47 ms Query memory: 0.022 MB Memory before query: 19.415 MB Rows returned: 0

SELECT * 
  FROM axs_notifications  
  WHERE enabled = 1  
  AND   DATE(start_date) <= NOW()  
  AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
  AND (  ( access_type = 'access' 
  AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
  AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
  AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:17
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1795
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.87 ms After last query: 24.34 ms Query memory: 0.023 MB Memory before query: 19.327 MB Rows returned: 1

SELECT sef 
  FROM joom_languages 
  WHERE lang_code = 'en-GB' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 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.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:257
12	AxsLanguage::getSefByLangCode()	JROOT/modules/mod_mediamodal/tmpl/default.php:8
11	require JROOT/modules/mod_mediamodal/tmpl/default.php	JROOT/modules/mod_mediamodal/mod_mediamodal.php:9
10	include JROOT/modules/mod_mediamodal/mod_mediamodal.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.77 ms After last query: 41.89 ms Query memory: 0.026 MB Memory before query: 19.564 MB Rows returned: 0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
20	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:415
19	EB::config()	JROOT/components/com_easyblog/router.php:19
18	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_defaultmenu/helper.php:134
11	ModDefaultHelper::getList()	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.89 ms After last query: 49.95 ms Query memory: 0.023 MB Memory before query: 19.672 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `joom_menu` AS `c`

  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 871

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
12	MenusHelper::getAssociations()	JROOT/modules/mod_language_selector/tmpl/default.php:91
11	require JROOT/modules/mod_language_selector/tmpl/default.php	JROOT/modules/mod_language_selector/mod_language_selector.php:4
10	include JROOT/modules/mod_language_selector/mod_language_selector.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
3 × SELECT `id` 
  FROM `joom_menu`
```

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `joom_extensions`

```
2 × SELECT * 
  FROM joom_languages
```

2 × SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt

2 × SELECT DISTINCT(user_id) 
  FROM joom_usergroups as ug1 
  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

1 × SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories

1 × SELECT * 
  FROM joom_kunena_categories

1 × SELECT groupid 
  FROM joom_community_groups_members

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

1 × SELECT code, location 
  FROM joom_kunena_smiley

1 × SELECT * 
  FROM `joom_kunena_topics`

1 × SELECT * 
  FROM joom_community_config

1 × SELECT `session_id` 
  FROM `joom_session`

```
1 × SELECT * 
  FROM joom_extensions
```

1 × SELECT * 
  FROM joom_kunena_announcement

1 × SELECT language,id 
  FROM `joom_menu`

```
1 × SELECT * 
  FROM `currency`
```
```
1 × SELECT * 
  FROM axs_fonts
```

1 × SELECT * 
  FROM accessibility_images

1 × SELECT * 
  FROM axs_notifications

```
1 × SELECT sef 
  FROM joom_languages
```

1 × SELECT * 
  FROM joom_easyblog_configs

1 × SELECT special_characters 
  FROM joom_languages

1 × SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role    
  FROM joom_kunena_categories AS c    
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `joom_assets`

1 × SELECT * 
  FROM axs_email_settings

1 × SELECT id, rules 
  FROM `joom_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM joom_extensions

```
1 × SELECT * 
  FROM axs_domains
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `joom_extensions`

```
1 × SELECT * 
  FROM `axs_brands`
```

1 × SELECT * 
  FROM `axs_homepage_templates`

1 × SELECT * 
  FROM `axs_dashboard_templates`

1 × SELECT * 
  FROM axs_payment_gateways

1 × SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid`

```
1 × SELECT * 
  FROM axs_integrations
```

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 joom_menu AS m 
  LEFT JOIN joom_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `id`,`title` 
  FROM `joom_usergroups`

1 × SELECT * 
  FROM joom_kunena_configuration

1 × SELECT * 
  FROM joom_kunena_aliases

1 × SELECT params 
  FROM axs_user_settings

```
1 × SELECT * 
  FROM `joom_users`
```

1 × SELECT id, home, template, s.params 
  FROM joom_template_styles as s 
  LEFT JOIN joom_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `joom_menu` AS `c` 
  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

OTHER Tables:

1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('nc39oqn8astufrrlfu8ck3roqb', 1, '1720853657', 0, ''

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"244e2ae6c1a8d8aa10fec862e7eda709\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom_users

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `joom_community_config

Welcome Mat

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

58 Queries Logged 78.79 ms

2 duplicate found!

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: