{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566185290,
                "last": 1566185290,
                "now": 1566185290
            },
            "token": "5yJmrae3vvmpAv6E0TzszGmnLQPqukTI"
        },
        "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
        }
    }
}

Time

Memory

35 Queries Logged 58.14 ms

1. Query Time: 0.22 ms Query memory: 0.025 MB Memory before query: 3.571 MB Rows returned: 0

   SELECT `data`
   
     FROM `jomos_session`
   
     WHERE `session_id` = '8b296f74147b8744a56bb05e9dbe2d79'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   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: 0.14 ms After last query: 0.99 ms Query memory: 0.022 MB Memory before query: 3.736 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jomos_session`
   
     WHERE `session_id` = '8b296f74147b8744a56bb05e9dbe2d79' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 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: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: 35.50 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 3.742 MB

   INSERT INTO `jomos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('8b296f74147b8744a56bb05e9dbe2d79', 1, 1566185290, 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `jomos_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('8b296f74147b8744a56bb05e9dbe2d79', 1, 1566185290, 0, '')

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.04 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	35.25 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.33 ms After last query: 2.28 ms Query memory: 0.030 MB Memory before query: 3.954 MB Rows returned: 38

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

   Explain

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

   Profile

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

   ---

5. Query Time: 0.18 ms After last query: 1.70 ms Query memory: 0.023 MB Memory before query: 4.152 MB Rows returned: 5

   SELECT id, rules
   
     FROM `jomos_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.]

   ---

6. Query Time: 0.22 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.163 MB Rows returned: 2

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

   Explain

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

   Profile

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

   ---

7. Query Time: 0.50 ms After last query: 0.47 ms Query memory: 0.034 MB Memory before query: 4.230 MB Rows returned: 99

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

   Explain

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

   Profile

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

   Call Stack

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

   ---

8. Query Time: 0.28 ms After last query: 20.99 ms Query memory: 0.027 MB Memory before query: 6.149 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jomos_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
   16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Container.php:240
   15	YOOtheme\Widgetkit\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
   14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
   13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113
   12	YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:149
   11	YOOtheme\Widgetkit\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:92
   10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
   9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
   8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.44 ms After last query: 8.01 ms Query memory: 0.042 MB Memory before query: 6.823 MB Rows returned: 24

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	27	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomlaOS.m.component_id	1	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	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.]

   ---

10. Query Time: 0.36 ms After last query: 6.67 ms Query memory: 0.033 MB Memory before query: 7.499 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	NULL
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomlaOS.s.template,const	1	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yootheme/yootheme.php:136
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.]

    ---

11. Query Time: 0.26 ms After last query: 16.55 ms Query memory: 0.031 MB Memory before query: 9.540 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    29	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    28	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    27	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    26	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    25	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    24	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    23	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    20	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla.php:54
    19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/index.php:113
    15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.]

    ---

12. Query Time: 12.34 ms After last query: 0.12 ms Query memory: 0.011 MB Memory before query: 9.536 MB

    UPDATE `jomos_extensions`
    
      SET `params` = '{\"mediaversion\":\"5d799d56662a4266e87be2edc5e7e1d4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.03 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	12.14 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    24	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    23	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    20	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla.php:54
    19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/index.php:113
    15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.]

    ---

13. Query Time: 0.20 ms After last query: 2.63 ms Query memory: 0.033 MB Memory before query: 9.814 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    25	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    24	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla.php:90
    23	YOOtheme\Theme\Joomla->onSite()	Same as call in the line below.
    22	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    21	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    20	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla.php:76
    19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/index.php:113
    15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.]

    ---

14. Query Time: 0.21 ms After last query: 35.62 ms Query memory: 0.025 MB Memory before query: 13.192 MB Rows returned: 1

    SELECT * 
      FROM jomos_zoo_application 
      WHERE id = 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
    9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.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.22 ms After last query: 5.58 ms Query memory: 0.031 MB Memory before query: 13.824 MB Rows returned: 1

    SELECT * 
      FROM jomos_zoo_item 
      WHERE id = 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jomos_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    15	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    14	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    13	AppTable->get()	JROOT/components/com_zoo/controllers/default.php:103
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.43 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 13.856 MB Rows returned: 38

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    14	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    13	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.16 ms After last query: 2.66 ms Query memory: 0.008 MB Memory before query: 14.088 MB

    UPDATE jomos_zoo_item 
      SET hits = (hits + 1) 
      WHERE id = 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jomos_zoo_item	range	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.02 ms
    updating	0.03 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
    14	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:670
    13	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.12 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 14.096 MB Rows returned: 1

    SELECT id 
      FROM jomos_users 
      WHERE id = 910

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
    15	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:44
    14	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
    13	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

19. Query Time: 0.43 ms After last query: 1.68 ms Query memory: 0.034 MB Memory before query: 14.306 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `jomos_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    22	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    21	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    20	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    15	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
    14	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
    13	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

20. Query Time: 0.13 ms After last query: 0.51 ms Query memory: 0.031 MB Memory before query: 14.426 MB Rows returned: 1

    SELECT *
    
      FROM `jomos_users`
    
      WHERE `id` = 910

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    15	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
    14	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
    13	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

21. Query Time: 0.19 ms After last query: 2.01 ms Query memory: 0.028 MB Memory before query: 15.175 MB Rows returned: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `jomos_usergroups` AS g
    
      INNER JOIN `jomos_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 910

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	joomlaOS.m.group_id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    15	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
    14	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
    13	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

22. Query Time: 0.20 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 15.184 MB Rows returned: 2

    SELECT b.id
    
      FROM jomos_user_usergroup_map AS map
    
      LEFT JOIN jomos_usergroups AS a 
      ON a.id = map.group_id
    
      LEFT JOIN jomos_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE map.user_id = 910

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	joomlaOS.map.group_id	1	100.00	NULL
    1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Range checked for each record (index map: 0x10)

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
    18	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
    17	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
    16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    15	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    14	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
    13	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

23. Query Time: 0.30 ms After last query: 14.27 ms Query memory: 0.031 MB Memory before query: 15.477 MB Rows returned: 7

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jomos_assets`
    
      WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    25	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    24	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    23	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    22	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    21	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
    20	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
    19	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
    18	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
    17	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
    16	Item->canEdit()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:11
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

24. Query Time: 0.38 ms After last query: 11.92 ms Query memory: 0.034 MB Memory before query: 15.706 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `jomos_assets`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    26	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    25	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
    24	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    23	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    22	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    21	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
    20	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
    19	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
    18	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
    17	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
    16	Item->canEdit()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:11
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

25. Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.031 MB Memory before query: 15.737 MB Rows returned: 0
    Duplicate queries: #26

    SELECT *
    
      FROM jomos_assets
    
      WHERE `name` = 'com_zoo.application.1.joomla.extensions'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    25	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    24	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    23	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    22	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    21	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
    20	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
    19	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
    18	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
    17	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
    16	Item->canEdit()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:11
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

26. Query Time: 0.14 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 15.751 MB Rows returned: 0
    Duplicate queries: #25

    SELECT *
    
      FROM jomos_assets
    
      WHERE `name` = 'com_zoo.application.1.joomla.extensions'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    24	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    23	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    22	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    21	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    20	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
    19	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
    18	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
    17	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
    16	Item->canEdit()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:11
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

27. Query Time: 0.52 ms After last query: 46.78 ms Query memory: 0.075 MB Memory before query: 16.220 MB Rows returned: 38

    SELECT id, title, module, position, content, showtitle, params, published 
      FROM jomos_modules AS m 
      LEFT JOIN jomos_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE m.access IN (1,5) 
      AND published = 1 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-08-19 03:28:10') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-08-19 03:28:10') 
      AND m.client_id = 0 
      ORDER BY position, ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	published	published	1	const	33	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomlaOS.m.id	1	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
    23	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:355
    22	DatabaseHelper->__call()	JROOT/administrator/components/com_zoo/helpers/module.php:57
    21	ModuleHelper->load()	JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:27
    20	ElementJoomlamodule->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
    19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/projects/templates/uikit3/renderer/item/full.php:25
    18	include JROOT/media/zoo/applications/projects/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
    16	ItemRenderer->render()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:22
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

28. Query Time: 0.57 ms After last query: 6.40 ms Query memory: 0.045 MB Memory before query: 16.929 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 jomos_fields AS a
    
      LEFT JOIN `jomos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jomos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jomos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jomos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jomos_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_zoo.element.textarea' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    34	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    33	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    32	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    31	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    30	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    28	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    27	JHtmlContent::prepare()	Same as call in the line below.
    26	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    25	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    24	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
    23	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
    22	ElementTextarea->render()	JROOT/media/zoo/applications/projects/templates/uikit3/renderer/element/uikit_block.php:20
    21	include JROOT/media/zoo/applications/projects/templates/uikit3/renderer/element/uikit_block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
    19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/projects/templates/uikit3/renderer/item/full.php:25
    18	include JROOT/media/zoo/applications/projects/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
    16	ItemRenderer->render()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:22
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

29. Query Time: 0.25 ms After last query: 4.96 ms Query memory: 0.031 MB Memory before query: 17.232 MB Rows returned: 0

    SELECT * 
      FROM jomos_zoo_comment 
      WHERE item_id = 9 
      AND (state = 1 OR (author = '' 
      AND email = '' 
      AND user_id = '' 
      AND user_type = '')) 
      ORDER BY created ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jomos_zoo_comment	ref	STATE_INDEX,ITEMID_INDEX,AUTHOR_INDEX,ITEMID_STATE_INDEX	ITEMID_INDEX	4	const	1	100.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    23	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    22	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    21	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    20	AppTable->all()	JROOT/administrator/components/com_zoo/tables/comment.php:94
    19	CommentTable->getCommentsForItem()	JROOT/administrator/components/com_zoo/classes/item.php:681
    18	Item->getComments()	JROOT/administrator/components/com_zoo/classes/item.php:692
    17	Item->getCommentTree()	JROOT/administrator/components/com_zoo/helpers/comment.php:75
    16	CommentHelper->renderComments()	JROOT/media/zoo/applications/projects/templates/uikit3/item.php:23
    15	include JROOT/media/zoo/applications/projects/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
    12	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

30. Query Time: 0.72 ms After last query: 3.67 ms Query memory: 0.066 MB Memory before query: 17.610 MB Rows returned: 29

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jomos_modules AS m
    
      LEFT JOIN jomos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jomos_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-08-19 03:28:10') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-19 03:28:10') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 126 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    38	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    37	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    36	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    35	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    34	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    33	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    32	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/Modules.php:161
    31	YOOtheme\Theme\Modules->countModules()	Same as call in the line below.
    30	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74
    29	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:53
    28	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252
    27	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
    26	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    25	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:153
    24	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    23	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla/UrlListener.php:32
    22	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    21	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
    20	YOOtheme\View->render()	JROOT/templates/yootheme/templates/header.php:86
    19	require JROOT/templates/yootheme/templates/header.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252
    18	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
    17	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    16	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:153
    15	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/Joomla/UrlListener.php:32
    13	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
    11	YOOtheme\View->render()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:132
    7	require JROOT/templates/yootheme/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.]

    ---

31. Query Time: 0.64 ms After last query: 10.12 ms Query memory: 0.038 MB Memory before query: 17.924 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 jomos_fields AS a
    
      LEFT JOIN `jomos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jomos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jomos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jomos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jomos_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

32. Query Time: 0.24 ms After last query: 1.95 ms Query memory: 0.031 MB Memory before query: 17.985 MB Rows returned: 1

    SELECT * 
      FROM jomos_widgetkit 
      WHERE id = "1"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/Database.php:35
    27	YOOtheme\Widgetkit\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Database/Database.php:88
    26	YOOtheme\Widgetkit\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
    25	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
    24	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:144
    23	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/plugins/content/widgetkit/widgetkit.php:14
    22	plgContentWidgetkit->{closure}()	Same as call in the line below.
    21	call_user_func()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:33
    20	YOOtheme\Widgetkit\Helper\Shortcode->YOOtheme\Widgetkit\Helper\{closure}()	Same as call in the line below.
    19	preg_replace_callback()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:35
    18	YOOtheme\Widgetkit\Helper\Shortcode->parse()	JROOT/plugins/content/widgetkit/widgetkit.php:15
    17	plgContentWidgetkit->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.26 ms After last query: 3.01 ms Query memory: 0.038 MB Memory before query: 18.131 MB Rows returned: 7

    SELECT * 
      FROM jomos_zoo_category 
      WHERE application_id = 1 
      AND published = 1 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jomos_zoo_category	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	7	100.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    35	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    34	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    33	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    32	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    31	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:222
    30	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
    29	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
    28	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/module.php:111
    27	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
    26	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
    25	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
    24	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:156
    23	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/plugins/content/widgetkit/widgetkit.php:14
    22	plgContentWidgetkit->{closure}()	Same as call in the line below.
    21	call_user_func()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:33
    20	YOOtheme\Widgetkit\Helper\Shortcode->YOOtheme\Widgetkit\Helper\{closure}()	Same as call in the line below.
    19	preg_replace_callback()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:35
    18	YOOtheme\Widgetkit\Helper\Shortcode->parse()	JROOT/plugins/content/widgetkit/widgetkit.php:15
    17	plgContentWidgetkit->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.58 ms After last query: 0.21 ms Query memory: 0.044 MB Memory before query: 18.167 MB Rows returned: 3

    SELECT a.* 
      FROM jomos_zoo_item AS a 
      LEFT JOIN jomos_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-19 03:28:10') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-19 03:28:10') 
      AND b.category_id  IN (6,5,3,13,4) 
      GROUP BY a.id 
      ORDER BY RAND() 
      LIMIT 0,4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	range	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	NULL	7	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	joomlaOS.b.item_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    30	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    29	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
    28	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
    27	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
    26	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
    25	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
    24	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:156
    23	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/plugins/content/widgetkit/widgetkit.php:14
    22	plgContentWidgetkit->{closure}()	Same as call in the line below.
    21	call_user_func()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:33
    20	YOOtheme\Widgetkit\Helper\Shortcode->YOOtheme\Widgetkit\Helper\{closure}()	Same as call in the line below.
    19	preg_replace_callback()	JROOT/administrator/components/com_widgetkit/src/Helper/Shortcode.php:35
    18	YOOtheme\Widgetkit\Helper\Shortcode->parse()	JROOT/plugins/content/widgetkit/widgetkit.php:15
    17	plgContentWidgetkit->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.27 ms After last query: 18.58 ms Query memory: 0.027 MB Memory before query: 18.450 MB Rows returned: 1

    SELECT * 
      FROM jomos_widgetkit 
      WHERE id = "5"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/Database.php:35
    16	YOOtheme\Widgetkit\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Database/Database.php:88
    15	YOOtheme\Widgetkit\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
    14	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
    13	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:144
    12	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
    11	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
    10	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---