pdf Bariatric Surgery (14 12 16) Popular

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563927003,
                "last": 1563927003,
                "now": 1563927003
            }
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "cacheids": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "f002cbadc7581877635f1f5559171b21": "{\"\\\/media\\\/jui\\\/js\\\/jquery.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-noconflict.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-migrate.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/koowa\\\/framework\\\/js\\\/koowa.kquery.js?1dd785e1\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/koowa\\\/framework\\\/js\\\/build\\\/modernizr.js?1dd785e1\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/koowa\\\/framework\\\/js\\\/build\\\/kui-initialize.js?1dd785e1\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/koowa\\\/framework\\\/js\\\/build\\\/koowa.js?1dd785e1\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/koowa\\\/framework\\\/js\\\/build\\\/jquery.magnific-popup.js?1dd785e1\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/com_docman\\\/js\\\/site\\\/downloadlabel.js?433e4a08\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/cache\\\/widgetkit\\\/widgetkit-13e6ab69.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/jui\\\/js\\\/bootstrap.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}}}"
                    }
                },
                "config": null,
                "shim": null,
                "jlayouts": null
            }
        }
    }
}

Time

Memory

21 Queries Logged 398.18 ms

1. Query Time: 0.34 ms Query memory: 0.022 MB Memory before query: 1.200 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = 'ubgfol7okdg4f3jq43r0gbq4su' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.01 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: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.]

   ---

2. Query Time: 37.36 ms After last query: 0.15 ms Query memory: 0.004 MB Memory before query: 1.206 MB

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('ubgfol7okdg4f3jq43r0gbq4su', 1, 1563927003, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ubgfol7okdg4f3jq43r0gbq4su', 1, 1563927003, 0, '', 0)

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.43 ms
   Waiting for query cache lock	0.01 ms
   update	0.00 ms
   end	0.01 ms
   query end	36.68 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   logging slow query	0.03 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.]

   ---

3. Query Time: 0.72 ms After last query: 4.78 ms Query memory: 0.030 MB Memory before query: 1.305 MB Rows returned: 44

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	45	Using where

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.28 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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.]

   ---

4. Query Time: 0.28 ms After last query: 3.65 ms Query memory: 0.023 MB Memory before query: 1.344 MB Rows returned: 5

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.00 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.]

   ---

5. Query Time: 0.36 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 1.356 MB Rows returned: 2

   SELECT b.id
   
     FROM jos_usergroups AS a
   
     LEFT JOIN jos_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	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

   Profile

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

   ---

6. Query Time: 1.50 ms After last query: 0.52 ms Query memory: 0.039 MB Memory before query: 1.379 MB Rows returned: 138

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jos_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	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	161	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.03 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sorting result	0.60 ms
   Sending data	0.50 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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.]

   ---

7. Query Time: 2.67 ms After last query: 118.71 ms Query memory: 0.190 MB Memory before query: 2.965 MB Rows returned: 143

   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 jos_menu AS m
   
     LEFT JOIN jos_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	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	185	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	norwich_db2.m.component_id	1

   Profile

   Status	Duration
   starting	0.13 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   System lock	0.01 ms
   init	0.08 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sorting result	0.50 ms
   Sending data	1.29 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.04 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   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.]

   ---

8. Query Time: 0.44 ms After last query: 20.76 ms Query memory: 0.024 MB Memory before query: 3.726 MB Rows returned: 1
   Duplicate queries: #9

   SELECT COUNT(*) 
     FROM jos_docman_documents 
     WHERE docman_document_id = 1926 
     AND slug = 'bariatric-surgery-14-12-16'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_docman_documents	const	docman_document_id,slug	docman_document_id	8	const	1

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.03 ms
   optimizing	0.01 ms
   statistics	0.14 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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/components/com_docman/router.php:296
   13	ComDocmanRouter->_isDocumentAlias()	JROOT/components/com_docman/router.php:272
   12	ComDocmanRouter->_findDocument()	JROOT/components/com_docman/router.php:321
   11	ComDocmanRouter->parse()	JROOT/components/com_docman/router.php:410
   10	DocmanParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   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.]

   ---

9. Query Time: 0.30 ms After last query: 0.69 ms Query memory: 0.028 MB Memory before query: 3.736 MB Rows returned: 1
   Duplicate queries: #8

   SELECT COUNT(*) 
     FROM jos_docman_documents 
     WHERE docman_document_id = 1926 
     AND slug = 'bariatric-surgery-14-12-16'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_docman_documents	const	docman_document_id,slug	docman_document_id	8	const	1

   Profile

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

   Call Stack

   #	Caller	File and line number
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   22	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:296
   21	ComDocmanRouter->_isDocumentAlias()	JROOT/components/com_docman/router.php:272
   20	ComDocmanRouter->_findDocument()	JROOT/components/com_docman/router.php:321
   19	ComDocmanRouter->parse()	JROOT/components/com_docman/router.php:410
   18	DocmanParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   17	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   16	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   15	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   14	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   13	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/joomlatools/component/koowa/event/subscriber/application.php:63
   12	ComKoowaEventSubscriberApplication->onAfterApplicationRoute()	JROOT/libraries/joomlatools/library/event/publisher/abstract.php:128
   11	KEventPublisherAbstract->publishEvent()	JROOT/libraries/joomlatools/component/koowa/event/publisher/publisher.php:43
   10	ComKoowaEventPublisher->publishEvent()	JROOT/plugins/system/joomlatools/joomlatools.php:303
   9	PlgSystemJoomlatools->_proxyEvent()	JROOT/plugins/system/joomlatools/joomlatools.php:230
   8	PlgSystemJoomlatools->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.]

   ---

10. Query Time: 0.38 ms After last query: 0.84 ms Query memory: 0.025 MB Memory before query: 3.764 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.01 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:1129
    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: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.]

    ---

11. Query Time: 343.88 ms After last query: 0.27 ms Query memory: 0.005 MB Memory before query: 3.755 MB

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"dd29667b8c63af18b077900e323f71cf\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.09 ms
    Updating	0.17 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	343.38 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 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:1129
    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: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.]

    ---

12. Query Time: 0.48 ms After last query: 3.61 ms Query memory: 0.025 MB Memory before query: 3.788 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.06 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 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.]

    ---

13. Query Time: 0.55 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 3.804 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	norwich_db2.s.template,const	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 1.06 ms After last query: 112.85 ms Query memory: 0.036 MB Memory before query: 4.634 MB Rows returned: 45

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_cbjuice2','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_fabrik','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_kunena','com_languages','com_linkchecker','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    Opening tables	0.04 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    30	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    29	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    28	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    27	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    26	Joomla\CMS\User\User->authorise()	JROOT/libraries/joomlatools/component/koowa/user/user.php:131
    25	ComKoowaUser->authorise()	JROOT/components/com_docman/dispatcher/http.php:104
    24	ComDocmanDispatcherHttp->getRequest()	JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:34
    23	ComKoowaDispatcherBehaviorDecoratable->isSupported()	JROOT/libraries/joomlatools/library/behavior/abstract.php:176
    22	KBehaviorAbstract->getHandle()	JROOT/libraries/joomlatools/library/object/queue.php:75
    21	KObjectQueue->enqueue()	JROOT/libraries/joomlatools/library/command/chain/chain.php:168
    20	KCommandChain->addHandler()	JROOT/libraries/joomlatools/library/command/mixin/mixin.php:259
    19	KCommandMixin->addCommandHandler()	JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:122
    18	KBehaviorMixin->addBehavior()	JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:45
    17	KBehaviorMixin->__construct()	JROOT/libraries/joomlatools/library/object/object.php:132
    16	KObject->mixin()	JROOT/libraries/joomlatools/library/controller/abstract.php:206
    15	KControllerAbstract->mixin()	JROOT/libraries/joomlatools/library/controller/abstract.php:77
    14	KControllerAbstract->__construct()	JROOT/libraries/joomlatools/library/dispatcher/abstract.php:49
    13	KDispatcherAbstract->__construct()	JROOT/libraries/joomlatools/library/dispatcher/http.php:32
    12	KDispatcherHttp->__construct()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:25
    11	ComKoowaDispatcherHttp->__construct()	JROOT/components/com_docman/dispatcher/http.php:13
    10	ComDocmanDispatcherHttp->__construct()	JROOT/libraries/joomlatools/library/dispatcher/http.php:75
    9	KDispatcherHttp::getInstance()	JROOT/libraries/joomlatools/library/object/manager/manager.php:721
    8	KObjectManager->_instantiate()	JROOT/libraries/joomlatools/library/object/manager/manager.php:161
    7	KObjectManager->getObject()	JROOT/components/com_docman/docman.php:10
    6	require_once JROOT/components/com_docman/docman.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.]

    ---

15. Query Time: 0.32 ms After last query: 443.91 ms Query memory: 0.040 MB Memory before query: 7.733 MB Rows returned: 1

    SELECT CONCAT_WS('-', tbl.docman_document_id, tbl.slug) AS alias
                
      FROM `jos_docman_documents` as tbl
                
      WHERE tbl.slug = 'bariatric-surgery-14-12-16'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tbl	const	slug	slug	767	const	1	Using index

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.01 ms
    checking permissions	0.48 ms
    Opening tables	0.09 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    49	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:105
    48	ComDocmanRouter->getDocumentAlias()	JROOT/components/com_docman/router.php:175
    47	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:398
    46	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    45	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    44	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    43	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    42	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    41	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127
    40	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92
    39	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:704
    38	KHttpUrl->__toString()	/tmp/buffer5d37a1dca2e6a744020031:27
    37	include /tmp/buffer5d37a1dca2e6a744020031	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    36	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    35	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    34	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    33	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1fe3326952649:11
    32	include /tmp/buffer5d37a1dca1fe3326952649	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    31	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    30	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    29	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    28	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1546927215277:11
    27	include /tmp/buffer5d37a1dca1546927215277	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    26	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    25	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    24	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    23	KTemplateAbstract->__call()	/tmp/buffer5d37a1dc99a16140373228:31
    22	include /tmp/buffer5d37a1dc99a16140373228	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:211
    19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
    18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:28
    17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
    16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
    15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
    14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:199
    12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
    10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177
    9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:394
    7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
    6	require_once JROOT/components/com_docman/docman.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.]

    ---

16. Query Time: 0.52 ms After last query: 0.13 ms Query memory: 0.040 MB Memory before query: 7.756 MB Rows returned: 1

    SELECT GROUP_CONCAT(c.slug 
      ORDER BY r.level DESC SEPARATOR '/')
                    
      FROM `jos_docman_category_relations` as r
                    
      INNER JOIN `jos_docman_categories` AS c2 
      ON c2.slug = 'freedom-of-information-1'
                    
      LEFT JOIN `jos_docman_categories` AS c 
      ON c.docman_category_id = r.ancestor_id
                    
      WHERE r.descendant_id = c2.docman_category_id
                    
      ORDER BY r.level DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c2	const	PRIMARY,slug	slug	767	const	1	Using index
    1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	norwich_db2.r.ancestor_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    49	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
    48	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
    47	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:398
    46	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    45	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    44	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    43	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    42	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    41	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:127
    40	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:92
    39	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:704
    38	KHttpUrl->__toString()	/tmp/buffer5d37a1dca2e6a744020031:27
    37	include /tmp/buffer5d37a1dca2e6a744020031	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    36	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    35	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    34	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    33	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1fe3326952649:11
    32	include /tmp/buffer5d37a1dca1fe3326952649	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    31	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    30	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    29	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    28	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1546927215277:11
    27	include /tmp/buffer5d37a1dca1546927215277	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    26	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    25	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    24	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    23	KTemplateAbstract->__call()	/tmp/buffer5d37a1dc99a16140373228:31
    22	include /tmp/buffer5d37a1dc99a16140373228	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:211
    19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
    18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:28
    17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
    16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
    15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
    14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:199
    12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
    10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177
    9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:394
    7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
    6	require_once JROOT/components/com_docman/docman.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.]

    ---

17. Query Time: 1.78 ms After last query: 11.88 ms Query memory: 0.051 MB Memory before query: 7.867 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 jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_docman.document' 
      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	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	norwich_db2.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	norwich_db2.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	norwich_db2.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	norwich_db2.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	norwich_db2.a.group_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    49	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    48	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    47	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    46	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    45	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:397
    44	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:317
    43	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
    42	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    41	JEventDispatcher->trigger()	JROOT/libraries/joomlatools/component/koowa/template/helper/event.php:47
    40	ComKoowaTemplateHelperEvent->trigger()	JROOT/libraries/joomlatools/library/template/template.php:290
    39	KTemplate->invoke()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    38	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca2e6a744020031:99
    37	include /tmp/buffer5d37a1dca2e6a744020031	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    36	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    35	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    34	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    33	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1fe3326952649:11
    32	include /tmp/buffer5d37a1dca1fe3326952649	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    31	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    30	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    29	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    28	KTemplateAbstract->__call()	/tmp/buffer5d37a1dca1546927215277:11
    27	include /tmp/buffer5d37a1dca1546927215277	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    26	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    25	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:402
    24	KTemplateEngineKoowa->_import()	JROOT/libraries/joomlatools/library/template/abstract.php:213
    23	KTemplateAbstract->__call()	/tmp/buffer5d37a1dc99a16140373228:31
    22	include /tmp/buffer5d37a1dc99a16140373228	JROOT/libraries/joomlatools/library/template/engine/koowa.php:352
    21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
    20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:211
    19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
    18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:28
    17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
    16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
    15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
    14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:199
    12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
    10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:177
    9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:156
    8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:394
    7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
    6	require_once JROOT/components/com_docman/docman.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.]

    ---

18. Query Time: 0.37 ms After last query: 107.86 ms Query memory: 0.024 MB Memory before query: 8.243 MB Rows returned: 1

    SELECT params 
      FROM jos_extensions AS e 
      WHERE e.element='com_widgetkit'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 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.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 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/administrator/components/com_widgetkit/helpers/system.php:278
    13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->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.]

    ---

19. Query Time: 0.34 ms After last query: 0.93 ms Query memory: 0.023 MB Memory before query: 8.251 MB Rows returned: 1

    SELECT id,template 
      FROM jos_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->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.]

    ---

20. Query Time: 3.72 ms After last query: 133.89 ms Query memory: 0.118 MB Memory before query: 8.689 MB Rows returned: 27

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_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 <= '2019-07-24 00:10:04') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-24 00:10:04') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 241 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    checking permissions	0.47 ms
    Opening tables	3.02 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	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:581
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_master/warp/systems/joomla/helpers/modules.php:49
    11	ModulesWarpHelper->count()	JROOT/templates/yoo_master/layouts/template.config.php:23
    10	include JROOT/templates/yoo_master/layouts/template.config.php	JROOT/templates/yoo_master/layouts/template.php:10
    9	include JROOT/templates/yoo_master/layouts/template.php	JROOT/templates/yoo_master/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_master/index.php:19
    7	require JROOT/templates/yoo_master/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    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.]

    ---

21. Query Time: 0.79 ms After last query: 285.38 ms Query memory: 0.022 MB Memory before query: 9.879 MB Rows returned: 1

    SELECT sleep_until < '2019-07-24 00:10:05' 
      FROM jos_scheduler_metadata 
      WHERE type = 'metadata' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_scheduler_metadata	const	unique_type	unique_type	98	const	1

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	1.77 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 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/joomlatoolsscheduler/joomlatoolsscheduler.php:128
    8	PlgSystemJoomlatoolsscheduler->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167
    6	PlgSystemJoomlatoolsscheduler->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:1050
    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.]

    ---

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2. 2 × SELECT COUNT(*) 
     FROM jos_docman_documents

3. 1 × SELECT `session_id` 
     FROM `jos_session`

4. 1 × SELECT CONCAT_WS('-', tbl.docman_document_id, tbl.slug) AS alias             
     FROM `jos_docman_documents` as tbl

5. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM jos_modules AS m 
     LEFT JOIN jos_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN jos_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

6. 1 × SELECT id,template 
     FROM jos_template_styles

7. 1 × SELECT params 
     FROM jos_extensions AS e

8. 1 × 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 jos_fields AS a 
     LEFT JOIN `jos_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN jos_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN jos_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN jos_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN jos_fields_groups AS g 
     ON g.id = a.group_id

9. 1 × SELECT GROUP_CONCAT(c.slug 
     ORDER BY r.level DESC SEPARATOR '/')                 
     FROM `jos_docman_category_relations` as r                 
     INNER JOIN `jos_docman_categories` AS c2 
     ON c2.slug = 'freedom-of-information-1'                 
     LEFT JOIN `jos_docman_categories` AS c 
     ON c.docman_category_id = r.ancestor_id

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

11. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jos_assets`

12. 1 × SELECT * 
      FROM jos_languages

13. 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 jos_menu AS m 
      LEFT JOIN jos_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jos_extensions

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

16. 1 × SELECT id, rules 
      FROM `jos_viewlevels

17. 1 × SELECT sleep_until < '2019-07-24 00:10:05' 
      FROM jos_scheduler_metadata

OTHER Tables:

1. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('ubgfol7okdg4f3jq43r0gbq4su', 1, 1563927003, 0, '', 0

2. 1 × UPDATE `jos_extensions` 
     SET `params` = '{\"mediaversion\":\"dd29667b8c63af18b077900e323f71cf\"}'