7th annual Aberdeen Curling Club Broom Snapper Bonspiel

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1782267740,
                "last": 1782267740,
                "now": 1782267740
            },
            "token": "8XmQsGnrLRL7tzbWxhXCPwLTwwIGBxAt"
        },
        "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
        },
        "eb_device_type": "desktop"
    }
}

Time

Memory

25 Queries Logged 10.04 ms

1. Query Time: 0.32 ms Query memory: 0.020 MB Memory before query: 4.245 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ixn1e_session`
   
     WHERE `session_id` = X'3765326436623437636465623834656339633434333338626435656133323030' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 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	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 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
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1741
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.82 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 4.250 MB

   INSERT INTO `ixn1e_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3765326436623437636465623834656339633434333338626435656133323030', 1, 1782267740, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ixn1e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3765326436623437636465623834656339633434333338626435656133323030', 1, 1782267740, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.01 ms
   Update	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.53 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 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
   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.]

   ---

3. Query Time: 0.28 ms After last query: 2.75 ms Query memory: 0.021 MB Memory before query: 4.817 MB Rows returned: 6

   SELECT id, rules
   
     FROM `ixn1e_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

4. Query Time: 0.33 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.829 MB Rows returned: 2

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.03 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

5. Query Time: 0.38 ms After last query: 24.00 ms Query memory: 0.021 MB Memory before query: 10.018 MB Rows returned: 1

   SELECT `template`
   
     FROM `ixn1e_template_styles`
   
     WHERE `client_id` = 0 
     AND `home` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ixn1e_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

   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.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1663
   10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
   9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
   8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.31 ms After last query: 8.11 ms Query memory: 0.021 MB Memory before query: 11.512 MB Rows returned: 1

   SELECT `query`
   
     FROM ixn1e_eb_urls
   
     WHERE md5_key = 'a474ec7aa2a06d4e338eb94a0c5c1d64'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ixn1e_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using index condition

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 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:1741
   10	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:528
   9	EventbookingRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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.84 ms After last query: 1.57 ms Query memory: 0.005 MB Memory before query: 11.698 MB

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.04 ms
   Updating	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.54 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.38 ms After last query: 8.49 ms Query memory: 0.061 MB Memory before query: 14.699 MB Rows returned: 417

   SELECT `config_key`,`config_value`
   
     FROM ixn1e_eb_configs

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.01 ms
   Sending data	0.11 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
   12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:42
   11	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:887
   10	EventbookingHelper::getConfig()	JROOT/components/com_eventbooking/controller/display.php:21
   9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:31
   8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
   7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
   6	require_once JROOT/components/com_eventbooking/eventbooking.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.26 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 14.777 MB Rows returned: 1

   SELECT *
   
     FROM ixn1e_eb_themes
   
     WHERE published = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ixn1e_eb_themes	system	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	1

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1663
   11	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:1130
   10	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/display.php:58
   9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:31
   8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
   7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
   6	require_once JROOT/components/com_eventbooking/eventbooking.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.59 ms After last query: 9.79 ms Query memory: 0.028 MB Memory before query: 15.770 MB Rows returned: 15

    SHOW FULL COLUMNS 
      FROM `ixn1e_eb_ticket_types`

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.17 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.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.04 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.05 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/plugins/eventbooking/tickettypes/tickettypes.php:52
    17	plgEventBookingTicketTypes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    16	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    15	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/admin.php:194
    14	RADModelAdmin->__construct()	JROOT/administrator/components/com_eventbooking/model/common/event.php:50
    13	EventbookingModelCommonEvent->__construct()	JROOT/components/com_eventbooking/model/event.php:24
    12	EventbookingModelEvent->__construct()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:150
    11	RADModel::getInstance()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:385
    10	RADController->getModel()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:330
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.65 ms After last query: 0.24 ms Query memory: 0.082 MB Memory before query: 15.803 MB Rows returned: 1

    SELECT a.*,DATEDIFF(event_date, '2026-06-23 22:22:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2026-06-23 22:22:20') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-06-23 22:22:20') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-06-23 22:22:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-06-23 22:22:20') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-06-23 22:22:20', early_bird_discount_date) AS date_diff,(IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate
    
      FROM ixn1e_eb_events AS a
    
      LEFT JOIN ixn1e_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%")))
    
      LEFT JOIN ixn1e_eb_locations AS c 
      ON a.location_id = c.id 
    
      LEFT JOIN ixn1e_eb_categories AS cat 
      ON a.main_category_id = cat.id
    
      WHERE a.id = 91
    
      GROUP BY a.id

    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	ref	jos_eb_registrants_FKIndex1,idx_published,idx_payment_method	jos_eb_registrants_FKIndex1	5	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	cat	eq_ref	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.07 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.06 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1663
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/model/event.php:73
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.56 ms After last query: 4.42 ms Query memory: 0.080 MB Memory before query: 16.692 MB Rows returned: 1

    SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2026-06-23 22:22:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-06-23 22:22:20') AS event_start_minutes,DATEDIFF('2026-06-23 22:22:20', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-06-23 22:22:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-06-23 22:22:20') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-06-23 22:22:20', early_bird_discount_date) AS date_diff,l.lat, l.long, l.address AS location_address,`l`.`name` AS `location_name`,c.tax_rate AS cat_tax_rate
    
      FROM ixn1e_eb_events AS a
    
      LEFT JOIN ixn1e_eb_categories AS c 
      ON a.main_category_id = c.id
    
      LEFT JOIN ixn1e_eb_locations AS l 
      ON a.location_id = l.id
    
      LEFT JOIN ixn1e_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%")))
    
      WHERE a.id = 91
    
      GROUP BY a.id

    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	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	b	ref	jos_eb_registrants_FKIndex1,idx_published,idx_payment_method	jos_eb_registrants_FKIndex1	5	const	1	Using where

    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.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1663
    14	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/database.php:111
    13	EventbookingHelperDatabase::getEvent()	JROOT/components/com_eventbooking/helper/registration.php:5803
    12	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/model/event.php:88
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.26 ms After last query: 0.88 ms Query memory: 0.024 MB Memory before query: 16.867 MB Rows returned: 3

    SELECT *
    
      FROM ixn1e_eb_locations

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:588
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:867
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.33 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 16.882 MB Rows returned: 1

    SELECT a.*, b.event_id
    
      FROM ixn1e_eb_categories AS a
    
      INNER JOIN ixn1e_eb_event_categories AS b 
      ON a.id = b.category_id
    
      WHERE b.event_id IN (91)
    
      ORDER BY b.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ref	ixn1e_eb_event_categories_FKIndex1,ixn1e_eb_event_categories_FKIndex2	ixn1e_eb_event_categories_FKIndex1	5	const	1	Using where; Using filesort
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	curlaber_joom3.b.category_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:615
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:867
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.33 ms After last query: 1.06 ms Query memory: 0.028 MB Memory before query: 17.052 MB Rows returned: 1

    SELECT `extension_id`,`name`,`enabled`,`params`
    
      FROM ixn1e_extensions
    
      WHERE `type` = 'plugin' 
      AND `element` = 'osyoutube' 
      AND `folder` = 'content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ixn1e_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.02 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	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1663
    27	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:168
    26	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:138
    25	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:63
    24	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:66
    23	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:89
    22	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:60
    21	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:64
    20	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:867
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.54 ms After last query: 5.57 ms Query memory: 0.033 MB Memory before query: 17.903 MB Rows returned: 49

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ixn1e_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akquickicons','com_associations','com_banners','com_cache','com_categories','com_cbjuice2','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_curling','com_eventbooking','com_facilitycalendar','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailcatcher','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocafavicon','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    27	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    26	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    25	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    24	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    23	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:49
    22	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/sourcerer.php:82
    21	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/SystemPlugin.php:226
    20	RegularLabs\Library\SystemPlugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:867
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.26 ms After last query: 1.30 ms Query memory: 0.006 MB Memory before query: 18.057 MB

    UPDATE ixn1e_eb_events
    
      SET hits = hits + 1
    
      WHERE id = 91

    Explain

    EXPLAIN not possible on query: UPDATE ixn1e_eb_events SET hits = hits + 1 WHERE id = 91

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    12	JDatabaseDriverMysqli->execute()	JROOT/components/com_eventbooking/model/event.php:180
    11	EventbookingModelEvent->updateHits()	JROOT/components/com_eventbooking/view/event/html.php:219
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.26 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 18.065 MB Rows returned: 0

    SELECT *
    
      FROM ixn1e_eb_sponsors AS a
    
      INNER JOIN ixn1e_eb_event_sponsors AS b 
      ON a.id = b.sponsor_id
    
      WHERE b.event_id = 91
    
      ORDER BY b.id

    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.01 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.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/eventbooking/sponsors/sponsors.php:242
    14	plgEventBookingSponsors->onEventDisplay()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_eventbooking/view/event/html.php:249
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.24 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 18.114 MB Rows returned: 0

    SELECT *
    
      FROM ixn1e_eb_event_group_prices
    
      WHERE event_id = 91
    
      ORDER BY id

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/database.php:193
    11	EventbookingHelperDatabase::getGroupRegistrationRates()	JROOT/components/com_eventbooking/view/event/html.php:293
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.25 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 18.247 MB Rows returned: 5

    SELECT id, parent, alias
    
      FROM ixn1e_eb_categories

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/route.php:636
    13	EventbookingHelperRoute::buildCategories()	JROOT/components/com_eventbooking/helper/route.php:591
    12	EventbookingHelperRoute::getCategoryIdsTree()	JROOT/components/com_eventbooking/helper/route.php:152
    11	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/view/event/html.php:297
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.]

    ---

21. Query Time: 0.27 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 18.379 MB Rows returned: 1

    SELECT id
    
      FROM ixn1e_eb_urls
    
      WHERE md5_key = 'a474ec7aa2a06d4e338eb94a0c5c1d64'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ixn1e_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1741
    18	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:489
    17	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/view/event/html.php:300
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.]

    ---

22. Query Time: 0.26 ms After last query: 2.07 ms Query memory: 0.027 MB Memory before query: 18.648 MB Rows returned: 1

    SELECT id
    
      FROM ixn1e_eb_urls
    
      WHERE md5_key = 'f5bbcb305c20c1341251c59981c3b15b'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ixn1e_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1741
    23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:489
    22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/event_properties.php:157
    15	include JROOT/components/com_eventbooking/themes/default/common/event_properties.php	JROOT/components/com_eventbooking/helper/html.php:688
    14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:184
    13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:271
    12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:156
    11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:308
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.]

    ---

23. Query Time: 0.27 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 18.679 MB Rows returned: 1

    SELECT id
    
      FROM ixn1e_eb_urls
    
      WHERE md5_key = '5ae25f41a4838d9b207a18d5f55fb559'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ixn1e_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1741
    25	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:489
    24	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/elements/location.php:28
    17	include JROOT/components/com_eventbooking/themes/default/elements/location.php	JROOT/components/com_eventbooking/helper/html.php:688
    16	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/common/event_properties.php:351
    15	include JROOT/components/com_eventbooking/themes/default/common/event_properties.php	JROOT/components/com_eventbooking/helper/html.php:688
    14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:184
    13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:271
    12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:156
    11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:308
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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.]

    ---

24. Query Time: 0.68 ms After last query: 10.59 ms Query memory: 0.031 MB Memory before query: 19.831 MB Rows returned: 222

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 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.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.23 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1551
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    14	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:724
    13	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:536
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:1080
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:26
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:24
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:148
    7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1118
    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.]

    ---

25. Query Time: 0.37 ms After last query: 0.06 ms Query memory: 0.035 MB Memory before query: 19.862 MB Rows returned: 213

    SELECT * 
      FROM ixn1e_acymailing_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1702
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:628
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:536
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:1080
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:26
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:24
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:148
    7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1118
    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. 3 × SELECT id 
     FROM ixn1e_eb_urls

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

3. 1 × SELECT a.*, b.event_id 
     FROM ixn1e_eb_categories AS a 
     INNER JOIN ixn1e_eb_event_categories AS b 
     ON a.id = b.category_id

4. 1 × SELECT id, parent, alias 
     FROM ixn1e_eb_categorie

5. 1 × SELECT * 
     FROM ixn1e_eb_event_group_prices

6. 1 × SELECT * 
     FROM ixn1e_eb_sponsors AS a 
     INNER JOIN ixn1e_eb_event_sponsors AS b 
     ON a.id = b.sponsor_id

7. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `ixn1e_assets`

8. 1 × SELECT `extension_id`,`name`,`enabled`,`params` 
     FROM ixn1e_extensions

9. 1 × SELECT * 
     FROM ixn1e_eb_location

10. 1 × SELECT id, rules 
      FROM `ixn1e_viewlevels

11. 1 × SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2026-06-23 22:22:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-06-23 22:22:20') AS event_start_minutes,DATEDIFF('2026-06-23 22:22:20', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-06-23 22:22:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-06-23 22:22:20') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-06-23 22:22:20', early_bird_discount_date) AS date_diff,l.lat, l.long, l.address AS location_address,`l`.`name` AS `location_name`,c.tax_rate AS cat_tax_rate 
      FROM ixn1e_eb_events AS a 
      LEFT JOIN ixn1e_eb_categories AS c 
      ON a.main_category_id = c.id 
      LEFT JOIN ixn1e_eb_locations AS l 
      ON a.location_id = l.id 
      LEFT JOIN ixn1e_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%")))

12. 1 × SELECT a.*,DATEDIFF(event_date, '2026-06-23 22:22:20') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2026-06-23 22:22:20') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-06-23 22:22:20') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-06-23 22:22:20') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-06-23 22:22:20') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-06-23 22:22:20', early_bird_discount_date) AS date_diff,(IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate 
      FROM ixn1e_eb_events AS a 
      LEFT JOIN ixn1e_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%"))) 
      LEFT JOIN ixn1e_eb_locations AS c 
      ON a.location_id = c.id  
      LEFT JOIN ixn1e_eb_categories AS cat 
      ON a.main_category_id = cat.id

13. 1 × SELECT * 
      FROM ixn1e_eb_themes

14. 1 × SELECT `config_key`,`config_value` 
      FROM ixn1e_eb_config

15. 1 × SELECT `query` 
      FROM ixn1e_eb_urls

16. 1 × SELECT `template` 
      FROM `ixn1e_template_styles`

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

18. 1 × SELECT * 
      FROM ixn1e_acymailing_confi

OTHER Tables:

1. 1 × INSERT INTO `ixn1e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3765326436623437636465623834656339633434333338626435656133323030', 1, 1782267740, 0, '', 0

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

3. 1 × SHOW FULL COLUMNS 
     FROM `ixn1e_eb_ticket_types

4. 1 × UPDATE ixn1e_eb_events 
     SET hits = hits + 1

5. 1 × SHOW TABLE