Welcome to JomSocial

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614409680,
                "last": 1614409680,
                "now": 1614409680
            },
            "token": "ni3jcpPx6Ktm1qLBsPOU1fPi591dHs8r"
        },
        "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
        },
        "jomsocial_userip": "3.238.186.43"
    }
}

Profile Information

Time

Memory

Time: 30.46 ms / 30.46 ms Memory: 2.564 MB / 2.80 MB Application: afterLoad

Time: 109.43 ms / 139.89 ms Memory: 8.708 MB / 11.50 MB Application: afterInitialise

Time: 36.19 ms / 176.08 ms Memory: 2.352 MB / 13.86 MB Application: afterRoute

Time: 8.45 ms / 184.53 ms Memory: 0.276 MB / 14.13 MB Application: beforeRenderComponent com_community

Time: 51.19 ms / 235.73 ms Memory: 5.306 MB / 19.44 MB Application: Before Access::preloadComponents (all components)

Time: 1.90 ms / 237.63 ms Memory: 0.103 MB / 19.54 MB Application: After Access::preloadComponents (all components)

Time: 0.08 ms / 237.71 ms Memory: -0.005 MB / 19.54 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 1.03 ms / 238.74 ms Memory: 0.054 MB / 19.59 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 61.58 ms / 300.32 ms Memory: 3.126 MB / 22.72 MB Application: Before Access::getAssetRules (id:290 name:com_community)

Time: 0.28 ms / 300.60 ms Memory: 0.029 MB / 22.74 MB Application: After Access::getAssetRules (id:290 name:com_community)

Time: 54.69 ms / 355.28 ms Memory: 1.779 MB / 24.52 MB Application: beforeRenderModule mod_community_members (JS Members)

Time: 10.49 ms / 365.77 ms Memory: 0.424 MB / 24.95 MB Application: afterRenderModule mod_community_members (JS Members)

Time: 1.48 ms / 367.26 ms Memory: -0.004 MB / 24.94 MB Application: beforeRenderModule mod_community_photos (JS Photos)

Time: 16.34 ms / 383.60 ms Memory: 1.901 MB / 26.84 MB Application: afterRenderModule mod_community_photos (JS Photos)

Time: 0.03 ms / 383.63 ms Memory: -0.005 MB / 26.84 MB Application: beforeRenderModule mod_community_videos (JS Videos)

Time: 7.54 ms / 391.17 ms Memory: 0.550 MB / 27.39 MB Application: afterRenderModule mod_community_videos (JS Videos)

Time: 1.55 ms / 392.72 ms Memory: -0.006 MB / 27.38 MB Application: beforeRenderModule mod_community_events (JS Events)

Time: 12.17 ms / 404.88 ms Memory: 0.882 MB / 28.26 MB Application: afterRenderModule mod_community_events (JS Events)

Time: 0.03 ms / 404.92 ms Memory: -0.007 MB / 28.26 MB Application: beforeRenderModule mod_community_groups (JS Groups)

Time: 3.39 ms / 408.30 ms Memory: 0.064 MB / 28.32 MB Application: afterRenderModule mod_community_groups (JS Groups)

Time: 0.03 ms / 408.33 ms Memory: -0.005 MB / 28.32 MB Application: beforeRenderModule mod_community_pages (JS Pages)

Time: 7.12 ms / 415.46 ms Memory: 0.615 MB / 28.93 MB Application: afterRenderModule mod_community_pages (JS Pages)

Time: 18.15 ms / 433.60 ms Memory: 0.182 MB / 29.11 MB Application: afterRenderComponent com_community

Time: 5.97 ms / 439.57 ms Memory: 0.620 MB / 29.73 MB Application: afterDispatch

Time: 120.80 ms / 560.38 ms Memory: 3.007 MB / 32.74 MB Application: beforeRenderModule mod_search (Search)

Time: 2.08 ms / 562.46 ms Memory: 0.028 MB / 32.77 MB Application: afterRenderModule mod_search (Search)

Time: 0.07 ms / 562.53 ms Memory: -0.011 MB / 32.76 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 8.85 ms / 571.37 ms Memory: 0.143 MB / 32.90 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.25 ms / 571.62 ms Memory: -0.014 MB / 32.88 MB Application: beforeRenderModule mod_search (Top Search)

Time: 0.96 ms / 572.59 ms Memory: 0.018 MB / 32.90 MB Application: afterRenderModule mod_search (Top Search)

Time: 0.24 ms / 572.82 ms Memory: -0.005 MB / 32.90 MB Application: beforeRenderModule mod_login (Login (Header))

Time: 3.44 ms / 576.26 ms Memory: 0.074 MB / 32.97 MB Application: afterRenderModule mod_login (Login (Header))

Time: 37.73 ms / 614.00 ms Memory: 1.070 MB / 34.04 MB Application: afterRender

Database queries total: 55.00 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_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	v310t_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Caller	File and line number
9	JDatabaseDriverMysqli->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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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 `v310t_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'696533676873657369706a363934763468386d757669326a6936', 1, 1614409680, 0, '', 0)

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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: 4.66 ms Query memory: 0.020 MB Memory before query: 6.195 MB Rows returned: 37

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

  FROM `v310t_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	v310t_extensions	NULL	ref	extension	extension	82	const	28	1.00	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->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:196
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: 4.08 ms Query memory: 0.015 MB Memory before query: 6.565 MB Rows returned: 5

SELECT id, rules

  FROM `v310t_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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:196
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: 0.24 ms Query memory: 0.015 MB Memory before query: 6.590 MB Rows returned: 2

SELECT b.id

  FROM v310t_usergroups AS a

  LEFT JOIN v310t_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	3	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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:196
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.69 ms After last query: 1.18 ms Query memory: 0.022 MB Memory before query: 6.706 MB Rows returned: 93

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

  FROM v310t_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	v310t_extensions	NULL	ref	extension	extension	82	const	157	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->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:196
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.14 ms After last query: 65.95 ms Query memory: 0.034 MB Memory before query: 11.866 MB Rows returned: 39

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 v310t_menu AS m

  LEFT JOIN v310t_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	wescoweb_caes.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.13 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/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:76
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:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:491
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:1073
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:196
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: 24.98 ms Query memory: 0.024 MB Memory before query: 13.481 MB Rows returned: 1

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

  FROM `v310t_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	v310t_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.32 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomsocial.system/jomsocial.system.php:90
8	azrulSysBot()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
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.37 ms Query memory: 0.016 MB Memory before query: 13.487 MB

UPDATE `v310t_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	v310t_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.17 ms
updating	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomsocial.system/jomsocial.system.php:90
8	azrulSysBot()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
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.64 ms After last query: 4.11 ms Query memory: 0.014 MB Memory before query: 13.864 MB Rows returned: 1

SELECT *

  FROM v310t_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	v310t_languages	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->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:196
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: 0.68 ms Query memory: 0.023 MB Memory before query: 13.893 MB Rows returned: 9

SELECT id, home, template, s.params

  FROM v310t_template_styles as s

  LEFT JOIN v310t_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	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	wescoweb_caes.e.element	2	72.73	Using index condition; Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:196
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.34 ms After last query: 25.78 ms Query memory: 0.022 MB Memory before query: 16.346 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `v310t_community_config`

Explain

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.45 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
10	CommunityTableConfiguration->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/core.php:1093
8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 1.12 ms Query memory: 0.016 MB Memory before query: 16.405 MB Rows returned: 1

SELECT *

  FROM v310t_community_config

  WHERE `name` = 'config'

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_community/libraries/core.php:1094
8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
6	require_once JROOT/components/com_community/community.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:196
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: 5.28 ms Query memory: 0.014 MB Memory before query: 16.829 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_users` 
  WHERE `id` = '0'

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.13 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
8	CFactory::getUser()	JROOT/components/com_community/controllers/controller.php:40
7	CommunityBaseController->__construct()	JROOT/components/com_community/community.php:144
6	require_once JROOT/components/com_community/community.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:196
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.96 ms After last query: 4.42 ms Query memory: 0.025 MB Memory before query: 17.339 MB Rows returned: 0

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`pages` as _pages,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  a.`longitude` as longitude,  a.`latitude` as latitude,  a.`default_avatar` as _defaultAvatar,  a.`usergroup` as _usergroup,  s.`userid` as _isonline, u.*  
  FROM `v310t_community_users` as a  
  LEFT JOIN `v310t_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `v310t_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='0'

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.21 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.39 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:176
9	CUser->init()	JROOT/components/com_community/libraries/core.php:199
8	CFactory::getUser()	JROOT/components/com_community/controllers/controller.php:40
7	CommunityBaseController->__construct()	JROOT/components/com_community/community.php:144
6	require_once JROOT/components/com_community/community.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:196
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.10 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 17.468 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `v310t_community_profiles`

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.40 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 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.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_community/tables/multiprofile.php:33
11	CTableMultiProfile->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/user.php:844
9	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
8	CFactory::getUser()	JROOT/components/com_community/controllers/controller.php:40
7	CommunityBaseController->__construct()	JROOT/components/com_community/community.php:144
6	require_once JROOT/components/com_community/community.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:196
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: 2.06 ms Query memory: 0.019 MB Memory before query: 17.741 MB Rows returned: 1

SELECT `id` 
  FROM `v310t_community_fields` 
  WHERE `fieldcode`='FIELD_GENDER'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_community_fields	NULL	ref	fieldcode	fieldcode	767	const	1	100.00	Using index

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:823
12	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:797
11	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:722
10	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:876
9	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
8	CFactory::getUser()	JROOT/components/com_community/controllers/controller.php:40
7	CommunityBaseController->__construct()	JROOT/components/com_community/community.php:144
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.15 ms Query memory: 0.018 MB Memory before query: 17.759 MB Rows returned: 0

SELECT `value` 
  FROM `v310t_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_community_fields_values	NULL	ref	field_id,user_id,idx_user_fieldid	field_id	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:806
11	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:722
10	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:876
9	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
8	CFactory::getUser()	JROOT/components/com_community/controllers/controller.php:40
7	CommunityBaseController->__construct()	JROOT/components/com_community/community.php:144
6	require_once JROOT/components/com_community/community.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:196
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.23 ms After last query: 11.82 ms Query memory: 0.033 MB Memory before query: 19.448 MB Rows returned: 37

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

  FROM `v310t_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','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_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	255	14.90	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.48 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
22	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/components/com_community/libraries/user.php:1399
17	CUser->authorise()	JROOT/components/com_community/helpers/owner.php:51
16	COwnerHelper::isCommunityAdmin()	JROOT/components/com_community/libraries/template.php:227
15	CTemplate->fetch()	JROOT/components/com_community/libraries/assets.php:113
14	CAssets->_init()	JROOT/components/com_community/libraries/assets.php:30
13	CAssets->__construct()	JROOT/components/com_community/libraries/assets.php:43
12	CAssets::getInstance()	JROOT/components/com_community/views/views.php:39
11	CommunityView->__construct()	JROOT/components/com_community/libraries/core.php:454
10	CFactory::getView()	JROOT/components/com_community/controllers/controller.php:249
9	CommunityBaseController->getView()	JROOT/components/com_community/controllers/frontpage.php:51
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.54 ms After last query: 10.89 ms Query memory: 0.019 MB Memory before query: 20.448 MB Rows returned: 0

SELECT `id`,`parent_id` 
  FROM `v310t_menu` 
  WHERE `menutype`='jomsocial' 
  AND `published`='1' 
  AND `link` LIKE '%index.php?option=com_community&view=frontpage%'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ref	idx_menutype	idx_menutype	98	const	16	1.11	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_community/models/toolbar.php:135
12	CommunityModelToolbar->getActiveId()	JROOT/components/com_community/helpers/head.php:96
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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: 1.36 ms Query memory: 0.022 MB Memory before query: 20.533 MB Rows returned: 1

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=frontpage%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:161
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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: 1.15 ms Query memory: 0.021 MB Memory before query: 20.587 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=groups%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:162
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 20.609 MB Rows returned: 1

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` = 'index.php?option=com_community&view=frontpage' 
  AND `published`='1' 
  AND `type`='component'

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1471
14	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1356
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:162
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 20.631 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=photos%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:163
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.54 ms After last query: 0.52 ms Query memory: 0.021 MB Memory before query: 20.654 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=videos%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:164
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.48 ms Query memory: 0.021 MB Memory before query: 20.676 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=events%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/libraries/core.php:1263
12	CRoute::getExternalURL()	JROOT/components/com_community/helpers/head.php:165
11	CHeadHelper::setType()	JROOT/components/com_community/views/frontpage/view.html.php:45
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.75 ms After last query: 1.15 ms Query memory: 0.020 MB Memory before query: 20.731 MB Rows returned: 1

SELECT * 
  FROM `v310t_community_theme` 
  WHERE `key`='settings' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_community_theme	NULL	const	key	key	98	const	1	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/models/theme.php:28
12	CommunityModelTheme->__construct()	JROOT/components/com_community/libraries/core.php:372
11	CFactory::getModel()	JROOT/components/com_community/views/frontpage/view.html.php:124
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.61 ms After last query: 0.89 ms Query memory: 0.022 MB Memory before query: 20.805 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=register%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php:32
12	require JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php	JROOT/components/com_community/libraries/template.php:240
11	CTemplate->fetch()	JROOT/components/com_community/views/frontpage/view.html.php:140
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.61 ms After last query: 6.51 ms Query memory: 0.022 MB Memory before query: 21.465 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=remind%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php:84
12	require JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php	JROOT/components/com_community/libraries/template.php:240
11	CTemplate->fetch()	JROOT/components/com_community/views/frontpage/view.html.php:140
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.61 ms After last query: 0.60 ms Query memory: 0.022 MB Memory before query: 21.490 MB Rows returned: 0

SELECT `id` 
  FROM `v310t_menu` 
  WHERE `link` LIKE '%option=com_community&view=reset%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_menu	NULL	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	168	0.60	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
14	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1327
13	CRoute::_()	JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php:85
12	require JROOT/components/com_community/templates/jomsocial/layouts/frontpage/guest.php	JROOT/components/com_community/libraries/template.php:240
11	CTemplate->fetch()	JROOT/components/com_community/views/frontpage/view.html.php:140
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.78 ms Query memory: 0.018 MB Memory before query: 21.468 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `v310t_users` 
  WHERE `block`='0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v310t_users	NULL	system	idx_block	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/user.php:161
11	CommunityModelUser->getMembersCount()	JROOT/components/com_community/views/frontpage/view.html.php:147
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 29.42 ms Query memory: 0.025 MB Memory before query: 22.656 MB Rows returned: 0

SELECT m.*,n.`name` 
  FROM `v310t_community_blocklist` m 
  LEFT JOIN `v310t_users` n 
  ON m.`blocked_userid`=n.`id` 
  WHERE m.`userid`='0' 
  AND m.`blocked_userid`!=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	userid,blocked_userid	userid	4	const	1	100.00	Using where
1	SIMPLE	n	NULL	eq_ref	PRIMARY	PRIMARY	4	wescoweb_caes.m.blocked_userid	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/models/block.php:133
16	CommunityModelBlock->getBlockedList()	JROOT/components/com_community/libraries/user.php:1510
15	CUser->getBlockedUsers()	JROOT/components/com_community/libraries/activities.php:425
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.33 ms Query memory: 0.024 MB Memory before query: 22.682 MB Rows returned: 0

Duplicate queries: #51

SELECT `id` 
  FROM `v310t_users` 
  WHERE `block`='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	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/user.php:780
16	CommunityModelUser->getBannedUser()	JROOT/components/com_community/models/activities.php:298
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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: 1.00 ms Query memory: 0.025 MB Memory before query: 22.745 MB Rows returned: 0

Duplicate queries: #40 #48 #52 #57 #64

SELECT `id` 
  FROM `v310t_community_groups` 
  WHERE `approvals` = 0

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:886
17	CommunityModelActivities->_getGroups()	JROOT/components/com_community/models/activities.php:586
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.50 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 22.770 MB Rows returned: 0

Duplicate queries: #41 #49 #53 #58 #65

SELECT `groupid` 
  FROM `v310t_community_groups_members` 
  WHERE `approved` = 1 
  AND `memberid` = 0 
  AND `memberid` > 0 
  GROUP BY `groupid`

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:894
17	CommunityModelActivities->_getGroups()	JROOT/components/com_community/models/activities.php:586
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.54 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 22.794 MB Rows returned: 0

Duplicate queries: #42 #54 #59

SELECT `id` 
  FROM `v310t_community_pages` 
  WHERE `approvals` = 0

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:912
17	CommunityModelActivities->_getPages()	JROOT/components/com_community/models/activities.php:598
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.50 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 22.819 MB Rows returned: 0

Duplicate queries: #43 #55 #60

SELECT `pageid` 
  FROM `v310t_community_pages_members` 
  WHERE `approved` = 1 
  AND `memberid` = 0 
  AND `memberid` > 0 
  GROUP BY `pageid`

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:920
17	CommunityModelActivities->_getPages()	JROOT/components/com_community/models/activities.php:598
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.19 ms After last query: 3.95 ms Query memory: 0.025 MB Memory before query: 23.360 MB Rows returned: 0

Duplicate queries: #56

SELECT DISTINCT a.`id` 
  FROM `v310t_community_events` AS a  
  LEFT JOIN `v310t_community_events_members` AS b  
  ON a.`id`=b.`eventid` 
  WHERE  (    b.`status`='1'		OR 	  b.`status`='2'		OR 	  b.`status`='3' )  
  AND b.memberid='0' 
  AND a.published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,idx_creator,idx_period,idx_type,idx_catid,idx_published	idx_published	5	const	1	100.00	Using index; Using temporary
1	SIMPLE	b	NULL	ref	idx_eventid,idx_status,idx_permission,idx_member_event	idx_eventid	4	wescoweb_caes.a.id	1	100.00	Using where; Distinct

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.59 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/events.php:652
17	CommunityModelEvents->getEventIds()	JROOT/components/com_community/models/activities.php:615
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.23 ms Query memory: 0.025 MB Memory before query: 23.384 MB Rows returned: 0

Duplicate queries: #35 #48 #52 #57 #64

SELECT `id` 
  FROM `v310t_community_groups` 
  WHERE `approvals` = 0

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:886
17	CommunityModelActivities->_getGroups()	JROOT/components/com_community/models/activities.php:659
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 23.409 MB Rows returned: 0

Duplicate queries: #36 #49 #53 #58 #65

SELECT `groupid` 
  FROM `v310t_community_groups_members` 
  WHERE `approved` = 1 
  AND `memberid` = 0 
  AND `memberid` > 0 
  GROUP BY `groupid`

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:894
17	CommunityModelActivities->_getGroups()	JROOT/components/com_community/models/activities.php:659
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
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.15 ms Query memory: 0.025 MB Memory before query: 23.433 MB Rows returned: 0

Duplicate queries: #37 #54 #59

SELECT `id` 
  FROM `v310t_community_pages` 
  WHERE `approvals` = 0

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_community/models/activities.php:912
17	CommunityModelActivities->_getPages()	JROOT/components/com_community/models/activities.php:667
16	CommunityModelActivities->_buildQuery()	JROOT/components/com_community/models/activities.php:340
15	CommunityModelActivities->getActivities()	JROOT/components/com_community/libraries/activities.php:447
14	CActivities->_getData()	JROOT/components/com_community/libraries/activities.php:1245
13	CActivities->getHTML()	JROOT/components/com_community/libraries/activities.php:1674
12	CActivities::getActivitiesByFilter()	JROOT/components/com_community/views/frontpage/view.html.php:343
11	CommunityViewFrontpage->showLatestActivities()	JROOT/components/com_community/views/frontpage/view.html.php:149
10	CommunityViewFrontpage->display()	JROOT/components/com_community/views/views.php:265
9	CommunityView->get()	JROOT/components/com_community/controllers/frontpage.php:52
8	CommunityFrontpageController->display()	JROOT/components/com_community/controllers/controller.php:388
7	CommunityBaseController->execute()	JROOT/components/com_community/community.php:145
6	require_once JROOT/components/com_community/community.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 23.458 MB Rows returned: 0

Get Connected!

Welcome to JomSocial

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

91 Queries Logged 55.00 ms

28 duplicate found!