trusted online casino malaysia FcUK Spamming Corner - Page 4 - Fearless Clan United Kingdom

FcUK Spamming Corner 295 topics

This Area is for pointless conversations about nothing !!

Start
Prev
1
2
3
4
5
6
...
15
Next
End

Subject	Replies / Views	Last Post
Unfortunate Name Topic started 17 years 1 month ago, by FcUK_D Last Post 17 years 1 month ago by Kopitee	Replies:5 Views:5177	Last Post by Kopitee 17 years 1 month ago
A Joke Topic started 17 years 2 months ago, by Kopitee Last Post 17 years 2 months ago by Kopitee	Replies:3 Views:5284	Last Post by Kopitee 17 years 2 months ago
false advertising RIPPED OFF Topic started 17 years 3 months ago, by FcUK_Z Last Post 17 years 3 months ago by FcUK_O	Replies:2 Views:5058	Last Post by FcUK_O 17 years 3 months ago
living life as a first person shooter Topic started 17 years 3 months ago, by FcUK_Q Last Post 17 years 3 months ago by FcUK_A	Replies:2 Views:4292	Last Post by FcUK_A 17 years 3 months ago
lol Topic started 17 years 3 months ago, by FcUK_K Last Post 17 years 3 months ago by FcUK_A	Replies:1 Views:5236	Last Post by FcUK_A 17 years 3 months ago
GG's !!!! Topic started 17 years 4 months ago, by Grave-Digger Last Post 17 years 4 months ago by FcUK_A	Replies:1 Views:4959	Last Post by FcUK_A 17 years 4 months ago
JUST A IDEA Topic started 17 years 4 months ago, by FcUK_O Last Post 17 years 4 months ago by FcUK_Z	Replies:4 Views:5196	Last Post by FcUK_Z 17 years 4 months ago
GGS Topic started 17 years 4 months ago, by FcUK_O Last Post 17 years 4 months ago by FcUK_Y	Replies:2 Views:4815	Last Post by FcUK_Y 17 years 4 months ago
13/06/09 Topic started 17 years 4 months ago, by FcUK_O Last Post 17 years 4 months ago by FcUK_A	Replies:5 Views:5168	Last Post by FcUK_A 17 years 4 months ago
SAME DAY Topic started 17 years 4 months ago, by FcUK_O Last Post 17 years 4 months ago by FcUK_A	Replies:1 Views:4720	Last Post by FcUK_A 17 years 4 months ago
I bet P is happy !! Topic started 17 years 5 months ago, by FcUK_A Last Post 17 years 5 months ago by FcUK_O	Replies:4 Views:5020	Last Post by FcUK_O 17 years 5 months ago
FcUK Me Y just been playing COD 4 Topic started 17 years 5 months ago, by FcUK_E Last Post 17 years 5 months ago by FcUK_I	Replies:2 Views:4287	Last Post by FcUK_I 17 years 5 months ago
P's gone on the Run !. Topic started 17 years 5 months ago, by FcUK_A Last Post 17 years 5 months ago by FcUK_A	Replies:4 Views:4387	Last Post by FcUK_A 17 years 5 months ago
FcUK me just seen Y Topic started 17 years 5 months ago, by FcUK_O Last Post 17 years 5 months ago by Grave-Digger 1 2 3	Replies:12 Views:15.8k	Last Post by Grave-Digger 17 years 5 months ago
new processor Topic started 17 years 5 months ago, by FcUK_D Last Post 17 years 5 months ago by FcUK_D 1 2 3 4	Replies:18 Views:19.9k	Last Post by FcUK_D 17 years 5 months ago
nice test Topic started 17 years 5 months ago, by Grave-Digger Last Post 17 years 5 months ago by Kopitee 1 2	Replies:8 Views:12.1k	Last Post by Kopitee 17 years 5 months ago
Evolution of a WoW player Topic started 17 years 6 months ago, by FcUK_P Last Post 17 years 6 months ago by FcUK_I	Replies:2 Views:5283	Last Post by FcUK_I 17 years 6 months ago
this i have of _J in front of his webcam!! Topic started 17 years 8 months ago, by Grave-Digger Last Post 17 years 8 months ago by FcUK_J 1 2	Replies:10 Views:11.5k	Last Post by FcUK_J 17 years 8 months ago
Battleshits Topic started 17 years 8 months ago, by FcUK_E Last Post 17 years 8 months ago by FcUK_J	Replies:4 Views:5163	Last Post by FcUK_J 17 years 8 months ago
Do Not Get GTA IV Topic started 17 years 8 months ago, by FcUK_I Last Post 17 years 8 months ago by FcUK_A 1 2 3 ... 5	Replies:29 Views:23.4k	Last Post by FcUK_A 17 years 8 months ago

Start
Prev
1
2
3
4
5
6
...
15
Next
End

Time to create page: 0.095 seconds

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1792799586,
                "last": 1792799590,
                "now": 1792799593
            },
            "token": "ygAdTyGmNxy5igL9hv5BOXy4Z6dn0Nu5"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "28": 28,
                    "1": 1,
                    "29": 29,
                    "30": 30,
                    "14": 14,
                    "35": 35,
                    "2": 2,
                    "16": 16,
                    "3": 3,
                    "18": 18,
                    "4": 4,
                    "5": 5,
                    "17": 17,
                    "6": 6,
                    "22": 22,
                    "7": 7,
                    "26": 26
                },
                "category6_html_list_start": 60,
                "topic": {
                    "lasthit": 3843
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Memory Usage

Database Queries

32 Queries Logged 28.28 ms

4 duplicate found!

2 duplicates: #20 #25

2 duplicates: #21 #26

Query Time: 0.44 ms Query memory: 0.023 MB Memory before query: 1.036 MB Rows returned: 1

SELECT `data`

  FROM `oytpc_session`

  WHERE `session_id` = X'666f643462373868323074353371396474353668686930763838'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.43 ms After last query: 1.98 ms Query memory: 0.021 MB Memory before query: 1.138 MB Rows returned: 6

SELECT id, rules

  FROM `oytpc_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.150 MB Rows returned: 2

SELECT b.id

  FROM oytpc_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

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

Call Stack

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

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

Query Time: 0.39 ms After last query: 4.92 ms Query memory: 0.022 MB Memory before query: 1.574 MB Rows returned: 1

SELECT `value`

  FROM `oytpc_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:695
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 1.582 MB Rows returned: 0

SELECT *

  FROM `oytpc_admintools_wafexceptions`

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

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:695
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 7.74 ms Query memory: 0.022 MB Memory before query: 1.798 MB Rows returned: 1

SELECT `params`

  FROM `oytpc_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:124
7	plgSystemJchoptimize->__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:695
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.34 ms Query memory: 0.021 MB Memory before query: 1.819 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `oytpc_admintools_redirects`

  WHERE ((`dest` = 'kunena/fcuk-spamming-corner-general-forum') OR (`dest` = 'kunena/fcuk-spamming-corner-general-forum?start=60') OR ('kunena/fcuk-spamming-corner-general-forum?start=60' 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	oytpc_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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:696
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.19 ms Query memory: 0.020 MB Memory before query: 1.828 MB Rows returned: 1

SELECT count(*)

  FROM `oytpc_cwgears_schedule`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oytpc_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
8	plgSystemCwgears->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:696
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.834 MB Rows returned: 1

SELECT count(*)

  FROM `oytpc_cwgears_schedule`

  WHERE time + '3600'<'1792799593'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
8	plgSystemCwgears->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:696
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 5.12 ms Query memory: 0.022 MB Memory before query: 2.128 MB Rows returned: 1

SELECT * 
  FROM oytpc_kunena_aliases 
  WHERE alias LIKE 'fcuk-spamming-corner-general-forum%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oytpc_kunena_aliases	range	alias	alias	767	NULL	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:936
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:321
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:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.56 ms Query memory: 0.006 MB Memory before query: 2.139 MB

UPDATE `oytpc_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.09 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.36 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
8	plgSystemCwgears->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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.32 ms Query memory: 0.021 MB Memory before query: 2.220 MB Rows returned: 1

SELECT count(*)

  FROM `oytpc_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

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.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
8	plgSystemCwgears->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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 2.20 ms Query memory: 0.025 MB Memory before query: 2.443 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `oytpc_kunena_sessions`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	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:253
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:75
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:320
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:129
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:87
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:53
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:145
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:101
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:68
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.07 ms After last query: 4.34 ms Query memory: 0.035 MB Memory before query: 2.766 MB Rows returned: 55

SHOW FULL COLUMNS 
  FROM `oytpc_kunena_users`

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.25 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.21 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 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:253
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:320
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:231
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:190
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:165
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
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:237
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 1.69 ms Query memory: 0.028 MB Memory before query: 2.864 MB Rows returned: 42

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

  FROM `oytpc_assets`

  WHERE `name` IN ('root.1','com_aclmanager','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gameserver','com_installer','com_jchoptimize','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_squadmanagement','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:292
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:259
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:385
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.31 ms After last query: 0.66 ms Query memory: 0.024 MB Memory before query: 2.927 MB Rows returned: 1

SELECT DISTINCT(user_id)

  FROM oytpc_usergroups AS ug1

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

  INNER JOIN oytpc_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	1827	Using where; Using index; Using join buffer (flat, BNL join)

Profile

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

Call Stack

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

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

Query Time: 1.29 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.937 MB Rows returned: 1

SELECT DISTINCT(user_id)

  FROM oytpc_usergroups AS ug1

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

  INNER JOIN oytpc_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	m	index	NULL	PRIMARY	8	NULL	1827	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	fcuk_joomlanew.m.group_id	1	Using where; Distinct

Profile

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

Call Stack

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

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

Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.945 MB Rows returned: 2

SELECT `user_id`,`category_id`,`role`

  FROM `oytpc_kunena_user_categories`

  WHERE `role` IN (1,2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oytpc_kunena_user_categories	range	role	role	1	NULL	3	Using where; Using index

Profile

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

Call Stack

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

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

Query Time: 0.67 ms After last query: 1.02 ms Query memory: 0.062 MB Memory before query: 3.054 MB Rows returned: 30

SELECT * 
  FROM oytpc_kunena_categories 
  ORDER BY ordering, name

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
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:106
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.03 ms After last query: 0.69 ms Query memory: 0.023 MB Memory before query: 3.255 MB Rows returned: 1

Duplicate queries: #25

SELECT COUNT(*) 
  FROM oytpc_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (6)

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	288	Using intersect(category_id,hold); Using where; Using index

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	1.58 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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:372
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:140
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.55 ms After last query: 0.08 ms Query memory: 0.051 MB Memory before query: 3.263 MB Rows returned: 20

Duplicate queries: #26

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 oytpc_kunena_topics AS tt
				
  LEFT JOIN oytpc_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 (6)    
  ORDER BY tt.ordering DESC, tt.last_post_time DESC 
  LIMIT 60, 20

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	288	Using intersect(category_id,hold); Using where; Using filesort
1	SIMPLE	ut	eq_ref	user_topic_id,topic_id	user_topic_id	8	const,fcuk_joomlanew.tt.id	1

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	2.96 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:414
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:140
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.45 ms Query memory: 0.055 MB Memory before query: 3.360 MB Rows returned: 13

SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid

  FROM `oytpc_users`AS u

  LEFT JOIN `oytpc_kunena_users` AS ku 
  ON u.id = ku.userid

  WHERE u.id IN (619,908,885,268,906,2,33,724,658,44,498,11,83)

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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:236
14	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/controller/category/topics/display.php:165
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 3.480 MB Rows returned: 0

SELECT * 
  FROM oytpc_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (3414,3405,3390,3385,3381,3364,3359,3361,3357,3358,3344,3342,3335,3326,3329,3325,3314,3288,3289,3279)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oytpc_kunena_user_topics	ref	user_topic_id,topic_id	user_topic_id	4	const	35	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/user/helper.php:146
16	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:99
15	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:242
14	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:168
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.32 ms Query memory: 0.029 MB Memory before query: 3.496 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `oytpc_kunena_user_topics`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.10 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 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:253
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausertopics.php:85
20	TableKunenaUserTopics->__construct()	JROOT/libraries/src/Table/Table.php:320
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/forum/topic/user/user.php:91
18	KunenaForumTopicUser->getTable()	JROOT/libraries/kunena/forum/topic/user/user.php:60
17	KunenaForumTopicUser->__construct()	JROOT/libraries/kunena/forum/topic/user/helper.php:164
16	KunenaForumTopicUserHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/user/helper.php:99
15	KunenaForumTopicUserHelper::getTopics()	JROOT/libraries/kunena/forum/topic/helper.php:242
14	KunenaForumTopicHelper::getUserTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:168
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.83 ms After last query: 1.32 ms Query memory: 0.025 MB Memory before query: 3.539 MB Rows returned: 1

Duplicate queries: #20

SELECT COUNT(*) 
  FROM oytpc_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (6)

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	288	Using intersect(category_id,hold); Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:372
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:349
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:410
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:182
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.29 ms After last query: 0.06 ms Query memory: 0.052 MB Memory before query: 3.549 MB Rows returned: 20

Duplicate queries: #21

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 oytpc_kunena_topics AS tt
				
  LEFT JOIN oytpc_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 (6)    
  ORDER BY tt.ordering DESC, tt.last_post_time DESC 
  LIMIT 60, 20

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	288	Using intersect(category_id,hold); Using where; Using filesort
1	SIMPLE	ut	eq_ref	user_topic_id,topic_id	user_topic_id	8	const,fcuk_joomlanew.tt.id	1

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.86 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 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:414
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:349
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:410
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:182
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 3.33 ms Query memory: 0.037 MB Memory before query: 3.777 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `oytpc_kunena_categories`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.15 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.04 ms
Reset for next command	0.01 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:253
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:241
23	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:320
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:224
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:243
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1152
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:633
18	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:84
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:144
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:28
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 2.24 ms Query memory: 0.030 MB Memory before query: 3.913 MB Rows returned: 66

SELECT code, location 
  FROM oytpc_kunena_smileys

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1137
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:57
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:92
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:180
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:703
16	KunenaForumCategory->displayField()	JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php:75
15	include JROOT/components/com_kunena/template/crypsis/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php:28
10	include JROOT/components/com_kunena/template/crypsis/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.61 ms After last query: 50.50 ms Query memory: 0.023 MB Memory before query: 4.215 MB Rows returned: 0

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

  FROM oytpc_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_kunena.category' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.16 ms
Preparing	0.05 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.05 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
13	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
11	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
10	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_kunena/kunena.php:141
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 3.80 ms Query memory: 0.023 MB Memory before query: 4.340 MB Rows returned: 0

SELECT *

  FROM oytpc_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-10-23 23:53:13') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-10-23 23:53:13')

  ORDER BY id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oytpc_kunena_announcement	index	NULL	PRIMARY	4	NULL	1	Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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:141
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:50
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
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:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:143
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 8.55 ms Query memory: 0.022 MB Memory before query: 4.533 MB Rows returned: 0

SELECT uikit

  FROM `oytpc_cwgears`

  WHERE url = 'https://fcuk.org.uk/kunena/fcuk-spamming-corner-general-forum?start=60'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:417
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 4.540 MB Rows returned: 0

SELECT uikit_plus

  FROM `oytpc_cwgears`

  WHERE url = 'https://fcuk.org.uk/kunena/fcuk-spamming-corner-general-forum?start=60'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:426
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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 oytpc_kunena_topics AS tt     
  LEFT JOIN oytpc_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'

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

2 × SELECT COUNT(*) 
  FROM oytpc_kunena_topics AS tt

1 × SELECT `user_id`,`category_id`,`role` 
  FROM `oytpc_kunena_user_categories`

1 × SELECT uikit 
  FROM `oytpc_cwgears`

1 × SELECT * 
  FROM oytpc_kunena_announcement

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM oytpc_fields AS a 
  LEFT JOIN `oytpc_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN oytpc_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN oytpc_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN oytpc_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN oytpc_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT code, location 
  FROM oytpc_kunena_smiley

1 × SELECT * 
  FROM oytpc_kunena_user_topics

1 × SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid 
  FROM `oytpc_users`AS u 
  LEFT JOIN `oytpc_kunena_users` AS ku 
  ON u.id = ku.userid

1 × SELECT * 
  FROM oytpc_kunena_categories

1 × SELECT `data` 
  FROM `oytpc_session`

1 × SELECT id, rules 
  FROM `oytpc_viewlevels

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

1 × SELECT count(*) 
  FROM `oytpc_extensions`

1 × SELECT * 
  FROM oytpc_kunena_aliases

1 × SELECT count(*) 
  FROM `oytpc_cwgears_schedule`

1 × SELECT count(*) 
  FROM `oytpc_cwgears_schedule

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

1 × SELECT `params` 
  FROM `oytpc_extensions`

1 × SELECT * 
  FROM `oytpc_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `oytpc_admintools_storage`

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

1 × SELECT uikit_plus 
  FROM `oytpc_cwgears`

OTHER Tables:

1 × UPDATE `oytpc_extensions` 
  SET `params` = '{\"mediaversion\":\"a9391e8fd422dd56d3384cd6c1a3085c\"}'

1 × SHOW FULL COLUMNS 
  FROM `oytpc_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `oytpc_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `oytpc_kunena_user_topics

1 × SHOW FULL COLUMNS 
  FROM `oytpc_kunena_categories