Kunena: User List (140/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
4171	Offline	yzozen	1	03 Jun 2020 11:21	04 Jun 2020 01:01	679
4172	Offline	yzupykec	0	19 May 2020 21:52	19 May 2020 22:48	541
4173	Offline	yzuwev	1	17 Apr 2020 15:14	17 Apr 2020 15:15	698
4174	Offline	yzygy	1	09 May 2020 06:25	09 May 2020 06:25	654
4175	Offline	yzywucuh	1	19 Jun 2020 14:45	19 Jun 2020 14:46	648
4176	Offline	zabenotam	1	15 Aug 2020 05:05	15 Aug 2020 05:06	706
4177	Offline	Zacesebaqoo	0	25 Jun 2020 07:13	26 Sep 2020 02:42	552
4178	Offline	zaimdncew	0	29 May 2020 17:41	29 May 2020 17:41	580
4179	Offline	Zalomaev614	0	27 Aug 2020 00:12	27 Aug 2020 12:31	534
4180	Offline	Zara11	1	27 Aug 2020 08:07	27 Aug 2020 08:08	706
4181	Offline	zasem	1	10 Sep 2020 13:05	10 Sep 2020 13:06	621
4182	Offline	zaxoryke	1	16 Jun 2020 17:56	16 Jun 2020 17:57	644
4183	Offline	zeboweb	1	22 Sep 2020 01:31	22 Sep 2020 02:27	703
4184	Offline	zedynezaw	1	07 Jul 2020 20:50	07 Jul 2020 20:52	654
4185	Offline	Zekbrive	0	16 May 2020 20:08	17 May 2020 17:47	642
4186	Offline	zeloq	1	09 Jul 2020 23:34	09 Jul 2020 23:35	642
4187	Offline	zepore	1	13 Aug 2020 02:41	13 Aug 2020 02:43	609
4188	Offline	zeqoqyp	1	25 Jul 2020 23:46	25 Jul 2020 23:46	577
4189	Offline	zerobu	1	01 Sep 2020 23:48	01 Sep 2020 23:50	704
4190	Offline	ZeveGeoni	0	20 Sep 2020 10:01	21 Sep 2020 11:19	543
4191	Offline	zewesir	1	15 Sep 2020 06:58	15 Sep 2020 07:00	655
4192	Offline	Zhuk771	0	23 Jun 2020 14:40	24 Jun 2020 02:09	560
4193	Offline	zibafa	1	23 Jul 2020 23:48	23 Jul 2020 23:49	604
4194	Offline	zicomy	1	02 Jun 2020 22:28	02 Jun 2020 22:29	649
4195	Offline	zifoxe	1	03 Aug 2020 08:23	03 Aug 2020 08:24	679
4196	Offline	zijary	0	18 Jun 2020 09:55	18 Jun 2020 09:56	566
4197	Offline	ZJDavid	0	21 Jul 2020 00:26	21 Jul 2020 00:26	605
4198	Offline	zodefege	1	09 Jul 2020 16:12	09 Jul 2020 16:14	660
4199	Offline	zollia998	1	13 Jun 2020 14:12	13 Jun 2020 14:12	650
4200	Offline	zolyqoc	1	09 Jul 2020 21:07	09 Jul 2020 21:09	619

Who Is Online

Total users online: 0 Members and 493 Guests Online

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

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 10,
            "timer": {
                "start": 1786632322,
                "last": 1786632327,
                "now": 1786632328
            },
            "client": {
                "forwarded": "10.9.77.18"
            },
            "token": "frtWwxCC64t24y901inTawCF9bi5EJtD"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                },
                "topic": {
                    "lasthit": 61441
                },
                "users_172_list_start": 4170
            }
        },
        "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: 20.94 ms / 20.94 ms Memory: 1.995 MB / 2.38 MB Application: afterLoad

Time: 54.42 ms / 75.36 ms Memory: 4.485 MB / 6.86 MB Application: afterInitialise

Time: 35.13 ms / 110.48 ms Memory: 1.954 MB / 8.81 MB Application: afterRoute

Time: 5.40 ms / 115.88 ms Memory: 0.233 MB / 9.05 MB Application: beforeRenderComponent com_kunena

Time: 27.21 ms / 143.09 ms Memory: 2.097 MB / 11.14 MB Application: Before Access::preloadComponents (all components)

Time: 1.01 ms / 144.11 ms Memory: 0.061 MB / 11.20 MB Application: After Access::preloadComponents (all components)

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

Time: 0.43 ms / 144.56 ms Memory: 0.026 MB / 11.23 MB Application: After Access::getAssetRules (id:185 name:com_kunena)

Time: 65.94 ms / 210.49 ms Memory: 2.045 MB / 13.27 MB Application: afterRenderComponent com_kunena

Time: 1.96 ms / 212.45 ms Memory: 0.111 MB / 13.38 MB Application: afterDispatch

Time: 9.73 ms / 222.19 ms Memory: 0.295 MB / 13.68 MB Application: beforeRenderModule mod_custom (Our Address)

Time: 0.84 ms / 223.03 ms Memory: 0.035 MB / 13.71 MB Application: afterRenderModule mod_custom (Our Address)

Time: 0.03 ms / 223.06 ms Memory: -0.001 MB / 13.71 MB Application: beforeRenderModule mod_menu (Social)

Time: 1.32 ms / 224.38 ms Memory: 0.044 MB / 13.76 MB Application: afterRenderModule mod_menu (Social)

Time: 0.06 ms / 224.44 ms Memory: -0.002 MB / 13.75 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrums)

Time: 0.77 ms / 225.21 ms Memory: 0.024 MB / 13.78 MB Application: afterRenderModule mod_breadcrumbs (Breadcrums)

Time: 0.06 ms / 225.26 ms Memory: -0.001 MB / 13.78 MB Application: beforeRenderModule mod_as_superfish_menu (Main Menu)

Time: 2.75 ms / 228.01 ms Memory: 0.738 MB / 14.51 MB Application: afterRenderModule mod_as_superfish_menu (Main Menu)

Time: 2.30 ms / 230.32 ms Memory: 0.272 MB / 14.79 MB Application: afterRender

Database queries total: 40.75 ms

Memory Usage

Database Queries

33 Queries Logged 40.75 ms

Query Time: 0.53 ms

SHOW VARIABLES LIKE 'query_cache_type'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.44 ms After last query: 0.05 ms

SHOW VARIABLES LIKE 'have_profiling'

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 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.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
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.51 ms After last query: 4.25 ms

SELECT `data`

  FROM `ce860_session`

  WHERE `session_id` = X'6331336533626130646431313430323235653331666431653331303638343538'

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

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.41 ms After last query: 2.14 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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.44 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.48 ms After last query: 0.09 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.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.33 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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.96 ms After last query: 0.65 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.12 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.01 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.03 ms
Executing	0.01 ms
Filling schema table	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 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.12 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.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 0.95 ms After last query: 32.77 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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 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: 1.07 ms After last query: 14.66 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.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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/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.59 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.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.57 ms After last query: 9.93 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.55 ms After last query: 3.03 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	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.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.55 ms After last query: 0.96 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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.40 ms After last query: 0.25 ms

UPDATE `ce860_extensions`

  SET `params` = '{\"mediaversion\":\"5f81a8ba4917a756885cfd913371e8ab\"}'

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

Explain

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

Profile

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

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.50 ms After last query: 1.93 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.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 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.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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.61 ms After last query: 0.21 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.10 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.02 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.11 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.72 ms After last query: 2.73 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.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 0.87 ms After last query: 15.55 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.01 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.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	1.63 ms
Removing tmp table	0.05 ms
Sending data	0.01 ms
End of update loop	0.01 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.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.80 ms After last query: 7.88 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

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.38 ms After last query: 0.06 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.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.04 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.39 ms After last query: 1.00 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.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	2.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.85 ms After last query: 7.48 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-08-13 14:45:28') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-13 14:45:28') 
  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.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 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.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 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: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.41 ms After last query: 2.22 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	13.11 ms
End of update loop	0.08 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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: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.47 ms After last query: 0.08 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.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 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: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: 13.65 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 4170, 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.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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.89 ms After last query: 0.18 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 (2631,2083,1295,1821,3397,5616,3581,2494,6111,6130,6813,3269,7276,4031,2003,4098,5536,4869,6400,7208,7003,3525,4757,2619,5148,3357,4619,4088,3055,4095)

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.08 ms
checking permissions	0.01 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.17 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.06 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
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.57 ms After last query: 6.88 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting for group	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 1.10 ms After last query: 3.34 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.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.61 ms After last query: 1.45 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 13.56 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	447	Using where

Profile

Status	Duration
Starting	0.11 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.43 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.05 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.40 ms After last query: 3.61 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\":\"5f81a8ba4917a756885cfd913371e8ab\"}'

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `ce860_kunena_categories