{
    "__default": {
        "session": {
            "counter": 25,
            "timer": {
                "start": 1794616699,
                "last": 1794616706,
                "now": 1794616707
            },
            "token": "zRu59eFCoW28DPkLeUFq2flAlWO7u3dw"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "a952637f0676c961681a6d852854ecc276bc17e3",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            },
            "com_content": {
                "category": {
                    "list": {
                        "16:151": {
                            "limit": 10
                        }
                    }
                }
            }
        },
        "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": {
                "688c5a0f4fa93c906d144a389629cb818f0974fc": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/81-test",
                    "expiry": 1794616700
                },
                "1ba1760c2728ddaa83d6b06679a02045fcf5948f": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/16-other-matters/82-annual-data-collection",
                    "expiry": 1794616701
                },
                "d6bd821274e49f3980f8e5e9aef60df215c9e102": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/16-other-matters/78-consultation",
                    "expiry": 1794616701
                },
                "59c68aeb2326a660a3b8db5e98a440ff0f476f36": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/2-other-matters/uncategorised/0-distributed-energy-resources-policy",
                    "expiry": 1794616702
                },
                "f9a744ccf308abdcf842d93743d3ebbc753d9cca": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/2-other-matters/uncategorised/91-digital-samoa-project",
                    "expiry": 1794616702
                },
                "a60d77b6432381d1f6c591155052a4de9f972a44": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/2-other-matters/uncategorised/89-2017-col",
                    "expiry": 1794616702
                },
                "120cf70fffa0fd2dd5b3d2dc4c059a1cfb512932": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/2-other-matters/uncategorised/90-girls-in-ict-2020",
                    "expiry": 1794616702
                },
                "5ac05b8a66002a43e157b70922483150b0fff95e": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/2-other-matters/uncategorised/88-news-events",
                    "expiry": 1794616702
                },
                "3c70403cd9c8a1e73d72f8fed3b51325beeba5d0": {
                    "link": "https://www.regulator.gov.ws/index.php/legal-framework/16-other-matters/77-vacancies",
                    "expiry": 1794616703
                },
                "9c3796645b4457e758f3e4002e701676fababbc8": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/91-digital-samoa-project",
                    "expiry": 1794616705
                },
                "a952637f0676c961681a6d852854ecc276bc17e3": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/89-2017-col",
                    "expiry": 1794616705
                },
                "b341a4f331cfbbdfaa362a95a286adbdc958b7d7": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/16-other-matters/82-annual-data-collection",
                    "expiry": 1794616705
                },
                "d47ba9ba44c607b3dbe244cdfbf0315a497b9561": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/0-distributed-energy-resources-policy",
                    "expiry": 1794616705
                },
                "611c40972a5d42c4ea9068e0f3445f5fdbc02a4e": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/90-girls-in-ict-2020",
                    "expiry": 1794616705
                },
                "d7e4bcc63343ea1f4beb27042e116a7daa3b0b8d": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/88-news-events",
                    "expiry": 1794616705
                },
                "2b8050ebaffce791e0d93e202986814a99bda901": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/16-other-matters/78-consultation",
                    "expiry": 1794616706
                },
                "4664b29b1f7dd057edb664c540d9f5f1ef3706f5": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/2-other-matters/uncategorised/87-ootr-ads",
                    "expiry": 1794616706
                },
                "5c44de37a1669a695b3931e766b2d7eec1abf20a": {
                    "link": "https://www.regulator.gov.ws/index.php/telecommunications-regulation/telecommunications/16-other-matters/77-vacancies",
                    "expiry": 1794616706
                }
            }
        }
    }
}

Time

Memory

10 Queries Logged 11.52 ms

1. Query Time: 0.58 ms Query memory: 0.022 MB Memory before query: 1.318 MB Rows returned: 1

   SELECT `session_id`
   
     FROM `ootr_session`
   
     WHERE `session_id` = X'71646e3230703675686333377470736538727039373472346673' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   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.]

   ---

2. Query Time: 1.22 ms After last query: 0.65 ms Query memory: 0.031 MB Memory before query: 1.417 MB Rows returned: 34

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ootr_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profile

   Status	Duration
   starting	0.07 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.03 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.69 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
   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:225
   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.]

   ---

3. Query Time: 0.43 ms After last query: 0.67 ms Query memory: 0.023 MB Memory before query: 1.447 MB Rows returned: 5

   SELECT id, rules
   
     FROM `ootr_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ootr_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	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.02 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.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 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:318
   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:225
   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.]

   ---

4. Query Time: 0.52 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 1.459 MB Rows returned: 2

   SELECT b.id
   
     FROM ootr_usergroups AS a
   
     LEFT JOIN ootr_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   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:318
   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:225
   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.]

   ---

5. Query Time: 1.02 ms After last query: 0.22 ms Query memory: 0.028 MB Memory before query: 1.482 MB Rows returned: 44

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM ootr_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

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

   Profile

   Status	Duration
   starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.56 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	4.63 ms
   cleaning up	0.03 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:351
   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:356
   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:225
   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.]

   ---

6. Query Time: 1.75 ms After last query: 22.85 ms Query memory: 0.062 MB Memory before query: 1.857 MB Rows returned: 48

   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 ootr_menu AS m
   
     LEFT JOIN ootr_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	90	1.11	Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	regulator.gov.ws.new.m.component_id	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.13 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.06 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.06 ms
   preparing	0.03 ms
   Sorting result	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	0.94 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.04 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:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   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:533
   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:1141
   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:225
   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.]

   ---

7. Query Time: 1.01 ms After last query: 4.33 ms Query memory: 0.025 MB Memory before query: 2.176 MB Rows returned: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ootr_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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:225
   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.]

   ---

8. Query Time: 3.47 ms After last query: 0.29 ms Query memory: 0.005 MB Memory before query: 2.166 MB

   UPDATE `ootr_extensions`
   
     SET `params` = '{\"mediaversion\":\"02ed5175d0b5b76164dabddf9aa3a891\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	ootr_extensions	NULL	index	NULL	PRIMARY	4	NULL	185	100.00	Using where

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.05 ms
   updating	0.81 ms
   end	0.02 ms
   query end	2.30 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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:225
   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.]

   ---

9. Query Time: 0.57 ms After last query: 0.61 ms Query memory: 0.025 MB Memory before query: 2.191 MB Rows returned: 1

   SELECT *
   
     FROM ootr_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   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:225
   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.]

   ---

10. Query Time: 0.95 ms After last query: 0.37 ms Query memory: 0.021 MB Memory before query: 2.201 MB Rows returned: 2

    SELECT id, home, template, s.params
    
      FROM ootr_template_styles as s
    
      LEFT JOIN ootr_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where
    1	SIMPLE	e	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	185	0.54	Using where; Using join buffer (Block Nested Loop)

    Profile

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

    Call Stack

    #	Caller	File and line number
    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:225
    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.]

    ---

9 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `ootr_extensions`

2. 1 × SELECT `session_id` 
     FROM `ootr_session`

3. 1 × SELECT id, rules 
     FROM `ootr_viewlevels

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

5. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM ootr_extensions

6. 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 ootr_menu AS m 
     LEFT JOIN ootr_extensions AS e 
     ON m.component_id = e.extension_id

7. 1 × SELECT * 
     FROM ootr_languages

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

OTHER Tables:

1. 1 × UPDATE `ootr_extensions` 
     SET `params` = '{\"mediaversion\":\"02ed5175d0b5b76164dabddf9aa3a891\"}'