Monthly Schedule

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732260270,
                "last": 1732260270,
                "now": 1732260270
            },
            "token": "vvNOI8rEwXJ2607bNUmE4b0RPWnz1K2N"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-CA"
        },
        "com_mailto": {
            "links": {
                "be2fbd1d1ec94ff6cdd020f934fa373ffc053f70": {
                    "link": "http://bahaimontreal.org/en-ca/calendars/monthly-schedule/search.form/2024/11/22/-",
                    "expiry": 1732260270
                }
            }
        }
    }
}

Time

Memory

17 Queries Logged 7.59 ms

1. Query Time: 0.30 ms Query memory: 0.007 MB Memory before query: 0.990 MB Rows returned: 0

   SELECT `data`
   
     FROM `ux026_session`
   
     WHERE `session_id` = X'6461613036653737376564366639373165633638613435336330306535643231'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ux026_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.02 ms
   Reset for next command	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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.22 ms After last query: 0.19 ms Query memory: 0.004 MB Memory before query: 1.004 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ux026_session`
   
     WHERE `session_id` = X'6461613036653737376564366639373165633638613435336330306535643231' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.00 ms
   Executing	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.04 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.28 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 1.009 MB

   INSERT INTO `ux026_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6461613036653737376564366639373165633638613435336330306535643231', 1, 1732260270, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ux026_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6461613036653737376564366639373165633638613435336330306535643231', 1, 1732260270, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.01 ms
   Update	0.07 ms
   Waiting for query cache lock	0.00 ms
   Update	0.00 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.03 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.00 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.27 ms After last query: 0.54 ms Query memory: 0.005 MB Memory before query: 1.099 MB Rows returned: 3

   SELECT id, rules
   
     FROM `ux026_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.02 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.33 ms After last query: 0.05 ms Query memory: 0.005 MB Memory before query: 1.111 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.06 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.04 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.46 ms After last query: 8.19 ms Query memory: 0.006 MB Memory before query: 2.686 MB

   UPDATE `ux026_extensions`
   
     SET `params` = '{\"mediaversion\":\"4efeabd36f054e60ef96b07e397ce399\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.14 ms
   Updating	0.05 ms
   End of update loop	0.00 ms
   Waiting for query cache lock	0.00 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.04 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
   8	plgSystemK2->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:1190
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.72 ms After last query: 3.93 ms Query memory: 0.010 MB Memory before query: 2.980 MB Rows returned: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `ux026_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_jevents','com_joomlaupdate','com_k2','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_search','com_tags','com_templates','com_users','com_vertexupdate','com_weblinks','com_wrapper','com_zhgooglemap')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ux026_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	Using index condition

   Profile

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.01 ms
   Statistics	0.09 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.31 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.06 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   17	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1428
   16	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1386
   15	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:50
   14	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:65
   13	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/geraint/abstract/abstract.php:32
   12	JEventsGeraintView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
   11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
   10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
   9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_jevents/controllers/search.php:72
   8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
   6	require_once JROOT/components/com_jevents/jevents.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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.77 ms After last query: 0.96 ms Query memory: 0.011 MB Memory before query: 3.155 MB Rows returned: 31

   SHOW FULL COLUMNS 
     FROM `ux026_content`

   Explain

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

   Profile

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.00 ms
   closing tables	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.22 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Filling schema table	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   checking permissions	0.09 ms
   closing tables	0.00 ms
   checking permissions	0.00 ms
   Executing	0.00 ms
   Sending data	0.05 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Removing tmp table	0.07 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.05 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
   23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
   22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
   21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
   20	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
   19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
   18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
   16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
   14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/search/tmpl/form.php:4
   12	include JROOT/components/com_jevents/views/geraint/search/tmpl/form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
   11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
   10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
   9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/search.php:92
   8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
   6	require_once JROOT/components/com_jevents/jevents.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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.97 ms After last query: 0.85 ms Query memory: 0.013 MB Memory before query: 3.279 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 ux026_fields AS a
   
     LEFT JOIN `ux026_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN ux026_users AS uc 
     ON uc.id=a.checked_out
   
     LEFT JOIN ux026_viewlevels AS ag 
     ON ag.id = a.access
   
     LEFT JOIN ux026_users AS ua 
     ON ua.id = a.created_user_id
   
     LEFT JOIN ux026_fields_groups AS g 
     ON g.id = a.group_id
   
     WHERE a.context = 'com_content.article' 
     AND a.access IN (1,1) 
     AND (a.group_id = 0 OR g.access IN (1,1)) 
     AND a.state = 1 
     AND (a.group_id = 0 OR g.state = 1)
   
     ORDER BY a.ordering ASC

   Explain

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

   Profile

   Status	Duration
   Starting	0.12 ms
   checking permissions	0.00 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.12 ms
   Preparing	0.03 ms
   Creating tmp table	0.05 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.22 ms
   Creating sort index	0.03 ms
   Removing tmp table	0.10 ms
   Creating sort index	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.05 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
   26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
   25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
   24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
   23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
   22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
   21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
   18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
   16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
   14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/search/tmpl/form.php:4
   12	include JROOT/components/com_jevents/views/geraint/search/tmpl/form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
   11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
   10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
   9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/search.php:92
   8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
   6	require_once JROOT/components/com_jevents/jevents.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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.56 ms After last query: 3.05 ms Query memory: 0.010 MB Memory before query: 3.466 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `ux026_jev_users`

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.15 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.06 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.05 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
    17	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1851
    16	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1706
    15	JEVHelper::isEventCreator()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperviewnavadminpanel.php:26
    14	DefaultViewHelperViewNavAdminPanel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/search/tmpl/form.php:7
    12	include JROOT/components/com_jevents/views/geraint/search/tmpl/form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/search.php:92
    8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.51 ms After last query: 0.52 ms Query memory: 0.011 MB Memory before query: 3.529 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ux026_categories` AS `c`
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND c.language IN ('en-CA','*')
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.08 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    22	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
    21	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:422
    19	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    18	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    17	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    16	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    15	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperviewnavadminpanel.php:34
    14	DefaultViewHelperViewNavAdminPanel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/search/tmpl/form.php:7
    12	include JROOT/components/com_jevents/views/geraint/search/tmpl/form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/search.php:92
    8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.38 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 3.558 MB Rows returned: 2

    SELECT c.id
    
      FROM ux026_categories AS c
    
      WHERE c.access   IN (1,1)
     
      AND c.published = 1
      
      AND c.language in ('en-CA','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	cat_idx,idx_access,idx_language	cat_idx	207	const,const,const	3	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    20	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:558
    19	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    18	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    17	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    16	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    15	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperviewnavadminpanel.php:34
    14	DefaultViewHelperViewNavAdminPanel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/search/tmpl/form.php:7
    12	include JROOT/components/com_jevents/views/geraint/search/tmpl/form.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:133
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/search.php:92
    8	SearchController->search()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
    6	require_once JROOT/components/com_jevents/jevents.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.39 ms After last query: 0.69 ms Query memory: 0.005 MB Memory before query: 3.521 MB Rows returned: 3

    SELECT language,id
    
      FROM `ux026_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	154	Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.13 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.26 ms After last query: 0.75 ms Query memory: 0.006 MB Memory before query: 3.569 MB Rows returned: 1

    SELECT * 
      FROM ux026_template_styles 
      WHERE template = 'oasis';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_template_styles	ref	idx_template	idx_template	202	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:20
    9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:169
    8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:33
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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.29 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 3.576 MB Rows returned: 0

    SELECT * 
      FROM ux026_menu 
      WHERE template_style_id IN (13) 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:45
    9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:169
    8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:33
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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.55 ms After last query: 2.47 ms Query memory: 0.007 MB Memory before query: 3.673 MB Rows returned: 1
    Duplicate queries: #17

    SELECT menutype  
      FROM  ux026_menu 
      WHERE language = 'en-CA' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_menu	ref	idx_language	idx_language	28	const	12	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.11 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:284
    10	include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:169
    9	require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12
    8	require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php	JROOT/templates/oasis/index.php:276
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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.34 ms After last query: 1.13 ms Query memory: 0.006 MB Memory before query: 3.903 MB Rows returned: 1
    Duplicate queries: #16

    SELECT menutype  
      FROM  ux026_menu 
      WHERE language = 'en-CA' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_menu	ref	idx_language	idx_language	28	const	12	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.11 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/s5flex_menu/default.php:89
    8	include JROOT/templates/oasis/vertex/s5flex_menu/default.php	JROOT/templates/oasis/index.php:300
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT menutype  
     FROM  ux026_menu

2. 1 × SELECT `data` 
     FROM `ux026_session`

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

4. 1 × SELECT id, rules 
     FROM `ux026_viewlevels

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

6. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `ux026_assets`

7. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
     FROM ux026_fields AS a 
     LEFT JOIN `ux026_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN ux026_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN ux026_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN ux026_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN ux026_fields_groups AS g 
     ON g.id = a.group_id

8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM `ux026_categories` AS `c`

9. 1 × SELECT c.id 
     FROM ux026_categories AS c

10. 1 × SELECT language,id 
      FROM `ux026_menu`

11. 1 × SELECT * 
      FROM ux026_template_styles

12. 1 × SELECT * 
      FROM ux026_menu

OTHER Tables:

1. 1 × INSERT INTO `ux026_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'6461613036653737376564366639373165633638613435336330306535643231', 1, 1732260270, 0, '', 0

2. 1 × UPDATE `ux026_extensions` 
     SET `params` = '{\"mediaversion\":\"4efeabd36f054e60ef96b07e397ce399\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `ux026_content

4. 1 × SHOW FULL COLUMNS 
     FROM `ux026_jev_users