Kunena: User List (5/141)

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

Innovative Habitat has 4210 registered users

Userlist

#	Status	Username	Posts	Join date	Last login	Hits
121	Offline	ahevaz	1	01 Apr 2020 09:53	01 Apr 2020 10:09	893
122	Offline	ahezobyl	0	31 Jul 2020 15:52	31 Jul 2020 15:55	618
123	Offline	Ahimen	0	28 Aug 2020 17:11	28 Aug 2020 17:11	701
124	Offline	ahisenys	1	17 Sep 2020 19:22	17 Sep 2020 19:23	639
125	Offline	ahodycy	1	24 May 2020 17:56	24 May 2020 17:58	816
126	Offline	Ahomen	0	15 Aug 2020 15:16	15 Aug 2020 15:16	664
127	Offline	ahonosesu	1	04 Apr 2020 14:18	04 Apr 2020 14:20	794
128	Offline	Ahrmen	0	16 Aug 2020 20:34	16 Aug 2020 20:34	673
129	Offline	Ahumen	0	18 Aug 2020 00:11	18 Aug 2020 00:11	672
130	Offline	ahyceb	1	24 Aug 2020 11:14	24 Aug 2020 11:16	696
131	Offline	ahypyjo	1	12 Aug 2020 13:43	12 Aug 2020 13:44	774
132	Offline	ahyrowefe	1	15 Sep 2020 15:11	15 Sep 2020 15:12	634
133	Offline	ahysuh	1	04 Jul 2020 15:15	04 Jul 2020 15:15	765
134	Offline	Aidext	0	08 Jun 2020 19:38	08 Jun 2020 19:41	654
135	Offline	Aidmen	0	31 Aug 2020 20:55	31 Aug 2020 20:55	721
136	Offline	AikWhath	0	01 Sep 2020 19:57	01 Sep 2020 19:57	621
137	Offline	AimWhath	0	03 Sep 2020 15:25	03 Sep 2020 15:25	586
138	Offline	Airmen	0	08 Sep 2020 06:41	08 Sep 2020 06:41	665
139	Offline	airstrikes	1	15 Aug 2020 11:05	15 Aug 2020 11:25	748
140	Offline	AirWhath	0	05 Sep 2020 10:33	05 Sep 2020 10:33	599
141	Offline	ajakoduge	1	11 Jun 2020 01:34	11 Jun 2020 01:35	710
142	Offline	ajesa	1	10 May 2020 16:07	10 May 2020 16:09	793
143	Offline	ajesita	0	02 Aug 2020 13:16	03 Aug 2020 03:51	608
144	Offline	ajolexa	1	14 Jun 2020 22:56	14 Jun 2020 23:00	683
145	Offline	ajowir	1	29 Apr 2020 04:56	29 Apr 2020 05:15	731
146	Offline	ajurodi	1	02 May 2020 19:20	02 May 2020 19:22	761
147	Offline	ajuwimob	1	26 Aug 2020 10:04	26 Aug 2020 10:06	648
148	Offline	ajycoboky	1	19 Apr 2020 02:11	19 Apr 2020 04:58	813
149	Offline	ajycynebo	1	05 May 2020 10:18	05 May 2020 15:05	842
150	Offline	ajyfut	1	20 Aug 2020 12:24	20 Aug 2020 12:25	757

Who Is Online

Total users online: 0 Members and 455 Guests Online

Legend: Site Administrator, Global Moderator, Moderator, Banned, User, Guest

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1790526318,
                "last": 1790526318,
                "now": 1790526320
            },
            "client": {
                "forwarded": "10.3.136.227"
            },
            "token": "ie7cvysFhKFA8aZQOKy6WpZGePCaIJjj"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                },
                "users_172_list_start": 120
            }
        },
        "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: 18.48 ms / 18.48 ms Memory: 2.171 MB / 7.63 MB Application: afterLoad

Time: 46.82 ms / 65.30 ms Memory: 4.324 MB / 11.96 MB Application: afterInitialise

Time: 24.38 ms / 89.68 ms Memory: 1.891 MB / 13.85 MB Application: afterRoute

Time: 4.84 ms / 94.52 ms Memory: 0.296 MB / 14.14 MB Application: beforeRenderComponent com_kunena

Time: 21.21 ms / 115.72 ms Memory: 2.096 MB / 16.24 MB Application: Before Access::preloadComponents (all components)

Time: 1.09 ms / 116.81 ms Memory: 0.061 MB / 16.30 MB Application: After Access::preloadComponents (all components)

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

Time: 0.41 ms / 117.24 ms Memory: 0.026 MB / 16.32 MB Application: After Access::getAssetRules (id:185 name:com_kunena)

Time: 53.56 ms / 170.81 ms Memory: 2.609 MB / 18.93 MB Application: afterRenderComponent com_kunena

Time: 1.86 ms / 172.66 ms Memory: 0.111 MB / 19.04 MB Application: afterDispatch

Time: 9.58 ms / 182.24 ms Memory: 0.357 MB / 19.40 MB Application: beforeRenderModule mod_custom (Our Address)

Time: 0.81 ms / 183.05 ms Memory: 0.035 MB / 19.43 MB Application: afterRenderModule mod_custom (Our Address)

Time: 0.03 ms / 183.08 ms Memory: -0.001 MB / 19.43 MB Application: beforeRenderModule mod_menu (Social)

Time: 1.33 ms / 184.41 ms Memory: 0.044 MB / 19.48 MB Application: afterRenderModule mod_menu (Social)

Time: 0.05 ms / 184.46 ms Memory: -0.002 MB / 19.47 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrums)

Time: 0.81 ms / 185.27 ms Memory: 0.024 MB / 19.50 MB Application: afterRenderModule mod_breadcrumbs (Breadcrums)

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

Time: 2.13 ms / 187.45 ms Memory: 0.113 MB / 19.61 MB Application: afterRenderModule mod_as_superfish_menu (Main Menu)

Time: 2.31 ms / 189.76 ms Memory: 0.209 MB / 19.82 MB Application: afterRender

Database queries total: 33.54 ms

Memory Usage

Database Queries

33 Queries Logged 33.54 ms

Query Time: 0.58 ms

SHOW VARIABLES LIKE 'query_cache_type'

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE 'query_cache_type'

Profile

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

Call Stack

#	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

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

Query Time: 0.45 ms After last query: 0.08 ms

SHOW VARIABLES LIKE 'have_profiling'

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE 'have_profiling'

Profile

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

Call Stack

#	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

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

Query Time: 0.68 ms After last query: 4.94 ms

SELECT `data`

  FROM `ce860_session`

  WHERE `session_id` = X'6430623434333264383932643539373338613333643434353838313338393561'

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.65 ms After last query: 3.15 ms

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

  FROM `ce860_extensions`

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

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.44 ms After last query: 1.90 ms

SELECT id, rules

  FROM `ce860_viewlevels`

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.52 ms After last query: 0.07 ms

SELECT b.id

  FROM ce860_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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

Profile

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

Call Stack

#	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

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

Query Time: 0.82 ms After last query: 0.58 ms

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

  FROM ce860_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 1.07 ms After last query: 20.01 ms

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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

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

Query Time: 0.90 ms After last query: 9.15 ms

SHOW FULL COLUMNS 
  FROM `ce860_komento_configs`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
17	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
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

[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.44 ms

SELECT *

  FROM ce860_komento_configs

  WHERE `component` = 'com_komento'

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.59 ms After last query: 7.33 ms

SELECT * 
  FROM ce860_kunena_configuration 
  WHERE id=1

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.50 ms After last query: 1.90 ms

SELECT * 
  FROM ce860_kunena_aliases 
  WHERE alias LIKE 'user%'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.05 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.10 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.05 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	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

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

Query Time: 0.51 ms After last query: 0.61 ms

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

  FROM `ce860_extensions`

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

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.57 ms After last query: 0.13 ms

UPDATE `ce860_extensions`

  SET `params` = '{\"mediaversion\":\"e5655f08745a3af88ba188ed2fe00753\"}'

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

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.51 ms After last query: 1.62 ms

SELECT *

  FROM ce860_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.58 ms After last query: 0.18 ms

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

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

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.79 ms After last query: 2.21 ms

SHOW FULL COLUMNS 
  FROM `ce860_kunena_sessions`

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 1.06 ms After last query: 10.25 ms

SHOW FULL COLUMNS 
  FROM `ce860_kunena_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
21	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:278
18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:246
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:269
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:92
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:46
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
11	JLoader::_load()	JROOT/libraries/loader.php:707
10	JLoader::_autoload()	Same as call in the line below.
9	spl_autoload_call()	JROOT/libraries/kunena/controller.php:29
8	KunenaController->__construct()	JROOT/libraries/kunena/controller.php:116
7	KunenaController::getInstance()	JROOT/components/com_kunena/kunena.php:101
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.89 ms After last query: 7.39 ms

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

  FROM `ce860_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_assets	range	idx_asset_name	idx_asset_name	202	NULL	39	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:454
17	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:229
16	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:111
15	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:75
14	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:87
13	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:435
12	KunenaUser->isAdmin()	JROOT/libraries/kunena/view.php:77
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: 2.36 ms After last query: 0.58 ms

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.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:435
18	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:485
17	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:229
16	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:111
15	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:75
14	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:87
13	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:435
12	KunenaUser->isAdmin()	JROOT/libraries/kunena/view.php:77
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: 2.22 ms After last query: 0.37 ms

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.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:435
18	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:485
17	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:229
16	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:111
15	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:75
14	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:87
13	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:435
12	KunenaUser->isAdmin()	JROOT/libraries/kunena/view.php:77
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.45 ms After last query: 0.05 ms

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.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.24 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:119
15	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:75
14	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:87
13	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:435
12	KunenaUser->isAdmin()	JROOT/libraries/kunena/view.php:77
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.47 ms After last query: 0.97 ms

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_kunena/template/astemplate/initialize.php:20
13	require_once JROOT/components/com_kunena/template/astemplate/initialize.php	JROOT/components/com_kunena/template/astemplate/template.php:35
12	KunenaTemplateASTemplate->initialize()	JROOT/libraries/kunena/view.php:104
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.93 ms After last query: 7.24 ms

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-27 16:25:20') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-27 16:25:20') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 172 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
21	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
20	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
19	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
18	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/kunena/view.php:286
17	KunenaView->getModulePosition()	JROOT/components/com_kunena/views/common/view.html.php:476
16	KunenaViewCommon->displayLoginBox()	JROOT/libraries/kunena/view.php:195
15	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:34
14	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:524
13	KunenaView->displayLoginBox()	JROOT/components/com_kunena/template/astemplate/html/display.php:18
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: 2.40 ms After last query: 2.10 ms

SELECT COUNT(*) 
  FROM ce860_users AS u 
  WHERE (u.block=0 OR u.activation="")

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_kunena/models/user.php:153
17	KunenaModelUser->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
15	KunenaView->get()	JROOT/components/com_kunena/views/user/view.html.php:56
14	KunenaViewUser->displayList()	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: 2.52 ms After last query: 0.06 ms

SELECT COUNT(*)
				
  FROM ce860_users AS u
				
  LEFT JOIN ce860_kunena_users AS ku 
  ON ku.userid = u.id
				
  WHERE (u.block=0 OR u.activation="")

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_kunena/models/user.php:174
17	KunenaModelUser->getCount()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
15	KunenaView->get()	JROOT/components/com_kunena/views/user/view.html.php:57
14	KunenaViewUser->displayList()	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: 5.28 ms After last query: 0.06 ms

SELECT u.id
				
  FROM ce860_users AS u
				
  LEFT JOIN ce860_kunena_users AS ku 
  ON ku.userid = u.id
				
  WHERE (u.block=0 OR u.activation="")  
  ORDER BY u.username  asc 
  LIMIT 120, 30

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_kunena/models/user.php:233
17	KunenaModelUser->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
15	KunenaView->get()	JROOT/components/com_kunena/views/user/view.html.php:58
14	KunenaViewUser->displayList()	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.86 ms After last query: 0.08 ms

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
				
  FROM ce860_users AS u
				
  LEFT JOIN ce860_kunena_users AS ku 
  ON u.id = ku.userid
				
  WHERE u.id IN (1130,5071,6204,7107,2244,5630,1167,5657,5707,5993,5518,7021,3912,2786,6324,6388,6507,6712,5623,6593,2870,1841,5119,3114,1657,1713,6074,1320,1769,5830)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u	range	PRIMARY	PRIMARY	4	NULL	30	Using where
1	SIMPLE	ku	eq_ref	PRIMARY	PRIMARY	4	innov178_innovativehabitat.u.id	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:182
18	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/models/user.php:237
17	KunenaModelUser->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:335
15	KunenaView->get()	JROOT/components/com_kunena/views/user/view.html.php:58
14	KunenaViewUser->displayList()	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.58 ms After last query: 4.76 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.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting for group	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:805
29	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:42
28	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:892
27	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
26	JLoader::_load()	JROOT/libraries/loader.php:707
25	JLoader::_autoload()	Same as call in the line below.
24	spl_autoload_call()	JROOT/libraries/kunena/access.php:535
23	KunenaAccess->getAllowedCategories()	JROOT/components/com_kunena/views/common/view.html.php:123
22	KunenaViewCommon->displayForumJump()	JROOT/libraries/kunena/view.php:195
21	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:34
20	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:543
19	KunenaView->displayForumJump()	JROOT/components/com_kunena/template/astemplate/html/user/list.php:41
18	include JROOT/components/com_kunena/template/astemplate/html/user/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
17	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
15	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:64
14	KunenaViewUser->displayList()	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.97 ms After last query: 2.93 ms

SHOW FULL COLUMNS 
  FROM `ce860_kunena_categories`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
37	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
35	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
34	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
33	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:58
32	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:328
31	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:282
30	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
29	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1012
28	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:87
27	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:51
26	JHtmlKunenaForum::categorylist()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
24	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
23	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_kunena/views/common/view.html.php:134
22	KunenaViewCommon->displayForumJump()	JROOT/libraries/kunena/view.php:195
21	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:34
20	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:543
19	KunenaView->displayForumJump()	JROOT/components/com_kunena/template/astemplate/html/user/list.php:41
18	include JROOT/components/com_kunena/template/astemplate/html/user/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
17	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
15	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:64
14	KunenaViewUser->displayList()	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.65 ms After last query: 1.26 ms

SELECT userid, MAX(time) AS time

  FROM ce860_session

  WHERE client_id=0 
  AND userid>0

  GROUP BY userid

  ORDER BY time DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_session	range	userid,client_id_guest	userid	5	NULL	1	Using index condition; Using where; Using temporary; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:303
21	KunenaUserHelper::getOnlineUsers()	JROOT/libraries/kunena/user/helper.php:379
20	KunenaUserHelper::isOnline()	JROOT/libraries/kunena/user/user.php:370
19	KunenaUser->isOnline()	JROOT/components/com_kunena/template/astemplate/html/user/list.php:130
18	include JROOT/components/com_kunena/template/astemplate/html/user/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
17	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
15	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:64
14	KunenaViewUser->displayList()	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.75 ms After last query: 12.49 ms

SELECT COUNT(*)

  FROM ce860_session

  WHERE client_id=0 
  AND userid=0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ce860_session	ALL	userid,client_id_guest	NO INDEX KEY COULD BE USED	NULL	NULL	416	Using where

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/user/helper.php:344
23	KunenaUserHelper::getOnlineCount()	JROOT/components/com_kunena/views/common/view.html.php:268
22	KunenaViewCommon->displayWhosonline()	JROOT/libraries/kunena/view.php:195
21	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:34
20	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:551
19	KunenaView->displayWhoIsOnline()	JROOT/components/com_kunena/template/astemplate/html/user/list.php:186
18	include JROOT/components/com_kunena/template/astemplate/html/user/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
17	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/kunena/view.php:265
15	KunenaView->render()	JROOT/components/com_kunena/views/user/view.html.php:64
14	KunenaViewUser->displayList()	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.52 ms After last query: 3.36 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.]

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × 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 template 
  FROM ce860_template_styles

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

1 × SELECT `data` 
  FROM `ce860_session`

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

1 × SELECT * 
  FROM ce860_kunena_categories

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

1 × SELECT u.id
     
  FROM ce860_users AS u
     
  LEFT JOIN ce860_kunena_users AS ku 
  ON ku.userid = u.id

1 × SELECT COUNT(*)
     
  FROM ce860_users AS u
     
  LEFT JOIN ce860_kunena_users AS ku 
  ON ku.userid = u.id

1 × SELECT COUNT(*) 
  FROM ce860_users AS u

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

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 COUNT(*) 
  FROM ce860_session

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\":\"e5655f08745a3af88ba188ed2fe00753\"}'

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_categories