thunderpup

Moderator Last seen online, 1 year ago

thunderpup updated his profile picture

3 years ago Editing

0

0

0

0

0

0

Post is under moderation

Stream item published successfully. Item will now be visible on your stream.

We're dedicated to spreading awareness and education for/about individuals who identify as diapersexual.

Email

contact@diapersexual.com

Useful Links

Never Miss a Post

Subscribe to our blog

FIND US ON SOCIAL MEDIA

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679641386,
                "last": 1679641386,
                "now": 1679641386
            },
            "token": "IZpnRnYp07bsT0PN7psmWYQdkh09bGJE"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__com_easysocial": {
        "easysocial": {
            "before_registration": "L2hvbWUvaW5kZXgucGhwP29wdGlvbj1jb21fZWFzeXNvY2lhbCZ2aWV3PXN0cmVhbSZpZD02MyZsYXlvdXQ9aXRlbSZJdGVtaWQ9",
            "callback": null
        },
        "oauth": {
            "login": {
                "redirection": "L2hvbWUvaW5kZXgucGhwP29wdGlvbj1jb21fZWFzeXNvY2lhbCZ2aWV3PXN0cmVhbSZpZD02MyZsYXlvdXQ9aXRlbSZJdGVtaWQ9"
            }
        },
        "messages": null
    }
}

Profile Information

Time

Memory

Time: 15.49 ms / 15.49 ms Memory: 1.823 MB / 2.20 MB Application: afterLoad

Time: 48.43 ms / 63.92 ms Memory: 4.576 MB / 6.78 MB Application: Before Access::preloadComponents (all components)

Time: 1.01 ms / 64.93 ms Memory: 0.057 MB / 6.84 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 64.96 ms Memory: -0.005 MB / 6.83 MB Application: Before Access::getAssetRules (id:3 name:com_banners)

Time: 0.49 ms / 65.45 ms Memory: 0.030 MB / 6.86 MB Application: After Access::getAssetRules (id:3 name:com_banners)

Time: 29.90 ms / 95.35 ms Memory: 2.977 MB / 9.84 MB Application: afterInitialise

Time: 52.85 ms / 148.21 ms Memory: 6.297 MB / 16.14 MB Application: afterRoute

Time: 0.52 ms / 148.73 ms Memory: 0.017 MB / 16.15 MB Application: beforeRenderComponent com_easysocial

Time: 5.21 ms / 153.94 ms Memory: 1.851 MB / 18.00 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 153.98 ms Memory: 0.007 MB / 18.01 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 591.80 ms / 745.78 ms Memory: 11.064 MB / 29.08 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 745.80 ms Memory: 0.002 MB / 29.08 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 67.04 ms / 812.84 ms Memory: 4.292 MB / 33.37 MB Application: afterRenderComponent com_easysocial

Time: 2.58 ms / 815.42 ms Memory: 0.202 MB / 33.57 MB Application: afterDispatch

Time: 41.64 ms / 857.06 ms Memory: 1.644 MB / 35.22 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 2.36 ms / 859.42 ms Memory: 0.080 MB / 35.30 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.06 ms / 859.48 ms Memory: -0.015 MB / 35.28 MB Application: beforeRenderModule mod_sppagebuilder (Footer)

Time: 69.46 ms / 928.94 ms Memory: 8.822 MB / 44.10 MB Application: beforeRenderModule mod_easyblogsubscribe (EasyBlog - Subscribe Module)

Time: 16.64 ms / 945.58 ms Memory: 2.486 MB / 46.59 MB Application: afterRenderModule mod_easyblogsubscribe (EasyBlog - Subscribe Module)

Time: 8.73 ms / 954.31 ms Memory: -0.240 MB / 46.35 MB Application: afterRenderModule mod_sppagebuilder (Footer)

Time: 0.08 ms / 954.38 ms Memory: -0.038 MB / 46.31 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.52 ms / 955.90 ms Memory: 0.056 MB / 46.37 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.07 ms / 955.97 ms Memory: -0.013 MB / 46.35 MB Application: beforeRenderModule mod_menu (User Menu)

Time: 0.64 ms / 956.61 ms Memory: 0.018 MB / 46.37 MB Application: afterRenderModule mod_menu (User Menu)

Time: 4.20 ms / 960.82 ms Memory: 0.513 MB / 46.89 MB Application: afterRender

Database queries total: 539.36 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Caller	File and line number
9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
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:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `dprs_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3437303132636361653936383130343038653939633337663939346332663836', 1, 1679641386, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
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:364
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.55 ms After last query: 2.49 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `dprs_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	NULL	ref	extension	extension	82	const	42	1.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 1.87 ms

SELECT id, rules

  FROM `dprs_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.37 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverPdo->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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.09 ms

SELECT b.id

  FROM dprs_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.12 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverPdo->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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.57 ms

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM dprs_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	NULL	ref	extension	extension	82	const	143	0.60	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.11 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 8.21 ms

Duplicate queries: #11

SELECT `manifest_cache`

  FROM `dprs_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_admintools'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	NULL	ref	extension	extension	82	const	42	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:795
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:683
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:162
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:143
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:848
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 3.78 ms

Duplicate queries: #10

SELECT `manifest_cache`

  FROM `dprs_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_admintools'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	NULL	ref	extension	extension	82	const	42	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:795
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:683
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:293
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:143
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:848
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.25 ms

SELECT `value`

  FROM `dprs_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.19 ms
preparing	0.01 ms
executing	0.40 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:866
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.14 ms

SELECT `query`

  FROM `dprs_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_easysocial') 
  AND (`view` IS NULL OR `view` = '' OR `view` = 'stream')

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

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

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/admintools/main.php:668
10	plgSystemAdmintools->loadWAFExceptionsByOption()	JROOT/plugins/system/admintools/admintools/main.php:506
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:875
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 1.74 ms

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

  FROM `dprs_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_easydiscuss','com_easysocial','com_fields','com_finder','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	43	100.00	Using index condition

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	1.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
8	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/admin8/admin8.php:29
7	plgSystemAdmin8->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 11.59 ms

SELECT * 
  FROM `dprs_social_config` 
  WHERE `type` = 'site'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_config	NULL	ref	type	type	1002	const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
14	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
13	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/config.php:45
12	EasySocialModelConfig->getConfig()	JROOT/administrator/components/com_easysocial/includes/config/config.php:92
11	SocialConfig->load()	JROOT/administrator/components/com_easysocial/includes/config/config.php:25
10	SocialConfig->__construct()	JROOT/administrator/components/com_easysocial/includes/config/config.php:40
9	SocialConfig::getInstance()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:415
8	ES::config()	JROOT/administrator/components/com_easysocial/includes/plugins.php:37
7	EasySocialPlugins->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.64 ms After last query: 15.18 ms

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.38 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/pdomysql.php:245
11	JDatabaseDriverPdomysql->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:745
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
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:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.14 ms

SELECT `source`,`keepurlparams`

  FROM `dprs_admintools_redirects`

  WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?option=com_easysocial&view=stream&id=63&layout=item&Itemid=') OR ('index.php?option=com_easysocial&view=stream&id=63&layout=item&Itemid=' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.48 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:745
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
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:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 3.05 ms

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM dprs_menu AS m

  LEFT JOIN dprs_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	174	4.37	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	diaperse_ds.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.32 ms After last query: 19.72 ms

SHOW FULL COLUMNS 
  FROM `dprs_komento_configs`

Explain

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

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
17	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:45
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/administrator/components/com_komento/includes/komento.php:512
10	KT::table()	JROOT/administrator/components/com_komento/includes/komento.php:608
9	KT::config()	JROOT/components/com_komento/bootstrap.php:37
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:14
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.12 ms

SELECT *

  FROM dprs_komento_configs

  WHERE `name` = 'config'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_komento_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_komento/includes/komento.php:609
9	KT::config()	JROOT/components/com_komento/bootstrap.php:37
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:14
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 5.39 ms

SELECT id, home, template, s.params

  FROM dprs_template_styles as s

  LEFT JOIN dprs_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	diaperse_ds.e.element	2	85.71	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.04 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	2.29 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/astroid/framework/library/astroid/Template.php:28
10	Astroid\Template->__construct()	JROOT/libraries/astroid/framework/library/astroid/Framework.php:32
9	Astroid\Framework::init()	JROOT/plugins/system/astroid/astroid.php:31
8	plgSystemAstroid->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:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 13.94 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `dprs_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/libraries/astroid/framework/library/astroid/Document.php:42
10	Astroid\Document->__construct()	JROOT/libraries/astroid/framework/library/astroid/Framework.php:33
9	Astroid\Framework::init()	JROOT/plugins/system/astroid/astroid.php:31
8	plgSystemAstroid->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:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.50 ms After last query: 0.13 ms

UPDATE `dprs_extensions`

  SET `params` = '{\"mediaversion\":\"073bcb811f2af55ad5798a001c715534\"}'

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/libraries/astroid/framework/library/astroid/Document.php:42
10	Astroid\Document->__construct()	JROOT/libraries/astroid/framework/library/astroid/Framework.php:33
9	Astroid\Framework::init()	JROOT/plugins/system/astroid/astroid.php:31
8	plgSystemAstroid->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:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 2.64 ms

SELECT * 
  FROM `dprs_social_access_rules` 
  WHERE `
  group` = 'user' 
  AND `state` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_access_rules	NULL	ref	state,group	group	258	const	65	96.79	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
17	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
16	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/accessrules.php:138
15	EasySocialModelAccessRules->getAllRules()	JROOT/administrator/components/com_easysocial/includes/access/access.php:127
14	SocialAccess->getDefaultValues()	JROOT/administrator/components/com_easysocial/includes/access/access.php:93
13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1913
11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:73
10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:165
9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
8	PlgSystemEasySocialAutologin->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:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 1.51 ms

SELECT `params` 
  FROM `dprs_social_access` 
  WHERE `uid` = NULL 
  AND `type` = 'profiles'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.33 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/access.php:55
14	EasySocialModelAccess->getParams()	JROOT/administrator/components/com_easysocial/includes/access/access.php:99
13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1913
11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:73
10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:165
9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
8	PlgSystemEasySocialAutologin->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:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.89 ms

SELECT *

  FROM dprs_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.41 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 9.40 ms

SELECT COUNT(1) 
  FROM `dprs_social_apps` AS `a` 
  WHERE `a`.`state` = '1' 
  AND `a`.`type` = 'apps' 
  AND `a`.`
  group` = 'user' OR ( `a`.`state` = '1' 
  AND `a`.`default` = '1' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	NO INDEX KEY COULD BE USED	NULL	NULL	233	21.07	Using where

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/model.php:510
11	EasySocialModel->setTotal()	JROOT/administrator/components/com_easysocial/models/apps.php:791
10	EasySocialModelApps->getApps()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:167
9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.10 ms

SELECT `a`.* 
  FROM `dprs_social_apps` AS `a` 
  WHERE `a`.`state` = '1' 
  AND `a`.`type` = 'apps' 
  AND `a`.`
  group` = 'user' OR ( `a`.`state` = '1' 
  AND `a`.`default` = '1' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	NO INDEX KEY COULD BE USED	NULL	NULL	233	21.07	Using where

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/model.php:577
11	EasySocialModel->getData()	JROOT/administrator/components/com_easysocial/models/apps.php:798
10	EasySocialModelApps->getApps()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:167
9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 3.64 ms

SELECT * 
  FROM `dprs_social_themes` 
  WHERE `element` = 'horizon'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.33 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/themes.php:247
17	EasySocialModelThemes->getParams()	JROOT/administrator/components/com_easysocial/includes/template/template.php:119
16	SocialTemplate->getConfig()	JROOT/administrator/components/com_easysocial/includes/template/template.php:77
15	SocialTemplate->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:31
14	SocialThemes->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:43
13	SocialThemes::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:159
12	ES::__callStatic()	JROOT/administrator/components/com_easysocial/includes/apps/libraries/abstract.php:63
11	SocialAppsAbstract->__construct()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:523
10	SocialApps->loadApp()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:179
9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 29.27 ms

SELECT *

  FROM dprs_social_stream

  WHERE `id` = '63'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_stream	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.19 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/tables/stream.php:73
11	SocialTableStream->load()	JROOT/components/com_easysocial/views/stream/view.html.php:53
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.95 ms After last query: 8.88 ms

SELECT  a.* , l.id as loc_id, l.uid as loc_uid, l.type as loc_type, l.user_id as loc_user_id, l.created as loc_created, l.short_address as loc_short_address ,l.address as loc_address, l.longitude as loc_longitude, l.latitude as loc_latitude, l.params as loc_params ,md.id as md_id, md.namespace as md_namespace,md.namespace_uid as md_namespace_uid, md.icon as md_icon, md.verb as md_verb, md.subject as md_subject, md.custom as md_custom ,md.text as md_text, md.user_id as md_user_id, md.created as md_created, a.sticky_id as sticky, a.`background_id` ,0 as bookmarked ,FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60) AS `min` ,FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60) AS `hour` ,FLOOR((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(a.`modified`)) / 60 / 60 / 24) AS `day`  
  FROM `dprs_social_stream` AS a 
  LEFT JOIN `dprs_social_events_meta` AS em 
  ON a.`cluster_id` = em.`cluster_id` 
  LEFT JOIN `dprs_social_locations` AS l 
  ON a.`location_id` = l.`id` 
  LEFT JOIN `dprs_social_moods` AS md 
  ON a.`mood_id` = md.`id` 
  WHERE a.`state` IN('1','2') 
  AND ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 
  and a.`cluster_access` IN (1, 4)) ) 
  AND a.`id`='63' 
  ORDER BY a.`modified` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	md	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	a	NULL	const	PRIMARY,idx_clusterid,idx_cluster_items,idx_cluster_access,idx_stream_total_cluster,idx_stream_total_user	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	em	NULL	ref	cluster_id	cluster_id	4	const	1	100.00	Using index
1	SIMPLE	l	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
Opening tables	0.03 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.06 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
14	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
13	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/stream.php:1919
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.10 ms

SELECT * 
  FROM `dprs_social_stream_item` as a 
  WHERE `uid` IN (63) 
  AND `context_type`='photos'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	activity_context,idx_context_verb,idx_uid	idx_uid	8	const	1	5.00	Using where

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.21 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/stream.php:2417
13	EasySocialModelStream->setBatchRelatedItems()	JROOT/administrator/components/com_easysocial/models/stream.php:1967
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 3.54 ms


  SET SQL_BIG_SELECTS=1

Explain

EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/database.php:33
20	JDatabase->query()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:932
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.41 ms

SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`robots`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
  FROM `dprs_users` AS `a` 
  LEFT JOIN `dprs_social_avatars` AS `b` 
  ON `b`.`uid` = `a`.`id` 
  AND `b`.`type` = 'user'  
  LEFT JOIN `dprs_social_profiles_maps` AS `d` 
  ON `d`.`user_id` = `a`.`id`  
  LEFT JOIN `dprs_social_users` AS `e` 
  ON `e`.`user_id` = `a`.`id`  
  LEFT JOIN `dprs_social_covers` AS `f` 
  ON `f`.`uid` = `a`.`id` 
  AND `f`.`type` = 'user'  
  LEFT JOIN `dprs_social_points_history` AS `g` 
  ON `g`.`user_id` = `a`.`id` 
  WHERE `a`.`id` IN ('392', '41') 
  GROUP BY `a`.`id`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	PRIMARY,idx_username,idx_name,idx_block,email	PRIMARY	4	NULL	2	100.00	Using where
1	SIMPLE	b	NULL	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	diaperse_ds.a.id	1	100.00	Using where
1	SIMPLE	d	NULL	ref	idx_userid,idx_user_profile	idx_userid	8	diaperse_ds.a.id	1	100.00	Using where
1	SIMPLE	e	NULL	eq_ref	PRIMARY,idx_types	PRIMARY	8	diaperse_ds.a.id	1	100.00	Using where
1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	diaperse_ds.a.id	1	100.00	Using where
1	SIMPLE	g	NULL	ref	idx_userid,user_points	user_points	8	diaperse_ds.a.id	15	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:1000
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.71 ms

SELECT * 
  FROM `dprs_social_default_avatars` 
  WHERE `uid` IN (2) 
  AND `type`='profiles'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/avatars.php:291
19	EasySocialModelAvatars->preloadDefaultAvatar()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:226
18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:1005
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.07 ms

SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
  FROM `dprs_usergroups` AS a 
  INNER JOIN `dprs_user_usergroup_map` AS b 
  ON a.`id` = b.`group_id` 
  WHERE b.`user_id` IN (392)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY	PRIMARY	4	const	4	100.00	Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	diaperse_ds.b.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
20	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3590
19	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:1005
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.07 ms

select * 
  from `dprs_social_users` 
  where `user_id` IN (392)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_users	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.03 ms
executing	470.45 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	3.24 ms
cleaning up	0.11 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:493
19	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:1005
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.08 ms

SELECT `session_id`, `userid` 
  FROM `dprs_session` 
  WHERE `userid` IN(392) 
  AND `time`>='1679640486'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_session	NULL	ref	userid,time	userid	5	const	1	21.48	Using where

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:522
19	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:1005
17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:896
16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:575
15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1531
14	ES::user()	JROOT/administrator/components/com_easysocial/models/stream.php:2343
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 471.23 ms After last query: 2.66 ms

select a.`type`, a.`rule`, b.`value`, a.`id`, b.`id` as `mapid`, b.`uid` 
  from `dprs_social_privacy` as a	
  inner join `dprs_social_privacy_map` as b 
  on a.`id` = b.`privacy_id` 
  where b.`uid` IN (392,41) 
  and b.`utype` = 'user' 
  and a.`state` = '1' 
  order by a.`type`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	43	10.00	Using where; Using filesort
1	SIMPLE	b	NULL	ref	privacy_id,uid_type,uid_type_value,idx_privacy_uid_type,idx_uid	privacy_id	4	diaperse_ds.a.id	4	1.25	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
17	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
16	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/privacy.php:322
15	EasySocialModelPrivacy->preloadUserPrivacy()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:134
14	SocialCache->cacheUsersPrivacy()	JROOT/administrator/components/com_easysocial/models/stream.php:2344
13	EasySocialModelStream->setActorsBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1975
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 3.00 ms

select * 
  from `dprs_social_photos` 
  where `id` IN (42)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_photos	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/photo.php:216
14	SocialTablePhoto->loadByBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:2293
13	EasySocialModelStream->setMediaBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1978
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.39 ms

select * 
  from `dprs_social_photos_meta` 
  where `photo_id` IN (42)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_photos_meta	NULL	ref	photo_id,idx_sql1,idx_sql2	idx_sql1	4	const	2	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/photos.php:1009
14	EasySocialModelPhotos->setMetasBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:2298
13	EasySocialModelStream->setMediaBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1978
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 1.11 ms

select * 
  from `dprs_social_albums` 
  where `id` IN (41)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_albums	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/album.php:264
14	SocialTableAlbum->loadByBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:2305
13	EasySocialModelStream->setMediaBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1978
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.14 ms

SELECT * 
  FROM `dprs_social_stream_tags` 
  WHERE `stream_id` IN('63') 
  ORDER BY `stream_id`, `offset` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/stream.php:2856
13	EasySocialModelStream->setTaggingBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1981
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 1.21 ms

SELECT a.* 
  FROM `dprs_social_likes` AS a 
  INNER JOIN `dprs_users` AS b 
  ON a.`created_by` = b.`id` 
  WHERE a.stream_id IN (63) 
  AND b.`block` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	social_likes_createdby,idx_stream_id,idx_usermood	idx_stream_id	9	const	1	100.00	Using where
1	SIMPLE	b	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	diaperse_ds.a.created_by	1	29.32	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/likes.php:230
13	EasySocialModelLikes->setStreamLikesBatch()	JROOT/administrator/components/com_easysocial/models/stream.php:1985
12	EasySocialModelStream->getStreamData()	JROOT/administrator/components/com_easysocial/includes/stream/stream.php:946
11	SocialStream->getItem()	JROOT/components/com_easysocial/views/stream/view.html.php:71
10	EasySocialViewStream->item()	JROOT/components/com_easysocial/controllers/controller.php:141
9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:100
6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.44 ms

User Menu

thunderpup

Email

Useful Links

Never Miss a Post

FIND US ON SOCIAL MEDIA

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

107 Queries Logged 539.36 ms

13 duplicate found!