Kunena: Profile for wholesale

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in libraries/kunena/menu/helper.php on line 99

Welcome, Guest

Forum

Profile for wholesale

Offline
Rank: New Member
Register Date: 23 Jul 2020
Last Visit Date: 09 Jun 2026
Time Zone: GMT +0:00
Local Time: 00:52
Posts: 14
Profile Views: 1171
Karma: 0

Location: Unknown
Gender: Unknown
Birthdate: Unknown

Signature

Posts

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1785372731,
                "last": 1785372733,
                "now": 1785372736
            },
            "client": {
                "forwarded": "10.1.117.36"
            },
            "token": "44P0pVjodpfMKZrm8F1o8kwrYd8P2BYd"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                },
                "category2_html_list_start": 80
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 17.68 ms / 17.68 ms Memory: 1.995 MB / 2.37 MB Application: afterLoad

Time: 42.13 ms / 59.81 ms Memory: 4.483 MB / 6.86 MB Application: afterInitialise

Time: 22.62 ms / 82.43 ms Memory: 1.939 MB / 8.80 MB Application: afterRoute

Time: 3.88 ms / 86.31 ms Memory: 0.233 MB / 9.03 MB Application: beforeRenderComponent com_kunena

Time: 20.89 ms / 107.20 ms Memory: 2.097 MB / 11.13 MB Application: Before Access::preloadComponents (all components)

Time: 0.86 ms / 108.05 ms Memory: 0.061 MB / 11.19 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 108.08 ms Memory: -0.005 MB / 11.18 MB Application: Before Access::getAssetRules (id:185 name:com_kunena)

Time: 0.42 ms / 108.50 ms Memory: 0.026 MB / 11.21 MB Application: After Access::getAssetRules (id:185 name:com_kunena)

Time: 69.49 ms / 177.99 ms Memory: 5.492 MB / 16.70 MB Application: afterRenderComponent com_kunena

Time: 1.37 ms / 179.36 ms Memory: 0.097 MB / 16.80 MB Application: afterDispatch

Time: 9.34 ms / 188.70 ms Memory: 0.351 MB / 17.15 MB Application: beforeRenderModule mod_custom (Our Address)

Time: 0.80 ms / 189.50 ms Memory: 0.035 MB / 17.18 MB Application: afterRenderModule mod_custom (Our Address)

Time: 0.03 ms / 189.53 ms Memory: -0.001 MB / 17.18 MB Application: beforeRenderModule mod_menu (Social)

Time: 1.32 ms / 190.85 ms Memory: 0.044 MB / 17.23 MB Application: afterRenderModule mod_menu (Social)

Time: 0.05 ms / 190.90 ms Memory: -0.002 MB / 17.22 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrums)

Time: 0.80 ms / 191.70 ms Memory: 0.024 MB / 17.25 MB Application: afterRenderModule mod_breadcrumbs (Breadcrums)

Time: 0.05 ms / 191.75 ms Memory: -0.001 MB / 17.25 MB Application: beforeRenderModule mod_as_superfish_menu (Main Menu)

Time: 2.02 ms / 193.78 ms Memory: 0.113 MB / 17.36 MB Application: afterRenderModule mod_as_superfish_menu (Main Menu)

Time: 2.16 ms / 195.93 ms Memory: 0.177 MB / 17.54 MB Application: afterRender

Database queries total: 24.34 ms

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:604
10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT/libraries/joomla/database/driver/pdomysql.php:160
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:590
10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:165
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_session	const	PRIMARY	PRIMARY	194	const	1

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_extensions	ref	extension	extension	82	const	38	Using index condition; Using where

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

#	Caller	File and line number
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

#	Caller	File and line number
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	229	Using where; Using filesort

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

#	Caller	File and line number
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	64	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.m.component_id	1	Using where

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

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

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_kunena_configuration	const	PRIMARY	PRIMARY	4	const	1

#	Caller	File and line number
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1227
18	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1174
17	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
16	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:429
15	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
14	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:759
13	JLoader::_load()	JROOT/libraries/loader.php:707
12	JLoader::_autoload()	Same as call in the line below.
11	spl_autoload_call()	JROOT/components/com_kunena/router.php:275
10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_kunena_aliases	range	alias	alias	767	NULL	1	Using where

#	Caller	File and line number
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:403
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:290
10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

#	Caller	File and line number
7	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

#	Caller	File and line number
6	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
16	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:85
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:99
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:25
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:49
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:96
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

EXPLAIN not possible on query: UPDATE `ce860_kunena_users` SET `view`='',`moderator`='0',`ordering`='0',`posts`='14',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='1171',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`='' WHERE `userid`='4712'

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Executing	0.01 ms
Sending data	1.58 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/kunena/tables/kunena.php:302
18	KunenaTable->updateObject()	JROOT/libraries/kunena/tables/kunena.php:145
17	KunenaTable->store()	JROOT/libraries/kunena/user/user.php:321
16	KunenaUser->save()	JROOT/components/com_kunena/views/user/view.html.php:243
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.90 ms After last query: 0.08 ms

Duplicate queries: #20

SELECT DISTINCT(user_id)

  FROM ce860_usergroups as ug1

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

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

  WHERE ug1.id IN (8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	7070	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:435
20	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:485
19	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:229
18	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:111
17	KunenaAccess->clearCache()	JROOT/libraries/kunena/user/user.php:327
16	KunenaUser->save()	JROOT/components/com_kunena/views/user/view.html.php:243
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.84 ms After last query: 0.06 ms

Duplicate queries: #21

SELECT DISTINCT(user_id)

  FROM ce860_usergroups as ug1

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

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

  WHERE ug1.id IN (7)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	7070	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:435
20	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:485
19	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:229
18	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:111
17	KunenaAccess->clearCache()	JROOT/libraries/kunena/user/user.php:327
16	KunenaUser->save()	JROOT/components/com_kunena/views/user/view.html.php:243
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.04 ms

Duplicate queries: #22

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

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:119
17	KunenaAccess->clearCache()	JROOT/libraries/kunena/user/user.php:327
16	KunenaUser->save()	JROOT/components/com_kunena/views/user/view.html.php:243
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 6.66 ms

SELECT * 
  FROM ce860_kunena_categories 
  ORDER BY ordering, name

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
39	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:805
37	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:42
36	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:892
35	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
34	JLoader::_load()	JROOT/libraries/loader.php:707
33	JLoader::_autoload()	Same as call in the line below.
32	spl_autoload_call()	JROOT/libraries/kunena/forum/message/helper.php:207
31	KunenaForumMessageHelper::getLatestMessages()	JROOT/components/com_kunena/models/topics.php:375
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 1.61 ms

SELECT COUNT(*)

  FROM ce860_kunena_messages AS m

  INNER JOIN ce860_kunena_messages_text AS t 
  ON m.id = t.mesid

  WHERE m.moved=0 
  AND m.catid IN (2,3) 
  AND m.hold=0 
  AND m.userid='4712' 
  AND m.time>'1753836736'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref\|filter	PRIMARY,userid,time,hold_time,catid_parent	userid\|time	4\|4	const	14 (0%)	Using where; Using rowid filter
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.m.id	1	Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
32	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/message/helper.php:259
31	KunenaForumMessageHelper::getLatestMessages()	JROOT/components/com_kunena/models/topics.php:375
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.07 ms

SELECT m.*, t.message

  FROM ce860_kunena_messages AS m

  INNER JOIN ce860_kunena_messages_text AS t 
  ON m.id = t.mesid

  WHERE m.moved=0 
  AND m.catid IN (2,3) 
  AND m.hold=0 
  AND m.userid='4712' 
  AND m.time>'1753836736'

  ORDER BY m.time DESC 
  LIMIT 6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref\|filter	PRIMARY,userid,time,hold_time,catid_parent	userid\|time	4\|4	const	14 (0%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.m.id	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
32	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/message/helper.php:273
31	KunenaForumMessageHelper::getLatestMessages()	JROOT/components/com_kunena/models/topics.php:375
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 2.35 ms

SELECT * 
  FROM ce860_kunena_topics 
  WHERE id IN (61608,61609,61607,61606,61605)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_kunena_topics	range	PRIMARY	PRIMARY	4	NULL	5	Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.04 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
34	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:655
32	KunenaForumTopicHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/helper.php:141
31	KunenaForumTopicHelper::getTopics()	JROOT/components/com_kunena/models/topics.php:395
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 2.67 ms

SELECT * 
  FROM ce860_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (61608,61609,61607,61606,61605)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_kunena_user_topics	ref	user_topic_id,topic_id	user_topic_id	4	const	15	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
35	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/user/helper.php:344
34	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:86
33	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:168
32	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/models/topics.php:428
31	KunenaModelTopics->_common()	JROOT/components/com_kunena/models/topics.php:405
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.52 ms

SHOW FULL COLUMNS 
  FROM `ce860_kunena_user_topics`

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.09 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
43	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
42	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
41	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
40	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
39	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausertopics.php:33
38	TableKunenaUserTopics->__construct()	JROOT/libraries/src/Table/Table.php:328
37	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/forum/topic/user/user.php:112
36	KunenaForumTopicUser->getTable()	JROOT/libraries/kunena/forum/topic/user/user.php:45
35	KunenaForumTopicUser->__construct()	JROOT/libraries/kunena/forum/topic/user/helper.php:358
34	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:86
33	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:168
32	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/models/topics.php:428
31	KunenaModelTopics->_common()	JROOT/components/com_kunena/models/topics.php:405
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.59 ms

SELECT * 
  FROM ce860_kunena_keywords_map AS m 
  INNER JOIN ce860_kunena_keywords AS k 
  ON m.keyword_id=k.id 
  WHERE m.topic_id IN (61608,61609,61607,61606,61605) 
  AND m.user_id IN (0,0)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	keyword_user_topic,user_id,topic_user	user_id	4	const	1	Using where; Using index
1	SIMPLE	k	eq_ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.m.keyword_id	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
35	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/keyword/helper.php:267
34	KunenaKeywordHelper::loadTopics()	JROOT/libraries/kunena/keyword/helper.php:150
33	KunenaKeywordHelper::getByTopics()	JROOT/libraries/kunena/forum/topic/helper.php:184
32	KunenaForumTopicHelper::getKeywords()	JROOT/components/com_kunena/models/topics.php:429
31	KunenaModelTopics->_common()	JROOT/components/com_kunena/models/topics.php:405
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.07 ms

SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id,
				SUM(mm.time<m.time) AS before_count,
				SUM(mm.time>m.time) AS after_count
			
  FROM ce860_kunena_messages AS m
			
  INNER JOIN ce860_kunena_messages AS mm 
  ON m.thread=mm.thread
			
  WHERE m.id IN (61629,61628,61627,61626,61625,61624)
			
  GROUP BY m.id, mm.hold

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,thread	PRIMARY	4	NULL	6	Using where; Using temporary; Using filesort
1	SIMPLE	mm	ref	thread	thread	5	innov178_innovativehabitat.m.thread	1

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
34	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/message/helper.php:384
32	KunenaForumMessageHelper::loadLocation()	JROOT/components/com_kunena/models/topics.php:435
31	KunenaModelTopics->_common()	JROOT/components/com_kunena/models/topics.php:405
30	KunenaModelTopics->getPosts()	JROOT/components/com_kunena/models/topics.php:444
29	KunenaModelTopics->getMessages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
28	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
27	KunenaView->get()	JROOT/components/com_kunena/views/topics/view.html.php:82
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 10.48 ms

SELECT code, location 
  FROM ce860_kunena_smileys

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.43 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
40	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
39	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1002
38	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:42
37	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:75
36	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:130
35	KunenaHtmlParser::stripBBCode()	JROOT/components/com_kunena/template/astemplate/html/topics/posts_row.php:31
34	include JROOT/components/com_kunena/template/astemplate/html/topics/posts_row.php	JROOT/libraries/kunena/view.php:706
33	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/topics/view.html.php:264
32	KunenaViewTopics->displayPostRows()	JROOT/components/com_kunena/views/topics/view.html.php:111
31	KunenaViewTopics->displayRows()	JROOT/components/com_kunena/template/astemplate/html/topics/posts_embed.php:32
30	include JROOT/components/com_kunena/template/astemplate/html/topics/posts_embed.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
29	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
28	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
27	KunenaView->render()	JROOT/components/com_kunena/views/topics/view.html.php:104
26	KunenaViewTopics->displayPosts()	JROOT/libraries/kunena/view.php:195
25	KunenaView->displayLayout()	JROOT/libraries/kunena/forum/forum.php:394
24	KunenaForum::display()	JROOT/components/com_kunena/views/user/view.html.php:292
23	KunenaViewUser->displayUserPosts()	JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php:63
22	include JROOT/components/com_kunena/template/astemplate/html/user/default_tab.php	JROOT/libraries/kunena/view.php:706
21	KunenaView->loadTemplateFile()	JROOT/components/com_kunena/views/user/view.html.php:456
20	KunenaViewUser->displayTab()	JROOT/components/com_kunena/template/astemplate/html/user/default.php:30
19	include JROOT/components/com_kunena/template/astemplate/html/user/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
17	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
16	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:260
15	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:23
14	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:195
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/astemplate/html/display.php:22
12	include JROOT/components/com_kunena/template/astemplate/html/display.php	JROOT/libraries/kunena/view.php:126
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:398
10	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:68
9	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:157
8	KunenaController->executeTask()	JROOT/libraries/kunena/controller.php:215
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 10.37 ms

SELECT template 
  FROM ce860_template_styles 
  WHERE client_id = 1 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/innovativehabitat/includes/includes.php:31
8	include_once JROOT/templates/innovativehabitat/includes/includes.php	JROOT/templates/innovativehabitat/index.php:15
7	require JROOT/templates/innovativehabitat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT DISTINCT(user_id) 
  FROM ce860_usergroups as ug1 
  INNER JOIN ce860_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN ce860_user_usergroup_map AS m 
  ON ug2.id=m.group_id

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

2 × SELECT template 
  FROM ce860_template_styles

2 × SELECT user_id, category_id, role 
  FROM ce860_kunena_user_categories

1 × SELECT `data` 
  FROM `ce860_session`

1 × SELECT * 
  FROM ce860_kunena_attachments

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

1 × SELECT * 
  FROM ce860_kunena_users_banned

1 × SELECT * 
  FROM ce860_kunena_categories

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `ce860_usergroups` AS g 
  INNER JOIN `ce860_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT COUNT(*) 
  FROM ce860_kunena_messages AS m 
  INNER JOIN ce860_kunena_messages_text AS t 
  ON m.id = t.mesid

1 × SELECT m.*, t.message 
  FROM ce860_kunena_messages AS m 
  INNER JOIN ce860_kunena_messages_text AS t 
  ON m.id = t.mesid

1 × SELECT * 
  FROM ce860_kunena_topics

1 × SELECT * 
  FROM ce860_kunena_user_topics

1 × SELECT * 
  FROM ce860_kunena_keywords_map AS m 
  INNER JOIN ce860_kunena_keywords AS k 
  ON m.keyword_id=k.id

1 × SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id,
     SUM(mm.time<m.time) AS before_count,
     SUM(mm.time>m.time) AS after_count
    
  FROM ce860_kunena_messages AS m
    
  INNER JOIN ce860_kunena_messages AS mm 
  ON m.thread=mm.thread

1 × SELECT * 
  FROM ce860_kunena_rank

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

```
1 × SELECT * 
  FROM `ce860_users`
```

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

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

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

```
1 × SELECT * 
  FROM ce860_languages
```

1 × SELECT * 
  FROM ce860_kunena_aliases

1 × SELECT * 
  FROM ce860_kunena_configuration

1 × SELECT * 
  FROM ce860_komento_configs

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM ce860_extensions

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

1 × SELECT id, rules 
  FROM `ce860_viewlevels

1 × SELECT code, location 
  FROM ce860_kunena_smiley

OTHER Tables:

1 × SHOW VARIABLES LIKE 'query_cache_type

1 × SHOW VARIABLES LIKE 'have_profiling

1 × SHOW FULL COLUMNS 
  FROM `ce860_komento_configs

1 × UPDATE `ce860_extensions` 
  SET `params` = '{\"mediaversion\":\"6d9071af1362e5ac1d440a9b8d9a7934\"}'

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `ce860_users

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_users_banned

1 × UPDATE `ce860_kunena_users` 
  SET `view`='',`moderator`='0',`ordering`='0',`posts`='14',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='1171',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`=''

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_user_topics

Profile for wholesale

Signature

Recent Posts

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

47 Queries Logged 24.34 ms

6 duplicate found!

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	23	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	innov178_innovativehabitat.m.module,const	1	Using index condition; Using where