Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714817930,
                "last": 1714817930,
                "now": 1714817930
            }
        },
        "registry": {},
        "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
        },
        "com_mailto": {
            "links": {
                "2420517d3c3940607fe93fa709bd5c4eaf7b2993": {
                    "link": "https:\/\/sptlkenya.com\/index.php\/component\/k2\/item\/3-the-big-business-of-smashing-bugs?tmpl=component&print=1",
                    "expiry": 1714817931
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

35 Queries Logged 460.39 ms

2 duplicate found!

2 duplicates: #26 #27

Query Time: 1.43 ms Query memory: 0.021 MB Memory before query: 0.933 MB Rows returned: 0

SELECT `data`

  FROM `chdg4_session`

  WHERE `session_id` = 'fmo6aa84u42c40irh7ouedd513'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	766	const	1

Profile

Status	Duration
Starting	0.15 ms
Checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.10 ms
Optimizing	0.06 ms
Statistics	0.20 ms
Preparing	0.05 ms
Executing	0.07 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.29 ms After last query: 1.91 ms Query memory: 0.012 MB Memory before query: 0.986 MB Rows returned: 0

SELECT `session_id`

  FROM `chdg4_session`

  WHERE `session_id` = 'fmo6aa84u42c40irh7ouedd513' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.06 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.07 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.61 ms After last query: 0.51 ms Query memory: 0.009 MB Memory before query: 1.001 MB

INSERT INTO `chdg4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('fmo6aa84u42c40irh7ouedd513', 1, '1714817930', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('fmo6aa84u42c40irh7ouedd513', 1, '1714817930', 0, '', 0)

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.04 ms
Init for update	0.07 ms
Update	0.33 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	1.29 ms
Closing tables	0.06 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.19 ms After last query: 2.63 ms Query memory: 0.025 MB Memory before query: 1.059 MB Rows returned: 37

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

  FROM `chdg4_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_extensions	ref	extension	extension	82	const	37	Using index condition

Profile

Status	Duration
Starting	0.17 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.05 ms
Init	0.09 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.10 ms
Executing	0.05 ms
Sending data	0.65 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.19 ms After last query: 3.61 ms Query memory: 0.015 MB Memory before query: 1.161 MB Rows returned: 0

SELECT b.id

  FROM chdg4_usergroups AS a

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

  WHERE a.id = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.06 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 0.79 ms Query memory: 0.014 MB Memory before query: 1.181 MB Rows returned: 5

SELECT id, rules

  FROM `chdg4_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.06 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.19 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.72 ms After last query: 0.74 ms Query memory: 0.017 MB Memory before query: 1.221 MB Rows returned: 76

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

  FROM chdg4_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.15 ms
Preparing	0.09 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	1.40 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.07 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.31 ms After last query: 12.32 ms Query memory: 0.013 MB Memory before query: 1.675 MB Rows returned: 1

SELECT `enabled`

  FROM `chdg4_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.08 ms
Statistics	0.20 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.65 ms After last query: 11.80 ms Query memory: 0.031 MB Memory before query: 2.029 MB Rows returned: 22

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

  LEFT JOIN chdg4_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	72	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.19 ms
Checking permissions	0.04 ms
Opening tables	0.09 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.09 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
Creating sort index	1.22 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 16.00 ms Query memory: 0.025 MB Memory before query: 2.399 MB Rows returned: 1

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

  FROM `chdg4_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.18 ms
Preparing	0.11 ms
Executing	0.04 ms
Sending data	0.13 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
18	JLibraryHelper::{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
15	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.25 ms After last query: 0.78 ms Query memory: 0.017 MB Memory before query: 2.405 MB

UPDATE `chdg4_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.17 ms
Updating	0.28 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	2.11 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.36 ms After last query: 2.29 ms Query memory: 0.022 MB Memory before query: 2.529 MB Rows returned: 1

SELECT *

  FROM chdg4_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	0.24 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:305
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.65 ms After last query: 2.11 ms Query memory: 0.039 MB Memory before query: 2.598 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM chdg4_template_styles as s

  LEFT JOIN chdg4_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.16 ms
Preparing	0.11 ms
Executing	0.03 ms
Sending data	0.42 ms
End of update loop	0.06 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.06 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
14	JHtmlJquery::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:79
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.72 ms After last query: 7.50 ms Query memory: 0.020 MB Memory before query: 2.789 MB Rows returned: 37

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

  FROM `chdg4_assets`

  WHERE `name` IN ('com_admin','com_advportfoliopro','com_ajax','com_akeeba','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_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	164	Using where

Profile

Status	Duration
Starting	0.17 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.14 ms
Optimizing	0.06 ms
Statistics	0.58 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.95 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.06 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
11	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
10	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
9	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 8.00 ms Query memory: 0.019 MB Memory before query: 3.101 MB Rows returned: 8

SELECT id 
  FROM chdg4_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_categories	ref	category,published,access,trash	category	2	const	8	Using where; Using index

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.16 ms
Preparing	0.09 ms
Executing	0.04 ms
Sending data	0.11 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 0.53 ms Query memory: 0.028 MB Memory before query: 3.119 MB Rows returned: 1

SELECT * 
  FROM chdg4_k2_items 
  WHERE id=3 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.09 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.06 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:36
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:42
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.48 ms After last query: 1.20 ms Query memory: 0.028 MB Memory before query: 3.201 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `chdg4_k2_categories`

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Closing tables	0.03 ms
Opening tables	0.70 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.27 ms
Closing tables	0.05 ms
Executing	0.03 ms
Sending data	0.12 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.27 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
14	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:74
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 1.73 ms Query memory: 0.023 MB Memory before query: 3.260 MB Rows returned: 1

SELECT * 
  FROM chdg4_k2_categories 
  WHERE id = '1'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.56 ms After last query: 1.49 ms Query memory: 0.023 MB Memory before query: 3.302 MB Rows returned: 8

SELECT id, name,  parent	
  FROM chdg4_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1) 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_categories	ref	category,published,access,trash	category	2	const	8	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.11 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.35 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1245
15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
14	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:78
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.28 ms After last query: 5.17 ms Query memory: 0.020 MB Memory before query: 3.420 MB Rows returned: 0

SELECT tag.*
		
  FROM chdg4_k2_tags AS tag
		JOIN chdg4_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 3 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	sptlkeny_sptlkenya.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.08 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1403
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.80 ms Query memory: 0.021 MB Memory before query: 3.443 MB Rows returned: 0

SELECT * 
  FROM chdg4_k2_attachments 
  WHERE itemID=3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_attachments	ref	itemID	itemID	4	const	1

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.05 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1693
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:190
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.33 ms Query memory: 0.022 MB Memory before query: 3.463 MB Rows returned: 0

SELECT * 
  FROM chdg4_k2_rating 
  WHERE itemID = 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.05 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1018
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:1074
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:196
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.48 ms After last query: 1.21 ms Query memory: 0.034 MB Memory before query: 3.513 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `chdg4_users`

Explain

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

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Closing tables	0.03 ms
Opening tables	0.68 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.08 ms
After opening tables	0.04 ms
Checking permissions	0.26 ms
Closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.26 ms
Closing tables	0.03 ms
Unlocking tables	0.04 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
19	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
18	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
17	JUser::getTable()	JROOT/libraries/joomla/user/user.php:875
16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.81 ms Query memory: 0.028 MB Memory before query: 3.580 MB Rows returned: 1

SELECT *

  FROM `chdg4_users`

  WHERE `id` = 292

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
17	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.20 ms After last query: 2.21 ms Query memory: 0.025 MB Memory before query: 4.340 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `chdg4_usergroups` AS g

  INNER JOIN `chdg4_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 292

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.m.group_id	1

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.10 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
17	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
16	JUser->load()	JROOT/libraries/joomla/user/user.php:243
15	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
14	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
13	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 4.89 ms Query memory: 0.021 MB Memory before query: 4.359 MB Rows returned: 0

Duplicate queries: #27

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM chdg4_k2_users 
  WHERE userID=292

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_users	ref	userID	userID	4	const	1

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1874
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:251
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.05 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 4.379 MB Rows returned: 0

Duplicate queries: #26

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM chdg4_k2_users 
  WHERE userID=292

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_users	ref	userID	userID	4	const	1

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1874
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:55
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:252
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 398.91 ms After last query: 0.36 ms Query memory: 0.020 MB Memory before query: 4.400 MB Rows returned: 1

SELECT COUNT(*) 
  FROM chdg4_k2_comments 
  WHERE itemID=3 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_comments	index_merge	itemID,published,latestComments,countComments	itemID,published	4,4	NULL	26729	Using intersect(itemID,published); Using where; Using index

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.26 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	397.59 ms
End of update loop	0.08 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1739
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.20 ms After last query: 7.24 ms Query memory: 0.034 MB Memory before query: 4.600 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM chdg4_fields AS a

  LEFT JOIN `chdg4_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN chdg4_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN chdg4_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN chdg4_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN chdg4_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `chdg4_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	sptlkeny_sptlkenya.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	sptlkeny_sptlkenya.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.42 ms
Checking permissions	0.04 ms
Opening tables	0.13 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.17 ms
Optimizing	0.11 ms
Statistics	0.27 ms
Preparing	0.14 ms
Creating tmp table	0.13 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	0.70 ms
Creating sort index	0.10 ms
Removing tmp table	0.18 ms
Creating sort index	0.05 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
20	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
19	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
18	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
16	PlgSystemFields->onContentPrepare()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:673
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.57 ms After last query: 3.76 ms Query memory: 0.029 MB Memory before query: 4.739 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `chdg4_k2_items`

Explain

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

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Closing tables	0.03 ms
Opening tables	0.61 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Filling schema table	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
Checking permissions	0.39 ms
Closing tables	0.05 ms
Executing	0.03 ms
Sending data	0.17 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Removing tmp table	0.24 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
14	TableK2Item->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:923
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.84 ms After last query: 1.59 ms Query memory: 0.017 MB Memory before query: 4.833 MB

UPDATE chdg4_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3'

Explain

EXPLAIN not possible on query: UPDATE chdg4_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '3'

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.06 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.15 ms
Updating	0.38 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.57 ms
Closing tables	0.04 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
13	JTable->hit()	JROOT/components/com_k2/models/item.php:924
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.07 ms After last query: 0.85 ms Query memory: 0.022 MB Memory before query: 4.850 MB Rows returned: 10

SELECT * 
  FROM chdg4_k2_comments 
  WHERE itemID=3 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_comments	range	itemID,published,latestComments,countComments	latestComments	4	NULL	53460	Using where

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.08 ms
Optimizing	0.08 ms
Statistics	0.28 ms
Preparing	0.13 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.70 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1717
12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:242
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.67 ms After last query: 23.06 ms Query memory: 0.029 MB Memory before query: 5.041 MB Rows returned: 5

SELECT i.*, c.alias as categoryalias 
  FROM chdg4_k2_items as i
				
  LEFT JOIN chdg4_k2_categories c 
  ON c.id = i.catid
				
  WHERE i.id != 3
				
  AND i.published = 1
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-04 10:18:50' )
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 10:18:50' )  
  AND i.access IN(1,1)  
  AND i.trash = 0
				
  AND i.created_by = 292
				
  AND i.created_by_alias=''
				
  AND c.published = 1  
  AND c.access IN(1,1)  
  AND c.trash = 0
				
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,item,catid,created_by	created_by	4	const	5	Using index condition; Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	sptlkeny_sptlkenya.i.catid	1	Using where

Profile

Status	Duration
Starting	0.20 ms
Checking permissions	0.04 ms
Opening tables	0.09 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.15 ms
Optimizing	0.11 ms
Statistics	0.36 ms
Preparing	0.12 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
Creating sort index	0.63 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:871
12	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:291
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.81 ms After last query: 4.86 ms Query memory: 0.028 MB Memory before query: 5.126 MB Rows returned: 1

SELECT * 
  FROM chdg4_k2_items 
  WHERE id != 3 
  AND catid=1 
  AND ordering > 3 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-04 10:18:50' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-04 10:18:50' )  
  AND access IN(1,1) 
  AND trash=0  
  ORDER BY ordering ASC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	3	Using where

Profile

Status	Duration
Starting	0.23 ms
Checking permissions	0.05 ms
Opening tables	0.09 ms
After opening tables	0.05 ms
System lock	0.07 ms
Table lock	0.07 ms
Init	0.23 ms
Optimizing	0.13 ms
Statistics	0.40 ms
Preparing	0.21 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.29 ms
End of update loop	0.05 ms
Query end	0.07 ms
Commit	0.07 ms
Closing tables	0.06 ms
Unlocking tables	0.06 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.06 ms
Updating status	0.09 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1855
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:323
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.55 ms After last query: 1.77 ms Query memory: 0.028 MB Memory before query: 5.157 MB Rows returned: 1

SELECT * 
  FROM chdg4_k2_items 
  WHERE id != 3 
  AND catid=1 
  AND ordering < 3 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-04 10:18:50' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-04 10:18:50' )  
  AND access IN(1,1) 
  AND trash=0  
  ORDER BY ordering DESC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	2	Using where

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.11 ms
Optimizing	0.08 ms
Statistics	0.17 ms
Preparing	0.13 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.18 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.05 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1810
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:364
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
3 × SELECT * 
  FROM chdg4_k2_items
```

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM chdg4_k2_users

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

```
1 × SELECT * 
  FROM `chdg4_users`
```
```
1 × SELECT * 
  FROM chdg4_k2_rating
```

1 × SELECT * 
  FROM chdg4_k2_attachments

1 × SELECT tag.*   
  FROM chdg4_k2_tags AS tag   JOIN chdg4_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

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

1 × SELECT COUNT(*) 
  FROM chdg4_k2_comments

1 × SELECT i.*, c.alias as categoryalias 
  FROM chdg4_k2_items as i     
  LEFT JOIN chdg4_k2_categories c 
  ON c.id = i.catid

1 × SELECT * 
  FROM chdg4_k2_comments

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM chdg4_fields AS a 
  LEFT JOIN `chdg4_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN chdg4_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN chdg4_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN chdg4_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN chdg4_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `chdg4_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT id, name,  parent 
  FROM chdg4_k2_categories

1 × SELECT `data` 
  FROM `chdg4_session`

1 × SELECT `enabled` 
  FROM `chdg4_extensions`

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

1 × SELECT id, rules 
  FROM `chdg4_viewlevels

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

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

```
1 × SELECT * 
  FROM chdg4_languages
```

1 × SELECT `session_id` 
  FROM `chdg4_session`

1 × SELECT id 
  FROM chdg4_k2_categories

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

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

1 × SELECT * 
  FROM chdg4_k2_categories

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `chdg4_k2_items

1 × UPDATE chdg4_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `chdg4_users

1 × SHOW FULL COLUMNS 
  FROM `chdg4_k2_categories

1 × UPDATE `chdg4_extensions` 
  SET `params` = '{\"mediaversion\":\"ea04f9adc7851954fc66a4f6a1c1f664\"}'

1 × INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('fmo6aa84u42c40irh7ouedd513', 1, '1714817930', 0, '', 0

The Big Business of Smashing Bugs

Super User

Latest from Super User

159910 comments

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 460.39 ms

2 duplicate found!

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: