Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728614001,
                "last": 1728614001,
                "now": 1728614001
            }
        },
        "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": {
                "91838248859e069d2cf695179e60f77f31bd7f6e": {
                    "link": "http:\/\/www.lonnielee.com\/2014\/index.php\/tamworth\/121-photo-gallery-2",
                    "expiry": 1728614001
                },
                "8786ca7d252620467d0b46b9854a937bb7cb79d1": {
                    "link": "http:\/\/www.lonnielee.com\/2014\/index.php\/tamworth\/120-voting-booth",
                    "expiry": 1728614001
                },
                "124c346a255847349feb1af92527c46108f315e0": {
                    "link": "http:\/\/www.lonnielee.com\/2014\/index.php\/tamworth\/118-lonnie-lee-radio-links",
                    "expiry": 1728614001
                },
                "0bcb1b1ad5f1345898f4b01e855a8f39b63f614f": {
                    "link": "http:\/\/www.lonnielee.com\/2014\/index.php\/tamworth\/119-sample-tracks",
                    "expiry": 1728614001
                },
                "92846115a2fce3c49acaf3269a4a3ea76e413486": {
                    "link": "http:\/\/www.lonnielee.com\/2014\/index.php\/friends\/thank-you-letter",
                    "expiry": 1728614001
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 0.65 ms / 0.65 ms Memory: 0.036 MB / 0.38 MB Application: afterLoad

Time: 10.65 ms / 11.30 ms Memory: 1.461 MB / 1.84 MB Application: afterInitialise

Time: 0.61 ms / 11.92 ms Memory: 0.021 MB / 1.86 MB Application: afterRoute

Time: 0.64 ms / 12.56 ms Memory: 0.041 MB / 1.90 MB Application: beforeRenderComponent com_content

Time: 1.37 ms / 13.92 ms Memory: 0.210 MB / 2.11 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.32 ms / 14.24 ms Memory: 0.015 MB / 2.12 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.02 ms / 14.26 ms Memory: 0.000 MB / 2.12 MB Application: New JAccess Preloading Process(com_content.category)

Time: 0.45 ms / 14.71 ms Memory: 0.087 MB / 2.21 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Time: 0.42 ms / 15.13 ms Memory: 0.118 MB / 2.32 MB Application: After preloadPermissions (com_content.category)

Time: 0.01 ms / 15.14 ms Memory: 0.001 MB / 2.33 MB Application: End New JAccess Preloading Process(com_content.category)

Time: 0.00 ms / 15.14 ms Memory: 0.001 MB / 2.33 MB Application: Start JAccess::getAssetRules New (com_content.category.37)

Time: 0.02 ms / 15.17 ms Memory: 0.007 MB / 2.33 MB Application: Finish JAccess::getAssetRules New (com_content.category.37)

Time: 4.08 ms / 19.25 ms Memory: 0.104 MB / 2.44 MB Application: Start JAccess::preload(components)

Time: 1.02 ms / 20.27 ms Memory: 0.252 MB / 2.69 MB Application: Finish JAccess::preload(components)

Time: 14.25 ms / 34.53 ms Memory: 0.446 MB / 3.14 MB Application: afterRenderComponent com_content

Time: 0.21 ms / 34.74 ms Memory: 0.003 MB / 3.14 MB Application: afterDispatch

Time: 4.17 ms / 38.91 ms Memory: 0.072 MB / 3.21 MB Application: beforeRenderModule mod_menu (Terms menu)

Time: 1.27 ms / 40.18 ms Memory: 0.021 MB / 3.23 MB Application: afterRenderModule mod_menu (Terms menu)

Time: 0.02 ms / 40.21 ms Memory: 0.000 MB / 3.23 MB Application: beforeRenderModule mod_custom (Note)

Time: 0.14 ms / 40.35 ms Memory: 0.005 MB / 3.23 MB Application: afterRenderModule mod_custom (Note)

Time: 0.02 ms / 40.37 ms Memory: 0.000 MB / 3.23 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.03 ms / 40.40 ms Memory: 0.003 MB / 3.24 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.01 ms / 40.41 ms Memory: 0.002 MB / 3.24 MB Application: beforeRenderModule mod_acymailing (Our Newsletters)

Time: 6.31 ms / 46.72 ms Memory: 0.354 MB / 3.59 MB Application: afterRenderModule mod_acymailing (Our Newsletters)

Time: 0.03 ms / 46.75 ms Memory: 0.000 MB / 3.58 MB Application: beforeRenderModule mod_menu (Social)

Time: 0.64 ms / 47.40 ms Memory: 0.011 MB / 3.59 MB Application: afterRenderModule mod_menu (Social)

Time: 0.03 ms / 47.42 ms Memory: 0.000 MB / 3.59 MB Application: beforeRenderModule mod_as_menu (Main menu)

Time: 5.17 ms / 52.59 ms Memory: 0.199 MB / 3.79 MB Application: afterRenderModule mod_as_menu (Main menu)

Time: 2.49 ms / 55.08 ms Memory: 0.141 MB / 3.93 MB Application: afterRender

Database queries total: 16.85 ms

Memory Usage

Database Queries

29 Queries Logged 16.85 ms

Query Time: 0.47 ms Query memory: 0.022 MB Memory before query: 0.653 MB Rows returned: 0

SELECT `data`

  FROM `ckuyg_session`

  WHERE `session_id` = '5f71ac15000044be6f7ac5f95c9b9ea3'

Explain

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

Profile

Status	Duration
Starting	0.07 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.01 ms
Statistics	0.21 ms
Preparing	0.01 ms
Executing	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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:780
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
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: 0.34 ms After last query: 0.17 ms Query memory: 0.003 MB Memory before query: 0.669 MB

DELETE 

  FROM `ckuyg_session`

  WHERE `time` < '1728613101'

Explain

EXPLAIN not possible on query: DELETE FROM `ckuyg_session` WHERE `time` < '1728613101'

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.16 ms
Updating	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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:797
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
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: 0.18 ms After last query: 0.03 ms Query memory: 0.019 MB Memory before query: 0.674 MB Rows returned: 0

SELECT `session_id`

  FROM `ckuyg_session`

  WHERE `session_id` = '5f71ac15000044be6f7ac5f95c9b9ea3' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:806
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
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: 0.40 ms After last query: 0.02 ms Query memory: 0.003 MB Memory before query: 0.678 MB

INSERT INTO `ckuyg_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('5f71ac15000044be6f7ac5f95c9b9ea3', 0, 1, '1728614001', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `ckuyg_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('5f71ac15000044be6f7ac5f95c9b9ea3', 0, 1, '1728614001', 0, '')

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.20 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:213
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:806
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
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: 0.76 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 0.700 MB Rows returned: 42

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

  FROM `ckuyg_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.40 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.37 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 0.722 MB Rows returned: 2

SELECT b.id

  FROM ckuyg_usergroups AS a

  LEFT JOIN ckuyg_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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 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.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.30 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 0.727 MB Rows returned: 4

SELECT id, rules

  FROM `ckuyg_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.13 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.68 ms After last query: 0.03 ms Query memory: 0.087 MB Memory before query: 0.735 MB Rows returned: 83

SELECT folder AS type, element AS name, params

  FROM ckuyg_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	ckuyg_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	222	Using where; Using filesort

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 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.01 ms
Creating sort index	0.44 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.92 ms After last query: 1.82 ms Query memory: 0.098 MB Memory before query: 1.330 MB Rows returned: 73

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

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.54 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
22	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
21	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
20	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
19	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:446
18	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
17	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
16	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
15	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
14	JHtml::script()	JROOT/libraries/cms/html/html.php:237
13	JHtml::call()	JROOT/libraries/cms/html/html.php:139
12	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
11	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
10	JHtml::call()	JROOT/libraries/cms/html/html.php:139
9	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.38 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 1.788 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM ckuyg_template_styles as s

  LEFT JOIN ckuyg_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	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
16	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
15	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
14	JHtml::script()	JROOT/libraries/cms/html/html.php:237
13	JHtml::call()	JROOT/libraries/cms/html/html.php:139
12	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
11	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
10	JHtml::call()	JROOT/libraries/cms/html/html.php:139
9	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.35 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 1.818 MB Rows returned: 1

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

  FROM `ckuyg_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 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.14 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.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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
22	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
21	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
20	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
19	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
18	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:705
14	JHtml::script()	JROOT/libraries/cms/html/html.php:237
13	JHtml::call()	JROOT/libraries/cms/html/html.php:139
12	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
11	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
10	JHtml::call()	JROOT/libraries/cms/html/html.php:139
9	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.25 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 1.813 MB

UPDATE `ckuyg_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
19	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
18	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:705
14	JHtml::script()	JROOT/libraries/cms/html/html.php:237
13	JHtml::call()	JROOT/libraries/cms/html/html.php:139
12	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
11	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
10	JHtml::call()	JROOT/libraries/cms/html/html.php:139
9	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
8	plgSystemJCKModal->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.40 ms After last query: 1.17 ms Query memory: 0.019 MB Memory before query: 1.883 MB Rows returned: 1

SELECT *

  FROM ckuyg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.15 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
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.44 ms After last query: 0.64 ms Query memory: 0.028 MB Memory before query: 2.079 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `ckuyg_assets`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
closing tables	0.01 ms
checking permissions	0.01 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.33 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.102 MB Rows returned: 1

SELECT *

  FROM ckuyg_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.25 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 2.110 MB Rows returned: 1

SELECT a.rules

  FROM ckuyg_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.38 ms After last query: 0.09 ms Query memory: 0.036 MB Memory before query: 2.122 MB Rows returned: 137

SELECT a.id, a.parent_id

  FROM ckuyg_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.17 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.28 ms After last query: 0.10 ms Query memory: 0.051 MB Memory before query: 2.210 MB Rows returned: 137

SELECT a.id, a.name, a.rules

  FROM ckuyg_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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.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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.39 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 2.406 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM ckuyg_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ckuyg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `ckuyg_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=37

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	40	Using where
1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	lonniele_2014.c.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	lonniele_2014.c.id	10	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	10	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.15 ms
Statistics	0.44 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.14 ms
Executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.97 ms
Creating sort index	0.02 ms
Removing tmp table	0.05 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.01 ms
closing tables	0.01 ms
Removing tmp table	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.32 ms After last query: 1.59 ms Query memory: 0.028 MB Memory before query: 2.435 MB Rows returned: 42

SELECT element

  FROM ckuyg_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.38 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 2.452 MB Rows returned: 42

SELECT a.name, a.rules

  FROM ckuyg_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_advpoll','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_finder','com_installer','com_jckman','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_profiles','com_redirect','com_search','com_simplecustomrouter','com_spidercalendar','com_tags','com_templates','com_users','com_visforms','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.12 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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.59 ms After last query: 0.30 ms Query memory: 0.103 MB Memory before query: 2.689 MB Rows returned: 9

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM ckuyg_content AS a

  LEFT JOIN ckuyg_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ckuyg_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ckuyg_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ckuyg_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ckuyg_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 37 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 02:33:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 02:33:21')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	27	Using where; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	lonniele_2014.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	lonniele_2014.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	lonniele_2014.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	10	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 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.06 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.18 ms
Preparing	0.02 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	0.35 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.25 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.03 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
Removing tmp table	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.16 ms After last query: 1.26 ms Query memory: 0.024 MB Memory before query: 2.895 MB Rows returned: 1

SELECT COUNT(*)

  FROM ckuyg_content AS a

  LEFT JOIN ckuyg_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ckuyg_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ckuyg_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ckuyg_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ckuyg_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 37 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 02:33:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 02:33:21')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	27	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	10	Using index condition; Using where

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
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.03 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
Removing tmp table	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.53 ms After last query: 1.42 ms Query memory: 0.022 MB Memory before query: 2.898 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ckuyg_contentitem_tag_map` AS m 

  INNER JOIN `ckuyg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 37 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	lonniele_2014.m.tag_id	1	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.01 ms
Statistics	0.20 ms
Preparing	0.02 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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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.88 ms After last query: 5.12 ms Query memory: 0.028 MB Memory before query: 3.047 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM ckuyg_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ckuyg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=37

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	40	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	lonniele_2014.c.id	10	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	10	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.09 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.05 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.16 ms
Creating sort index	0.03 ms
Removing tmp table	0.04 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.01 ms
closing tables	0.01 ms
Removing tmp table	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
20	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/helpers/icon.php:249
19	JHtmlIcon::print_popup()	JROOT/libraries/cms/html/html.php:237
18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
17	JHtml::_()	JROOT/templates/as002061/html/com_content/category/category_item.php:27
16	include JROOT/templates/as002061/html/com_content/category/category_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/as002061/html/com_content/category/category.php:53
14	include JROOT/templates/as002061/html/com_content/category/category.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:268
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: 4.69 ms Query memory: 0.024 MB Memory before query: 3.200 MB Rows returned: 9

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM ckuyg_modules AS m

  LEFT JOIN ckuyg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN ckuyg_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 <= '2024-10-11 02:33:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-11 02:33:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 222 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	43	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	lonniele_2014.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	lonniele_2014.m.module,const	1	Using index condition; Using where

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.02 ms
Optimizing	0.02 ms
Statistics	0.17 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.79 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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/as002061/params.php:164
8	include JROOT/templates/as002061/params.php	JROOT/templates/as002061/index.php:60
7	require JROOT/templates/as002061/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1079
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
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.27 ms After last query: 5.90 ms Query memory: 0.028 MB Memory before query: 3.518 MB Rows returned: 124

SELECT * 
  FROM ckuyg_acymailing_config

Explain

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

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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	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
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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:343
11	acymailing_config()	JROOT/modules/mod_acymailing/mod_acymailing.php:18
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
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.22 ms After last query: 1.52 ms Query memory: 0.022 MB Memory before query: 3.599 MB Rows returned: 1

SELECT * 
  FROM ckuyg_acymailing_list 
  WHERE type = 'list' 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ckuyg_acymailing_list	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:24
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:115
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
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.37 ms After last query: 4.20 ms Query memory: 0.028 MB Memory before query: 3.726 MB Rows returned: 1

SELECT * 
  FROM ckuyg_kunena_configuration 
  WHERE id=1

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.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.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1227
26	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1174
25	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
24	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:429
23	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
22	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:640
21	JLoader::_load()	JROOT/libraries/loader.php:595
20	JLoader::_autoload()	Same as call in the line below.
19	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
18	KunenaBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_as_menu/helper.php:101
11	modASMenuHelper::getList()	JROOT/modules/mod_as_menu/mod_as_menu.php:25
10	include JROOT/modules/mod_as_menu/mod_as_menu.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:49

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

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT `data` 
  FROM `ckuyg_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM ckuyg_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM ckuyg_acymailing_list

1 × SELECT * 
  FROM ckuyg_acymailing_confi

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

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM ckuyg_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ckuyg_contentitem_tag_map` AS m  
  INNER JOIN `ckuyg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM ckuyg_content AS a 
  LEFT JOIN ckuyg_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ckuyg_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ckuyg_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ckuyg_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ckuyg_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM ckuyg_content AS a 
  LEFT JOIN ckuyg_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ckuyg_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ckuyg_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ckuyg_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ckuyg_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ckuyg_categories AS cat JOIN ckuyg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.name, a.rules 
  FROM ckuyg_assets AS a

1 × SELECT element 
  FROM ckuyg_extensions

1 × SELECT a.id, a.name, a.rules 
  FROM ckuyg_assets AS a

1 × SELECT `session_id` 
  FROM `ckuyg_session`

1 × SELECT a.id, a.parent_id 
  FROM ckuyg_assets AS a

1 × SELECT a.rules 
  FROM ckuyg_assets AS a

```
1 × SELECT * 
  FROM ckuyg_assets
```
```
1 × SELECT * 
  FROM ckuyg_languages
```

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

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

1 × SELECT folder AS type, element AS name, params 
  FROM ckuyg_extensions

1 × SELECT id, rules 
  FROM `ckuyg_viewlevels

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

1 × SELECT * 
  FROM ckuyg_kunena_configuration

OTHER Tables:

```
1 × DELETE  
  FROM `ckuyg_session`
```

1 × INSERT INTO `ckuyg_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('5f71ac15000044be6f7ac5f95c9b9ea3', 0, 1, '1728614001', 0, ''

1 × UPDATE `ckuyg_extensions` 
  SET `params` = '{\"mediaversion\":\"5cefedecd8d81fb72d0a1ba721949b98\"}'

1 × SHOW FULL COLUMNS 
  FROM `ckuyg_assets

PHOTO GALLERY 2

VOTING BOOTH

LONNIE LEE RADIO LINKS

SAMPLE TRACKS

Here are some sample tracks from some of Lonnie's albums.
We hope you enjoy.

THANK YOU LETTER

Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

29 Queries Logged 16.85 ms

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

PHOTO GALLERY 2

VOTING BOOTH

LONNIE LEE RADIO LINKS

SAMPLE TRACKS

Here are some sample tracks from some of Lonnie's albums. We hope you enjoy.

THANK YOU LETTER

Contact Us

Our Newsletters

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

29 Queries Logged 16.85 ms

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Here are some sample tracks from some of Lonnie's albums.
We hope you enjoy.