Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734799530,
                "last": 1734799530,
                "now": 1734799530
            },
            "token": "7lsk60FhFXbYnzSWwCP0HnvXn7RpVv7l"
        },
        "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": {
                "d5a3e6e9e9302dd43d4612cbf5734ecbddb26055": {
                    "link": "http:\/\/lonnielee.com\/2014\/index.php\/awards",
                    "expiry": 1734799530
                },
                "4d89456969cbd31ca43c9fc1dffabeeb1d687e5a": {
                    "link": "http:\/\/lonnielee.com\/2014\/index.php\/show-menu",
                    "expiry": 1734799530
                },
                "b0e05ad2ba67289186a54fa96e788076871d9122": {
                    "link": "http:\/\/lonnielee.com\/2014\/index.php\/friends\/doyou-havestory",
                    "expiry": 1734799530
                },
                "210ee54a535d1259a9133315cb74509be1711349": {
                    "link": "http:\/\/lonnielee.com\/2014\/index.php\/about\/timeline",
                    "expiry": 1734799530
                },
                "50748441039ee54a726e735175cc9cb594c7ce1b": {
                    "link": "http:\/\/lonnielee.com\/2014\/index.php\/tamworth\/105-track-menu",
                    "expiry": 1734799530
                }
            }
        }
    }
}

Profile Information

Time

Memory

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

Time: 8.21 ms / 8.49 ms Memory: 1.461 MB / 1.84 MB Application: afterInitialise

Time: 0.87 ms / 9.37 ms Memory: 0.084 MB / 1.92 MB Application: afterRoute

Time: 0.52 ms / 9.89 ms Memory: 0.042 MB / 1.96 MB Application: beforeRenderComponent com_content

Time: 2.04 ms / 11.93 ms Memory: 0.148 MB / 2.11 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.33 ms / 12.27 ms Memory: 0.015 MB / 2.13 MB Application: Finish JAccess::getAssetRules Old (1)

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

Time: 0.38 ms / 12.66 ms Memory: 0.085 MB / 2.21 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Time: 0.44 ms / 13.10 ms Memory: 0.183 MB / 2.39 MB Application: After preloadPermissions (com_content.category)

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

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

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

Time: 1.34 ms / 14.47 ms Memory: 0.040 MB / 2.44 MB Application: Start JAccess::preload(components)

Time: 1.00 ms / 15.47 ms Memory: 0.252 MB / 2.69 MB Application: Finish JAccess::preload(components)

Time: 11.22 ms / 26.70 ms Memory: 0.415 MB / 3.11 MB Application: beforeRenderModule mod_visforms (Visforms)

Time: 8.31 ms / 35.01 ms Memory: 0.140 MB / 3.24 MB Application: afterRenderModule mod_visforms (Visforms)

Time: 4.95 ms / 39.97 ms Memory: 0.184 MB / 3.43 MB Application: afterRenderComponent com_content

Time: 0.27 ms / 40.24 ms Memory: 0.005 MB / 3.43 MB Application: afterDispatch

Time: 1.55 ms / 41.80 ms Memory: 0.049 MB / 3.48 MB Application: beforeRenderModule mod_menu (Terms menu)

Time: 0.93 ms / 42.72 ms Memory: 0.014 MB / 3.50 MB Application: afterRenderModule mod_menu (Terms menu)

Time: 0.02 ms / 42.75 ms Memory: 0.000 MB / 3.49 MB Application: beforeRenderModule mod_custom (Note)

Time: 0.16 ms / 42.90 ms Memory: 0.005 MB / 3.50 MB Application: afterRenderModule mod_custom (Note)

Time: 0.02 ms / 42.92 ms Memory: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.03 ms / 42.95 ms Memory: 0.003 MB / 3.50 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.01 ms / 42.96 ms Memory: 0.002 MB / 3.50 MB Application: beforeRenderModule mod_acymailing (Our Newsletters)

Time: 5.57 ms / 48.53 ms Memory: 0.353 MB / 3.86 MB Application: afterRenderModule mod_acymailing (Our Newsletters)

Time: 0.03 ms / 48.56 ms Memory: 0.000 MB / 3.85 MB Application: beforeRenderModule mod_menu (Social)

Time: 0.68 ms / 49.24 ms Memory: 0.011 MB / 3.86 MB Application: afterRenderModule mod_menu (Social)

Time: 0.03 ms / 49.27 ms Memory: 0.000 MB / 3.85 MB Application: beforeRenderModule mod_as_menu (Main menu)

Time: 5.63 ms / 54.90 ms Memory: 0.207 MB / 4.06 MB Application: afterRenderModule mod_as_menu (Main menu)

Time: 2.68 ms / 57.58 ms Memory: 0.274 MB / 4.34 MB Application: afterRender

Database queries total: 15.81 ms

Memory Usage

Database Queries

30 Queries Logged 15.81 ms

Query Time: 0.32 ms Query memory: 0.022 MB Memory before query: 0.655 MB Rows returned: 0

SELECT `data`

  FROM `ckuyg_session`

  WHERE `session_id` = 'db3f2ff84a8c2cf8a26288779316bc0b'

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.08 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.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.04 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.21 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 0.671 MB Rows returned: 0

SELECT `session_id`

  FROM `ckuyg_session`

  WHERE `session_id` = 'db3f2ff84a8c2cf8a26288779316bc0b' 
  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.29 ms After last query: 0.03 ms Query memory: 0.003 MB Memory before query: 0.676 MB

INSERT INTO `ckuyg_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('db3f2ff84a8c2cf8a26288779316bc0b', 0, 1, '1734799530', 0, '')

Explain

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

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 for update	0.01 ms
Update	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.07 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.32 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 0.699 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.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.08 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.27 ms After last query: 0.10 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.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.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.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.21 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 0.726 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.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
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
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.42 ms After last query: 0.03 ms Query memory: 0.087 MB Memory before query: 0.734 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.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.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	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.03 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.55 ms After last query: 1.50 ms Query memory: 0.098 MB Memory before query: 1.328 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.06 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
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.25 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.29 ms After last query: 0.41 ms Query memory: 0.024 MB Memory before query: 1.787 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.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.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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.25 ms After last query: 0.11 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.03 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.28 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 1.813 MB

UPDATE `ckuyg_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `ckuyg_extensions` SET `params` = '{\"mediaversion\":\"dd1dd1feb99bd8b0973c7d33bf594ad5\"}' 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.06 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.30 ms After last query: 2.14 ms Query memory: 0.019 MB Memory before query: 1.946 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.05 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.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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.47 ms After last query: 1.36 ms Query memory: 0.028 MB Memory before query: 2.081 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.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 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.04 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.25 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.104 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.02 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.27 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.112 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.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.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.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: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.32 ms After last query: 0.08 ms Query memory: 0.035 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.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: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.31 ms After last query: 0.09 ms Query memory: 0.051 MB Memory before query: 2.273 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: 1.08 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 2.407 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.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.06 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.07 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.03 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.31 ms
Creating sort index	0.02 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
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.29 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 2.436 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.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 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.39 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.11 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: 2.37 ms After last query: 0.29 ms Query memory: 0.212 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-12-21 16:45:30') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-21 16:45:30')

  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 10, 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.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.05 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.06 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.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.03 ms
Executing	0.01 ms
Sending data	0.29 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.26 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.27 ms
Executing	0.01 ms
Sending data	0.12 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.19 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 2.965 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-12-21 16:45:30') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-21 16:45:30')

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.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Statistics	0.05 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.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.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.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
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.68 ms After last query: 1.46 ms Query memory: 0.022 MB Memory before query: 2.969 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.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.24 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
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: 1.32 ms After last query: 3.82 ms Query memory: 0.026 MB Memory before query: 3.020 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-12-21 16:45:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-21 16:45:30') 
  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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.82 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
18	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
17	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
16	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
15	JModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
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.57 ms After last query: 2.28 ms Query memory: 0.028 MB Memory before query: 3.139 MB Rows returned: 1

SELECT * 
  FROM ckuyg_visforms 
  where id=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ckuyg_visforms	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
20	JDatabaseDriver->loadObject()	JROOT/components/com_visforms/models/visforms.php:98
19	VisformsModelVisforms->getForm()	JROOT/modules/mod_visforms/helper.php:33
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:25
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/libraries/cms/module/helper.php:199
16	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
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.55 ms After last query: 0.02 ms Query memory: 0.128 MB Memory before query: 3.155 MB Rows returned: 20

SELECT * 
  FROM ckuyg_visfields 
  where fid=1 
  and published=1 
  order by ordering asc

Explain

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

Profile

Status	Duration
Starting	0.03 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
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
Unlocking tables	0.01 ms
closing tables	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.02 ms
Creating sort index	0.15 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
20	JModelLegacy->_getList()	JROOT/components/com_visforms/models/visforms.php:111
19	VisformsModelVisforms->getFields()	JROOT/modules/mod_visforms/helper.php:34
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:25
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/libraries/cms/module/helper.php:199
16	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:106
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.00 ms After last query: 7.29 ms Query memory: 0.028 MB Memory before query: 3.270 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.14 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.04 ms
Statistics	0.06 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.03 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.17 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: 0.33 ms After last query: 7.37 ms Query memory: 0.028 MB Memory before query: 3.781 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.09 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.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.27 ms After last query: 1.57 ms Query memory: 0.022 MB Memory before query: 3.862 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
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.43 ms After last query: 4.35 ms Query memory: 0.028 MB Memory before query: 3.995 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.06 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.]

29 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 element 
  FROM ckuyg_extensions

1 × SELECT * 
  FROM ckuyg_acymailing_list

1 × SELECT * 
  FROM ckuyg_acymailing_confi

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 * 
  FROM ckuyg_visfields
```
```
1 × SELECT * 
  FROM ckuyg_visforms
```

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 `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 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 `session_id` 
  FROM `ckuyg_session`

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

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 × INSERT INTO `ckuyg_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('db3f2ff84a8c2cf8a26288779316bc0b', 0, 1, '1734799530', 0, ''

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

1 × SHOW FULL COLUMNS 
  FROM `ckuyg_assets

	1959 he was named by Lee Gordon as the Artist Most Likely to Succeed 1960 he was named by the media as.. The Most Constant Hit Parader 1961 as the most popular star on ABCTV's Six O'Clock Rock music TV Show 1961 as the 2nd most popular star on Channel 9's 'Bandstand' Show 1961 GOLDEN MICROPHONE He recieved this prestigious award as Australia's most popular recording star. It was the most coveted award in the Australian music industry and it was presented to him at the Princess Theatre Perth by Radio 6IX the leading Top 40 station at the time.
	1998 MOST POPULAR NOSTALGIA STAR
	2011 MOST POPULAR NOSTALGIA STAR
	1999 BEST PERFORMING ARTIST
	2010 PARKES ELVIS FESTIVAL WALL OF FAME


The Hillbilly Cat Show	This show tells the story of Elvis Presley. How he got to record for Sun Records in Memphis, how he fused several styles to create what we now call Rockabilly, and the songs which became his first records for Sun Records. Lonnie sings them blending hos own energetic style with that of the young Elvis.
The Cry! Show	Prior to Elvis amd Rock'n'Roll, Johnnie Ray was the world's most popular recording and stage star. His show attendenaces broke all records and some still stand today. His antics on stage included lying on the stage floor making love to a microphone stand, jumping on a piano, and frantically moving around the stage. These were the moves that a young Elvis and Jerry Lee Lewis year later put to a Rock.n.Rioll beat. His vocal style was also unique so much so they named him, Mr Emotion, The Nabob of Sob and The Cry Guy. Lonnie take 26 of the great Johnnie Ray songs and with his Leemen and a big band, presents a swing show like no other. He links them together in an exciting story.
The Rockabilly Frenzy Show	Due to requests for Lonnie do perform dance show, he has this show which presents the best Rock and Rockabilly songs especially for dances and those who love Lonnie's energy and style. Many of these songs are not performed in any of his other shows.
The Roots of Aussie Rock Show	As a tribute to the first original Rock.n.Roll era, Lonnie sings the songs and tells the story of his friends and peers who were Australia's first music stars.

1940	September 18 born in Private Nursing home in Chatswood. Back to Grandparents sheep property in Rowena.
1946	Started boarding school at Trinity Grammar School Strathfield then 1951 day school at Summer Hill.
1947 - 1952	Singing in school choir and at home with parents playing piano Learned piano at school.
1953 - 1955	Went to Crows Nest Technical College Singing in Lavender Bay Christ Church choir Taught himself ukelele Joined Cubs Lavender Bay then Sea Scouts 1st Sailors Bay Sea Scouts
1955	Sang 30's and 40's songs then Johnnie Ray, Hank Williams & others Taught himself guitar. Paper deliveries before and after school.. Worked in Luna Park, on Ferries , in Woostores and factories in school holidays. Left school after Intermediate Certificate.
1956	Saw Blackboard Jungle Movie - heard Rock'n Roll in movie Australia's Amateur Hour sang new release Heartbeak Hotel came 2nd First professional singing at small hotels, restaurants, parties Started working in National Bank Crows Nest,Newtown,Marrickville. Study Accountancy.
1957	Started work at 2GB in Schedules and as Panel Operator. Trocadero Ballroom Australia's ELVIS, for Love Me Tender promo - won Surryville Ballroom- Sydney's Elvis Presley Contest - won Sydney's Sunday Sun Newspaper - 1st full page story about a local rock singer .. Laurie Rix (Lonnie) First Trocadero show with J.OK, one of Sydney first Rock'n'Roll shows Started first Rockabilly Trio with Billy Mostyn & Kenny Hands Performed in ATN7 'Sydney Tonight' - Sydney's first of it's type Played dances, charity events, parties,football clubs in halls First full time 6 shows a week at Riverview Hotel Tempe Car accident in late December so father called him home to Rowena
1958	Went back to family sheep property at Rowena, near Moree, Walgett Worked as Jackaroo on property Sang at local halls and balls, offered touring with Rodeo, Circuses Sang with country band, Frank Bourke and his White Rose Orchestra Offered to join most popular country band, White Rose Orchestra
1959	Returned to Sydney in January Started new bands called Laurie Rix and The Beatnix, then Laurie R Lee and The Leemen, then Lonnie Lee and The Leemen Playing nearly every night at dances and shows. Fan Club started by Margaret Roberts and Dianne Farr and others in Bendigo and across Australia. Offered to record first EP for Lee Gordon, 'This is Lonnie Lee' Performed on Stadium Show with Fabian. Featured in first Rock'n'Roll Movie filmed at Stadium 1st # 1 of 8 Hit Records... 'Aint it So" - Lonnie & J.OK wrote it. First Australian Rock'n'Roll tour - across Victoria with J.O'K
1960	Featured on many Stadium, Festival Hall shows with US stars, Ricky Nelson, Jerry Lee Lewis, Crash Craddock, Bobby Rydell, Marv Johnson, The Everly Bros, Johnny Cash, The Crickets, Tommy Sands, Chan Romero and many more. Started 2 year run as featured star on Australia's first Rock TV Show First Rock'n'Roll tour to Queensland and many other dances, shows. On tour in June, Lonnie found J.OK accident near Kempsey. Started own publishing company, 'Lonnie Lee Music' Had 3 sings on Hit Parade at same time. Signature song, 'Starlight Starbright' released in January. First Gold. First Full colour LP in Australia released, 'A Night out with Lonnie Lee'.
1961	Public vote 'Most Popular Star ABC TV's 'Six O'Clock Rock' -J.Ok 2nd 2nd most popular star on TV's Bandstand. Col Joye first. Golden Microphone Award as Australia's Most Popular Star. Many shows and dances across Australia. Started performing on Showgrounds
1962	Press Award "Australia's Most Consistent Hit Parader First tour of New Zealand, 'Phillips Showtime' - 2 months. Many more records released.. Sitting by the River, When the bells etc
1959-1965	8 Top 10 Hit Records - 5 Gold Records many Albums Concert tours with every major US superstar of the era. More Australian hits than Buddy Holly, Jerry Lee Lewis, Chuck Berry Tours and record releases worldwide. 1st OZ Stereo LP in 1964 also 1st Full colour album cover in Australia 1960 1st artist to record a Bee Gee song 1960 "I'd like to leave" 1st Australian to top NZ parades and successfully concert tour -1959-64 Started The Bowl Booking Agency Promoted 2nd Wave of Australian stars such as Normie Rowe, Tony Worsley and wrote and produced tracks for Mike Furber, Donna Gaye, The Rajahs and many others. Started own agency ' Lonnie Lee Entertainment Agency' Toured NZ with Dinah Lee Recorded for EMI Records', HMV Label. 'Discovered' John Rowles, named him JA-AR signed and recorded him for Leedon Records and managed and booked him.
1966-1967	Performed in clubs and tours across NZ and Australia Continued booking stars Offered trip to Europe left on Chandris to Greece. Performed across Europe and England
1968	Toured South Pacific Islands, Fiji, New Caledonia and Tahiti Managed and produced for Sunshine Records Australia. Helped promote Swinger Circuit.. Australia's biggest ever tour circuit.
1969	Toured NZ with Judith Durham - when she left The Seekers. Toured Ivan Dayman's 'Swinger Circuit' across Australia
1971 -1984	Went to USA to Seattle then Las Vegas then Hollywood & Nashville. Living in Nashville on/off for 9yrs - wrote for and with Roy Orbison and other stars. Roy made him his, 'Personal Assistant'. 1980 was made an "Honourary Delegate to the USA House of Representatives. Produced Health and Exercise TV Show at Channel 17 in Nashville for 2 seasons for ex Mr America. Promoted franchises for 'American Health Studios' Nashville. Managed and promoted Nashville's top Country Music Nightclubs, Nashville Palace and Web Pierce's Rhinestone Cowboy. Had world's first 'Solar and Alternatives' Expo in Nashville, 'Living in the 80's' . Lived in Las Vegas on/off 5 yrs performing and had own record label and music companies. Started the first computerised 'Record Promotion' company in USA. Performed and had own shows across USA. Spent a year in LA with Motown producer Mickey Stevenson of "Dancin in the Street" fame. A Founder Director of 'American Society of Country Music' - Las Vegas. Owned record label & promo company in Nashville & Las Vegas. Produced Country Music TV Show from Silver Nugget Casino Las Vegas. Lonnie Lee's Nashville Country Music Show first full country show in major clubs and Sydney Town Hall. Had Country Music Radio show for Edels Record Stores, on Radio 2KY. Promoted stars such as Ray Charles, The Hollies, Gene Pitney, Tom T Hall. Toured Australia with Roy Orbison. Toured Australia as Specila Guest on Las Vegas show, 'Elvis - The Final Farewell Concert'

1984-2000	Started radio show ' Lonnie Lee's Rock'n'Remember Show' on 2GLF 99.3FM Brought back Australia's first rock stars such as Barry Stanton, Warren Williams, Johnny Devlin, Booka Highland, Lucky Starr and others with guest Glen Shorrack for big Rock'n'Remember' concert recorded by ABC radio. Chosen to represent pop music by ABC TV at 60th Anniversary. Ausmusic launch, chosen to represent the first Australian Rock Stars. One of the most featured stars at Powerhouse Museum's "Real Wild Child" exhibit. Major attraction at Canberra festival and other major provincial events. Major show at Darling Harbour "Australia Day" celebrations for 3 years. 1998 and 1999 awarded "Australia Post Best Performing Artist" . 2001 awarded Australia Post ‘Best Nostalgia Act’ Tours all clubs, casino's, outdoor events,festivals and corporate events. Started Starlite Records and writes, records and releases new CD's. Recorded major hits with stars of ABC TV show, 'Six O'Clock Rock'. 1984 Suggested Festival Records re-release albums of original rock stars. Series became known as, 'The Festival File'. Started and toured 'Lonnie Lee's Dance Ranch', the first major Line Dance show. Cameo performances and interviews on many TV Shows.
2002-2024	Featured on major venue tour, 'Long Way to The Top'. Performance on Australia first Music cruise, 'The Blue Suede Cruise' . Wrote and released CDs such as Light of Love', 'North West Mail' and 'Back to Base X' and DVDs .. 'Good Rockin' Tonight'. Releases Black and White DVD series of old TV shows from 1959. Vol 1 and 2 and LIve shows, '30th Anniversary of Six O'Clock Rock' Vol1 and 2 and The TV Years 1980 to 2018 Cable TV Channel 'Ovation' featuring and repeating Lonnie's shows. Performing at major venues such as Crown Casino QPAC and festivals with Leemen across Australia. Turned 79 on 18th September 2019 Still writing songs and releasing CDs and DVDs. Writing his book. 180,000 + words so far.. Two week QLD Seniors Tour 2016 and 2017 Victoria West Tour 2017, 2018 and 2019 Melbourne Seniors Tour 2018 - Sydney Premiers Concert to 35,000 in ICC Repeat performances at leading clubs and other venues 2019 new CD Back to Base X of his own songs plus those of John Marascalo (Rip it up) and Otis Blackwell (Don't be Cruel) Biggest Hits CD from original Masters COVID MANDATES STOPS ALL SHOWS Starts one man solo shows 'Last Man Standing', 'Just me and my Music', 'Loving LIfe Tour' Solo Theatre shows across Australia Victorian Seniors tours every year Tamworth Festival and Parkes Elvis Festival shows
OVERVIEW	Lonnie Lee is unique - one of a kind - his music style, his vocal style and energy and his accomplishments attest to that. His shows are unique from all of his peers whether international or local. His 'firsts' are also unique. See testimonials from fans and reviewers on another area of this site.

	Today he still gets more plays than his peers on radio for both older and current releases. Has recently released 45 CDs over recent years, 6 'live' show DVDs and archival DVDs. He has never had a manager or exclusive agent and has always stood alone. So incredibly, 68 years later it's still.. LONNIE LEE - STANDING ALONE - ONE OF A KIND!

Lonnie Lee CD's	Starlite label
Lonnie Lee Cassettes
Lonnie Lee Vinyl	US import labels
Lonnie Lee Video	Other Artist Labels
Lonnie Lee T-Shirts- Caps etc
Lonnie Lee Fliers	Books
Lonnie Lee Posters	Magazines
Lonnie Lee Photos

	CD's
ST805 ST811 ST812 ST813 ST814 ST815 ST816 ST817 ST818 ST819 ST820 ST821 ST822 ST823 ST825 ST826 ST827 ST828 ST829 ST830 ST831 ST832 ST833 ST834 ST835 ST836 ST837 ST838 ST839 ST840 ST841	Solid Gold (With orchestra) Don't Look Back - Lonnie originals some he wrote for Roy Orbison) Really Rockin' Live at The Dance Ranch I Like it I love it The Original Definitive Collection - Lonnie Lee - Vol 1 - The Leedon Years The Original Definitive Collection - Lonnie Lee - Vol 2 - The Leedon Years Like it is The Original Definitive Collection Lonnie Lee Vol 3 - The TV Shows Good Rockin' Tonight - Lonnie Lee - The Live Show 2004 CD Can't you see it in my eyes-Sat night at the Trocadero watching Lonnie Lee (Chain) Single Best Friends - Who made the rules It takes me back - Lonely Nights and Lonely Days Light of Love Crikey - CD Single My Rockabilly Band - Lotta Lovin' - CD Single North West Mail The Last of The Big Shows The Best of Lonnie Lee LIVE Rockin' Wild in the Country Holy Xmas - CD Singles The Original Definitive Collection - Lonnie Lee - Vol 4 - The HMV-Sunshine Records Years 1969-1970 Convoy for kids - CD Single CFK-1 The Hillbilly Cat Show Solid Gold Show LIVE 2014 The Original Definitive Collection - Lonnie Lee - Vol 5 - The American Years Hits and Memories LIVE Biggest Hits Back to Base X 60 Years and Still Rockin' LIVE
	CASSETTES
ST805c ST806c ST811c	Solid Gold - Lonnie Lee with orchestra Let's go - Let's dance (Casingle) Don't look back
	VINYL
ST805LP ST801 RP116	Solid Gold Johnny Rock'n'Roll (45rpm 7"single) Collectors Edition (33 1/3rpm 7" album) 4 tracks
	VIDEO and DVD
VT01 VT02 VT03 VT04 VT05 VT06 VT07 VT08 VT09 VT10 VT11	Rock 'n' Remember Show - 57 mins stereo Live at The Dance Ranch -72 mins stereo Good Rockin' Tonight - The Live Show 2004 DVD CRY ! The songs and stories of Johnnie Ray - LIVE SHOW Black and White TV Shows Volume 1 - Lonnie's Bandstand-Six O'Clock Rock Black and White TV Shows Volume 2 - Lonnie's Bandstand-Six O'Clock Rock Lonnie Lee -The TV Shows (Show performances, interviews from 1980) 30th Anniversay of Six O'Clock Rock Vol 1 30th Anniversay of Six O'Clock Rock - Vol 2 -THE STARS
	T-SHIRTS - CAPS
TS-FF1 TS-HH1 TS-DR1 CAPS1	50's Forever Hail Hail Rock'n'Roll Hot & Honky Dance Ranch Good quality black 'Hail Hail' cap
	FLIERS
F-P1 F-R1	A4 gloss purple 2 sided 2 fold flier A4 gloss red 2 sided 1 fold flier
	POSTERS
SP1 SP2 SP3 SP4	This is Lonnie Lee- large A2 full colour poster Hail Hail Rock'n'Roll A3 siz poster Rock'n'Remember Show A4 small poster Good Rockin' Tonight - large A2 full colour poster
	PHOTOS
PH-1 PH-2 PH-3 PH-4	A4 B&W Lonnie Lee photo on gloss board A4 B&W 1999 with guitar A4 2 on page at Powerhouse 10x8 Glossy actual photo of several of the living legends of the Six O'Clock TV show

AWARDS

SHOW MENU

DO YOU HAVE A STORY

Visforms

LONNIE LEE STORY

TIME LINE

STARLITE COVER MENU

Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

30 Queries Logged 15.81 ms

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

CD'S		VINYL
ST804	Living Legends of Six O'Clock Rock	ST804LP	Living Legends of Six O'Clock Rock
CASSETTES		ST801	Lonnie Lee - Johnny Rock'n'Roll - 45rpm
ST804c	Living Legends of Six O'Clock Rock

RP116 - Vinyl	Spotlite Records	Lonnie Lee - Collectors - 1982 4 track -33 1/3rpm - mini album
WR1 - CD	Warrior Records	Chan Romero - Fifties Flashback with Hippy Hippy Shake

	Wayne Jackson of the Memphis Horns
	Bob Babbitt of the Funk Bros
	Normie Rowe
	Lil Fi
	Chain

BST01	Six O'Clock Rock - The Facts	Lonnie Lee
BST04	Lonnie Lee's Photo Memories - Coffee Table book - 700 pix	Lonnie Lee
BST02	Johnny O'Keefe - The Facts	Lonnie Lee
BST03	Who am I ? - Self Realisation journey - Poems from 1965	Lonnie Lee