Diapersexual - All Polls

Polls

There are no polls to show.

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": 1695571579,
                "last": 1695571579,
                "now": 1695571579
            },
            "token": "ZfICVKlmUHTdeENQuIQsGNSo1DWRV6de"
        },
        "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": "L2hvbWUvaW5kZXgucGhwP29wdGlvbj1jb21fZWFzeXNvY2lhbCZ2aWV3PXBvbGxzJkl0ZW1pZD0=",
            "callback": null
        },
        "oauth": {
            "login": {
                "redirection": "L2hvbWUvaW5kZXgucGhwP29wdGlvbj1jb21fZWFzeXNvY2lhbCZ2aWV3PXBvbGxzJkl0ZW1pZD0="
            }
        },
        "messages": null
    }
}

Profile Information

Time

Memory

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

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

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

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

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

Time: 40.85 ms / 1718.35 ms Memory: 2.976 MB / 9.84 MB Application: afterInitialise

Time: 70.67 ms / 1789.02 ms Memory: 6.297 MB / 16.14 MB Application: afterRoute

Time: 0.86 ms / 1789.88 ms Memory: 0.017 MB / 16.15 MB Application: beforeRenderComponent com_easysocial

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

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

Time: 68.22 ms / 1864.56 ms Memory: 4.431 MB / 22.44 MB Application: beforeRenderModule mod_easysocial_sidebar (EasySocial Sidebar)

Time: 16.96 ms / 1881.52 ms Memory: 1.166 MB / 23.61 MB Application: afterRenderModule mod_easysocial_sidebar (EasySocial Sidebar)

Time: 79.38 ms / 1960.91 ms Memory: 4.669 MB / 28.28 MB Application: afterRenderComponent com_easysocial

Time: 2.82 ms / 1963.73 ms Memory: 0.202 MB / 28.48 MB Application: afterDispatch

Time: 47.43 ms / 2011.15 ms Memory: 1.572 MB / 30.05 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 2.85 ms / 2014.01 ms Memory: 0.071 MB / 30.12 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.09 ms / 2014.10 ms Memory: -0.015 MB / 30.11 MB Application: beforeRenderModule mod_sppagebuilder (Footer)

Time: 83.17 ms / 2097.27 ms Memory: 8.822 MB / 38.93 MB Application: beforeRenderModule mod_easyblogsubscribe (EasyBlog - Subscribe Module)

Time: 20.63 ms / 2117.90 ms Memory: 2.487 MB / 41.42 MB Application: afterRenderModule mod_easyblogsubscribe (EasyBlog - Subscribe Module)

Time: 10.76 ms / 2128.65 ms Memory: -0.240 MB / 41.18 MB Application: afterRenderModule mod_sppagebuilder (Footer)

Time: 0.12 ms / 2128.77 ms Memory: -0.038 MB / 41.14 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.05 ms / 2130.83 ms Memory: 0.034 MB / 41.17 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.09 ms / 2130.91 ms Memory: -0.014 MB / 41.16 MB Application: beforeRenderModule mod_menu (User Menu)

Time: 0.84 ms / 2131.75 ms Memory: 0.018 MB / 41.18 MB Application: afterRenderModule mod_menu (User Menu)

Time: 5.13 ms / 2136.88 ms Memory: 0.536 MB / 41.71 MB Application: afterRender

Database queries total: 89.29 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

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'3031333138393336333161313130613563303636313532613833373030633132', 1, 1695571579, 0, '', 0)

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.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.07 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
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.93 ms After last query: 17.99 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

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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.04 ms
end	0.01 ms
query end	0.01 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
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: 2.32 ms After last query: 2.60 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.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 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.03 ms
executing	0.54 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.01 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.65 ms After last query: 0.25 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.17 ms
Executing hook on transaction	0.01 ms
starting	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.03 ms
executing	0.19 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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: 1.42 ms After last query: 1.10 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.13 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.04 ms
executing	0.18 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.87 ms After last query: 13.56 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.05 ms
Executing hook on transaction	0.01 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.03 ms
executing	0.01 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.05 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.86 ms After last query: 5.02 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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.27 ms After last query: 0.42 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.08 ms
Executing hook on transaction	0.00 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.01 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.31 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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.44 ms After last query: 1.62 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` = 'polls')

  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.16 ms
Executing hook on transaction	0.01 ms
starting	0.02 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.11 ms
preparing	0.03 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.01 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.80 ms After last query: 1.56 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.13 ms
checking permissions	0.05 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
statistics	0.01 ms
preparing	0.02 ms
executing	1.69 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 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.68 ms After last query: 14.86 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.15 ms
Executing hook on transaction	0.01 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.03 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.05 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.01 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: 2.37 ms After last query: 17.28 ms

SHOW VARIABLES LIKE "collation_database"

Explain

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

Profile

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.53 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 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.49 ms After last query: 0.29 ms

SELECT `source`,`keepurlparams`

  FROM `dprs_admintools_redirects`

  WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?option=com_easysocial&view=polls&Itemid=') OR ('index.php?option=com_easysocial&view=polls&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.17 ms
Executing hook on transaction	0.01 ms
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.65 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.04 ms
Creating tmp table	0.11 ms
executing	0.12 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 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: 1.32 ms After last query: 8.29 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.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 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
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.80 ms After last query: 28.62 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.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.11 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 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.18 ms After last query: 0.13 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.14 ms
Executing hook on transaction	0.01 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.13 ms
preparing	0.03 ms
executing	0.07 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.01 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.79 ms After last query: 6.05 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.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.05 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	4.10 ms
closing tables	0.03 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: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.65 ms After last query: 16.86 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.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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: 4.39 ms After last query: 0.14 ms

UPDATE `dprs_extensions`

  SET `params` = '{\"mediaversion\":\"4568dd468a80b55bd45a1dabcf1708c5\"}'

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

Explain

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

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.03 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.01 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.71 ms After last query: 3.54 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.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.07 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
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.24 ms After last query: 1.71 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.17 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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.34 ms After last query: 1.05 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.05 ms
preparing	0.01 ms
executing	0.33 ms
end	0.01 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.99 ms After last query: 11.62 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.12 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.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.56 ms After last query: 0.13 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.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.37 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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.39 ms After last query: 4.32 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.26 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.91 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.05 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.02 ms
freeing items	0.03 ms
cleaning up	0.02 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: 1.09 ms After last query: 40.86 ms

SELECT * 
  FROM `dprs_menu` 
  WHERE `published` = '1' 
  AND `link` LIKE 'index.php?option=com_easysocial%' 
  AND `client_id` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	77	1.11	Using where

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 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.03 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.01 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/includes/router.php:589
15	ESR::getMenus()	JROOT/administrator/components/com_easysocial/includes/router.php:809
14	ESR::getItemId()	JROOT/administrator/components/com_easysocial/includes/router/router.php:373
13	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:125
12	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:996
11	ESR::__callStatic()	JROOT/components/com_easysocial/views/polls/view.html.php:55
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 1.55 ms After last query: 2.22 ms

SELECT COUNT(1) 
  FROM (select a.* 
  from `dprs_social_polls` as a 
  inner join `dprs_social_stream` as b 
  on a.`uid` = b.`id` 
  and a.`element` = 'stream' 
  where (a.`cluster_id` is null or ((select count(1) 
  from `dprs_social_clusters` as c 
  where c.`id` = a.`cluster_id`) > 0)) 
  AND b.`access` = '0' 
  AND ( (b.`cluster_id`= 0) OR (b.`cluster_id` > 0 
  and b.`cluster_access` IN (1,4)))) AS zcount

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
3	DEPENDENT SUBQUERY	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.18 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	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/includes/model.php:510
12	EasySocialModel->setTotal()	JROOT/administrator/components/com_easysocial/models/polls.php:296
11	EasySocialModelPolls->getPolls()	JROOT/components/com_easysocial/views/polls/view.html.php:58
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 0.13 ms

select a.* 
  from `dprs_social_polls` as a 
  inner join `dprs_social_stream` as b 
  on a.`uid` = b.`id` 
  and a.`element` = 'stream' 
  where (a.`cluster_id` is null or ((select count(1) 
  from `dprs_social_clusters` as c 
  where c.`id` = a.`cluster_id`) > 0)) 
  AND b.`access` = '0' 
  AND ( (b.`cluster_id`= 0) OR (b.`cluster_id` > 0 
  and b.`cluster_access` IN (1,4))) 
  order by a.`created` desc 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
2	SUBQUERY	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Not optimized, outer query is empty

Profile

Status	Duration
starting	0.23 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
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.06 ms
statistics	0.38 ms
preparing	0.07 ms
executing	0.57 ms
end	0.01 ms
query end	0.04 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 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/includes/model.php:577
12	EasySocialModel->getData()	JROOT/administrator/components/com_easysocial/models/polls.php:298
11	EasySocialModelPolls->getPolls()	JROOT/components/com_easysocial/views/polls/view.html.php:58
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 1.20 ms After last query: 3.40 ms

select count(1) as `cnt`, 'photos' as `type` 
  FROM `dprs_social_photos` 
  where `type` = 'user' 
  and `chk_access` = 0 UNION ALL select count(1) as `cnt`, 'albums' as `type` 
  FROM `dprs_social_albums` 
  where `type` = 'user' 
  and `chk_access` = 0 
  and `core` IN (0, 3) UNION ALL select count(1) as `cnt`, 'audios' as `type` 
  FROM `dprs_social_audios` 
  where `type` = 'user' 
  and `chk_access` = 0 UNION ALL select count(1) as `cnt`, 'videos' as `type` 
  FROM `dprs_social_videos` 
  where `type` = 'user' 
  and `chk_access` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	dprs_social_photos	NULL	ref	idx_type_chkaccess	idx_type_chkaccess	260	const,const	1	100.00	Using where
2	UNION	dprs_social_albums	NULL	ref	idx_core,idx_type_chkaccess	idx_type_chkaccess	260	const,const	1	5.00	Using where
3	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
4	UNION	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.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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/maintenance.php:235
13	EasySocialModelMaintenance->getMediaPrivacyCounts()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2646
12	ES::hasUnsyncedPrivacy()	JROOT/components/com_easysocial/views/views.php:199
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 1.86 ms After last query: 3.26 ms

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

  FROM dprs_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-24 16:06:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-24 16:06:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	29	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	diaperse_ds.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	diaperse_ds.m.id	1	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
24	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
23	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
22	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:57
21	SocialThemes->getModulesFromPosition()	JROOT/components/com_easysocial/themes/wireframe/helpers/html/sidebar.php:14
20	include JROOT/components/com_easysocial/themes/wireframe/helpers/html/sidebar.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
19	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
18	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/html.php:419
17	ThemesHelperHTML->sidebar()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
16	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/polls/default/default.php:20
15	include JROOT/components/com_easysocial/themes/wireframe/polls/default/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
14	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
13	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/views.php:270
12	EasySocialView->display()	JROOT/components/com_easysocial/views/views.php:230
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.55 ms After last query: 14.87 ms

SELECT * 
  FROM `dprs_social_backgrounds` 
  WHERE `state`='1'

Explain

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

Profile

Status	Duration
starting	0.09 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.03 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.15 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
39	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
37	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
36	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/background.php:100
35	EasySocialModelBackground->getPresetBackgrounds()	JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php:160
34	include JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
33	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
32	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/stylesheet/stylesheet.php:829
31	SocialStylesheet->attach()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:177
30	SocialModules->requireCSS()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:34
29	SocialModules->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:341
28	ES::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:318
27	ES::get()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2045
26	ES::modules()	JROOT/modules/mod_easysocial_sidebar/mod_easysocial_sidebar.php:29
25	include JROOT/modules/mod_easysocial_sidebar/mod_easysocial_sidebar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
24	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
23	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:361
22	SocialThemes->renderModule()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:282
21	SocialThemes->render()	JROOT/components/com_easysocial/themes/wireframe/helpers/html/sidebar.php:16
20	include JROOT/components/com_easysocial/themes/wireframe/helpers/html/sidebar.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
19	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
18	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/html.php:419
17	ThemesHelperHTML->sidebar()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
16	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/polls/default/default.php:20
15	include JROOT/components/com_easysocial/themes/wireframe/polls/default/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
14	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
13	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/views.php:270
12	EasySocialView->display()	JROOT/components/com_easysocial/views/views.php:230
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 24.20 ms After last query: 8.35 ms

select distinct a.* 
  from `dprs_finder_taxonomy` as a 	
  inner join `dprs_finder_taxonomy_map` as b 
  on a.`id` = b.`node_id` 	
  inner join `dprs_finder_links` as c 
  on c.`link_id` = b.`link_id` 
  where a.`access` IN ( 1,1,5 ) 
  and a.`state` = 1 
  and a.`parent_id` = ( select id 
  from `dprs_finder_taxonomy` 
  where `parent_id` = 1 
  and `title` = 'Type' ) 
  AND a.`title` IN (select `title` 
  FROM `dprs_finder_types`)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,parent_id,state,access,idx_parent_published	parent_id	4	const	10	100.00	Using where; Using temporary
1	PRIMARY	dprs_finder_types	NULL	eq_ref	title	title	402	diaperse_ds.a.title	1	100.00	Using where; Using index; Distinct
1	PRIMARY	b	NULL	ref	PRIMARY,link_id,node_id	node_id	4	diaperse_ds.a.id	8	100.00	Using index; Distinct
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	diaperse_ds.b.link_id	1	100.00	Using index; Distinct
2	SUBQUERY	dprs_finder_taxonomy	NULL	ref	parent_id,idx_parent_published	parent_id	4	const	10	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.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	3.06 ms
cleaning up	0.03 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/includes/search/search.php:275
14	SocialSearch->getFilters()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:164
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.39 ms After last query: 1.04 ms

SELECT *

  FROM dprs_social_verification_requests

  WHERE `uid` = '0' 
  AND `type` = 'user'

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	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
executing	0.08 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.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/verification/verification.php:72
15	SocialVerification->hasRequested()	JROOT/administrator/components/com_easysocial/includes/verification/verification.php:53
14	SocialVerification->canRequest()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:182
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.11 ms

SELECT *

  FROM dprs_social_users

  WHERE `user_id` = '0' 
  AND `verified` = '1'

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.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 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.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/verification/verification.php:81
15	SocialVerification->hasRequested()	JROOT/administrator/components/com_easysocial/includes/verification/verification.php:53
14	SocialVerification->canRequest()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:182
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.79 ms After last query: 7.92 ms

SELECT template 
  FROM `dprs_template_styles` AS s 
  LEFT JOIN `dprs_extensions` AS e 
  ON e.type = `template` 
  AND e.element=s.template 
  AND e.client_id=s.client_id 
  WHERE s.client_id = '1' 
  AND home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	diaperse_ds.s.template,diaperse_ds.s.template	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.08 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.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
30	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
29	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/assets/assets.php:279
28	SocialAssets::getJoomlaTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:161
27	SocialThemes::resolve()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:403
26	ES::call()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1249
25	ES::resolve()	JROOT/administrator/components/com_easysocial/includes/template/template.php:150
24	SocialTemplate->getTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:188
23	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/form.php:110
22	ThemesHelperForm->action()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
21	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/toolbar/search.php:64
20	include JROOT/components/com_easysocial/themes/wireframe/toolbar/search.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
19	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
18	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/template.php:201
17	SocialTemplate->includeTemplate()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:182
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.45 ms After last query: 3.16 ms

SELECT *

  FROM dprs_social_profiles

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	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.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:193
22	SocialOauth->getDefaultProfile()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:612
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.41 ms After last query: 3.99 ms

SELECT * 
  FROM `dprs_social_workflows` 
  WHERE `type` = 'user'

Explain

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

Profile

Status	Duration
starting	0.06 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
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.22 ms
end	0.00 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
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
27	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
26	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/workflows.php:134
25	EasySocialModelWorkflows->getWorkflowByType()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:421
24	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1158
23	SocialTableProfile->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1032
22	SocialTableProfile->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:613
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.26 ms After last query: 0.24 ms

SELECT *

  FROM dprs_social_workflows_maps

  WHERE `uid` = '1' 
  AND `type` = 'user'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_social_workflows_maps	NULL	ref	uid	uid	4	const	1	10.00	Using where

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 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.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
25	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:429
24	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1158
23	SocialTableProfile->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1032
22	SocialTableProfile->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:613
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.59 ms After last query: 0.18 ms

SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` 
  FROM `dprs_social_fields` AS `a` 
  LEFT JOIN `dprs_social_apps` AS `b` 
  ON `b`.`id` = `a`.`app_id`  
  LEFT JOIN `dprs_social_fields_steps` AS `d` 
  ON `a`.`step_id` = `d`.`id` 
  WHERE ( `a`.`core` = '1' OR `a`.`state` = '1' ) 
  AND `d`.`workflow_id` = '1' 
  ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d	NULL	ref	PRIMARY,workflow_id	workflow_id	8	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	a	NULL	ref	state,step_id	step_id	4	diaperse_ds.d.id	21	19.00	Using where
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	diaperse_ds.a.app_id	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.51 ms
end	0.01 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
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
25	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
24	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/fields.php:1088
23	EasySocialModelFields->getCustomFields()	JROOT/administrator/components/com_easysocial/tables/profile.php:1033
22	SocialTableProfile->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:613
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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.26 ms After last query: 1.49 ms

SELECT * 
  FROM `dprs_social_fields_options` 
  WHERE `parent_id` IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17') 
  ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC

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.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.61 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.12 ms
checking permissions	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
26	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
25	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/field.php:371
24	SocialTableField->setBatchFieldOptions()	JROOT/administrator/components/com_easysocial/models/fields.php:1121
23	EasySocialModelFields->getCustomFields()	JROOT/administrator/components/com_easysocial/tables/profile.php:1033
22	SocialTableProfile->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:613
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 1.16 ms After last query: 11.13 ms

SELECT * 
  FROM `dprs_social_apps`

Explain

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

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.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
39	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
37	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
36	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:124
35	SocialDbcacheTable->initTable()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:112
34	SocialDbcacheTable->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:78
33	SocialDbcacheTable->__construct()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:56
32	SocialDbcache->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:31
31	SocialDbcache->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:346
30	ES::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:318
29	ES::get()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2824
28	ES::dbcache()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:571
27	SocialFields->loadAppData()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:616
26	SocialFields->getFieldConfigParameters()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:739
25	SocialFields->getFieldConfigValues()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:262
24	SocialFieldTriggers->onEvent()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:320
23	SocialFieldTriggers->__call()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:323
22	SocialFields->trigger()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:616
21	SocialConsumerFacebook->getAuthorizeURL()	JROOT/administrator/components/com_easysocial/includes/oauth/clients/facebook/consumer.php:757
20	SocialConsumerFacebook->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/oauth/oauth.php:101
19	SocialOauth->__call()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:148
18	SocialSSO->getLoginButton()	JROOT/administrator/components/com_easysocial/includes/sso/sso.php:187
17	SocialSSO->getSocialButtons()	JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php:318
16	include JROOT/components/com_easysocial/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
15	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
14	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/toolbar/toolbar.php:223
13	SocialToolbar->render()	JROOT/components/com_easysocial/views/views.php:352
12	EasySocialSiteView->getToolbar()	JROOT/components/com_easysocial/views/views.php:264
11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/polls/view.html.php:88
10	EasySocialViewPolls->display()	JROOT/components/com_easysocial/controllers/controller.php:144
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: 1.91 ms After last query: 27.40 ms

SHOW FULL COLUMNS 
  FROM `dprs_extensions`

Explain

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

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.02 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.01 ms
closing tables	0.01 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/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/libraries/src/Table/Extension.php:32
14	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/astroid/framework/template.php:1075
12	AstroidFrameworkTemplate->inspect()	JROOT/libraries/astroid/framework/template.php:55
11	AstroidFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/template.php:15
10	JollyanyFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/jollyany.php:20
9	JollyanyFramework::createTemplate()	JROOT/libraries/jollyany/framework/jollyany.php:15
8	JollyanyFramework::getTemplate()	JROOT/templates/tz_charity/index.php:25
7	require JROOT/templates/tz_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.25 ms

Duplicate queries: #49

SELECT `extension_id`

  FROM `dprs_extensions`

  WHERE element = 'astroid' 
  AND type = 'library'

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	Using index

Profile

Status	Duration
starting	0.15 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.02 ms
statistics	0.54 ms
preparing	0.03 ms
executing	0.07 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.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
13	Joomla\CMS\Table\Extension->find()	JROOT/libraries/astroid/framework/template.php:1076
12	AstroidFrameworkTemplate->inspect()	JROOT/libraries/astroid/framework/template.php:55
11	AstroidFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/template.php:15
10	JollyanyFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/jollyany.php:20
9	JollyanyFramework::createTemplate()	JROOT/libraries/jollyany/framework/jollyany.php:15
8	JollyanyFramework::getTemplate()	JROOT/templates/tz_charity/index.php:25
7	require JROOT/templates/tz_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.10 ms

Duplicate queries: #50

SELECT *

  FROM dprs_extensions

  WHERE `extension_id` = '10523'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_extensions	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.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.01 ms
executing	0.01 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
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/libraries/astroid/framework/template.php:1077
12	AstroidFrameworkTemplate->inspect()	JROOT/libraries/astroid/framework/template.php:55
11	AstroidFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/template.php:15
10	JollyanyFrameworkTemplate->__construct()	JROOT/libraries/jollyany/framework/jollyany.php:20
9	JollyanyFramework::createTemplate()	JROOT/libraries/jollyany/framework/jollyany.php:15
8	JollyanyFramework::getTemplate()	JROOT/templates/tz_charity/index.php:25
7	require JROOT/templates/tz_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.07 ms After last query: 7.92 ms

Duplicate queries: #47

SELECT `extension_id`

  FROM `dprs_extensions`

  WHERE element = 'astroid' 
  AND type = 'library'

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	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
17	Joomla\CMS\Table\Extension->find()	JROOT/libraries/astroid/framework/template.php:1076
16	AstroidFrameworkTemplate->inspect()	JROOT/libraries/astroid/framework/template.php:55
15	AstroidFrameworkTemplate->__construct()	JROOT/libraries/astroid/framework/astroid.php:50
14	AstroidFramework::createTemplate()	JROOT/libraries/astroid/framework/astroid.php:17
13	AstroidFramework::getTemplate()	JROOT/libraries/astroid/framework/menu.php:562
12	AstroidMenu::getMobileMenu()	JROOT/libraries/jollyany/framework/frontend/mobilemenu.php:34
11	include JROOT/libraries/jollyany/framework/frontend/mobilemenu.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/jollyany/framework/template.php:33
9	JollyanyFrameworkTemplate->loadLayout()	JROOT/libraries/astroid/framework/template.php:262
8	AstroidFrameworkTemplate->renderLayout()	JROOT/templates/tz_charity/index.php:98
7	require JROOT/templates/tz_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.13 ms

Duplicate queries: #48

SELECT *

  FROM dprs_extensions

  WHERE `extension_id` = '10523'

Explain

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

Profile

Status	Duration
starting	0.11 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.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.05 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.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/libraries/astroid/framework/template.php:1077
16	AstroidFrameworkTemplate->inspect()	JROOT/libraries/astroid/framework/template.php:55
15	AstroidFrameworkTemplate->__construct()	JROOT/libraries/astroid/framework/astroid.php:50
14	AstroidFramework::createTemplate()	JROOT/libraries/astroid/framework/astroid.php:17
13	AstroidFramework::getTemplate()	JROOT/libraries/astroid/framework/menu.php:562
12	AstroidMenu::getMobileMenu()	JROOT/libraries/jollyany/framework/frontend/mobilemenu.php:34
11	include JROOT/libraries/jollyany/framework/frontend/mobilemenu.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/jollyany/framework/template.php:33
9	JollyanyFrameworkTemplate->loadLayout()	JROOT/libraries/astroid/framework/template.php:262
8	AstroidFrameworkTemplate->renderLayout()	JROOT/templates/tz_charity/index.php:98
7	require JROOT/templates/tz_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.37 ms After last query: 30.35 ms

SELECT *

  FROM `dprs_sppagebuilder`

  WHERE `extension` = 'mod_sppagebuilder' 
  AND `extension_view` = 'module' 
  AND `view_id` = '159'

Explain

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

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.06 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.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:38
12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:14
11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 2.79 ms

Duplicate queries: #53

SELECT `template`

  FROM `dprs_template_styles`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_template_styles	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	14	8.57	Using where

Profile

Status	Duration
starting	0.14 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.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:633
14	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
13	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:729
12	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/modules/mod_sppagebuilder/tmpl/default.php:11
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 31.12 ms

Duplicate queries: #52

SELECT `template`

  FROM `dprs_template_styles`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_template_styles	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	14	8.57	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.24 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.02 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_sppagebuilder/builder/classes/base.php:37
14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 3.24 ms

SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id

  FROM (
SELECT id,title,level,published,parent_id,lft,rgt

  FROM dprs_tags

  WHERE `published` = '1') AS a

  LEFT JOIN `dprs_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`level` != '0'

  ORDER BY a.lft ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dprs_tags	NULL	ref	tag_idx	tag_idx	1	const	4	75.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Range checked for each record (index map: 0x20); Distinct

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
preparing	0.01 ms
executing	0.16 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.01 ms
cleaning up	0.01 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_sppagebuilder/builder/classes/base.php:194
15	SpPgaeBuilderBase::getArticleTags()	JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php:163
14	require_once JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:66
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.10 ms

Duplicate queries: #56 #57

SELECT a.enabled

  FROM `dprs_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

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.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.17 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.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:588
15	SpPgaeBuilderBase::k2CatList()	JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php:172
14	require_once JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:66
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.14 ms

Duplicate queries: #55 #57

SELECT a.enabled

  FROM `dprs_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 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.01 ms
statistics	0.13 ms
preparing	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.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:588
15	SpPgaeBuilderBase::k2CatList()	JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php:317
14	require_once JROOT/templates/tz_charity/sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:66
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.96 ms

Duplicate queries: #55 #56

SELECT a.enabled

  FROM `dprs_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

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

Profile

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.02 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.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:588
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
14	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 16.36 ms

SELECT a.enabled

  FROM `dprs_extensions` AS `a`

  WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	100.00	Using index condition

Profile

Status	Duration
starting	0.10 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.03 ms
preparing	0.03 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:513
15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 21.63 ms

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM dprs_modules AS m

  WHERE m.published = 1 
  AND m.id = 358 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-24 16:06:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-24 16:06:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.04 ms
statistics	0.01 ms
preparing	0.02 ms
executing	1.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
15	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:430
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:284
12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:29
11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 3.54 ms

User Menu

Email

Useful Links

Never Miss a Post

FIND US ON SOCIAL MEDIA

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

60 Queries Logged 89.29 ms

11 duplicate found!