Monthly Schedule

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1731696415,
                "last": 1731696415,
                "now": 1731696415
            },
            "token": "H6GAKZqc9agMcjfVdrHCwbjnallGzzkp"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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": {
                "f3125b510d33f868da3ce314869c87779810a6b5": {
                    "link": "http://bahaimontreal.org/en-ca/calendars/monthly-schedule/week.listevents/2022/04/21/-",
                    "expiry": 1731696415
                }
            }
        }
    }
}

Time

Memory

24 Queries Logged 12.15 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'6330356364333431663663326462653565373031343761613066353433313364'

   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.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 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.01 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 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.26 ms After last query: 0.24 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'6330356364333431663663326462653565373031343761613066353433313364' 
     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.01 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.01 ms
   Updating status	0.07 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.26 ms After last query: 0.06 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'6330356364333431663663326462653565373031343761613066353433313364', 1, 1731696415, 0, '', 0)

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.00 ms
   init for update	0.01 ms
   Update	0.09 ms
   Waiting for query cache lock	0.00 ms
   Update	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
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.02 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 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.26 ms After last query: 0.62 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.03 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.06 ms
   End of update loop	0.01 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.01 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.28 ms After last query: 0.07 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.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 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.01 ms
   Query end	0.01 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.01 ms
   Updating status	0.01 ms
   Reset for next command	0.02 ms

   Call Stack

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

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

   ---

6. Query Time: 0.52 ms After last query: 8.27 ms Query memory: 0.006 MB Memory before query: 2.415 MB

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.16 ms
   Updating	0.06 ms
   End of update loop	0.01 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.01 ms
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 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: 1.01 ms After last query: 4.95 ms Query memory: 0.010 MB Memory before query: 2.981 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.10 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.07 ms
   Optimizing	0.01 ms
   Statistics	0.16 ms
   Preparing	0.04 ms
   Executing	0.00 ms
   Sending data	0.34 ms
   End of update loop	0.01 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.01 ms
   Updating status	0.02 ms
   Reset for next command	0.06 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/week.php:59
   8	WeekController->listevents()	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.79 ms After last query: 1.00 ms Query memory: 0.012 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.05 ms
   checking permissions	0.01 ms
   closing tables	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.27 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 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.03 ms
   After opening tables	0.00 ms
   checking permissions	0.09 ms
   closing tables	0.01 ms
   checking permissions	0.01 ms
   Executing	0.00 ms
   Sending data	0.06 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.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
   24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
   23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
   22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
   21	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
   20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
   19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
   17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
   15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:4
   13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
   12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
   8	WeekController->listevents()	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: 1.31 ms After last query: 0.98 ms Query memory: 0.014 MB Memory before query: 3.281 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.01 ms
   Opening tables	0.05 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.13 ms
   Preparing	0.03 ms
   Creating tmp table	0.11 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.26 ms
   Creating sort index	0.06 ms
   Removing tmp table	0.13 ms
   Creating sort index	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.06 ms
   Starting cleanup	0.00 ms
   Freeing items	0.03 ms
   Updating status	0.02 ms
   Reset for next command	0.04 ms

   Call Stack

   #	Caller	File and line number
   29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
   27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
   26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
   25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
   24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
   23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
   22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
   19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
   17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
   15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:4
   13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
   12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
   8	WeekController->listevents()	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.77 ms After last query: 3.82 ms Query memory: 0.014 MB Memory before query: 3.491 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.06 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.25 ms
    After opening tables	0.02 ms
    System lock	0.00 ms
    table lock	0.01 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.07 ms
    closing tables	0.01 ms
    checking permissions	0.00 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
    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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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:448
    28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
    25	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1851
    24	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1706
    23	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:86
    22	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3008
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3358
    18	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:682
    17	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:9
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.68 ms After last query: 0.52 ms Query memory: 0.014 MB Memory before query: 3.550 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.16 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.10 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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
    26	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:422
    24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3008
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3358
    18	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:682
    17	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:9
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.15 ms Query memory: 0.013 MB Memory before query: 3.583 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.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.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    25	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:558
    24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1021
    23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:186
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3008
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3358
    18	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:682
    17	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:9
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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: 1.30 ms After last query: 0.25 ms Query memory: 0.011 MB Memory before query: 3.604 MB Rows returned: 1

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM ux026_jevents_repetition as rpt
     
      INNER JOIN ux026_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN ux026_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN ux026_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN ux026_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,34,64)
     
      AND rpt.endrepeat >= '2022-04-17 00:00:00' 
      AND rpt.startrepeat <= '2022-04-23 23:59:59'
     
      AND NOT (rpt.startrepeat < '2022-04-17 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1
     
      AND ev.access IN (1,1)  
      AND icsf.state=1 
      AND icsf.access IN (1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	ev	ALL	PRIMARY,icsid,stateidx,evaccess	NO INDEX KEY COULD BE USED	NULL	NULL	42	Using where
    1	SIMPLE	rpt	ref|filter	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid|startend	4|5	petitsv_jooMont.ev.ev_id	108 (8%)	Using where; Using rowid filter
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	petitsv_jooMont.rpt.eventdetail_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	petitsv_jooMont.ev.ev_id	1

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.61 ms
    End of update loop	0.01 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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.06 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3300
    20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3231
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3358
    18	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:682
    17	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:9
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

14. Query Time: 0.29 ms After last query: 0.19 ms Query memory: 0.012 MB Memory before query: 3.663 MB Rows returned: 0

    SELECT *, summary as title, description as content 
      FROM ux026_jevents_translation 
      WHERE evdet_id IN(44) 
      AND language='en-CA'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_jevents_translation	ref	evdet_id,langdetail	evdet_id	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.04 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
    Commit	0.01 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.00 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:776
    21	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3338
    20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3231
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3358
    18	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:682
    17	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:9
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

15. Query Time: 0.36 ms After last query: 0.61 ms Query memory: 0.011 MB Memory before query: 3.749 MB Rows returned: 7

    SELECT c.* 
      FROM ux026_categories as c 
      WHERE 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	cat_idx	202	const	7	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 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.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.13 ms
    End of update loop	0.01 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.00 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:191
    19	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:144
    18	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:614
    17	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:50
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

16. Query Time: 0.26 ms After last query: 0.23 ms Query memory: 0.011 MB Memory before query: 3.789 MB Rows returned: 2

    SELECT a.id, a.parent_id
    
      FROM ux026_categories AS a
    
      WHERE a.parent_id > 0 
      AND a.extension = "com_jevents" 
      AND a.published = 1 
      AND a.language in ('en-CA','*')
    
      ORDER BY a.lft

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 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.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.04 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:52
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

17. Query Time: 0.30 ms After last query: 0.03 ms Query memory: 0.011 MB Memory before query: 3.803 MB Rows returned: 0

    SELECT * 
      FROM ux026_jev_defaults 
      WHERE state=1 
      AND name= 'icalevent.list_row' 
      AND value<>'' 
      AND language in ('en-CA','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ux026_jev_defaults	ref	name,langcodename	name	152	const	12	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.02 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.04 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.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:52
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

18. Query Time: 0.24 ms After last query: 0.41 ms Query memory: 0.012 MB Memory before query: 3.827 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `ux026_menu` AS `c`
    
      INNER JOIN `ux026_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `ux026_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `ux026_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 410

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 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.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	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/Language/Associations.php:115
    21	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    20	MenusHelper::getAssociations()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292
    19	jIcalEventRepeat->viewDetailLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:567
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:52
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

19. Query Time: 0.39 ms After last query: 0.83 ms Query memory: 0.012 MB Memory before query: 3.902 MB Rows returned: 7

    SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
      FROM ux026_categories  as cat 
      LEFT JOIN ux026_categories as pcat 
      on pcat.id=cat.parent_id 
      WHERE cat.extension='com_jevents' 
      ORDER BY cat.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cat	ref	cat_idx	cat_idx	202	const	7	Using index condition; Using where; Using filesort
    1	SIMPLE	pcat	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.cat.parent_id	1	Using where

    Profile

    Status	Duration
    Starting	0.04 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.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 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/components/com_jevents/libraries/jeventcal.php:523
    22	jEventCal->getCategoryData()	JROOT/components/com_jevents/libraries/jeventcal.php:478
    21	jEventCal->getCategoryName()	JROOT/components/com_jevents/libraries/jicaleventdb.php:683
    20	jIcalEventDB->getCategoryName()	JROOT/components/com_jevents/libraries/jeventcal.php:468
    19	jEventCal->catname()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:659
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:52
    16	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/week/tmpl/listevents.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/week.php:77
    8	WeekController->listevents()	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.]

    ---

20. Query Time: 0.35 ms After last query: 1.40 ms Query memory: 0.005 MB Memory before query: 3.867 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.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.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.09 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 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.]

    ---

21. Query Time: 0.22 ms After last query: 0.93 ms Query memory: 0.006 MB Memory before query: 3.914 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.02 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.03 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.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 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.]

    ---

22. Query Time: 0.38 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 3.922 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.02 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.00 ms
    Updating status	0.12 ms
    Reset for next command	0.02 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.]

    ---

23. Query Time: 0.78 ms After last query: 2.92 ms Query memory: 0.007 MB Memory before query: 4.019 MB Rows returned: 1
    Duplicate queries: #24

    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.05 ms
    checking permissions	0.01 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.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.15 ms
    End of update loop	0.01 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.01 ms
    Updating status	0.02 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.]

    ---

24. Query Time: 0.46 ms After last query: 1.79 ms Query memory: 0.006 MB Memory before query: 4.244 MB Rows returned: 1
    Duplicate queries: #23

    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.05 ms
    checking permissions	0.01 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.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 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.01 ms
    Updating status	0.02 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.]

    ---

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT menutype  
     FROM  ux026_menu

2. 1 × SELECT c.* 
     FROM ux026_categories as c

3. 1 × SELECT * 
     FROM ux026_menu

4. 1 × SELECT * 
     FROM ux026_template_styles

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

6. 1 × SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
     FROM ux026_categories  as cat 
     LEFT JOIN ux026_categories as pcat 
     on pcat.id=cat.parent_id

7. 1 × SELECT `c2`.`language`,`c2`.`id` 
     FROM `ux026_menu` AS `c` 
     INNER JOIN `ux026_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item' 
     INNER JOIN `ux026_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key` 
     INNER JOIN `ux026_menu` AS `c2` 
     ON a2.id = c2.`id`

8. 1 × SELECT * 
     FROM ux026_jev_defaults

9. 1 × SELECT a.id, a.parent_id 
     FROM ux026_categories AS a

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

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

12. 1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
      FROM ux026_jevents_repetition as rpt  
      INNER JOIN ux026_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id  
      INNER JOIN ux026_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid   
      INNER JOIN ux026_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id  
      LEFT JOIN ux026_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid

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

14. 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`

15. 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

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

17. 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

18. 1 × SELECT id, rules 
      FROM `ux026_viewlevels

19. 1 × SELECT *, summary as title, description as content 
      FROM ux026_jevents_translation

OTHER Tables:

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

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

3. 1 × SHOW FULL COLUMNS 
     FROM `ux026_content

4. 1 × SHOW FULL COLUMNS 
     FROM `ux026_jev_users