{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1534569182,
                "last": 1534569182,
                "now": 1534569182
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "4896f2aa69740fb6d61cd4ab2e3e7f6e15a9ab12": {
                    "link": "https:\/\/bahamaslibraries.org\/index.php\/113-uncategorised\/642-free-library",
                    "expiry": 1534569182
                },
                "40e48ba87564b8949c167eaec8ef72dfbcaeb53e": {
                    "link": "https:\/\/bahamaslibraries.org\/index.php\/58-news\/recent-news\/639-gapmil-poster",
                    "expiry": 1534569182
                }
            }
        }
    }
}

Time

Memory

44 Queries Logged 50.06 ms

1. Query Time: 0.91 ms Query memory: 0.019 MB Memory before query: 3.134 MB Rows returned: 0

   SELECT `data`
   
     FROM `f4soy_session`
   
     WHERE `session_id` = 'l1rj3ldc7qb4vedprg5a6u8o57'

   Explain

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

   Profile

   Status	Duration
   starting	0.30 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.09 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.11 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:63

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

   ---

2. Query Time: 1.87 ms After last query: 3.96 ms Query memory: 0.010 MB Memory before query: 3.277 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `f4soy_session`
   
     WHERE `session_id` = 'l1rj3ldc7qb4vedprg5a6u8o57' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	f4soy_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profile

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:63

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

   ---

3. Query Time: 0.66 ms After last query: 0.26 ms Query memory: 0.009 MB Memory before query: 3.293 MB

   INSERT INTO `f4soy_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('l1rj3ldc7qb4vedprg5a6u8o57', 1, '1534569182', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `f4soy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('l1rj3ldc7qb4vedprg5a6u8o57', 1, '1534569182', 0, '', 0)

   Profile

   Status	Duration
   starting	0.21 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   update	0.17 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.11 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:63

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

   ---

4. Query Time: 1.03 ms After last query: 6.55 ms Query memory: 0.013 MB Memory before query: 3.544 MB Rows returned: 42

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `f4soy_extensions`
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	f4soy_extensions	ref	extension	extension	82	const	42	100.00	Using index condition

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   9	JComponentHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

5. Query Time: 0.66 ms After last query: 6.46 ms Query memory: 0.013 MB Memory before query: 3.830 MB Rows returned: 5

   SELECT id, rules
   
     FROM `f4soy_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.22 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.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.13 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

6. Query Time: 0.75 ms After last query: 0.50 ms Query memory: 0.014 MB Memory before query: 3.854 MB Rows returned: 2

   SELECT b.id
   
     FROM f4soy_usergroups AS a
   
     LEFT JOIN f4soy_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.14 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.10 ms
   preparing	0.05 ms
   executing	0.02 ms
   Sending data	0.07 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.16 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

7. Query Time: 1.08 ms After last query: 1.46 ms Query memory: 0.013 MB Memory before query: 3.949 MB Rows returned: 71

   SELECT `folder` AS `type`,`element` AS `name`,`params`
   
     FROM f4soy_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	f4soy_extensions	ref	extension	extension	82	const	96	100.00	Using index condition; Using where; Using filesort

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   9	JPluginHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

8. Query Time: 2.42 ms After last query: 64.49 ms Query memory: 0.023 MB Memory before query: 7.309 MB Rows returned: 177

   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 f4soy_menu AS m
   
     LEFT JOIN f4soy_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	234	78.21	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.m.component_id	1	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
   17	JMenuSite->{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

9. Query Time: 1.91 ms After last query: 28.18 ms Query memory: 0.023 MB Memory before query: 9.270 MB Rows returned: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `f4soy_assets`
   
     WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_hdwplayer','com_installer','com_jce','com_joomlaupdate','com_jupgradepro','com_jxtcalbumplayer','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rquote','com_search','com_speasyimagegallery','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zcalendar')

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
   18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
   17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
   16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
   15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
   14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
   13	RegularLabs\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
   12	RegularLabs\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
   11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:110
   10	RegularLabs\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/src/Plugin.php:54
   9	RegularLabs\AdvancedModules\Plugin->onAfterRoute()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:66

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

   ---

10. Query Time: 0.89 ms After last query: 3.29 ms Query memory: 0.016 MB Memory before query: 9.445 MB Rows returned: 4