Lancia Fulvia 3 topics

Any Problems with your Fulvia ?

Start
Prev
1
Next
End

Subject	Replies / Views	Last Post
Wiring loom S2 coupe Topic started 1 year 6 months ago, by oldest Last Post 1 year 6 months ago by oldest	Replies:0 Views:238	Last Post by oldest 1 year 6 months ago
Fulvia Seat Hinges 1 Topic started 4 years 9 months ago, by keithver Last Post 4 years 9 months ago by oldest	Replies:2 Views:1178	Last Post by oldest 4 years 9 months ago
Distributor Tester Topic started 6 years 1 week ago, by tangmonster Last Post 6 years 1 week ago by tangmonster	Replies:2 Views:2004	Last Post by tangmonster 6 years 1 week ago

Start
Prev
1
Next
End

Time to create page: 0.968 seconds

Latest News

Latest Forum Topics

No posts to display.

Legal

Cape Lancia Museum ®

3 Plein st.

Woodstock 7925

South Africa

Tel: ++27 21 4477616

museum@lancia.org.za

PBO: 930072064

Banking Details: Download

Registration: NPC 2013/026617/08

Trademark: 2013/08064

Constitution: Download

PAIA: Download

The Cape Lancia Museum is a Member of the:

South African Museums Association

South African Heritage Resource Agency

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778022357,
                "last": 1778022357,
                "now": 1778022357
            },
            "token": "wzSiAGt3Rzn43t0hV4KgnHJCl8ZoC4zs"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_kunena": {
                "user0_read": {
                    "12": 12,
                    "14": 14,
                    "8": 8,
                    "4": 4,
                    "7": 7,
                    "9": 9,
                    "5": 5,
                    "10": 10,
                    "6": 6,
                    "11": 11,
                    "13": 13
                }
            }
        },
        "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
        },
        "jsn_original_id": 0,
        "redirectAfterLogin": null
    }
}

Profile Information

Time

Memory

Time: 70.11 ms / 70.11 ms Memory: 0.346 MB / 0.70 MB Application: afterLoad

Time: 475.31 ms / 545.42 ms Memory: 1.183 MB / 1.89 MB Application: afterInitialise

Time: 53.96 ms / 599.38 ms Memory: 0.299 MB / 2.19 MB Application: Before Access::preloadComponents (all components)

Time: 12.24 ms / 611.62 ms Memory: 0.050 MB / 2.24 MB Application: After Access::preloadComponents (all components)

Time: 0.34 ms / 611.95 ms Memory: -0.001 MB / 2.24 MB Application: Before Access::getAssetRules (id:24 name:com_users)

Time: 1.97 ms / 613.93 ms Memory: 0.007 MB / 2.24 MB Application: After Access::getAssetRules (id:24 name:com_users)

Time: 1.55 ms / 615.47 ms Memory: 0.002 MB / 2.24 MB Application: afterRoute

Time: 57.60 ms / 673.07 ms Memory: 0.029 MB / 2.27 MB Application: beforeRenderComponent com_kunena

Time: 150.87 ms / 823.95 ms Memory: 0.634 MB / 2.91 MB Application: Before Access::getAssetRules (id:81 name:com_kunena)

Time: 0.51 ms / 824.46 ms Memory: 0.006 MB / 2.91 MB Application: After Access::getAssetRules (id:81 name:com_kunena)

Time: 824.63 ms / 1649.09 ms Memory: 0.992 MB / 3.91 MB Application: afterRenderComponent com_kunena

Time: 7.95 ms / 1657.03 ms Memory: 0.005 MB / 3.91 MB Application: afterDispatch

Time: 129.25 ms / 1786.29 ms Memory: 0.131 MB / 4.04 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 51.80 ms / 1838.09 ms Memory: 0.024 MB / 4.06 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 122.22 ms / 1960.31 ms Memory: 0.080 MB / 4.14 MB Application: beforeRenderModule mod_search (Search)

Time: 19.64 ms / 1979.94 ms Memory: 0.013 MB / 4.16 MB Application: afterRenderModule mod_search (Search)

Time: 37.75 ms / 2017.69 ms Memory: 0.002 MB / 4.16 MB Application: beforeRenderModule mod_phocagallery_tree (Cape Lancia Gallery )

Time: 161.55 ms / 2179.25 ms Memory: 0.201 MB / 4.36 MB Application: afterRenderModule mod_phocagallery_tree (Cape Lancia Gallery )

Time: 2.08 ms / 2181.33 ms Memory: -0.065 MB / 4.30 MB Application: beforeRenderModule mod_menu (Side Menu)

Time: 24.85 ms / 2206.18 ms Memory: 0.058 MB / 4.35 MB Application: afterRenderModule mod_menu (Side Menu)

Time: 22.02 ms / 2228.20 ms Memory: 0.004 MB / 4.36 MB Application: beforeRenderModule mod_kunenalatest (Latest Forum Topics)

Time: 8.72 ms / 2236.92 ms Memory: 0.021 MB / 4.38 MB Application: afterRenderModule mod_kunenalatest (Latest Forum Topics)

Time: 9.97 ms / 2246.89 ms Memory: 0.020 MB / 4.40 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 7.51 ms / 2254.40 ms Memory: 0.004 MB / 4.40 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 125.83 ms / 2380.23 ms Memory: 0.322 MB / 4.73 MB Application: afterRender

Database queries total: 496.63 ms

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

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `rxtgu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6b7563743469686d71736b736d656e6d703474676f7367713339', 1, 1778022357, 0, '', 0)

Profile

Status	Duration
Starting	0.46 ms
Checking permissions	0.08 ms
Opening tables	0.13 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.07 ms
Init for update	0.12 ms
Update	1.42 ms
Waiting for query cache lock	0.07 ms
Update	0.33 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	138.39 ms
Closing tables	0.12 ms
Unlocking tables	0.06 ms
Closing tables	0.09 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	4.96 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 4.02 ms After last query: 13.30 ms Query memory: 0.020 MB Memory before query: 1.110 MB Rows returned: 5

SELECT id, rules

  FROM `rxtgu_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.09 ms After last query: 1.01 ms Query memory: 0.020 MB Memory before query: 1.119 MB Rows returned: 2

SELECT b.id

  FROM rxtgu_usergroups AS a

  LEFT JOIN rxtgu_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.87 ms After last query: 51.38 ms Query memory: 0.021 MB Memory before query: 1.507 MB Rows returned: 1

SELECT `value`

  FROM `rxtgu_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtgu_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:673
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.87 ms After last query: 2.18 ms Query memory: 0.020 MB Memory before query: 1.514 MB Rows returned: 0

SELECT *

  FROM `rxtgu_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:673
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.31 ms After last query: 109.19 ms Query memory: 0.020 MB Memory before query: 1.752 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `rxtgu_admintools_redirects`

  WHERE ((`dest` = 'forum/lancia-fulvia') OR (`dest` = 'forum/lancia-fulvia') OR ('forum/lancia-fulvia' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:674
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.97 ms After last query: 67.64 ms Query memory: 0.021 MB Memory before query: 2.181 MB Rows returned: 1

SELECT * 
  FROM rxtgu_kunena_aliases 
  WHERE alias LIKE 'lancia-fulvia%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtgu_kunena_aliases	range	alias	alias	767	NULL	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:450
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:316
10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1148
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.89 ms After last query: 3.95 ms Query memory: 0.024 MB Memory before query: 2.193 MB Rows returned: 46

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

  FROM `rxtgu_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_joomgallery','com_joomlaupdate','com_jsn','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_securitycheck','com_tags','com_templates','com_users','com_wrapper','com_yendifvideoshare')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtgu_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	145	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:140
8	plgSystemJsn_System->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 46.03 ms After last query: 7.82 ms Query memory: 0.004 MB Memory before query: 2.247 MB

UPDATE `rxtgu_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.48 ms
Checking permissions	0.08 ms
Opening tables	0.15 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.06 ms
Init for update	0.74 ms
Updating	0.53 ms
End of update loop	0.06 ms
Waiting for query cache lock	0.05 ms
End of update loop	0.07 ms
Query end	0.06 ms
Commit	41.63 ms
Closing tables	0.11 ms
Unlocking tables	0.06 ms
Closing tables	0.10 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	6.85 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 12.83 ms After last query: 26.31 ms Query memory: 0.023 MB Memory before query: 2.382 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_sessions`

Explain

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

Profile

Status	Duration
Starting	0.50 ms
Checking permissions	0.07 ms
Closing tables	0.06 ms
Opening tables	5.65 ms
After opening tables	0.10 ms
System lock	0.05 ms
Table lock	0.08 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.13 ms
Preparing	0.15 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.12 ms
After opening tables	0.06 ms
Checking permissions	1.16 ms
Closing tables	0.11 ms
Executing	0.05 ms
Sending data	0.40 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Removing tmp table	2.21 ms
Closing tables	0.24 ms
Unlocking tables	0.05 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	3.81 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 17.23 ms After last query: 79.35 ms Query memory: 0.032 MB Memory before query: 2.763 MB Rows returned: 51

SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_users`

Explain

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

Profile

Status	Duration
Starting	0.51 ms
Checking permissions	0.07 ms
Closing tables	0.06 ms
Opening tables	4.89 ms
After opening tables	0.09 ms
System lock	0.05 ms
Table lock	0.08 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.13 ms
Preparing	0.15 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.15 ms
After opening tables	0.08 ms
Checking permissions	4.21 ms
Closing tables	0.11 ms
Executing	0.05 ms
Sending data	1.21 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Removing tmp table	3.83 ms
Closing tables	0.08 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	7.04 ms
Reset for next command	0.11 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:252
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
11	JLoader::_load()	JROOT/libraries/loader.php:707
10	JLoader::_autoload()	Same as call in the line below.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:227
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.49 ms After last query: 25.18 ms Query memory: 0.022 MB Memory before query: 2.916 MB Rows returned: 2

SELECT DISTINCT(user_id)

  FROM rxtgu_usergroups as ug1

  INNER JOIN rxtgu_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN rxtgu_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	81	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.70 ms
Checking permissions	0.08 ms
Opening tables	0.53 ms
After opening tables	0.08 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.19 ms
Optimizing	0.18 ms
Statistics	0.64 ms
Preparing	0.07 ms
Unlocking tables	0.05 ms
Preparing	0.17 ms
Creating tmp table	0.51 ms
Executing	0.06 ms
Sending data	1.03 ms
Removing tmp table	0.15 ms
Sending data	0.87 ms
End of update loop	0.08 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.06 ms
Unlocking tables	0.05 ms
Closing tables	0.09 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	1.43 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:233
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.25 ms After last query: 0.98 ms Query memory: 0.022 MB Memory before query: 2.923 MB Rows returned: 4

SELECT DISTINCT(user_id)

  FROM rxtgu_usergroups as ug1

  INNER JOIN rxtgu_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN rxtgu_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	81	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.60 ms
Checking permissions	0.08 ms
Opening tables	0.16 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.08 ms
Init	0.18 ms
Optimizing	0.44 ms
Statistics	0.62 ms
Preparing	0.07 ms
Unlocking tables	0.05 ms
Preparing	0.17 ms
Creating tmp table	0.49 ms
Executing	0.06 ms
Sending data	1.10 ms
Removing tmp table	0.15 ms
Sending data	0.62 ms
End of update loop	0.08 ms
Query end	0.06 ms
Commit	0.06 ms
Closing tables	0.06 ms
Unlocking tables	0.04 ms
Closing tables	0.18 ms
Starting cleanup	0.06 ms
Freeing items	0.07 ms
Updating status	1.24 ms
Reset for next command	0.08 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:233
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.32 ms After last query: 0.78 ms Query memory: 0.021 MB Memory before query: 2.929 MB Rows returned: 0

SELECT user_id, category_id, role 
  FROM rxtgu_kunena_user_categories 
  WHERE role IN (1,2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtgu_kunena_user_categories	range	role	role	1	NULL	2	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:233
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.02 ms After last query: 78.03 ms Query memory: 0.032 MB Memory before query: 2.974 MB Rows returned: 14

SELECT * 
  FROM rxtgu_kunena_categories 
  ORDER BY ordering, name

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
17	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
16	JLoader::_load()	JROOT/libraries/loader.php:707
15	JLoader::_autoload()	Same as call in the line below.
14	spl_autoload_call()	JROOT/components/com_kunena/controller/category/topics/display.php:71
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 17.01 ms After last query: 5.60 ms Query memory: 0.022 MB Memory before query: 3.103 MB Rows returned: 1

Duplicate queries: #23

SELECT COUNT(*) 
  FROM rxtgu_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (9)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	index_merge	category_id,hold	category_id,hold	4,1	NULL	2	Using intersect(category_id,hold); Using where; Using index

Profile

Status	Duration
Starting	0.52 ms
Checking permissions	0.08 ms
Opening tables	0.13 ms
After opening tables	0.06 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.17 ms
Optimizing	0.15 ms
Statistics	0.38 ms
Preparing	0.21 ms
Executing	0.06 ms
Sending data	14.11 ms
End of update loop	0.11 ms
Query end	0.06 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	1.12 ms
Reset for next command	0.08 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:99
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 44.69 ms After last query: 0.67 ms Query memory: 0.023 MB Memory before query: 3.109 MB Rows returned: 3

Duplicate queries: #24

SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
				
  FROM rxtgu_kunena_topics AS tt
				
  LEFT JOIN rxtgu_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'
				
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (9)    
  ORDER BY tt.ordering DESC, tt.last_post_time DESC 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	ref	category_id,hold	category_id	4	const	3	Using where; Using filesort
1	SIMPLE	ut	eq_ref	user_topic_id,topic_id	user_topic_id	8	const,lancia_org.tt.id	1

Profile

Status	Duration
Starting	0.84 ms
Checking permissions	0.08 ms
Opening tables	0.15 ms
After opening tables	0.06 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.34 ms
Optimizing	0.20 ms
Statistics	0.50 ms
Preparing	0.25 ms
Sorting result	0.12 ms
Executing	0.06 ms
Sending data	0.22 ms
Creating sort index	40.31 ms
End of update loop	0.10 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.10 ms
Starting cleanup	0.05 ms
Freeing items	0.10 ms
Updating status	2.47 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:316
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:99
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.12 ms After last query: 1.73 ms Query memory: 0.025 MB Memory before query: 3.136 MB Rows returned: 3

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
				
  FROM rxtgu_users AS u
				
  LEFT JOIN rxtgu_kunena_users AS ku 
  ON u.id = ku.userid
				
  WHERE u.id IN (745,868,751)

Explain

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

Profile

Status	Duration
Starting	0.61 ms
Checking permissions	0.08 ms
Opening tables	0.24 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.44 ms
Optimizing	0.19 ms
Statistics	0.37 ms
Preparing	0.73 ms
Executing	0.06 ms
Sending data	4.65 ms
End of update loop	0.09 ms
Query end	0.06 ms
Commit	0.06 ms
Closing tables	0.06 ms
Unlocking tables	0.05 ms
Closing tables	0.09 ms
Starting cleanup	0.05 ms
Freeing items	0.10 ms
Updating status	3.04 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:201
14	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/controller/category/topics/display.php:117
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.10 ms After last query: 2.29 ms Query memory: 0.023 MB Memory before query: 3.156 MB Rows returned: 0

SELECT * 
  FROM rxtgu_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (48,31,23)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtgu_kunena_user_topics	range	user_topic_id,topic_id	user_topic_id	8	NULL	3	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/user/helper.php:379
16	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:86
15	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:168
14	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:120
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 10.65 ms After last query: 2.23 ms Query memory: 0.026 MB Memory before query: 3.169 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_user_topics`

Explain

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

Profile

Status	Duration
Starting	0.44 ms
Checking permissions	0.30 ms
Closing tables	0.07 ms
Opening tables	4.17 ms
After opening tables	0.09 ms
System lock	0.05 ms
Table lock	0.07 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.13 ms
Preparing	0.15 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.12 ms
After opening tables	0.06 ms
Checking permissions	0.91 ms
Closing tables	0.10 ms
Executing	0.05 ms
Sending data	0.46 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.04 ms
Removing tmp table	1.89 ms
Closing tables	0.08 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	4.60 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausertopics.php:36
20	TableKunenaUserTopics->__construct()	JROOT/libraries/src/Table/Table.php:312
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/forum/topic/user/user.php:112
18	KunenaForumTopicUser->getTable()	JROOT/libraries/kunena/forum/topic/user/user.php:45
17	KunenaForumTopicUser->__construct()	JROOT/libraries/kunena/forum/topic/user/helper.php:397
16	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:86
15	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:168
14	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:120
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.00 ms After last query: 4.02 ms Query memory: 0.023 MB Memory before query: 3.188 MB Rows returned: 1

Duplicate queries: #18

SELECT COUNT(*) 
  FROM rxtgu_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (9)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	index_merge	category_id,hold	category_id,hold	4,1	NULL	2	Using intersect(category_id,hold); Using where; Using index

Profile

Status	Duration
Starting	0.46 ms
Checking permissions	0.07 ms
Opening tables	0.13 ms
After opening tables	0.06 ms
System lock	0.06 ms
Table lock	0.08 ms
Init	0.17 ms
Optimizing	0.15 ms
Statistics	0.38 ms
Preparing	0.21 ms
Executing	0.24 ms
Sending data	0.83 ms
End of update loop	0.09 ms
Query end	0.06 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	1.10 ms
Reset for next command	0.08 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:307
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:362
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:134
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.39 ms After last query: 0.65 ms Query memory: 0.024 MB Memory before query: 3.196 MB Rows returned: 3

Duplicate queries: #19

SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
				
  FROM rxtgu_kunena_topics AS tt
				
  LEFT JOIN rxtgu_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'
				
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (9)    
  ORDER BY tt.ordering DESC, tt.last_post_time DESC 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	ref	category_id,hold	category_id	4	const	3	Using where; Using filesort
1	SIMPLE	ut	eq_ref	user_topic_id,topic_id	user_topic_id	8	const,lancia_org.tt.id	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:316
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:307
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:362
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:134
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 12.74 ms After last query: 51.18 ms Query memory: 0.034 MB Memory before query: 3.271 MB Rows returned: 35

SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_categories`

Explain

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

Profile

Status	Duration
Starting	0.47 ms
Checking permissions	0.07 ms
Closing tables	0.06 ms
Opening tables	5.07 ms
After opening tables	0.10 ms
System lock	0.05 ms
Table lock	0.08 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.12 ms
Preparing	0.15 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.14 ms
After opening tables	0.06 ms
Checking permissions	2.87 ms
Closing tables	0.11 ms
Executing	0.05 ms
Sending data	0.82 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.04 ms
Removing tmp table	1.01 ms
Closing tables	0.07 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	5.20 ms
Reset for next command	0.10 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
23	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:282
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1051
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
17	JHtmlKunenaForum::categorylist()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_kunena/controller/category/index/display.php:61
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 12.88 ms After last query: 47.09 ms Query memory: 0.029 MB Memory before query: 3.376 MB Rows returned: 17

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

  FROM rxtgu_modules AS m

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

  LEFT JOIN rxtgu_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-05-05 23:05:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-05 23:05:57') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 132 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	21	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	lancia_org.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	lancia_org.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	1.14 ms
Checking permissions	0.08 ms
Opening tables	0.20 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.08 ms
Init	0.38 ms
Optimizing	0.33 ms
Statistics	0.67 ms
Preparing	0.42 ms
Sorting result	0.13 ms
Executing	0.06 ms
Sending data	0.11 ms
Creating sort index	7.55 ms
End of update loop	0.10 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.06 ms
Unlocking tables	0.05 ms
Closing tables	0.10 ms
Starting cleanup	0.06 ms
Freeing items	0.36 ms
Updating status	5.33 ms
Reset for next command	0.12 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
24	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
23	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
22	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
21	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
20	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php:13
19	include JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
16	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php:39
15	include JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.59 ms After last query: 11.13 ms Query memory: 0.027 MB Memory before query: 3.481 MB Rows returned: 66

SELECT code, location 
  FROM rxtgu_kunena_smileys

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1035
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:45
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:79
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:112
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:354
16	KunenaForumCategory->displayField()	JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php:70
15	include JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.95 ms After last query: 74.76 ms Query memory: 0.032 MB Memory before query: 3.549 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `rxtgu_users`

Explain

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

Profile

Status	Duration
Starting	0.47 ms
Checking permissions	0.07 ms
Closing tables	0.06 ms
Opening tables	3.72 ms
After opening tables	0.09 ms
System lock	0.05 ms
Table lock	0.08 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.13 ms
Preparing	0.15 ms
Executing	0.06 ms
Filling schema table	0.10 ms
Opening tables	0.18 ms
After opening tables	0.09 ms
Checking permissions	1.70 ms
Closing tables	0.11 ms
Executing	0.05 ms
Sending data	0.57 ms
End of update loop	0.07 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Removing tmp table	1.00 ms
Closing tables	0.07 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	5.71 ms
Reset for next command	0.11 ms

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
34	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
33	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
32	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
31	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
30	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
29	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
28	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
27	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
26	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
25	Joomla\CMS\Factory::getUser()	JROOT/components/com_jsn/helpers/helper.php:602
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.06 ms After last query: 5.14 ms Query memory: 0.027 MB Memory before query: 3.578 MB Rows returned: 1

SELECT *

  FROM `rxtgu_users`

  WHERE `id` = 745

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
29	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
28	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
27	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
26	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
25	Joomla\CMS\Factory::getUser()	JROOT/components/com_jsn/helpers/helper.php:602
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.68 ms After last query: 2.87 ms Query memory: 0.027 MB Memory before query: 3.594 MB Rows returned: 7

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

  FROM `rxtgu_usergroups` AS g

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

  WHERE `m`.`user_id` = 745

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
29	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
28	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
27	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
26	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
25	Joomla\CMS\Factory::getUser()	JROOT/components/com_jsn/helpers/helper.php:602
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 10.61 ms After last query: 3.10 ms Query memory: 0.027 MB Memory before query: 3.610 MB Rows returned: 1

SELECT a.*

  FROM rxtgu_jsn_users AS a

  WHERE a.id = 745

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/plugins/user/jsn_users/jsn_users.php:60
27	PlgUserJsn_Users->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/components/com_jsn/helpers/helper.php:611
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.32 ms After last query: 0.93 ms Query memory: 0.038 MB Memory before query: 3.622 MB Rows returned: 13

SELECT a.*

  FROM rxtgu_jsn_fields AS a

  WHERE a.level = 2 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	field_idx	field_idx	1	const	14	Using where

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/user/jsn_users/jsn_users.php:74
27	PlgUserJsn_Users->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/components/com_jsn/helpers/helper.php:611
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.29 ms After last query: 4.72 ms Query memory: 0.038 MB Memory before query: 3.679 MB Rows returned: 13

SELECT a.*,b.access as parent_access

  FROM rxtgu_jsn_fields AS a

  LEFT JOIN rxtgu_jsn_fields AS b 
  ON a.parent_id = b.id

  WHERE a.level = 2 
  AND a.published = 1

  ORDER BY a.lft ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	field_idx	field_idx	1	const	14	Using where; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	lancia_org.a.parent_id	1

Profile

Status	Duration
Starting	0.57 ms
Checking permissions	0.08 ms
Opening tables	0.33 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.39 ms
Optimizing	0.20 ms
Statistics	0.37 ms
Preparing	0.22 ms
Sorting result	0.11 ms
Executing	0.06 ms
Sending data	0.27 ms
Creating sort index	2.25 ms
End of update loop	0.09 ms
Query end	0.06 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.09 ms
Updating status	2.57 ms
Reset for next command	0.11 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/components/com_jsn/helpers/helper.php:236
25	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:613
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.18 ms After last query: 1.81 ms Query memory: 0.027 MB Memory before query: 3.726 MB Rows returned: 21

SELECT b.id

  FROM rxtgu_user_usergroup_map AS map

  LEFT JOIN rxtgu_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 745

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	7	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	lancia_org.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	9	Range checked for each record (index map: 0x10)

Profile

Status	Duration
Starting	0.58 ms
Checking permissions	0.08 ms
Opening tables	0.17 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.08 ms
Init	0.19 ms
Optimizing	0.16 ms
Statistics	0.45 ms
Preparing	0.32 ms
Executing	0.06 ms
Sending data	2.72 ms
End of update loop	0.08 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.09 ms
Starting cleanup	0.06 ms
Freeing items	0.07 ms
Updating status	5.80 ms
Reset for next command	0.12 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
28	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
27	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
26	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/components/com_jsn/helpers/helper.php:240
25	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:613
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.46 ms After last query: 91.38 ms Query memory: 0.027 MB Memory before query: 3.803 MB Rows returned: 1

SELECT *

  FROM `rxtgu_users`

  WHERE `id` = 751

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
30	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
29	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
28	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
27	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
26	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
25	Joomla\CMS\Factory::getUser()	JROOT/components/com_jsn/helpers/helper.php:602
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.58 ms After last query: 1.35 ms Query memory: 0.027 MB Memory before query: 3.817 MB Rows returned: 6

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

  FROM `rxtgu_usergroups` AS g

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

  WHERE `m`.`user_id` = 751

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
29	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
28	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
27	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
26	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
25	Joomla\CMS\Factory::getUser()	JROOT/components/com_jsn/helpers/helper.php:602
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.20 ms After last query: 1.74 ms Query memory: 0.027 MB Memory before query: 3.828 MB Rows returned: 1

SELECT a.*

  FROM rxtgu_jsn_users AS a

  WHERE a.id = 751

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/plugins/user/jsn_users/jsn_users.php:60
27	PlgUserJsn_Users->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/components/com_jsn/helpers/helper.php:611
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.55 ms After last query: 4.24 ms Query memory: 0.027 MB Memory before query: 3.842 MB Rows returned: 19

SELECT b.id

  FROM rxtgu_user_usergroup_map AS map

  LEFT JOIN rxtgu_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 751

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	6	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	lancia_org.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	9	Range checked for each record (index map: 0x10)

Profile

Status	Duration
Starting	0.57 ms
Checking permissions	0.08 ms
Opening tables	0.17 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.08 ms
Init	0.18 ms
Optimizing	0.16 ms
Statistics	0.46 ms
Preparing	0.32 ms
Executing	0.06 ms
Sending data	2.43 ms
End of update loop	0.09 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.06 ms
Unlocking tables	0.05 ms
Closing tables	0.09 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	6.24 ms
Reset for next command	0.13 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
28	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
27	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
26	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/components/com_jsn/helpers/helper.php:240
25	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:613
24	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
23	JsnHelper::getUser()	JROOT/plugins/kunena/easyprofile/avatar.php:51
22	KunenaAvatarEasyprofile->_getURL()	JROOT/libraries/kunena/integration/avatar.php:124
21	KunenaAvatar->getURL()	JROOT/libraries/kunena/integration/avatar.php:141
20	KunenaAvatar->getLink()	JROOT/libraries/kunena/user/user.php:528
19	KunenaUser->getAvatarImage()	JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php:23
18	include JROOT/components/com_kunena/template/crypsis/layouts/topic/row/category.php	JROOT/libraries/kunena/layout/base.php:183
17	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
16	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
15	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php:99
14	include JROOT/components/com_kunena/template/crypsis/layouts/category/item/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:30
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.10 ms After last query: 190.44 ms Query memory: 0.022 MB Memory before query: 3.919 MB Rows returned: 0

SELECT *

  FROM rxtgu_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-05-05 23:05:57') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-05 23:05:57')

  ORDER BY id DESC 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/layouts/page/default.php:35
10	include JROOT/components/com_kunena/template/crypsis/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:69
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.38 ms After last query: 409.86 ms Query memory: 0.036 MB Memory before query: 4.195 MB Rows returned: 103

SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM rxtgu_phocagallery_categories AS cc 
  WHERE cc.published = 1 
  AND cc.approved = 1 
  AND cc.id != 0  
  ORDER BY cc.ordering

Explain

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

Profile

Status	Duration
Starting	0.75 ms
Checking permissions	0.08 ms
Opening tables	0.17 ms
After opening tables	0.07 ms
System lock	0.06 ms
Table lock	0.09 ms
Init	0.24 ms
Optimizing	0.16 ms
Statistics	0.32 ms
Preparing	0.71 ms
Sorting result	0.11 ms
Executing	0.05 ms
Sending data	0.11 ms
Creating sort index	5.21 ms
End of update loop	0.08 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.05 ms
Closing tables	0.08 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	6.03 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_tree/mod_phocagallery_tree.php:96
16	include JROOT/modules/mod_phocagallery_tree/mod_phocagallery_tree.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_master/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_master/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_master/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_master/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_master/layouts/template.php:119
9	include JROOT/templates/yoo_master/layouts/template.php	JROOT/templates/yoo_master/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_master/index.php:19
7	require JROOT/templates/yoo_master/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.64 ms After last query: 140.56 ms Query memory: 0.031 MB Memory before query: 4.349 MB Rows returned: 101

SELECT name,value 
  FROM rxtgu_yendifvideoshare_options

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/components/com_yendifvideoshare/router.php:233
28	YendifVideoShareRouter->getYendifConfig()	JROOT/components/com_yendifvideoshare/router.php:68
27	YendifVideoShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
20	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
19	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_master/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_master/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_master/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_master/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_master/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_master/layouts/template.php:119
9	include JROOT/templates/yoo_master/layouts/template.php	JROOT/templates/yoo_master/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_master/index.php:19
7	require JROOT/templates/yoo_master/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.16 ms After last query: 110.49 ms Query memory: 0.030 MB Memory before query: 4.432 MB Rows returned: 154

SELECT * 
  FROM rxtgu_acymailing_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1124
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT a.* 
  FROM rxtgu_jsn_users AS a

2 × SELECT b.id 
  FROM rxtgu_user_usergroup_map AS map 
  LEFT JOIN rxtgu_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN rxtgu_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

2 × SELECT DISTINCT(user_id) 
  FROM rxtgu_usergroups as ug1 
  INNER JOIN rxtgu_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN rxtgu_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `rxtgu_usergroups` AS g 
  INNER JOIN `rxtgu_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
2 × SELECT * 
  FROM `rxtgu_users`
```

2 × SELECT COUNT(*) 
  FROM rxtgu_kunena_topics AS tt

2 × SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread     
  FROM rxtgu_kunena_topics AS tt     
  LEFT JOIN rxtgu_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'

1 × SELECT `data` 
  FROM `rxtgu_session`

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

1 × SELECT name,value 
  FROM rxtgu_yendifvideoshare_option

1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM rxtgu_phocagallery_categories AS cc

1 × SELECT * 
  FROM rxtgu_kunena_announcement

1 × SELECT a.*,b.access as parent_access 
  FROM rxtgu_jsn_fields AS a 
  LEFT JOIN rxtgu_jsn_fields AS b 
  ON a.parent_id = b.id

1 × SELECT a.* 
  FROM rxtgu_jsn_fields AS a

1 × SELECT code, location 
  FROM rxtgu_kunena_smiley

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

1 × SELECT * 
  FROM rxtgu_kunena_user_topics

1 × SELECT `session_id` 
  FROM `rxtgu_session`

1 × SELECT * 
  FROM rxtgu_kunena_categories

1 × SELECT user_id, category_id, role 
  FROM rxtgu_kunena_user_categories

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

1 × SELECT * 
  FROM rxtgu_kunena_aliases

1 × SELECT `source`,`keepurlparams` 
  FROM `rxtgu_admintools_redirects`

1 × SELECT * 
  FROM `rxtgu_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `rxtgu_admintools_storage`

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

1 × SELECT id, rules 
  FROM `rxtgu_viewlevels

1 × SELECT * 
  FROM rxtgu_acymailing_confi

OTHER Tables:

1 × INSERT INTO `rxtgu_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6b7563743469686d71736b736d656e6d703474676f7367713339', 1, 1778022357, 0, '', 0

1 × UPDATE `rxtgu_extensions` 
  SET `params` = '{\"mediaversion\":\"f76ebf6a4c5b80244780b5ffa9a98078\"}'

1 × SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_user_topics

1 × SHOW FULL COLUMNS 
  FROM `rxtgu_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `rxtgu_users

Lancia Fulvia 3 topics

Latest News

Latest Forum Topics

Legal

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

42 Queries Logged 496.63 ms

4 duplicate found!

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: