Free Real South African Community Sign Language Dictionary

Forgot your password? Forgot your username?

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611592520,
                "last": 1611592520,
                "now": 1611592520
            },
            "token": "4O1Dhva0SsrlisGVV7EA92JLmIs5BxWz"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "https:\/\/www.realsasl.com\/all-videos\/video\/445-absent"
                        }
                    }
                }
            },
            "yendif": {
                "search": {
                    "public": ""
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 6.95 ms / 6.95 ms Memory: 0.506 MB / 0.88 MB Application: afterLoad

Time: 45.98 ms / 52.92 ms Memory: 2.079 MB / 2.96 MB Application: afterInitialise

Time: 11.80 ms / 64.72 ms Memory: 0.557 MB / 3.51 MB Application: afterRoute

Time: 2.52 ms / 67.23 ms Memory: 0.162 MB / 3.67 MB Application: beforeRenderComponent com_users

Time: 17.73 ms / 84.96 ms Memory: 0.375 MB / 4.05 MB Application: afterRenderComponent com_users

Time: 11.39 ms / 96.35 ms Memory: 0.271 MB / 4.32 MB Application: afterDispatch

Time: 8.75 ms / 105.09 ms Memory: 0.181 MB / 4.50 MB Application: Before Access::preloadComponents (all components)

Time: 1.25 ms / 106.35 ms Memory: 0.059 MB / 4.56 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 106.38 ms Memory: -0.002 MB / 4.56 MB Application: Before Access::getAssetRules (id:94 name:com_jfbconnect)

Time: 0.35 ms / 106.73 ms Memory: 0.010 MB / 4.57 MB Application: After Access::getAssetRules (id:94 name:com_jfbconnect)

Time: 0.46 ms / 107.19 ms Memory: 0.007 MB / 4.58 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.54 ms / 108.73 ms Memory: 0.026 MB / 4.60 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.07 ms / 108.80 ms Memory: -0.004 MB / 4.60 MB Application: beforeRenderModule mod_custom (Contact Bottom)

Time: 5.97 ms / 114.77 ms Memory: 0.100 MB / 4.70 MB Application: afterRenderModule mod_custom (Contact Bottom)

Time: 0.08 ms / 114.85 ms Memory: -0.002 MB / 4.70 MB Application: beforeRenderModule mod_custom (Terms & Conditions)

Time: 0.14 ms / 114.99 ms Memory: 0.003 MB / 4.70 MB Application: afterRenderModule mod_custom (Terms & Conditions)

Time: 0.04 ms / 115.03 ms Memory: -0.001 MB / 4.70 MB Application: beforeRenderModule mod_custom (bottom3_blank)

Time: 0.32 ms / 115.35 ms Memory: 0.005 MB / 4.70 MB Application: afterRenderModule mod_custom (bottom3_blank)

Time: 0.04 ms / 115.39 ms Memory: -0.001 MB / 4.70 MB Application: beforeRenderModule mod_custom (bottom1_blank)

Time: 0.24 ms / 115.63 ms Memory: 0.003 MB / 4.71 MB Application: afterRenderModule mod_custom (bottom1_blank)

Time: 0.07 ms / 115.70 ms Memory: -0.001 MB / 4.70 MB Application: beforeRenderModule mod_yendifvideoshare_search (Search SA Sign Language By Handshape)

Time: 3.51 ms / 119.21 ms Memory: 0.214 MB / 4.92 MB Application: afterRenderModule mod_yendifvideoshare_search (Search SA Sign Language By Handshape)

Time: 0.03 ms / 119.24 ms Memory: -0.094 MB / 4.82 MB Application: beforeRenderModule mod_custom (*SASL = South African Sign Language)

Time: 0.13 ms / 119.37 ms Memory: 0.003 MB / 4.83 MB Application: afterRenderModule mod_custom (*SASL = South African Sign Language)

Time: 0.07 ms / 119.44 ms Memory: 0.048 MB / 4.88 MB Application: beforeRenderModule mod_sclogin (Login)

Time: 19.03 ms / 138.47 ms Memory: 0.578 MB / 5.45 MB Application: afterRenderModule mod_sclogin (Login)

Time: 0.10 ms / 138.57 ms Memory: -0.017 MB / 5.44 MB Application: beforeRenderModule mod_custom (custom logo)

Time: 0.52 ms / 139.09 ms Memory: 0.003 MB / 5.44 MB Application: afterRenderModule mod_custom (custom logo)

Time: 17.67 ms / 156.76 ms Memory: 0.234 MB / 5.67 MB Application: afterRender

Database queries total: 19.31 ms

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_session	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 `josgr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6131366630646230663336356437653766623261333561656661303163646138', 1, 1611592520, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.02 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.47 ms After last query: 1.38 ms Query memory: 0.040 MB Memory before query: 1.301 MB Rows returned: 47

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

  FROM `josgr_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_extensions	ref	extension	extension	82	const	47	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.21 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.25 ms After last query: 1.26 ms Query memory: 0.021 MB Memory before query: 1.357 MB Rows returned: 7

SELECT id, rules

  FROM `josgr_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 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.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.34 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.370 MB Rows returned: 2

SELECT b.id

  FROM josgr_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 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: 0.76 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 1.393 MB Rows returned: 110

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

  FROM josgr_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_extensions	ref	extension	extension	82	const	140	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.48 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 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: 0.41 ms After last query: 11.35 ms Query memory: 0.048 MB Memory before query: 2.098 MB Rows returned: 134

SELECT setting,value 
  FROM josgr_jfbconnect_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:281
14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:292
13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:327
12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:32
11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/meetup.php:20
10	JFBConnectProviderMeetup->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:55
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.32 ms After last query: 6.34 ms Query memory: 0.024 MB Memory before query: 2.496 MB Rows returned: 1

Duplicate queries: #21

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_joomla"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:638
16	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
15	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/amazon.php:82
11	JFBConnectProfileAmazon->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:34
10	JFBConnectProviderAmazon->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:56
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.14 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 2.508 MB Rows returned: 1

Duplicate queries: #22

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_customdb"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:638
16	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
15	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/amazon.php:82
11	JFBConnectProfileAmazon->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:34
10	JFBConnectProviderAmazon->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:56
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.12 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 2.518 MB Rows returned: 1

Duplicate queries: #23

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_communitybuilder"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:638
16	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
15	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/amazon.php:82
11	JFBConnectProfileAmazon->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:34
10	JFBConnectProviderAmazon->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:56
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.18 ms After last query: 10.66 ms Query memory: 0.020 MB Memory before query: 2.942 MB Rows returned: 1

SELECT count(*)

  FROM `josgr_cwgears_schedule`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 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.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.13 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 2.947 MB Rows returned: 1

SELECT count(*)

  FROM `josgr_cwgears_schedule`

  WHERE time + '86400'<'1611592520'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.81 ms After last query: 1.46 ms Query memory: 0.103 MB Memory before query: 3.061 MB Rows returned: 44

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

  LEFT JOIN josgr_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	62	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.43 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 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.31 ms After last query: 4.81 ms Query memory: 0.024 MB Memory before query: 3.380 MB Rows returned: 1

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

  FROM `josgr_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/helixultimate/helixultimate.php:134
8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.34 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 3.373 MB

UPDATE `josgr_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.06 ms
updating	0.10 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.06 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/helixultimate/helixultimate.php:134
8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.54 ms After last query: 4.49 ms Query memory: 0.020 MB Memory before query: 3.520 MB Rows returned: 1

SELECT *

  FROM josgr_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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.45 ms After last query: 0.44 ms Query memory: 0.066 MB Memory before query: 3.529 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM josgr_template_styles as s

  LEFT JOIN josgr_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	realsas2_rs2019test.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.02 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.75 ms After last query: 9.16 ms Query memory: 0.027 MB Memory before query: 3.914 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM josgr_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_users.login' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	realsas2_rs2019test.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.68 ms
Creating sort index	0.03 ms
end	0.00 ms
removing tmp table	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 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/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
11	UsersModelLogin->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.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.29 ms After last query: 9.95 ms Query memory: 0.021 MB Memory before query: 4.136 MB Rows returned: 0

SELECT *

  FROM `josgr_opengraph_action`

  WHERE `published`='1'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 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.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jfbconnect/models/opengraphaction.php:80
10	JFBConnectModelOpenGraphAction->getActions()	JROOT/components/com_jfbconnect/libraries/profile/facebook.php:114
9	JFBConnectProfileFacebook->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/facebook.php:254
8	JFBConnectProviderFacebook->onAfterDispatch()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:88
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.24 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 4.142 MB Rows returned: 1

Duplicate queries: #9

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_joomla"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 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/libraries/sourcecoast/plugins/socialprofile.php:638
14	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
13	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/facebook.php:130
9	JFBConnectProfileFacebook->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/facebook.php:254
8	JFBConnectProviderFacebook->onAfterDispatch()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:88
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.08 ms Query memory: 0.023 MB Memory before query: 4.150 MB Rows returned: 1

Duplicate queries: #10

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_customdb"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/libraries/sourcecoast/plugins/socialprofile.php:638
14	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
13	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/facebook.php:130
9	JFBConnectProfileFacebook->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/facebook.php:254
8	JFBConnectProviderFacebook->onAfterDispatch()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:88
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.19 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 4.157 MB Rows returned: 1

Duplicate queries: #11

SELECT value

  FROM josgr_jfbconnect_config

  WHERE setting="profile_communitybuilder"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jfbconnect_config	const	setting	setting	152	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 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/libraries/sourcecoast/plugins/socialprofile.php:638
14	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
13	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/facebook.php:130
9	JFBConnectProfileFacebook->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/facebook.php:254
8	JFBConnectProviderFacebook->onAfterDispatch()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:88
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.36 ms After last query: 6.02 ms Query memory: 0.023 MB Memory before query: 4.238 MB Rows returned: 0

SELECT * 
  FROM josgr_opengraph_object 
  WHERE  plugin = 'custom' 
  AND system_name = 'custom' 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_opengraph_object	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.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jfbconnect/models/opengraphobject.php:61
14	JFBConnectModelOpenGraphObject->getPluginObjects()	JROOT/libraries/sourcecoast/openGraphPlugin.php:129
13	OpenGraphPlugin->getObjects()	JROOT/plugins/opengraph/custom/custom.php:49
12	plgOpenGraphCustom->findObjectType()	JROOT/libraries/sourcecoast/openGraphPlugin.php:80
11	OpenGraphPlugin->onOpenGraphAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
8	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:152
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.36 ms After last query: 5.00 ms Query memory: 0.073 MB Memory before query: 4.516 MB Rows returned: 114

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

  FROM josgr_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-25 16:35:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-25 16:35:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	67	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	realsas2_rs2019test.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.m.id	2	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:570
11	HelixUltimate->count_modules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:374
10	HelixUltimate->get_current_row()	JROOT/plugins/system/helixultimate/core/helixultimate.php:306
9	HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/core/helixultimate.php:274
8	HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:142
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.07 ms After last query: 3.15 ms Query memory: 0.026 MB Memory before query: 4.505 MB Rows returned: 47

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

  FROM `josgr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_jchat','com_jfbconnect','com_jmap','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_regularlabsmanager','com_scriptmerge','com_search','com_tags','com_templates','com_users','com_wrapper','com_yendifvideoshare')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	424	11.32	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 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.67 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
8	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:164
7	plgSystemJFBCSystem->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.02 ms After last query: 3.10 ms Query memory: 0.026 MB Memory before query: 4.620 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM josgr_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	realsas2_rs2019test.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	realsas2_rs2019test.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.85 ms
Creating sort index	0.03 ms
end	0.00 ms
removing tmp table	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 4.78 ms Query memory: 0.027 MB Memory before query: 4.730 MB Rows returned: 105

Duplicate queries: #30 #31

SELECT name,value 
  FROM josgr_yendifvideoshare_options

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yendifvideoshare/libraries/utils.php:151
11	YendifVideoShareUtils::getConfig()	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:37
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.34 ms Query memory: 0.023 MB Memory before query: 4.767 MB Rows returned: 3

SELECT * 
  FROM josgr_yendifvideoshare_categories 
  WHERE published=1 
  AND parent=0 
  ORDER BY parent

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yendifvideoshare/libraries/utils.php:457
12	YendifVideoShareUtils::getParents()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:55
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 4.779 MB Rows returned: 105

Duplicate queries: #28 #31

SELECT name,value 
  FROM josgr_yendifvideoshare_options

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_yendifvideoshare/router.php:238
19	YendifVideoShareRouter->getYendifConfig()	JROOT/components/com_yendifvideoshare/router.php:69
18	YendifVideoShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:63
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.25 ms Query memory: 0.029 MB Memory before query: 4.788 MB Rows returned: 105

Duplicate queries: #28 #30

SELECT name,value 
  FROM josgr_yendifvideoshare_options

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/administrator/components/com_yendifvideoshare/libraries/utils.php:151
13	YendifVideoShareUtils::getConfig()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php:12
12	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:117
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.10 ms Query memory: 0.060 MB Memory before query: 4.796 MB Rows returned: 77

SELECT * 
  FROM josgr_yendifvideoshare_categories 
  WHERE published=1 
  AND parent=2 
  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_yendifvideoshare/libraries/utils.php:466
13	YendifVideoShareUtils::getChildren()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php:29
12	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:117
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 4.931 MB Rows returned: 25

SELECT * 
  FROM josgr_yendifvideoshare_categories 
  WHERE published=1 
  AND parent=13 
  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/administrator/components/com_yendifvideoshare/libraries/utils.php:466
13	YendifVideoShareUtils::getChildren()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php:29
12	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:117
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.07 ms Query memory: 0.032 MB Memory before query: 4.884 MB Rows returned: 23

SELECT * 
  FROM josgr_yendifvideoshare_categories 
  WHERE published=1 
  AND parent=257 
  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/administrator/components/com_yendifvideoshare/libraries/utils.php:466
13	YendifVideoShareUtils::getChildren()	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php:29
12	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_category.php	JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php:117
11	require JROOT/modules/mod_yendifvideoshare_search/tmpl/default_sign.php	JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php:60
10	include JROOT/modules/mod_yendifvideoshare_search/mod_yendifvideoshare_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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: 7.96 ms Query memory: 0.033 MB Memory before query: 5.204 MB Rows returned: 1

SELECT `params`
 
  FROM `josgr_comprofiler_plugin`
 
  WHERE `id` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
37	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
36	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
35	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
34	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
33	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
32	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:71
31	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
30	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
29	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
28	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
27	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
26	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
25	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
24	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
23	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
22	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
21	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/router.php:75
20	ComprofilerRouter->loadCB()	JROOT/components/com_comprofiler/router.php:125
19	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_sclogin/helper.php:217
12	modSCLoginHelper->getPasswordAndProfileLinks()	JROOT/modules/mod_sclogin/helper.php:48
11	modSCLoginHelper->__construct()	JROOT/modules/mod_sclogin/mod_sclogin.php:18
10	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 5.64 ms Query memory: 0.025 MB Memory before query: 5.390 MB Rows returned: 0

SELECT `id`
 
  FROM `josgr_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	63	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
15	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
14	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
13	CBframework->viewUrl()	JROOT/modules/mod_sclogin/tmpl/joomlaLogin_vertical.php:31
12	require JROOT/modules/mod_sclogin/tmpl/joomlaLogin_vertical.php	JROOT/modules/mod_sclogin/tmpl/login.php:53
11	require JROOT/modules/mod_sclogin/tmpl/login.php	JROOT/modules/mod_sclogin/mod_sclogin.php:79
10	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.05 ms Query memory: 0.025 MB Memory before query: 5.400 MB Rows returned: 0

SELECT `id`
 
  FROM `josgr_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	63	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 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.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
15	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:235
14	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
13	CBframework->viewUrl()	JROOT/modules/mod_sclogin/tmpl/joomlaLogin_vertical.php:31
12	require JROOT/modules/mod_sclogin/tmpl/joomlaLogin_vertical.php	JROOT/modules/mod_sclogin/tmpl/login.php:53
11	require JROOT/modules/mod_sclogin/tmpl/login.php	JROOT/modules/mod_sclogin/mod_sclogin.php:79
10	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.35 ms After last query: 4.85 ms Query memory: 0.022 MB Memory before query: 5.454 MB Rows returned: 0

SELECT *
 
  FROM josgr_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.realsasl.com/component/users/'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josgr_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 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.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.08 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 5.468 MB Rows returned: 0

SELECT uikit

  FROM `josgr_cwgears`

  WHERE url = 'https://www.realsasl.com/component/users/?view=login&return=aHR0cHM6Ly93d3cucmVhbHNhc2wuY29tL2FsbC12aWRlb3MvdmlkZW8vNDQ1LWFic2VudA==&Itemid=101'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:428
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 5.475 MB Rows returned: 0

SELECT uikit_plus

  FROM `josgr_cwgears`

  WHERE url = 'https://www.realsasl.com/component/users/?view=login&return=aHR0cHM6Ly93d3cucmVhbHNhc2wuY29tL2FsbC12aWRlb3MvdmlkZW8vNDQ1LWFic2VudA==&Itemid=101'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:437
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT value 
  FROM josgr_jfbconnect_config

4 × SELECT * 
  FROM josgr_yendifvideoshare_categories

3 × SELECT name,value 
  FROM josgr_yendifvideoshare_option

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM josgr_fields AS a 
  LEFT JOIN `josgr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN josgr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN josgr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN josgr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN josgr_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `josgr_extensions`

```
2 × SELECT `id`  
  FROM `josgr_menu`
```

1 × SELECT `data` 
  FROM `josgr_session`

1 × SELECT uikit 
  FROM `josgr_cwgears`

1 × SELECT *  
  FROM josgr_jmap_metainfo

1 × SELECT `params`  
  FROM `josgr_comprofiler_plugin`

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM josgr_modules AS m 
  LEFT JOIN josgr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN josgr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM josgr_opengraph_object

1 × SELECT id, home, template, s.params 
  FROM josgr_template_styles as s 
  LEFT JOIN josgr_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM `josgr_opengraph_action`

1 × SELECT `session_id` 
  FROM `josgr_session`

```
1 × SELECT * 
  FROM josgr_languages
```

1 × 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 josgr_menu AS m 
  LEFT JOIN josgr_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT count(*) 
  FROM `josgr_cwgears_schedule`

1 × SELECT count(*) 
  FROM `josgr_cwgears_schedule

1 × SELECT setting,value 
  FROM josgr_jfbconnect_confi

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM josgr_extensions

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

1 × SELECT id, rules 
  FROM `josgr_viewlevels

1 × SELECT uikit_plus 
  FROM `josgr_cwgears`

OTHER Tables:

1 × INSERT INTO `josgr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6131366630646230663336356437653766623261333561656661303163646138', 1, 1611592520, 0, '', 0

1 × UPDATE `josgr_extensions` 
  SET `params` = '{\"mediaversion\":\"bd8a4f9a9b249220103aa438d2d55da0\"}'

Log in

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

40 Queries Logged 19.31 ms

9 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: