Event Categories - 大溫哥華聖道堂

ECBC

YAM

大溫哥華聖道堂座落於加拿大Canada, BC.省Burnaby市，Marine Drive 南邊，在Royal Oak Avenue與Nelson Street兩路之間；教會建築建於1993年，1995年3月5日落成啟用。佔地4.52畝，建築面積達53,696呎，有350多個地面停車位，大禮拜堂可容納1,200人聚會、副堂150人、課室23間、還有圖書館及體育館。

Children Ministry

兒童事工的目標是與家長們合作，一同訓練孩子們，讓他們的智慧和身量，並神和人喜愛他們的心，都一齊增長 (路2:52)。

我們透過 ”S.T.E.P.S.” 五個原則來教導孩子。
Share the Good News of Christ (分享基督的福音，歌羅西書 1:13-14)
Teach the Word of God (教導上帝的話語，歌羅西書 1:28)
Encourage Friendship (鼓勵人際關係，歌羅西書 3:12-14)
Promote Worship of God (鼓勵敬拜上帝，歌羅西書 3:16)
Serve God and One Another (學習事奉上帝及彼此服事，歌羅西書 3:17)

線上兒主ZOOM 密碼請洽教會辦公室 (604) 438-3222

AWANA

10 Forward Cafe

Prayer meeting - 1st Service

禱告會-Prayer meeting

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1768298573,
                "last": 1768298573,
                "now": 1768298573
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "eb_device_type": "desktop"
    }
}

Profile Information

Time

Memory

Time: 26.66 ms / 26.66 ms Memory: 2.009 MB / 2.39 MB Application: afterLoad

Time: 110.59 ms / 137.25 ms Memory: 6.610 MB / 9.00 MB Application: afterInitialise

Time: 46.35 ms / 183.59 ms Memory: 4.103 MB / 13.10 MB Application: Before Access::preloadComponents (all components)

Time: 1.09 ms / 184.68 ms Memory: 0.067 MB / 13.17 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 184.72 ms Memory: -0.005 MB / 13.16 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.71 ms / 185.43 ms Memory: 0.030 MB / 13.19 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 0.10 ms / 185.53 ms Memory: -0.000 MB / 13.19 MB Application: afterRoute

Time: 6.09 ms / 191.62 ms Memory: 0.277 MB / 13.47 MB Application: beforeRenderComponent com_eventbooking

Time: 107.19 ms / 298.82 ms Memory: 4.367 MB / 17.83 MB Application: afterRenderComponent com_eventbooking

Time: 3.10 ms / 301.92 ms Memory: 0.023 MB / 17.86 MB Application: afterDispatch

Time: 22.00 ms / 323.91 ms Memory: 0.877 MB / 18.73 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)

Time: 1.23 ms / 325.15 ms Memory: 0.042 MB / 18.78 MB Application: Before Access::getAssetRules (id:23 name:com_templates)

Time: 0.04 ms / 325.18 ms Memory: 0.002 MB / 18.78 MB Application: After Access::getAssetRules (id:23 name:com_templates)

Time: 0.97 ms / 326.15 ms Memory: 0.020 MB / 18.80 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)

Time: 0.12 ms / 326.27 ms Memory: -0.000 MB / 18.80 MB Application: beforeRenderModule mod_custom (footer-map)

Time: 0.79 ms / 327.06 ms Memory: 0.007 MB / 18.80 MB Application: afterRenderModule mod_custom (footer-map)

Time: 0.06 ms / 327.12 ms Memory: -0.002 MB / 18.80 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.22 ms / 329.34 ms Memory: 0.047 MB / 18.85 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.15 ms / 329.49 ms Memory: -0.003 MB / 18.85 MB Application: beforeRenderModule mod_icemegamenu (Main menu)

Time: 21.55 ms / 351.03 ms Memory: 0.891 MB / 19.74 MB Application: beforeRenderModule mod_search (Menu search)

Time: 2.86 ms / 353.90 ms Memory: 0.035 MB / 19.77 MB Application: afterRenderModule mod_search (Menu search)

Time: 27.45 ms / 381.35 ms Memory: -0.002 MB / 19.77 MB Application: afterRenderModule mod_icemegamenu (Main menu)

Time: 45.06 ms / 426.40 ms Memory: 2.754 MB / 22.52 MB Application: afterRender

Database queries total: 49.30 ms

Memory Usage

Database Queries

69 Queries Logged 49.30 ms

2 duplicate found!

2 duplicates: #67 #68

Query Time: 0.87 ms Query memory: 0.023 MB Memory before query: 4.155 MB Rows returned: 0

SELECT `data`

  FROM `s4gur_session`

  WHERE `session_id` = X'34307236366f756a71373237686f356672706b746d7469666738'

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 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: 1.08 ms After last query: 2.24 ms Query memory: 0.020 MB Memory before query: 4.251 MB Rows returned: 0

SELECT `session_id`

  FROM `s4gur_session`

  WHERE `session_id` = X'34307236366f756a71373237686f356672706b746d7469666738' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 2.38 ms After last query: 0.15 ms Query memory: 0.004 MB Memory before query: 4.256 MB

INSERT INTO `s4gur_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'34307236366f756a71373237686f356672706b746d7469666738', 1, 1768298573, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `s4gur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'34307236366f756a71373237686f356672706b746d7469666738', 1, 1768298573, 0, '', 0)

Profile

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

Call Stack

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

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

Query Time: 1.53 ms After last query: 3.84 ms Query memory: 0.042 MB Memory before query: 4.444 MB Rows returned: 51

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

  FROM `s4gur_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	s4gur_extensions	ref	extension	extension	82	const	51	Using index condition; Using where

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.04 ms
Statistics	0.21 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.38 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.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.81 ms After last query: 3.92 ms Query memory: 0.021 MB Memory before query: 4.715 MB Rows returned: 5

SELECT id, rules

  FROM `s4gur_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.65 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 4.727 MB Rows returned: 2

SELECT b.id

  FROM s4gur_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.68 ms After last query: 1.05 ms Query memory: 0.051 MB Memory before query: 4.795 MB Rows returned: 132

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

  FROM s4gur_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	s4gur_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	400	Using where; Using filesort

Profile

Status	Duration
Starting	0.10 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.05 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 1.06 ms After last query: 35.51 ms Query memory: 0.021 MB Memory before query: 7.648 MB Rows returned: 1

SELECT *

  FROM s4gur_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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.55 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 7.656 MB Rows returned: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `s4gur_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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.83 ms After last query: 8.93 ms Query memory: 0.021 MB Memory before query: 7.932 MB Rows returned: 1

SELECT `value` 
  FROM s4gur_acym_configuration 
  WHERE `name` = 'level'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_acym_configuration	const	PRIMARY	PRIMARY	762	const	1

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/acymtriggers/acymtriggers.php:639
10	plgSystemAcymtriggers->getAcyConf()	JROOT/plugins/system/acymtriggers/acymtriggers.php:655
9	plgSystemAcymtriggers->handleCron()	JROOT/plugins/system/acymtriggers/acymtriggers.php:344
8	plgSystemAcymtriggers->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: 1.82 ms After last query: 14.80 ms Query memory: 0.093 MB Memory before query: 8.664 MB Rows returned: 57

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 s4gur_menu AS m

  LEFT JOIN s4gur_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	129	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ecbcgo.m.component_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->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.72 ms After last query: 47.05 ms Query memory: 0.022 MB Memory before query: 13.042 MB Rows returned: 12

SELECT id, home, template, s.params

  FROM s4gur_template_styles as s

  LEFT JOIN s4gur_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ref\|filter	idx_template,idx_client_id,idx_client_id_home	idx_template\|idx_client_id	202\|1	ecbcgo.e.element	1 (86%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:261
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:112
8	plgSystemGantry5->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.78 ms After last query: 1.68 ms Query memory: 0.028 MB Memory before query: 13.103 MB Rows returned: 51

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

  FROM `s4gur_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_eventbooking','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jdonation','com_jmap','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_sermonspeaker','com_sigpro','com_spstgsrv','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
8	RegularLabs\Library\SystemPlugin->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.37 ms After last query: 1.51 ms Query memory: 0.022 MB Memory before query: 13.291 MB Rows returned: 1

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

  FROM `s4gur_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.55 ms After last query: 0.18 ms Query memory: 0.005 MB Memory before query: 13.282 MB

UPDATE `s4gur_extensions`

  SET `params` = '{\"mediaversion\":\"47383d69aa9a6b22455662f5bb59fac5\"}'

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.97 ms After last query: 15.95 ms Query memory: 0.057 MB Memory before query: 14.166 MB Rows returned: 362

SELECT `config_key`,`config_value`

  FROM s4gur_eb_configs

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:41
9	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:393
8	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:87
7	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/components/com_eventbooking/eventbooking.php:16
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.64 ms After last query: 20.60 ms Query memory: 0.022 MB Memory before query: 15.452 MB Rows returned: 1

SELECT *

  FROM s4gur_eb_themes

  WHERE published = 1

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.06 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	1.09 ms
Reset for next command	0.01 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:551
10	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/display.php:53
9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:30
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 1.25 ms After last query: 20.18 ms Query memory: 0.026 MB Memory before query: 15.939 MB Rows returned: 19

SHOW FULL COLUMNS 
  FROM `s4gur_eb_categories`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:82
13	RADModelList->__construct()	JROOT/components/com_eventbooking/model/categories.php:25
12	EventbookingModelCategories->__construct()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:121
11	RADModel::getInstance()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:368
10	RADController->getModel()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.57 ms After last query: 0.62 ms Query memory: 0.023 MB Memory before query: 15.959 MB Rows returned: 1

SELECT COUNT(*)

  FROM s4gur_eb_categories AS tbl

  WHERE tbl.published=1 
  AND tbl.parent = 0 
  AND tbl.access IN (1,1,5) 
  AND tbl.language IN ('en-GB','*', "")

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ALL	idx_parent,idx_access,idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	16	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:205
14	RADModelList->getTotal()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:167
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.49 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 15.962 MB Rows returned: 10

SELECT tbl.*

  FROM s4gur_eb_categories AS tbl

  WHERE tbl.published=1 
  AND tbl.parent = 0 
  AND tbl.access IN (1,1,5) 
  AND tbl.language IN ('en-GB','*', "")

  ORDER BY tbl.ordering ASC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ALL	idx_parent,idx_access,idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	16	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:181
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 15.989 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 2 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

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.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.42 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 5.21 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 16.002 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (2) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 14.64 ms Query memory: 0.024 MB Memory before query: 17.203 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 4 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.60 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 17.212 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (4) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 17.220 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 3 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.18 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.36 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 17.229 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (3) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.20 ms Query memory: 0.024 MB Memory before query: 17.236 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 1 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.33 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 17.245 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (1) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	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.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 0.19 ms Query memory: 0.024 MB Memory before query: 17.253 MB Rows returned: 6

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 12 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ALL	idx_parent,idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	16	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 17.262 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 18 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.12 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 17.270 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 17 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.06 ms Query memory: 0.024 MB Memory before query: 17.278 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 16 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.21 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 17.292 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 15 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.05 ms Query memory: 0.024 MB Memory before query: 17.302 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 14 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.11 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 17.310 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 13 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.48 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 17.319 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (12,13,14,15,16,17,18) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ALL	idx_event_id,idx_category_id	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 17.327 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 19 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.40 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 17.336 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (19) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.21 ms Query memory: 0.024 MB Memory before query: 17.343 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 20 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 0.09 ms Query memory: 0.024 MB Memory before query: 17.352 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (20) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	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.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.20 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.16 ms Query memory: 0.024 MB Memory before query: 17.360 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 21 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.024 MB Memory before query: 17.369 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (21) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 17.376 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 22 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.16 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.30 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 17.385 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (22) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	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.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.15 ms Query memory: 0.024 MB Memory before query: 17.393 MB Rows returned: 0

SELECT id

  FROM s4gur_eb_categories

  WHERE parent = 23 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_categories	ref	idx_parent,idx_published	idx_parent	5	const	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.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_eventbooking/helper/helper.php:1504
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.39 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 17.402 MB Rows returned: 1

SELECT COUNT(DISTINCT a.id)

  FROM s4gur_eb_events AS a

  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

  WHERE b.category_id IN (23) 
  AND published = 1 
  AND a.hidden = 0 
  AND `access` IN (1,1,5) 
  AND (DATE(a.event_date) >= '2026-01-13' OR DATE(a.cut_off_date) >= '2026-01-13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	1	Using where
1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_category_id	5	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/helper.php:1540
15	EventbookingHelper::getTotalEvent()	JROOT/components/com_eventbooking/model/categories.php:73
14	EventbookingModelCategories->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:183
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:60
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/categories/html.php:49
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.49 ms After last query: 2.30 ms Query memory: 0.042 MB Memory before query: 17.492 MB Rows returned: 72

SELECT `message_key`,`message`

  FROM s4gur_eb_messages

Explain

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:41
13	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:628
12	EventbookingHelper::getMessages()	JROOT/components/com_eventbooking/view/categories/html.php:71
11	EventbookingViewCategoriesHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:134
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.57 ms After last query: 7.36 ms Query memory: 0.026 MB Memory before query: 17.759 MB Rows returned: 16

SELECT id, parent, alias

  FROM s4gur_eb_categories

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/route.php:588
17	EventbookingHelperRoute::buildCategories()	JROOT/components/com_eventbooking/helper/route.php:550
16	EventbookingHelperRoute::getCategoryIdsTree()	JROOT/components/com_eventbooking/helper/route.php:158
15	EventbookingHelperRoute::getCategoryRoute()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 1.43 ms After last query: 1.33 ms Query memory: 0.027 MB Memory before query: 17.808 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '806ad1e1a4aa6498a4b7adaed7639293'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 0.62 ms Query memory: 0.027 MB Memory before query: 17.821 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '34f8279371b9dba07c53ca90088fbedb'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 17.832 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '10285d66c6192ddb6b30b036a38a51df'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.21 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 17.844 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = 'e039bb6fc5487710a16a796fc111ab13'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.20 ms Query memory: 0.027 MB Memory before query: 17.856 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = 'b4a0fb3e1fe5a677e0478b091e906442'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 17.868 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = 'cec5a256b80b36ad372348f30c6a6429'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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: 0.21 ms Query memory: 0.027 MB Memory before query: 17.880 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '617480245356452ba6a7629abd117c78'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 17.892 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '900a309cbad298b1fa8289570f2a85f6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.20 ms Query memory: 0.027 MB Memory before query: 17.904 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '3a6f3f39c9fce270fc9460f8faa96d15'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.23 ms After last query: 0.24 ms Query memory: 0.027 MB Memory before query: 17.916 MB Rows returned: 1

SELECT id

  FROM s4gur_eb_urls

  WHERE md5_key = '016f24ab299bb966380e1a6ef8813d94'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:396
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/categories.php:37
14	include JROOT/components/com_eventbooking/themes/default/common/categories.php	JROOT/components/com_eventbooking/helper/html.php:338
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/categories/default.php:32
12	include JROOT/components/com_eventbooking/themes/default/categories/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:252
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:136
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:318
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:73
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:283
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:38
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.57 ms After last query: 0.54 ms Query memory: 0.020 MB Memory before query: 17.838 MB Rows returned: 1

SELECT language,id

  FROM `s4gur_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

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

Profile

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

Call Stack

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

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

Query Time: 2.20 ms After last query: 8.04 ms Query memory: 0.080 MB Memory before query: 18.119 MB Rows returned: 35

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM s4gur_modules AS m

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

  LEFT JOIN s4gur_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds,idx_language	published	1	const	40	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ecbcgo.m.module,const	1	Using index condition; Using where
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	ecbcgo.m.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
15	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
14	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme3323/includes/includes.php:130
8	include_once JROOT/templates/theme3323/includes/includes.php	JROOT/templates/theme3323/index.php:2
7	require JROOT/templates/theme3323/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.]

Query Time: 1.02 ms After last query: 39.87 ms Query memory: 0.027 MB Memory before query: 19.705 MB Rows returned: 1

SELECT distinct(m.id), title, module, position, content, showtitle, params 
  FROM s4gur_modules AS m 
  LEFT JOIN s4gur_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE  m.id in(195) 
  AND m.published > 0 
  ORDER BY position, ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1	Using temporary
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	const	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
23	IceModuleHelper->_getModules()	JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
22	IceModuleHelper->getContentByModule()	JROOT/modules/mod_icemegamenu/libs/menucore.php:168
21	IceMenuTree->_getSubmenuByType()	JROOT/modules/mod_icemegamenu/libs/menucore.php:286
20	IceMenuTree->_getLevelXML()	JROOT/modules/mod_icemegamenu/libs/menucore.php:461
19	IceMenuTree->_getLevelXML()	JROOT/modules/mod_icemegamenu/libs/menucore.php:142
18	IceMenuTree->toXML()	JROOT/modules/mod_icemegamenu/helper.php:104
17	modIceMegamenuHelper::buildXML()	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/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_icemegamenu/helper.php:116
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:155
12	modIceMegamenuHelper->render()	JROOT/templates/theme3323/html/mod_icemegamenu/default.php:23
11	require JROOT/templates/theme3323/html/mod_icemegamenu/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Query Time: 0.75 ms After last query: 2.14 ms Query memory: 0.032 MB Memory before query: 19.757 MB Rows returned: 1

SELECT a.params

  FROM s4gur_advancedmodules AS a

  WHERE a.moduleid = 195

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
33	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:191
32	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:174
31	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:440
30	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:301
29	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:149
28	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:245
25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
23	IceModuleHelper->_renderModule()	JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
22	IceModuleHelper->getContentByModule()	JROOT/modules/mod_icemegamenu/libs/menucore.php:168
21	IceMenuTree->_getSubmenuByType()	JROOT/modules/mod_icemegamenu/libs/menucore.php:286
20	IceMenuTree->_getLevelXML()	JROOT/modules/mod_icemegamenu/libs/menucore.php:461
19	IceMenuTree->_getLevelXML()	JROOT/modules/mod_icemegamenu/libs/menucore.php:142
18	IceMenuTree->toXML()	JROOT/modules/mod_icemegamenu/helper.php:104
17	modIceMegamenuHelper::buildXML()	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/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_icemegamenu/helper.php:116
13	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:155
12	modIceMegamenuHelper->render()	JROOT/templates/theme3323/html/mod_icemegamenu/default.php:23
11	require JROOT/templates/theme3323/html/mod_icemegamenu/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
10	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Query Time: 0.85 ms After last query: 28.59 ms Query memory: 0.022 MB Memory before query: 19.859 MB Rows returned: 0

SELECT *
 
  FROM s4gur_jmap_metainfo
 
  WHERE `linkurl` = 'https://dev.ecbcgo.org/en/component/eventbooking'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s4gur_jmap_metainfo	ref	published	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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.]

Query Time: 1.05 ms After last query: 1.35 ms Query memory: 0.020 MB Memory before query: 19.920 MB Rows returned: 1

SELECT `value` 
  FROM s4gur_acym_configuration 
  WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/acymtriggers/acymtriggers.php:430
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.72 ms After last query: 0.55 ms Query memory: 0.033 MB Memory before query: 19.951 MB Rows returned: 112

SELECT * 
  FROM s4gur_acym_configuration

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
11	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:22
10	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:44
9	acym_config()	JROOT/plugins/system/acymtriggers/acymtriggers.php:447
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.00 ms After last query: 0.48 ms Query memory: 0.037 MB Memory before query: 20.027 MB Rows returned: 353

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:122
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 1.25 ms Query memory: 0.023 MB Memory before query: 20.055 MB Rows returned: 4

Duplicate queries: #68

SELECT * 
  FROM s4gur_acym_plugin

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
12	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/plugin.php:20
11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:88
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 20.066 MB Rows returned: 4

Duplicate queries: #67

SELECT * 
  FROM s4gur_acym_plugin

Explain

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

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
11	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:89
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 11.26 ms Query memory: 0.023 MB Memory before query: 20.841 MB Rows returned: 9

SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` 
        
  FROM s4gur_usergroups AS `groups`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/user.php:46
12	acym_getGroups()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:21
11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:130
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

16 × SELECT id 
  FROM s4gur_eb_categories

```
10 × SELECT id 
  FROM s4gur_eb_urls
```

10 × SELECT COUNT(DISTINCT a.id) 
  FROM s4gur_eb_events AS a 
  INNER JOIN s4gur_eb_event_categories AS b 
  ON a.id = b.event_id

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

```
2 × SELECT * 
  FROM s4gur_acym_plugi
```

2 × SELECT `value` 
  FROM s4gur_acym_configuration

1 × SELECT `data` 
  FROM `s4gur_session`

1 × SELECT * 
  FROM s4gur_acym_configuratio

1 × SELECT *  
  FROM s4gur_jmap_metainfo

1 × SELECT a.params 
  FROM s4gur_advancedmodules AS a

1 × SELECT distinct(m.id), title, module, position, content, showtitle, params 
  FROM s4gur_modules AS m 
  LEFT JOIN s4gur_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM s4gur_modules AS m 
  LEFT JOIN s4gur_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN s4gur_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT language,id 
  FROM `s4gur_menu`

1 × SELECT id, parent, alias 
  FROM s4gur_eb_categorie

1 × SELECT `message_key`,`message` 
  FROM s4gur_eb_message

1 × SELECT COUNT(*) 
  FROM s4gur_eb_categories AS tbl

1 × SELECT tbl.* 
  FROM s4gur_eb_categories AS tbl

1 × SELECT `session_id` 
  FROM `s4gur_session`

```
1 × SELECT * 
  FROM s4gur_eb_themes
```

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

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

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

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 s4gur_menu AS m 
  LEFT JOIN s4gur_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `s4gur_extensions`

```
1 × SELECT * 
  FROM s4gur_languages
```

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

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

1 × SELECT id, rules 
  FROM `s4gur_viewlevels

1 × SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`          
  FROM s4gur_usergroups AS `groups

OTHER Tables:

1 × INSERT INTO `s4gur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'34307236366f756a71373237686f356672706b746d7469666738', 1, 1768298573, 0, '', 0

1 × UPDATE `s4gur_extensions` 
  SET `params` = '{\"mediaversion\":\"47383d69aa9a6b22455662f5bb59fac5\"}'

1 × SHOW FULL COLUMNS 
  FROM `s4gur_eb_categories

```
1 × SHOW TABLE
```

YAM

Youth Lighthouse

成人教育課程

Venue Renting - 場地租借

Life Group

Children Ministry

AWANA

10 Forward Cafe

Prayer meeting - 1st Service

禱告會-Prayer meeting

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

69 Queries Logged 49.30 ms

2 duplicate found!

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: