Realty Times - Spring Brings Record-High Monthly Housing Costs, Keeping Pending Home Sales at Bay

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1790268292,
                "last": 1790268292,
                "now": 1790268293
            },
            "token": "NF5aMZ6OtoJf6A2AwYmwDmJTEqLJhbAk"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "3229f7992c50553005e7392ad3046e037c1198eb",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "b91648f908776fdc3598841be180a0b5a8b84e6c": {
                    "link": "https://j3.realtytimes.com/headlines/item/1051901-permits-to-build-u-s-apartments-drop-below-pre-pandemic-levels",
                    "expiry": 1790268292
                },
                "234794fa62d1f335b92dd23ddcdf035aa54389ca": {
                    "link": "https://j3.realtytimes.com/headlines/item/1051200-single-women-own-2-72-million-more-homes-than-single-men-new-lendingtree-report",
                    "expiry": 1790268293
                },
                "7f9e27ae02f0ce0d2339cd37942bfc2f3cb4d84e": {
                    "link": "https://j3.realtytimes.com/headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay",
                    "expiry": 1790268293
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

49 Queries Logged 73.14 ms

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

SELECT `data`

  FROM `unx0p_session`

  WHERE `session_id` = X'3536743931613573396633706c67346e75383370356f64643868'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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:386
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.11 ms Query memory: 0.021 MB Memory before query: 1.173 MB Rows returned: 5

SELECT id, rules

  FROM `unx0p_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.56 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.185 MB Rows returned: 1

SELECT b.id

  FROM unx0p_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.10 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.10 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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.39 ms After last query: 3.11 ms Query memory: 0.022 MB Memory before query: 1.651 MB Rows returned: 1

SELECT `value`

  FROM `unx0p_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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: 0.17 ms Query memory: 0.021 MB Memory before query: 1.660 MB Rows returned: 0

SELECT *

  FROM `unx0p_admintools_wafexceptions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:667
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.45 ms After last query: 12.48 ms Query memory: 0.021 MB Memory before query: 6.333 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `unx0p_admintools_redirects`

  WHERE ((`dest` = 'headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay') OR (`dest` = 'headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay') OR ('headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay' 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	unx0p_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

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.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 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:668
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.37 ms After last query: 1.32 ms Query memory: 0.021 MB Memory before query: 6.366 MB Rows returned: 0

SELECT manifest_cache

  FROM `unx0p_extensions`

  WHERE element = "com_affiliatetracker"

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:199
9	plgSystemAffiliate_tracker->checkComponentInstalled()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:35
8	plgSystemAffiliate_tracker->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:668
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.33 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 6.448 MB Rows returned: 1

SELECT `template`

  FROM `unx0p_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 4.95 ms Query memory: 0.006 MB Memory before query: 6.681 MB

UPDATE `unx0p_extensions`

  SET `params` = '{\"mediaversion\":\"8b15cf2c8fabb0b6587df43b04b30217\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.03 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.05 ms
Updating	0.04 ms
End of update loop	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/k2/k2.php:374
8	plgSystemK2->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 1.81 ms Query memory: 0.027 MB Memory before query: 7.018 MB Rows returned: 56

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

  FROM `unx0p_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_apiforfeed','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_jchoptimize','com_jmap','com_joomlaupdate','com_k2','com_k2additionalcategories','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nletter','com_plugins','com_postinstall','com_privacy','com_realtymanager','com_realtyvideo','com_redirect','com_rereplacer','com_search','com_sigpro','com_sitemapfaster','com_sppagebuilder','com_stats','com_subscribemanager','com_tags','com_templates','com_users','com_videogallery','com_widgetkit','com_wrapper','com_xmap')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.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.41 ms After last query: 1.38 ms Query memory: 0.024 MB Memory before query: 7.237 MB Rows returned: 37

SELECT id 
  FROM unx0p_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_categories	range	category,published,access,trash,idx_category	category	8	NULL	38	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.26 ms After last query: 0.07 ms Query memory: 0.055 MB Memory before query: 7.244 MB Rows returned: 1

SELECT * 
  FROM unx0p_k2_items 
  WHERE id=1051677 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.88 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.74 ms After last query: 0.26 ms Query memory: 0.027 MB Memory before query: 7.281 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `unx0p_k2_categories`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.22 ms Query memory: 0.023 MB Memory before query: 7.305 MB Rows returned: 1

SELECT * 
  FROM unx0p_k2_categories 
  WHERE id = '1143'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.90 ms Query memory: 0.023 MB Memory before query: 7.429 MB Rows returned: 0

SELECT tag.*
            
  FROM unx0p_k2_tags AS tag
            JOIN unx0p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 1051677
            
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	j3realtytimescom_j3.xref.tagID	1	Using where

Profile

Status	Duration
Starting	0.03 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.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1216
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.24 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.438 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_attachments 
  WHERE itemID=1051677

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_attachments	ref	itemID	itemID	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1444
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.21 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 7.448 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_rating 
  WHERE itemID = 1051677

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:929
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:973
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:169
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.62 ms After last query: 0.23 ms Query memory: 0.035 MB Memory before query: 7.463 MB Rows returned: 43

SHOW FULL COLUMNS 
  FROM `unx0p_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 7.520 MB Rows returned: 1

SELECT *

  FROM `unx0p_users`

  WHERE `id` = 826053

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.32 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 7.535 MB Rows returned: 1

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

  FROM `unx0p_usergroups` AS g

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

  WHERE `m`.`user_id` = 826053

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 0.33 ms Query memory: 0.024 MB Memory before query: 7.541 MB Rows returned: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM unx0p_k2_users 
  WHERE userID=826053

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_users	ref	userID	userID	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1696
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.38 ms After last query: 1.49 ms Query memory: 0.025 MB Memory before query: 7.660 MB Rows returned: 0

SELECT r.*

  FROM unx0p_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:64
18	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/rereplacer.php:98
17	PlgSystemReReplacer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/SystemPlugin.php:226
16	RegularLabs\Library\SystemPlugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:603
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.04 ms After last query: 0.31 ms Query memory: 0.026 MB Memory before query: 7.684 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 unx0p_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  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	j3realtytimescom_j3.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.group_id	1	Using where

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:603
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.03 ms After last query: 7.24 ms Query memory: 0.026 MB Memory before query: 7.856 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 unx0p_fields AS a

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

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

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

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

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

  LEFT JOIN `unx0p_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1143,0)) 
  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	j3realtytimescom_j3.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	j3realtytimescom_j3.a.id	1	Using where; Distinct

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.06 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
Removing tmp table	0.09 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:674
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.78 ms After last query: 2.17 ms Query memory: 0.034 MB Memory before query: 7.954 MB Rows returned: 43

SHOW FULL COLUMNS 
  FROM `unx0p_k2_items`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:854
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.05 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 8.009 MB

UPDATE unx0p_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1051677'

Explain

EXPLAIN not possible on query: UPDATE unx0p_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '1051677'

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.03 ms
Updating	0.42 ms
End of update loop	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.35 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
14	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:855
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.36 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 8.016 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_comments 
  WHERE itemID=1051677 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_comments	range	itemID,published,latestComments,idx_countComments	latestComments	4	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.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.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1465
13	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 46.38 ms After last query: 0.18 ms Query memory: 0.136 MB Memory before query: 8.025 MB Rows returned: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM unx0p_k2_items AS i
            
  LEFT JOIN unx0p_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 1051677
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-24 16:44:53')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-24 16:44:53') 
  AND i.access IN(1,1,5) 
  AND i.trash = 0
            
  AND i.created_by = 826053
            
  AND i.created_by_alias=''
            
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0
            
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,catid,created_by,idx_items_common,idx_items_common_backend,idx_items_authors,idx_catid_id	created_by	4	const	570	Using index condition; Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash,idx_category	PRIMARY	4	j3realtytimescom_j3.i.catid	1	Using where

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.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	45.73 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:547
13	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:266
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 0.47 ms Query memory: 0.039 MB Memory before query: 8.141 MB Rows returned: 1

SELECT *
            
  FROM unx0p_k2_items
            
  WHERE id < 1051677
                
  AND catid = 1143
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-24 16:44:53')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-24 16:44:53')
                
  AND access IN (1,1,5)
                
            
  ORDER BY id DESC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_items	range	PRIMARY,catid,idx_items_common,idx_items_common_backend,idx_catid_id	catid	8	NULL	1120	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1619
13	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:290
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 0.43 ms Query memory: 0.023 MB Memory before query: 8.216 MB Rows returned: 0

SELECT tag.*
            
  FROM unx0p_k2_tags AS tag
            JOIN unx0p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 1051671
            
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	j3realtytimescom_j3.xref.tagID	1	Using where

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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1216
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.32 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.224 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_attachments 
  WHERE itemID=1051671

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_attachments	ref	itemID	itemID	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1444
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 0.04 ms Query memory: 0.024 MB Memory before query: 8.232 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_rating 
  WHERE itemID = 1051671

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:929
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:973
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:169
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.80 ms After last query: 1.68 ms Query memory: 0.040 MB Memory before query: 8.227 MB Rows returned: 1

SELECT *
            
  FROM unx0p_k2_items
            
  WHERE id > 1051677
                
  AND catid = 1143
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-24 16:44:53')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-24 16:44:53')
                
  AND access IN (1,1,5)
                
            
  ORDER BY id ASC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_items	range\|filter	PRIMARY,catid,idx_items_common,idx_items_common_backend,idx_catid_id	catid\|idx_items_common_backend	8\|6	NULL	351 (9%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1678
13	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:331
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.36 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 8.310 MB Rows returned: 0

SELECT tag.*
            
  FROM unx0p_k2_tags AS tag
            JOIN unx0p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 1051689
            
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	j3realtytimescom_j3.xref.tagID	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1216
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.318 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_attachments 
  WHERE itemID=1051689

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_attachments	ref	itemID	itemID	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1444
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 8.325 MB Rows returned: 0

SELECT * 
  FROM unx0p_k2_rating 
  WHERE itemID = 1051689

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:929
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:973
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:169
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.71 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 8.340 MB Rows returned: 1

SELECT *

  FROM `unx0p_users`

  WHERE `id` = 818629

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.49 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 8.354 MB Rows returned: 1

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

  FROM `unx0p_usergroups` AS g

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

  WHERE `m`.`user_id` = 818629

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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: 0.38 ms Query memory: 0.024 MB Memory before query: 8.359 MB Rows returned: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM unx0p_k2_users 
  WHERE userID=818629

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_k2_users	ref	userID	userID	4	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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.22 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1696
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.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.40 ms After last query: 11.19 ms Query memory: 0.023 MB Memory before query: 8.414 MB Rows returned: 1

SELECT params 
  FROM unx0p_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 8.422 MB Rows returned: 1

SELECT id,template 
  FROM unx0p_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.78 ms After last query: 33.30 ms Query memory: 0.022 MB Memory before query: 9.161 MB Rows returned: 0

SELECT *
 
  FROM unx0p_jmap_metainfo
 
  WHERE `linkurl` = 'https://j3.realtytimes.com/headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	unx0p_jmap_metainfo	ref	published	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:780
12	plgSystemJMap->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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.29 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 9.167 MB Rows returned: 0

SELECT *
 
  FROM unx0p_jmap_canonicals
 
  WHERE `linkurl` = 'https://j3.realtytimes.com/headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay'

Explain

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

Profile

Status	Duration
Starting	0.03 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.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:920
12	plgSystemJMap->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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.26 ms After last query: 5.26 ms Query memory: 0.020 MB Memory before query: 10.363 MB Rows returned: 0

SELECT *
 
  FROM unx0p_jmap_headings
 
  WHERE `linkurl` = 'https://j3.realtytimes.com/headlines/item/1051677-spring-brings-record-high-monthly-housing-costs-keeping-pending-home-sales-at-bay'

Explain

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

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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:1272
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.22 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 10.368 MB Rows returned: 0

SELECT
 `original_text`,
 `target_text`,
 `original_text_regex`,
 `target_text_regex`
 
  FROM
 `unx0p_jmap_text_replacements`
 
  WHERE
`published` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jmap/jmap.php:397
8	plgSystemJMap->patternReplacements()	JROOT/plugins/system/jmap/jmap.php:1353
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.73 ms After last query: 64.07 ms Query memory: 0.021 MB Memory before query: 10.371 MB Rows returned: 0

SELECT r.*

  FROM unx0p_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'component')

  ORDER BY r.ordering, r.id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:64
11	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/src/Replace.php:152
10	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea()	JROOT/plugins/system/rereplacer/src/Replace.php:66
9	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas()	JROOT/plugins/system/rereplacer/rereplacer.php:144
8	PlgSystemReReplacer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.30 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 10.376 MB Rows returned: 0

SELECT r.*

  FROM unx0p_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'head')

  ORDER BY r.ordering, r.id

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:64
11	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/src/Replace.php:152
10	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea()	JROOT/plugins/system/rereplacer/src/Replace.php:67
9	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas()	JROOT/plugins/system/rereplacer/rereplacer.php:144
8	PlgSystemReReplacer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.41 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 10.382 MB Rows returned: 0

SELECT r.*

  FROM unx0p_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'body')

  ORDER BY r.ordering, r.id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:64
11	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/src/Replace.php:152
10	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea()	JROOT/plugins/system/rereplacer/src/Replace.php:68
9	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas()	JROOT/plugins/system/rereplacer/rereplacer.php:144
8	PlgSystemReReplacer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.36 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 10.388 MB Rows returned: 1

SELECT r.*

  FROM unx0p_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'everywhere')

  ORDER BY r.ordering, r.id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rereplacer/src/Items.php:64
11	RegularLabs\Plugin\System\ReReplacer\Items::getItemList()	JROOT/plugins/system/rereplacer/src/Replace.php:140
10	RegularLabs\Plugin\System\ReReplacer\Replace::replaceEverywhere()	JROOT/plugins/system/rereplacer/src/Replace.php:70
9	RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas()	JROOT/plugins/system/rereplacer/rereplacer.php:144
8	PlgSystemReReplacer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.]

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT r.* 
  FROM unx0p_rereplacer AS r

```
3 × SELECT * 
  FROM unx0p_k2_rating
```

3 × SELECT * 
  FROM unx0p_k2_attachments

3 × SELECT tag.*             
  FROM unx0p_k2_tags AS tag             JOIN unx0p_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

```
2 × SELECT * 
  FROM `unx0p_users`
```

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM unx0p_k2_users

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

2 × SELECT *             
  FROM unx0p_k2_items

1 × SELECT params 
  FROM unx0p_extensions AS e

1 × SELECT * 
  FROM unx0p_k2_comments

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 unx0p_fields AS a 
  LEFT JOIN `unx0p_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN unx0p_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN unx0p_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN unx0p_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN unx0p_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `unx0p_fields_categories` AS fc 
  ON fc.field_id = a.id

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 unx0p_fields AS a 
  LEFT JOIN `unx0p_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN unx0p_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN unx0p_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN unx0p_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN unx0p_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT id,template 
  FROM unx0p_template_styles

1 × SELECT *  
  FROM unx0p_jmap_metainfo

1 × SELECT *  
  FROM unx0p_jmap_canonicals

1 × SELECT *  
  FROM unx0p_jmap_headings

1 × SELECT i.*, c.alias AS categoryalias             
  FROM unx0p_k2_items AS i             
  LEFT JOIN unx0p_k2_categories c 
  ON c.id = i.catid

1 × SELECT `data` 
  FROM `unx0p_session`

1 × SELECT id, rules 
  FROM `unx0p_viewlevels

1 × SELECT * 
  FROM unx0p_k2_categories

```
1 × SELECT * 
  FROM unx0p_k2_items
```

1 × SELECT id 
  FROM unx0p_k2_categories

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

1 × SELECT `template` 
  FROM `unx0p_template_styles`

1 × SELECT manifest_cache 
  FROM `unx0p_extensions`

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

1 × SELECT * 
  FROM `unx0p_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `unx0p_admintools_storage`

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

1 × SELECT  `original_text`,  `target_text`,  `original_text_regex`,  `target_text_regex`  
  FROM  `unx0p_jmap_text_replacements`

OTHER Tables:

1 × UPDATE `unx0p_extensions` 
  SET `params` = '{\"mediaversion\":\"8b15cf2c8fabb0b6587df43b04b30217\"}'

1 × SHOW FULL COLUMNS 
  FROM `unx0p_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `unx0p_users

1 × SHOW FULL COLUMNS 
  FROM `unx0p_k2_items

1 × UPDATE unx0p_k2_items 
  SET `hits` = (`hits` + 1)

Leading indicators

Indicators of homebuying demand and activity
	Value (if applicable)	Recent change	Year-over-year change	Source
Daily average 30-year fixed mortgage rate	6.72% (April 2)	Down from 6.82% a week earlier; near lowest level since early December	Down from 7.07%	Mortgage News Daily
Weekly average 30-year fixed mortgage rate	6.65% (week ending March 27)	Down marginally from the week before; near lowest level since mid-December	Down from 6.79%	Freddie Mac
Mortgage-purchase applications (seasonally adjusted)		Up 2% from a week earlier (as of week ending March 28)	Up 9%	Mortgage Bankers Association
Touring activity		Up 37% from the start of the year (as of March 31)	At this time last year, it was up 16% from the start of 2024	ShowingTime, a home touring technology company
Google searches for “home for sale”		Up 17% from a month earlier (as of March 31)	Up 4%	Google Trends
The Redfin Homebuyer Demand Index has been excluded this week to ensure data accuracy.

Key housing-market data

U.S. highlights: Four weeks ending March 30, 2025 Redfin’s national metrics include data from 400+ U.S. metro areas, and are based on homes listed and/or sold during the period. Weekly housing-market data goes back through 2015. Subject to revision.
	Four weeks ending March 30, 2025	Year-over-year change	Notes
Median sale price	$386,019	3.4%
Median asking price	$424,975	6.7%
Median monthly mortgage payment	$2,802 at a 6.65% mortgage rate	5.2%	Record high
Pending sales	85,402	-2.3%	Smallest decline since start of 2025
New listings	100,366	12.7%	Biggest increase in 11 months
Active listings	981,872	11.7%
Months of supply	4.1	+0.7 pts.	4 to 5 months of supply is considered balanced, with a lower number indicating seller’s market conditions
Share of homes off market in two weeks	38.5%	Down from 42%
Median days on market	45	+6 days
Share of homes sold above list price	24.6%	Down from 28%
Average sale-to-list price ratio	98.6%	Down from 98.9%

Metro-level highlights: Four weeks ending March 30, 2025 Redfin’s metro-level data includes the 50 most populous U.S. metros. Select metros may be excluded from time to time to ensure data accuracy.
	Metros with biggest year-over-year increases	Metros with biggest year-over-year decreases	Notes
Median sale price	Cleveland (10.4%) Nassau County, NY (10%) Newark, NJ (9%) Chicago (7.8%) New Brunswick, NJ (7.3%)	Jacksonville, FL (-4.6%) Tampa, FL (-1.7%) Dallas (-1.4%) Atlanta (-0.6%) Orlando, FL (-0.4%) Portland, OR (-0.3%)	Declined in 6 metros
Pending sales	Montgomery County, PA (10.1%) Pittsburgh (4.6%) Cincinnati (3.7%) Denver (3%) Phoenix (2%)	Fort Lauderdale, FL (-15.8%) Miami (-15.1%) Las Vegas (-13.7%) Columbus, OH (-12.3%) Houston (-11.4%)	Increased in 11 metros
New listings	Denver (29.1%) Montgomery County, PA (28.1%) Phoenix (26%) Washington, D.C. (26%) Boston (23.1%)	San Antonio (-4.8%) Columbus, OH (-1.6%)	Declined in 2 metros

Spring Brings Record-High Monthly Housing Costs, Keeping Pending Home Sales at Bay

Redfin

Latest from Redfin

Agent Resource

Links

Sections

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

49 Queries Logged 73.14 ms

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Spring Brings Record-High Monthly Housing Costs, Keeping Pending Home Sales at Bay

Redfin

Latest from Redfin

Agent Resource

Today's Headlines

Links

Sections

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

49 Queries Logged 73.14 ms

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: