Online California - Initial CCW - Solano County ONLY

Name: Online California - Initial CCW - Solano County ONLY
Start: 2026-10-01T09:00
End: 2026-10-31T18:00
Location: Richmond Rod & Gun Club

This course will satisfy 16-Hours SB2 training requirements for Solano County Only.

After you complete the online course. You will need to schedule the IN PERSON live fire qualification.

Live fire will be at Richmond Rod & Gun Club.

*You must be a resident of SOLANO County.

Here is a list of states that currently recognize a California concealed carry weapons permit. (27 states as of July 2024)

Alabama, Alaska, Arizona, Arkansas, Florida, Georgia, Idaho, Indiana, Iowa, Kansas, Kentucky, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, North Carolina, Ohio, Oklahoma, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Wisconsin.

*** Although these states will recognize a California Permit - The State of California says the permit is only valid in the State of California. Because of this fact, whenever you are outside the State of California and you have another permit that is valid in the state you are visiting, use the other permit.

We supply targets and pay range fees.

EB_EVENT_PROPERTIES

EB_EVENT_DATE	10-01-2026 9:00 am
EB_EVENT_END_DATE	10-31-2026 6:00 pm
EB_CUT_OFF_DATE	10-31-2026 6:00 pm
EB_AVAILABLE_PLACE	99
EB_INDIVIDUAL_PRICE	$275.00
Location	Richmond Rod & Gun Club
EB_CATEGORIES	California - Initial CCW Online

PLG_EB_MAP

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1793238461,
                "last": 1793238462,
                "now": 1793238463
            },
            "token": "OmdA2ePDCEm66gGYzsUZdqDlycCWfrmF"
        },
        "registry": {
            "com_beestohelpdesk": {
                "edit": {
                    "ticket": {
                        "data": []
                    }
                }
            }
        },
        "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",
        "bhd_log_session": 1
    }
}

Profile Information

Time

Memory

Time: 8.29 ms / 8.29 ms Memory: 0.410 MB / 0.76 MB Application: afterLoad

Time: 27.43 ms / 35.72 ms Memory: 0.934 MB / 1.69 MB Application: afterInitialise

Time: 9.95 ms / 45.67 ms Memory: 0.385 MB / 2.08 MB Application: afterRoute

Time: 3.40 ms / 49.07 ms Memory: 0.015 MB / 2.09 MB Application: beforeRenderComponent com_eventbooking

Time: 21.02 ms / 70.09 ms Memory: 0.507 MB / 2.60 MB Application: Before Access::preloadComponents (all components)

Time: 1.18 ms / 71.26 ms Memory: 0.071 MB / 2.67 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 71.29 ms Memory: -0.002 MB / 2.67 MB Application: Before Access::getAssetRules (id:76 name:com_eventbooking)

Time: 0.44 ms / 71.73 ms Memory: 0.016 MB / 2.68 MB Application: After Access::getAssetRules (id:76 name:com_eventbooking)

Time: 14.81 ms / 86.54 ms Memory: 0.174 MB / 2.86 MB Application: afterRenderComponent com_eventbooking

Time: 1.01 ms / 87.55 ms Memory: 0.006 MB / 2.86 MB Application: afterDispatch

Time: 4.76 ms / 92.31 ms Memory: 0.046 MB / 2.91 MB Application: beforeRenderModule mod_login (Login)

Time: 3.33 ms / 95.64 ms Memory: 0.094 MB / 3.00 MB Application: afterRenderModule mod_login (Login)

Time: 0.04 ms / 95.68 ms Memory: -0.003 MB / 3.00 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.82 ms / 96.50 ms Memory: 0.012 MB / 3.01 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.07 ms / 96.57 ms Memory: -0.001 MB / 3.01 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 9.40 ms / 105.97 ms Memory: 0.222 MB / 3.23 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.04 ms / 106.02 ms Memory: 0.005 MB / 3.24 MB Application: beforeRenderModule mod_maximenuck (Menu)

Time: 0.09 ms / 106.10 ms Memory: 0.016 MB / 3.25 MB Application: afterRenderModule mod_maximenuck (Menu)

Time: 0.04 ms / 106.14 ms Memory: -0.024 MB / 3.23 MB Application: beforeRenderModule mod_search (Search)

Time: 1.36 ms / 107.50 ms Memory: 0.014 MB / 3.24 MB Application: afterRenderModule mod_search (Search)

Time: 1.83 ms / 109.33 ms Memory: 0.045 MB / 3.29 MB Application: afterRender

Database queries total: 15.96 ms

Memory Usage

Database Queries

31 Queries Logged 15.96 ms

Query Time: 0.23 ms Query memory: 0.023 MB Memory before query: 1.037 MB Rows returned: 1

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = X'67346372763263636f64376e6f316c6a61763438397671676569'

Explain

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

Profile

Status	Duration
starting	0.03 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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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.]

Query Time: 0.49 ms After last query: 1.63 ms Query memory: 0.042 MB Memory before query: 1.084 MB Rows returned: 49

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jos_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	50	Using index condition; 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.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.17 ms After last query: 1.20 ms Query memory: 0.021 MB Memory before query: 1.129 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.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.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	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.]

Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.141 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.01 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.]

Query Time: 1.12 ms After last query: 0.26 ms Query memory: 0.035 MB Memory before query: 1.163 MB Rows returned: 139

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM jos_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	242	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.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.70 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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.]

Query Time: 0.77 ms After last query: 11.22 ms Query memory: 0.024 MB Memory before query: 1.678 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jos_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

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.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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/responsivizer/responsivizer.php:141
8	plgSystemResponsivizer->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.]

Query Time: 0.89 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 1.671 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"cf73acfbdeb24911a08f94ac9597aec1\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

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.04 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.68 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	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/responsivizer/responsivizer.php:141
8	plgSystemResponsivizer->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.]

Query Time: 0.76 ms After last query: 2.08 ms Query memory: 0.091 MB Memory before query: 1.780 MB Rows returned: 55

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 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.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.20 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

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

Query Time: 0.28 ms After last query: 6.71 ms Query memory: 0.021 MB Memory before query: 2.062 MB Rows returned: 1

SELECT `query`

  FROM jos_eb_urls

  WHERE md5_key = '0c1d568e61fcadd139fd98b09b7bbd5e'

Explain

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

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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

Query Time: 0.45 ms After last query: 0.46 ms Query memory: 0.021 MB Memory before query: 2.070 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla_5.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

Query Time: 0.27 ms After last query: 0.39 ms Query memory: 0.019 MB Memory before query: 2.078 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.40 ms After last query: 6.56 ms Query memory: 0.061 MB Memory before query: 2.235 MB Rows returned: 397

SELECT `config_key`,`config_value`

  FROM jos_eb_configs

Explain

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

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.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:42
11	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:888
10	EventbookingHelper::getConfig()	JROOT/components/com_eventbooking/controller/display.php:21
9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:32
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.19 ms After last query: 0.59 ms Query memory: 0.022 MB Memory before query: 2.305 MB Rows returned: 1

SELECT *

  FROM jos_eb_themes

  WHERE published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eb_themes	ref	idx_published	idx_published	2	const	1

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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:1131
10	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/display.php:58
9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:32
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.29 ms After last query: 3.93 ms Query memory: 0.025 MB Memory before query: 2.363 MB Rows returned: 0

SELECT id, name, title

  FROM jos_fields

  WHERE `context`='com_users.user' 
  AND `state` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_fields	ref	idx_state,idx_context	idx_state	1	const	1	Using where

Profile

Status	Duration
starting	0.04 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.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/eventbooking/userprofile/userprofile.php:312
18	plgEventbookingUserprofile::getUserFields()	JROOT/plugins/eventbooking/userprofile/userprofile.php:42
17	plgEventbookingUserprofile->__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:25
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:378
10	RADController->getModel()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:323
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.87 ms After last query: 0.93 ms Query memory: 0.080 MB Memory before query: 2.467 MB Rows returned: 1

SELECT a.*,DATEDIFF(event_date, '2026-10-28 18:47:43') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2026-10-28 18:47:43') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-10-28 18:47:43') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-10-28 18:47:43') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-10-28 18:47:43') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-10-28 18:47:43', 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 jos_eb_events AS a

  LEFT JOIN jos_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 jos_eb_locations AS c 
  ON a.location_id = c.id 

  LEFT JOIN jos_eb_categories AS cat 
  ON a.main_category_id = cat.id

  WHERE a.id = 924

  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.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.00 ms
Unlocking tables	0.03 ms
executing	0.06 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/model/event.php:74
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.81 ms After last query: 0.48 ms Query memory: 0.080 MB Memory before query: 2.502 MB Rows returned: 1

SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2026-10-28 18:47:43') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-10-28 18:47:43') AS event_start_minutes,DATEDIFF('2026-10-28 18:47:43', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-10-28 18:47:43') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-10-28 18:47:43') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-10-28 18:47:43', 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 jos_eb_events AS a

  LEFT JOIN jos_eb_categories AS c 
  ON a.main_category_id = c.id

  LEFT JOIN jos_eb_locations AS l 
  ON a.location_id = l.id

  LEFT JOIN jos_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 = 924

  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.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.03 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/database.php:112
13	EventbookingHelperDatabase::getEvent()	JROOT/components/com_eventbooking/helper/registration.php:5878
12	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/model/event.php:89
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.18 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.535 MB Rows returned: 0

SELECT *

  FROM jos_eb_taxes

  WHERE published = 1 
  LIMIT 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eb_taxes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	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.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/registration.php:5841
15	EventbookingHelperRegistration::getUniqueTaxRate()	JROOT/components/com_eventbooking/helper/registration.php:5903
14	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/helper/database.php:116
13	EventbookingHelperDatabase::getEvent()	JROOT/components/com_eventbooking/helper/registration.php:5878
12	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/model/event.php:89
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.22 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 2.540 MB Rows returned: 6

SELECT *

  FROM jos_eb_locations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eb_locations	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.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.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:616
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:868
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:95
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.28 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.559 MB Rows returned: 1

SELECT a.*, b.event_id

  FROM jos_eb_categories AS a

  INNER JOIN jos_eb_event_categories AS b 
  ON a.id = b.category_id

  WHERE b.event_id IN (924)

  ORDER BY b.id

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.02 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:643
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:868
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:95
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 3.37 ms After last query: 2.19 ms Query memory: 0.006 MB Memory before query: 2.572 MB

UPDATE jos_eb_events

  SET hits = hits + 1

  WHERE id = 924

Explain

EXPLAIN not possible on query: UPDATE jos_eb_events SET hits = hits + 1 WHERE id = 924

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
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	3.14 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/components/com_eventbooking/model/event.php:189
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 2.579 MB Rows returned: 1

SELECT a.*

  FROM jos_eb_locations AS a

  INNER JOIN jos_eb_events AS b 
  ON a.id = b.location_id

  WHERE b.id = 924

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	const	PRIMARY,jos_eb_events_FKIndex2	PRIMARY	4	const	1
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/eventbooking/map/map.php:69
14	plgEventBookingMap->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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.92 ms After last query: 1.95 ms Query memory: 0.031 MB Memory before query: 2.602 MB Rows returned: 49

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_arrausermigrate','com_associations','com_banners','com_beestohelpdesk','com_cache','com_categories','com_checkin','com_civicrm','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eshop','com_eventbooking','com_ffexplorer','com_fields','com_finder','com_guru','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_migrateme4','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_responsivizer','com_rsform','com_search','com_surveyforce','com_tags','com_templates','com_users','com_vquiz','com_weblinks','com_wrapper')

Explain

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

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.00 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.45 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/components/com_eventbooking/helper/acl.php:29
16	EventbookingHelperAcl::canViewRegistrantList()	JROOT/components/com_eventbooking/helper/helper.php:868
15	EventbookingHelper::callOverridableHelperMethod()	JROOT/plugins/eventbooking/waitinglist/waitinglist.php:36
14	plgEventBookingWaitinglist->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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.24 ms After last query: 0.77 ms Query memory: 0.022 MB Memory before query: 2.681 MB Rows returned: 0

SELECT *

  FROM jos_eb_event_group_prices

  WHERE event_id = 924

  ORDER BY id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eb_event_group_prices	ref	jos_eb_event_prices_FKIndex1	jos_eb_event_prices_FKIndex1	5	const	1	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.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/database.php:198
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.25 ms After last query: 1.29 ms Query memory: 0.024 MB Memory before query: 2.689 MB Rows returned: 24

SELECT id, parent, alias

  FROM jos_eb_categories

Explain

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

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.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.24 ms After last query: 1.58 ms Query memory: 0.025 MB Memory before query: 2.781 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = '0c1d568e61fcadd139fd98b09b7bbd5e'

Explain

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

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.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.18 ms After last query: 2.43 ms Query memory: 0.028 MB Memory before query: 2.871 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = '4fff93a1b4741072e25aa6fc63c796d2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	2	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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/common/buttons_register.php:74
17	include JROOT/components/com_eventbooking/themes/default/common/buttons_register.php	JROOT/components/com_eventbooking/helper/html.php:688
16	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/common/buttons.php:40
15	include JROOT/components/com_eventbooking/themes/default/common/buttons.php	JROOT/components/com_eventbooking/helper/html.php:688
14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:55
13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:294
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:179
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:312
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.27 ms After last query: 4.03 ms Query memory: 0.028 MB Memory before query: 2.896 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = '86c4809f4650117ac3b849f048292659'

Explain

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

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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/common/save_calendar.php:49
17	include JROOT/components/com_eventbooking/themes/default/common/save_calendar.php	JROOT/components/com_eventbooking/helper/html.php:688
16	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/common/buttons.php:52
15	include JROOT/components/com_eventbooking/themes/default/common/buttons.php	JROOT/components/com_eventbooking/helper/html.php:688
14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:55
13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:294
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:179
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:312
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.20 ms After last query: 0.41 ms Query memory: 0.027 MB Memory before query: 2.891 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = '9a9dbab84a1bc75d943c12d0c8c53b22'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/buttons.php:61
15	include JROOT/components/com_eventbooking/themes/default/common/buttons.php	JROOT/components/com_eventbooking/helper/html.php:688
14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:55
13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:294
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:179
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:312
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.24 ms After last query: 1.54 ms Query memory: 0.028 MB Memory before query: 2.927 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = 'ec37528a5e3884ecc16603590ea9576f'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_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.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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:34
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:350
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:294
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:179
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:312
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.19 ms After last query: 0.48 ms Query memory: 0.028 MB Memory before query: 2.941 MB Rows returned: 1

SELECT id

  FROM jos_eb_urls

  WHERE md5_key = '74006e26b689e9810382c51c36e8a5be'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_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.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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/categories.php:25
17	include JROOT/components/com_eventbooking/themes/default/elements/categories.php	JROOT/components/com_eventbooking/helper/html.php:688
16	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/common/event_properties.php:365
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:294
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:179
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:312
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:328
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:75
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
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.]

Query Time: 0.72 ms After last query: 4.84 ms Query memory: 0.023 MB Memory before query: 2.908 MB Rows returned: 6

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jos_modules AS m

  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-29 01:47:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-29 01:47:43') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 128 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	11	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla_5.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla_5.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 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.03 ms
optimizing	0.06 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.14 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/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.]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
6 × SELECT id 
  FROM jos_eb_urls
```

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

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT id, parent, alias 
  FROM jos_eb_categorie

1 × SELECT * 
  FROM jos_eb_event_group_prices

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

1 × SELECT a.* 
  FROM jos_eb_locations AS a 
  INNER JOIN jos_eb_events AS b 
  ON a.id = b.location_id

1 × SELECT a.*, b.event_id 
  FROM jos_eb_categories AS a 
  INNER JOIN jos_eb_event_categories AS b 
  ON a.id = b.category_id

```
1 × SELECT * 
  FROM jos_eb_location
```
```
1 × SELECT * 
  FROM jos_eb_taxes
```

1 × SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2026-10-28 18:47:43') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-10-28 18:47:43') AS event_start_minutes,DATEDIFF('2026-10-28 18:47:43', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-10-28 18:47:43') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-10-28 18:47:43') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-10-28 18:47:43', 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 jos_eb_events AS a 
  LEFT JOIN jos_eb_categories AS c 
  ON a.main_category_id = c.id 
  LEFT JOIN jos_eb_locations AS l 
  ON a.location_id = l.id 
  LEFT JOIN jos_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%")))

1 × SELECT id, name, title 
  FROM jos_fields

1 × SELECT a.*,DATEDIFF(event_date, '2026-10-28 18:47:43') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2026-10-28 18:47:43') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-10-28 18:47:43') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2026-10-28 18:47:43') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-10-28 18:47:43') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2026-10-28 18:47:43', 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 jos_eb_events AS a 
  LEFT JOIN jos_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 jos_eb_locations AS c 
  ON a.location_id = c.id  
  LEFT JOIN jos_eb_categories AS cat 
  ON a.main_category_id = cat.id

```
1 × SELECT * 
  FROM jos_eb_themes
```

1 × SELECT `config_key`,`config_value` 
  FROM jos_eb_config

```
1 × SELECT * 
  FROM jos_languages
```

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

1 × SELECT `query` 
  FROM jos_eb_urls

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

OTHER Tables:

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"cf73acfbdeb24911a08f94ac9597aec1\"}'

1 × UPDATE jos_eb_events 
  SET hits = hits + 1