Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1743645685,
                "last": 1743645685,
                "now": 1743645695
            },
            "client": {
                "forwarded": "13.58.214.82"
            },
            "token": "mK5mD9eZ46Q53CgN9CC4zfPkwFSLwJsg"
        },
        "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": "13.58.214.82"
    }
}

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1531
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:273
1	JApplicationCms->execute()	JROOT/index.php:72

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1575
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:273
1	JApplicationCms->execute()	JROOT/index.php:72

EXPLAIN not possible on query: 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

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	1.24 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:273
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.18 ms After last query: 4.98 ms Query memory: 0.024 MB Memory before query: 5.714 MB Rows returned: 1

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

  FROM `joom_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
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:777
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:747
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:273
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.79 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 5.706 MB

UPDATE `joom_extensions`

  SET `params` = '{\"mediaversion\":\"9b1736cf545fc8e642270b6d7298219b\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `joom_extensions` SET `params` = '{\"mediaversion\":\"9b1736cf545fc8e642270b6d7298219b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.07 ms
updating	0.18 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.01 ms
freeing items	0.02 ms
async commit	2.52 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:777
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:747
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:273
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: 17.92 ms Query memory: 0.029 MB Memory before query: 8.107 MB Rows returned: 19

SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published=1 ORDER BY ordering ASC

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.17 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:747
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:273
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: 0.40 ms Query memory: 0.021 MB Memory before query: 8.179 MB Rows returned: 1

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

Explain

EXPLAIN not possible on query: SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:183
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:747
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:273
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.32 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.187 MB Rows returned: 94

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

  FROM `joom_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.36 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:747
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:273
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.02 ms After last query: 0.89 ms Query memory: 0.022 MB Memory before query: 8.320 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

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

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:298
11	AxsBrands::getData()	JROOT/libraries/axslibs/brands.php:363
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:748
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:273
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.07 ms After last query: 0.04 ms Query memory: 0.030 MB Memory before query: 8.341 MB Rows returned: 19

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

Explain

EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.17 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/language.php:342
12	AxsLanguage::getPublishedLanguages()	JROOT/libraries/axslibs/language.php:251
11	AxsLanguage::getCurrentLanguage()	JROOT/libraries/axslibs/brands.php:379
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:748
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:273
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.94 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.366 MB Rows returned: 1

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

Explain

EXPLAIN not possible on query: SELECT * FROM `axs_homepage_templates` WHERE id='1'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:396
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:748
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:273
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: 0.07 ms Query memory: 0.021 MB Memory before query: 8.407 MB Rows returned: 1

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

Explain

EXPLAIN not possible on query: SELECT * FROM `axs_dashboard_templates` WHERE id='2'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:414
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:748
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:273
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: 0.05 ms Query memory: 0.022 MB Memory before query: 8.427 MB Rows returned: 1

SELECT *

  FROM axs_email_settings

  WHERE id = '1'

Explain

EXPLAIN not possible on query: SELECT * FROM axs_email_settings WHERE id = '1'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:640
11	AxsBrands::getEmailSettingsById()	JROOT/libraries/axslibs/brands.php:417
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:748
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:273
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: 0.04 ms Query memory: 0.022 MB Memory before query: 8.434 MB Rows returned: 1

SELECT *

  FROM axs_payment_gateways

  WHERE id = '1'

Explain

EXPLAIN not possible on query: SELECT * FROM axs_payment_gateways WHERE id = '1'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:590
11	AxsBrands::getPaymentGatewayById()	JROOT/libraries/axslibs/brands.php:420
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:748
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:273
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: 0.06 ms Query memory: 0.022 MB Memory before query: 8.447 MB Rows returned: 1

SELECT *

  FROM axs_integrations

  WHERE id = '1'

Explain

EXPLAIN not possible on query: SELECT * FROM axs_integrations WHERE id = '1'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:667
11	AxsBrands::getIntegrationById()	JROOT/libraries/axslibs/brands.php:426
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:748
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:273
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.23 ms After last query: 10.62 ms Query memory: 0.101 MB Memory before query: 10.160 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

EXPLAIN not possible on query: 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

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.94 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:508
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:613
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:748
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:273
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.43 ms After last query: 10.08 ms Query memory: 0.028 MB Memory before query: 11.682 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.53 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.08 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:1228
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:273
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.93 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 11.726 MB Rows returned: 1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

Explain

EXPLAIN not possible on query: SELECT `id`,`title` FROM `joom_usergroups` WHERE `id` = 1

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1531
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:1228
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:273
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.95 ms After last query: 10.69 ms Query memory: 0.019 MB Memory before query: 12.321 MB Rows returned: 0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

Explain

EXPLAIN not possible on query: SELECT params FROM axs_user_settings WHERE id = 1

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
6	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:707
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:35
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:385
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:273
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.05 ms After last query: 2.22 ms Query memory: 0.019 MB Memory before query: 12.711 MB Rows returned: 0

SELECT *

  FROM `joom_users`

  WHERE `id` = 0

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_users` WHERE `id` = 0

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:389
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:273
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.11 ms Query memory: 0.019 MB Memory before query: 12.719 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

EXPLAIN not possible on query: 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

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:273
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.96 ms After last query: 1.36 ms Query memory: 0.021 MB Memory before query: 12.900 MB Rows returned: 1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

Explain

EXPLAIN not possible on query: SELECT * FROM joom_kunena_configuration WHERE id=1

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1490
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:33
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:273
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.07 ms After last query: 2.61 ms Query memory: 0.025 MB Memory before query: 13.227 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:273
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.96 ms After last query: 5.64 ms Query memory: 0.036 MB Memory before query: 13.941 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.09 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
20	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:252
18	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
17	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
16	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
15	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
14	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	Same as call in the line below.
11	spl_autoload_call()	JROOT/libraries/kunena/route/route.php:699
10	KunenaRoute::build()	JROOT/libraries/kunena/route/route.php:852
9	KunenaRoute::setItemID()	JROOT/libraries/kunena/route/route.php:115
8	KunenaRoute::getItemID()	JROOT/components/com_kunena/controller/application/home/default/display.php:55
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.09 ms After last query: 0.36 ms Query memory: 0.026 MB Memory before query: 14.039 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

EXPLAIN not possible on query: 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)

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
17	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
16	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:63
15	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
14	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	Same as call in the line below.
11	spl_autoload_call()	JROOT/libraries/kunena/route/route.php:699
10	KunenaRoute::build()	JROOT/libraries/kunena/route/route.php:852
9	KunenaRoute::setItemID()	JROOT/libraries/kunena/route/route.php:115
8	KunenaRoute::getItemID()	JROOT/components/com_kunena/controller/application/home/default/display.php:55
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.41 ms After last query: 11.81 ms Query memory: 0.023 MB Memory before query: 15.248 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

EXPLAIN not possible on query: 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'

Profile

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/access.php:136
14	KunenaAccessCommunity->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.66 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 15.268 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

EXPLAIN not possible on query: 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

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.26 ms
preparing	0.03 ms
executing	0.39 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:530
16	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 0.37 ms Query memory: 0.024 MB Memory before query: 15.366 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

EXPLAIN not possible on query: 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)

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1575
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.22 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 15.375 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

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.19 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1575
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.93 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 15.392 MB Rows returned: 0

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

Explain

EXPLAIN not possible on query: SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 1.91 ms Query memory: 0.030 MB Memory before query: 16.233 MB Rows returned: 3

SELECT * 
  FROM joom_kunena_categories 
  ORDER BY ordering, name

Explain

EXPLAIN not possible on query: SELECT * FROM joom_kunena_categories ORDER BY ordering, name

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	Same as call in the line below.
16	spl_autoload_call()	JROOT/libraries/kunena/access.php:559
15	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/category/index/display.php:50
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 1.06 ms Query memory: 0.027 MB Memory before query: 16.506 MB Rows returned: 0

SELECT groupid

  FROM joom_community_groups_members

  WHERE approved = 1 
  AND memberid = 0

Explain

EXPLAIN not possible on query: SELECT groupid FROM joom_community_groups_members WHERE approved = 1 AND memberid = 0

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:881
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	Same as call in the line below.
16	spl_autoload_call()	JROOT/libraries/kunena/access.php:559
15	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/controller/category/index/display.php:50
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.77 ms After last query: 1.09 ms Query memory: 0.037 MB Memory before query: 16.644 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
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.48 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
25	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
24	JTable->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
23	TableKunenaCategories->__construct()	JROOT/libraries/joomla/table/table.php:311
22	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1031
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
17	JHtmlKunenaForum::categorylist()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/components/com_kunena/controller/category/index/display.php:61
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.27 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 16.701 MB Rows returned: 0

Duplicate queries: #42

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='2'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
17	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
16	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:536
15	KunenaForumCategory->getLastCategory()	JROOT/components/com_kunena/controller/category/index/display.php:146
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 0.04 ms Query memory: 0.025 MB Memory before query: 16.711 MB Rows returned: 0

Duplicate queries: #43

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='3'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
17	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
16	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:536
15	KunenaForumCategory->getLastCategory()	JROOT/components/com_kunena/controller/category/index/display.php:146
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.92 ms After last query: 0.45 ms Query memory: 0.025 MB Memory before query: 16.774 MB Rows returned: 0

SELECT * 
  FROM joom_kunena_topics 
  WHERE id IN (3,2)

Explain

EXPLAIN not possible on query: SELECT * FROM joom_kunena_topics WHERE id IN (3,2)

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1531
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:689
16	KunenaForumTopicHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/helper.php:141
15	KunenaForumTopicHelper::getTopics()	JROOT/components/com_kunena/controller/category/index/display.php:173
14	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:13
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 1.88 ms Query memory: 0.032 MB Memory before query: 17.006 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 <= '2025-04-03 02:01:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-03 02:01:35') 
  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

EXPLAIN not possible on query: 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 <= '2025-04-03 02:01:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-03 02:01:35') 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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	1.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.05 ms After last query: 4.55 ms Query memory: 0.030 MB Memory before query: 17.804 MB Rows returned: 66

SELECT code, location 
  FROM joom_kunena_smileys

Explain

EXPLAIN not possible on query: SELECT code, location FROM joom_kunena_smileys

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.03 ms After last query: 0.73 ms Query memory: 0.026 MB Memory before query: 17.839 MB Rows returned: 0

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='1'

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='1'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.95 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 17.850 MB Rows returned: 0

Duplicate queries: #36

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='2'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.93 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 17.860 MB Rows returned: 0

Duplicate queries: #37

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

Explain

EXPLAIN not possible on query: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='3'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.48 ms After last query: 1.83 ms Query memory: 0.033 MB Memory before query: 18.209 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `joom_kunena_topics`

Explain

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

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.50 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.10 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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/libraries/kunena/tables/kunenatopics.php:50
24	TableKunenaTopics->__construct()	JROOT/libraries/joomla/table/table.php:311
23	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
22	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
21	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:964
20	KunenaForumTopic->load()	JROOT/libraries/kunena/database/object.php:271
19	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/topic/topic.php:119
18	KunenaForumTopic->__construct()	JROOT/libraries/kunena/forum/topic/helper.php:47
17	KunenaForumTopicHelper::get()	JROOT/libraries/kunena/forum/category/category.php:546
16	KunenaForumCategory->getLastTopic()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:110
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/components/com_kunena/template/nts_kbento/pages/category/list/default.php:20
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.22 ms After last query: 0.64 ms Query memory: 0.024 MB Memory before query: 18.224 MB Rows returned: 0

SELECT userid, MAX(time) AS time

  FROM joom_session

  WHERE client_id=0 
  AND userid>0 
  AND time > 1743643895

  GROUP BY userid

  ORDER BY time DESC

Explain

EXPLAIN not possible on query: SELECT userid, MAX(time) AS time FROM joom_session WHERE client_id=0 AND userid>0 AND time > 1743643895 GROUP BY userid ORDER BY time DESC

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.13 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:365
15	KunenaUserHelper::getOnlineUsers()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:45
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 515.31 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 18.232 MB Rows returned: 1

SELECT COUNT(*)

  FROM joom_session

  WHERE client_id=0 
  AND userid=0 
  AND time > 1743643895

Explain

EXPLAIN not possible on query: SELECT COUNT(*) FROM joom_session WHERE client_id=0 AND userid=0 AND time > 1743643895

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	514.17 ms
end	0.04 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
16	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/user/helper.php:484
15	KunenaUserHelper::getOnlineCount()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:47
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.99 ms After last query: 1.85 ms Query memory: 0.028 MB Memory before query: 18.368 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.50 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
20	CommunityTableConfiguration->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/components/com_community/libraries/core.php:1057
18	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
17	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.95 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 18.385 MB Rows returned: 1

SELECT *

  FROM joom_community_config

  WHERE `name` = 'config'

Explain

EXPLAIN not possible on query: SELECT * FROM joom_community_config WHERE `name` = 'config'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1490
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
19	JTable->load()	JROOT/components/com_community/libraries/core.php:1058
18	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
17	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.38 ms After last query: 2.34 ms Query memory: 0.025 MB Memory before query: 18.592 MB Rows returned: 0

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

Explain

EXPLAIN not possible on query: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=search%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.36 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
17	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.02 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 18.602 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

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
17	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.25 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 18.611 MB Rows returned: 27

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

Explain

EXPLAIN not possible on query: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community%' AND `published`='1' AND `type`='component'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.34 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
18	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1440
17	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
16	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
15	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:99
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:21
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.58 ms After last query: 1.12 ms Query memory: 0.025 MB Memory before query: 18.680 MB Rows returned: 1

SELECT COUNT(*), MAX(id) 
  FROM joom_users 
  WHERE (block=0 OR activation="")

Explain

EXPLAIN not possible on query: SELECT COUNT(*), MAX(id) FROM joom_users WHERE (block=0 OR activation="")

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.65 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1798
18	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:277
17	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:181
16	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:103
15	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/controller/widget/statistics/display.php:45
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.98 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 18.690 MB Rows returned: 1

SELECT
				SUM(time>=1743638400 
  AND parent=0) AS todayTopicCount,
				SUM(time>=1743638400 
  AND parent>0) AS todayReplyCount,
				SUM(time>=1743552000 
  AND time<1743638400 
  AND parent=0) AS yesterdayTopicCount,
				SUM(time>=1743552000 
  AND time<1743638400 
  AND parent>0) AS yesterdayReplyCount
				
  FROM joom_kunena_messages 
  WHERE time>=1743552000 
  AND hold=0

Explain

EXPLAIN not possible on query: SELECT SUM(time>=1743638400 AND parent=0) AS todayTopicCount, SUM(time>=1743638400 AND parent>0) AS todayReplyCount, SUM(time>=1743552000 AND time<1743638400 AND parent=0) AS yesterdayTopicCount, SUM(time>=1743552000 AND time<1743638400 AND parent>0) AS yesterdayReplyCount FROM joom_kunena_messages WHERE time>=1743552000 AND hold=0

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
17	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:227
16	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:106
15	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/controller/widget/statistics/display.php:45
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.97 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 18.712 MB Rows returned: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621331

Explain

EXPLAIN not possible on query: SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid WHERE u.id = 1621331

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1490
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
19	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
18	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
17	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.09 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 18.722 MB Rows returned: 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` 
  WHERE a.`userid` IN (1621331)

Explain

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.20 ms After last query: 2.20 ms Query memory: 0.030 MB Memory before query: 19.010 MB Rows returned: 15

SHOW FULL COLUMNS 
  FROM `joom_community_profiles`

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/components/com_community/tables/multiprofile.php:32
21	CTableMultiProfile->__construct()	JROOT/libraries/joomla/table/table.php:311
20	JTable::getInstance()	JROOT/components/com_community/libraries/user.php:732
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.98 ms After last query: 1.34 ms Query memory: 0.027 MB Memory before query: 19.143 MB Rows returned: 1

SELECT `id` 
  FROM `joom_community_fields` 
  WHERE `fieldcode`='FIELD_GENDER'

Explain

EXPLAIN not possible on query: SELECT `id` FROM `joom_community_fields` WHERE `fieldcode`='FIELD_GENDER'

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:788
22	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:762
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.85 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 19.154 MB Rows returned: 0

Duplicate queries: #61

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621331'

Explain

EXPLAIN not possible on query: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621331'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:771
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
18	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
17	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:71
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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: 0.76 ms Query memory: 0.025 MB Memory before query: 19.185 MB Rows returned: 1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621331'

Explain

EXPLAIN not possible on query: SELECT `id` FROM `joom_users` WHERE id='1621331'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
19	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.09 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 19.197 MB Rows returned: 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.`cover`	as _cover , 	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.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  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` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621331'

Explain

EXPLAIN not possible on query: SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , 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.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, 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` AND s.`client_id` !='1' WHERE a.`userid`='1621331'

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
20	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
19	CUser->init()	JROOT/components/com_community/libraries/core.php:201
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.85 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 19.224 MB Rows returned: 0

Duplicate queries: #58

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621331'

Explain

EXPLAIN not possible on query: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621331'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:771
21	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
20	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
19	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
18	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.29 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 19.235 MB Rows returned: 3

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

Explain

EXPLAIN not possible on query: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.36 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
20	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
19	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
18	CRoute::_()	JROOT/plugins/kunena/community/profile.php:63
17	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
16	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
15	KunenaUser->getLink()	JROOT/components/com_kunena/controller/widget/statistics/display.php:48
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php:22
11	include JROOT/components/com_kunena/template/nts_kbento/pages/category/list/default.php	JROOT/libraries/kunena/layout/base.php:183
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:107
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->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:273
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.33 ms After last query: 1.85 ms Query memory: 0.027 MB Memory before query: 19.366 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

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.35 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
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:273
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.09 ms After last query: 3.91 ms Query memory: 0.023 MB Memory before query: 19.743 MB Rows returned: 0

SELECT *

  FROM joom_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-03 02:01:35') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-03 02:01:35')

  ORDER BY id DESC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT * FROM joom_kunena_announcement WHERE (published = 1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-03 02:01:35') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-03 02:01:35') ORDER BY id DESC LIMIT 1

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1531
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:273
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.29 ms After last query: 1.72 ms Query memory: 0.027 MB Memory before query: 19.800 MB Rows returned: 1

SELECT language,id

  FROM `joom_menu`

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

Explain

EXPLAIN not possible on query: SELECT language,id FROM `joom_menu` WHERE home = 1 AND published = 1 AND client_id = 0

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.24 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:273
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.59 ms Query memory: 0.021 MB Memory before query: 19.857 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

EXPLAIN not possible on query: 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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:746
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:273
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: 3.27 ms Query memory: 0.022 MB Memory before query: 20.192 MB Rows returned: 1

SELECT *

  FROM `currency`

  WHERE `base_currency`=1 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT * FROM `currency` WHERE `base_currency`=1 LIMIT 1

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
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:60
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:1181
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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.96 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 20.198 MB Rows returned: 10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

Explain

EXPLAIN not possible on query: SELECT * FROM axs_fonts WHERE enabled = 1

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
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:60
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:1181
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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.97 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 20.234 MB Rows returned: 0

SELECT *

  FROM accessibility_images

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

Explain

EXPLAIN not possible on query: SELECT * FROM accessibility_images WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
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:799
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:60
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:1181
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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.09 ms After last query: 1.81 ms Query memory: 0.022 MB Memory before query: 20.351 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

EXPLAIN not possible on query: 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' ) )

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1726
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:19
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1788
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:60
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:1181
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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.96 ms After last query: 0.71 ms Query memory: 0.023 MB Memory before query: 20.265 MB Rows returned: 1

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

Explain

EXPLAIN not possible on query: SELECT sef FROM joom_languages WHERE lang_code = 'en-GB' LIMIT 1

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:285
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:1198
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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.97 ms After last query: 3.10 ms Query memory: 0.026 MB Memory before query: 20.502 MB Rows returned: 0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

Explain

EXPLAIN not possible on query: SELECT * FROM joom_easyblog_configs WHERE `name` = 'config'

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1490
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:1198
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
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: 0.73 ms Query memory: 0.024 MB Memory before query: 20.566 MB Rows returned: 1

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

Explain

EXPLAIN not possible on query: SELECT special_characters FROM joom_languages WHERE sef = 'en' LIMIT 1

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1687
15	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:308
14	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:26
13	AxsLanguage::translate()	JROOT/modules/mod_defaultmenu/tmpl/default_component.php:21
12	require JROOT/modules/mod_defaultmenu/tmpl/default_component.php	JROOT/modules/mod_defaultmenu/tmpl/default.php:72
11	require JROOT/modules/mod_defaultmenu/tmpl/default.php	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:25
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:1198
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:279
1	JApplicationCms->execute()	JROOT/index.php:72

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

60 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT * 
  FROM `joom_kunena_topics`

```
5 × SELECT `id` 
  FROM `joom_menu`
```

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

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

2 × 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`

2 × SELECT `value` 
  FROM `joom_community_fields_values`

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

1 × SELECT * 
  FROM accessibility_images

1 × SELECT COUNT(*), MAX(id) 
  FROM joom_users

1 × SELECT * 
  FROM joom_easyblog_configs

1 × SELECT code, location 
  FROM joom_kunena_smiley

1 × SELECT userid, MAX(time) AS time 
  FROM joom_session

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

1 × SELECT COUNT(*) 
  FROM joom_session

1 × SELECT * 
  FROM joom_community_config

1 × SELECT * 
  FROM axs_notifications

1 × SELECT     SUM(time>=1743638400 
  AND parent=0) AS todayTopicCount,     SUM(time>=1743638400 
  AND parent>0) AS todayReplyCount,     SUM(time>=1743552000 
  AND time<1743638400 
  AND parent=0) AS yesterdayTopicCount,     SUM(time>=1743552000 
  AND time<1743638400 
  AND parent>0) AS yesterdayReplyCount     
  FROM joom_kunena_messages

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

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM joom_users AS u    
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid

1 × SELECT `id` 
  FROM `joom_community_fields`

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 `id` 
  FROM `joom_users`
```

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.`cover` as _cover ,  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.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  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` 
  AND s.`client_id` !='1'

1 × SELECT * 
  FROM joom_kunena_announcement

1 × SELECT language,id 
  FROM `joom_menu`

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`

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

1 × SELECT `session_id` 
  FROM `joom_session`

1 × SELECT groupid 
  FROM joom_community_groups_members

1 × SELECT * 
  FROM joom_kunena_topics

1 × SELECT * 
  FROM axs_payment_gateways

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_email_settings

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

1 × SELECT * 
  FROM joom_kunena_categories

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 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 * 
  FROM joom_kunena_configuration

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 user_id, category_id, role 
  FROM joom_kunena_user_categories

1 × SELECT special_characters 
  FROM joom_languages

OTHER Tables:

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"9b1736cf545fc8e642270b6d7298219b\"}'

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_kunena_topics

1 × SHOW FULL COLUMNS 
  FROM `joom_community_config

1 × SHOW FULL COLUMNS 
  FROM `joom_community_profiles

Notice

Main Forum

Statistics

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

73 Queries Logged 608.50 ms

6 duplicate found!

60 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: