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

FcUK Spamming Corner 295 topics

This Area is for pointless conversations about nothing !!

Start
Prev
1
...
6
7
8
9
10
...
15
Next
End

Subject	Replies / Views	Last Post
Drunk woman tasered in police station !! Topic started 19 years 1 month ago, by FcUK_A Last Post 19 years 1 month ago by FcUK_A	Replies:0 Views:3591	Last Post by FcUK_A 19 years 1 month ago
Test Topic started 19 years 2 months ago, by FcUK_A Last Post 19 years 2 months ago by FcUK_Y 1 2 3 ... 5	Replies:25 Views:20.5k	Last Post by FcUK_Y 19 years 2 months ago
Dream WoW Girl for the WoWers !! Topic started 19 years 2 months ago, by FcUK_A Last Post 19 years 2 months ago by FcUK_L	Replies:1 Views:3536	Last Post by FcUK_L 19 years 2 months ago
Office Prank On Boss Topic started 19 years 2 months ago, by FcUK_A Last Post 19 years 2 months ago by FcUK_L	Replies:1 Views:3832	Last Post by FcUK_L 19 years 2 months ago
G en his Fish!!! Topic started 19 years 2 months ago, by Grave-Digger Last Post 19 years 2 months ago by FcUK_L 1 2 3	Replies:14 Views:13.2k	Last Post by FcUK_L 19 years 2 months ago
SWASTIKA Topic started 19 years 2 months ago, by FcUK_O Last Post 19 years 2 months ago by Sheepy 1 2	Replies:8 Views:9897	Last Post by Sheepy 19 years 2 months ago
lo Topic started 19 years 3 months ago, by Grave-Digger Last Post 19 years 3 months ago by FcUK_O	Replies:3 Views:4278	Last Post by FcUK_O 19 years 3 months ago
Wish you were here (A letter from America) Topic started 19 years 3 months ago, by Julian Last Post 19 years 3 months ago by FcUK_H 1 2	Replies:6 Views:9654	Last Post by FcUK_H 19 years 3 months ago
Americans are not stupid! (not much anyway) Topic started 19 years 3 months ago, by Sheepy Last Post 19 years 3 months ago by FcUK_J	Replies:4 Views:3765	Last Post by FcUK_J 19 years 3 months ago
WoW Topic started 19 years 4 months ago, by Herman Last Post 19 years 4 months ago by FcUK_A 1 2	Replies:10 Views:10.1k	Last Post by FcUK_A 19 years 4 months ago
Tip -Grand National Topic started 19 years 4 months ago, by Cully Last Post 19 years 4 months ago by FcUK_O 1 2	Replies:11 Views:10.3k	Last Post by FcUK_O 19 years 4 months ago
you know they want to! Topic started 19 years 4 months ago, by Sheepy Last Post 19 years 4 months ago by FcUK_O	Replies:4 Views:4433	Last Post by FcUK_O 19 years 4 months ago
Evolution X Topic started 19 years 5 months ago, by FcUK_D Last Post 19 years 5 months ago by Cully 1 2 3	Replies:15 Views:13.9k	Last Post by Cully 19 years 5 months ago
Anyone Seen S or K ? Topic started 19 years 5 months ago, by FcUK_A Last Post 19 years 5 months ago by Stormdog 1 2	Replies:7 Views:9891	Last Post by Stormdog 19 years 5 months ago
300 Topic started 19 years 5 months ago, by Sheepy Last Post 19 years 5 months ago by Sheepy	Replies:3 Views:4124	Last Post by Sheepy 19 years 5 months ago
World's Worst Driver... Topic started 19 years 5 months ago, by FcUK_L Last Post 19 years 5 months ago by FcUK_O 1 2	Replies:8 Views:9779	Last Post by FcUK_O 19 years 5 months ago
FcUK_W... Being Welsh is still a problem for him... Topic started 19 years 5 months ago, by FcUK_L Last Post 19 years 5 months ago by Stormdog	Replies:1 Views:3367	Last Post by Stormdog 19 years 5 months ago
XD Topic started 19 years 5 months ago, by Julian Last Post 19 years 5 months ago by FcUK_L	Replies:1 Views:3747	Last Post by FcUK_L 19 years 5 months ago
Are you driving under the influence? Topic started 19 years 5 months ago, by Julian Last Post 19 years 5 months ago by Julian	Replies:0 Views:3376	Last Post by Julian 19 years 5 months ago
World of Warcraft... Topic started 19 years 5 months ago, by Julian Last Post 19 years 5 months ago by FcUK_B 1 2	Replies:9 Views:10.2k	Last Post by FcUK_B 19 years 5 months ago

Start
Prev
1
...
6
7
8
9
10
...
15
Next
End

Time to create page: 0.076 seconds

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1789026451,
                "last": 1789026453,
                "now": 1789026455
            },
            "token": "UpDn82bYEJqwFb7AWaC7eRWPrRXUjycO"
        },
        "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
                },
                "topic": {
                    "lasthit": 2490
                },
                "category6_html_list_start": 140
            }
        },
        "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 19.95 ms

4 duplicate found!

2 duplicates: #20 #25

2 duplicates: #21 #26

Query Time: 0.34 ms Query memory: 0.023 MB Memory before query: 1.037 MB Rows returned: 1

SELECT `data`

  FROM `oytpc_session`

  WHERE `session_id` = X'626870366671326b3639726f6767397562626f65736c7069726b'

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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 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.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
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.26 ms After last query: 1.31 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.04 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.01 ms
Optimizing	0.00 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.00 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: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.37 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.151 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.04 ms
checking permissions	0.00 ms
Opening tables	0.02 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.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.08 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
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.34 ms After last query: 3.98 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.04 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.03 ms
Preparing	0.00 ms
Unlocking tables	0.04 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.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
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.26 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 1.583 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.03 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.01 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.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
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.48 ms After last query: 6.63 ms Query memory: 0.022 MB Memory before query: 1.799 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.04 ms
checking permissions	0.00 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.02 ms
Statistics	0.08 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.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
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.30 ms After last query: 0.37 ms Query memory: 0.021 MB Memory before query: 1.820 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `oytpc_admintools_redirects`

  WHERE ((`dest` = 'forum/fcuk-spamming-corner-general-forum') OR (`dest` = 'forum/fcuk-spamming-corner-general-forum?start=140') OR ('forum/fcuk-spamming-corner-general-forum?start=140' 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.05 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.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 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
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.22 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.02 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 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.00 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: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.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 1.835 MB Rows returned: 1

SELECT count(*)

  FROM `oytpc_cwgears_schedule`

  WHERE time + '3600'<'1789026455'

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.05 ms
checking permissions	0.02 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.02 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.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
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.31 ms After last query: 3.72 ms Query memory: 0.022 MB Memory before query: 2.129 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.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.06 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	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
Unlocking tables	0.00 ms
closing tables	0.00 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
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.56 ms After last query: 0.40 ms Query memory: 0.006 MB Memory before query: 2.140 MB

UPDATE `oytpc_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.07 ms
Updating	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.27 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
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.21 ms After last query: 0.25 ms Query memory: 0.021 MB Memory before query: 2.221 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.03 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.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.00 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.53 ms After last query: 1.45 ms Query memory: 0.025 MB Memory before query: 2.444 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.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.19 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 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.05 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.08 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.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: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: 0.68 ms After last query: 3.21 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.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.14 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.06 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.07 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.01 ms
Reset for next command	0.00 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.52 ms After last query: 1.25 ms Query memory: 0.028 MB Memory before query: 2.865 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.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.04 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.18 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
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.50 ms After last query: 0.37 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.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Executing	0.01 ms
Sending data	1.05 ms
Removing tmp table	0.04 ms
Sending data	0.01 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
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.11 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.938 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.05 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.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.77 ms
Removing tmp table	0.01 ms
Sending data	0.01 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
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.25 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.946 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.03 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.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 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.00 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
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.51 ms After last query: 0.87 ms Query memory: 0.062 MB Memory before query: 3.055 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.03 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.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.21 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
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: 1.08 ms After last query: 0.80 ms Query memory: 0.023 MB Memory before query: 3.256 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	ref	category_id,hold	category_id	4	const	295	Using where

Profile

Status	Duration
Starting	0.03 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.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.76 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: 2.08 ms After last query: 0.05 ms Query memory: 0.051 MB Memory before query: 3.264 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 140, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	ref	category_id,hold	category_id	4	const	295	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.07 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.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.57 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
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.58 ms After last query: 0.32 ms Query memory: 0.055 MB Memory before query: 3.359 MB Rows returned: 14

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 (2,658,684,724,268,19,719,27,83,10,219,619,340,75)

Explain

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

Profile

Status	Duration
Starting	0.05 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.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.22 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
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.42 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 3.486 MB Rows returned: 0

SELECT * 
  FROM oytpc_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (2693,2673,2677,2676,2669,2670,2661,2658,2654,2626,2624,2622,2617,2601,2599,2595,2597,2596,2593,2587)

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.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.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.63 ms After last query: 0.21 ms Query memory: 0.029 MB Memory before query: 3.503 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.23 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
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.06 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.01 ms
Reset for next command	0.00 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: 0.99 ms After last query: 1.13 ms Query memory: 0.025 MB Memory before query: 3.546 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	ref	category_id,hold	category_id	4	const	295	Using where

Profile

Status	Duration
Starting	0.03 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.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.73 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
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: 1.83 ms After last query: 0.09 ms Query memory: 0.052 MB Memory before query: 3.555 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 140, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tt	ref	category_id,hold	category_id	4	const	295	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.02 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.44 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
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.76 ms After last query: 2.60 ms Query memory: 0.037 MB Memory before query: 3.782 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.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.20 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.06 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.12 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.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
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.39 ms After last query: 1.71 ms Query memory: 0.030 MB Memory before query: 3.918 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.03 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.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	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
Unlocking tables	0.00 ms
closing tables	0.00 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.29 ms After last query: 43.57 ms Query memory: 0.023 MB Memory before query: 4.235 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.18 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.02 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 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.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: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.34 ms After last query: 2.83 ms Query memory: 0.023 MB Memory before query: 4.357 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-09-10 07:47:35') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-10 07:47:35')

  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.06 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.01 ms
Preparing	0.02 ms
Sorting result	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.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.03 ms
Reset for next command	0.00 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.28 ms After last query: 6.38 ms Query memory: 0.022 MB Memory before query: 4.550 MB Rows returned: 0

SELECT uikit

  FROM `oytpc_cwgears`

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

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.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.01 ms
Preparing	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
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
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.25 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.557 MB Rows returned: 0

SELECT uikit_plus

  FROM `oytpc_cwgears`

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

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.03 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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 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.00 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
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\":\"f392f6bbc9cb2ece43ff0357050e0a42\"}'

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