Narcotics

Event	Event Date	Location	Individual Price	Capacity	Register
CRISIS INTERVENTION TRAINING	07-10-2019	Mississippi Gulf Coast Community College - AMTC Building	$119.00	40	Register
Confidential Informant Management and Development	08-06-2019	Oxford Police Department	$249.00	40	Register
PATROL NEGOTIATIONS	08-07-2019	Harrison County Law Enforcement Training Academy	$119.00	30	Register
Principles and Tactics of Undercover Narcotics Operations	08-12-2019	Oxford Police Department	$579.00	30	Register
INTERVIEW AND INTERROGATION LEVEL I	09-10-2019	Mississippi Gulf Coast Community College - AMTC Building	$249.00	30	Register
FIRST LINE SUPERVISION LEVEL I	10-07-2019	Mississippi Gulf Coast Community College - AMTC Building	$295.00	40	Register

Joomla! Debug Console

Session

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

Profile Information

Memory Usage

Database Queries

99 Queries Logged 70.68 ms

16 duplicate found!

4 duplicates: #29 #30 #42 #99

2 duplicates: #38 #76

2 duplicates: #39 #85

2 duplicates: #47 #62

2 duplicates: #49 #63

2 duplicates: #50 #66

2 duplicates: #52 #67

Query Time: 0.42 ms Query memory: 0.025 MB Memory before query: 1.543 MB Rows returned: 0

SELECT `data`

  FROM `qtnm6_session`

  WHERE `session_id` = '3c006b6c1c68f48a3cd450d605058cd5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.28 ms After last query: 4.05 ms Query memory: 0.022 MB Memory before query: 1.621 MB Rows returned: 0

SELECT `session_id`

  FROM `qtnm6_session`

  WHERE `session_id` = '3c006b6c1c68f48a3cd450d605058cd5' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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: 17.63 ms After last query: 0.14 ms Query memory: 0.004 MB Memory before query: 1.626 MB

INSERT INTO `qtnm6_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('3c006b6c1c68f48a3cd450d605058cd5', 1, 1560725489, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `qtnm6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('3c006b6c1c68f48a3cd450d605058cd5', 1, 1560725489, 0, '', 0)

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
update	0.13 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	17.25 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.17 ms After last query: 10.04 ms Query memory: 0.030 MB Memory before query: 1.663 MB Rows returned: 37

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

  FROM `qtnm6_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_extensions	ref	extension	extension	82	const	37	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.54 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:196
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: 8.23 ms Query memory: 0.023 MB Memory before query: 1.760 MB Rows returned: 5

SELECT id, rules

  FROM `qtnm6_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
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.34 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 1.772 MB Rows returned: 2

SELECT b.id

  FROM qtnm6_usergroups AS a

  LEFT JOIN qtnm6_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
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.51 ms After last query: 3.02 ms Query memory: 0.039 MB Memory before query: 1.795 MB Rows returned: 129

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

  FROM qtnm6_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	filtered	Extra
1	SIMPLE	qtnm6_extensions	ref	extension	extension	82	const	148	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
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:196
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.21 ms After last query: 71.75 ms Query memory: 0.147 MB Memory before query: 2.656 MB Rows returned: 94

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

  LEFT JOIN qtnm6_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	168	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	fitsc3_gpsnew.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	1.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
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: 29.07 ms Query memory: 0.023 MB Memory before query: 3.242 MB Rows returned: 1

SELECT `query`

  FROM qtnm6_eb_urls

  WHERE md5_key = '6c5fe7d3dc96f0626f1c875799f8ddb1'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:429
9	EventbookingRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
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.86 ms Query memory: 0.025 MB Memory before query: 3.250 MB Rows returned: 11

SELECT id, home, template, s.params

  FROM qtnm6_template_styles as s

  LEFT JOIN qtnm6_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	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	fitsc3_gpsnew.e.element	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/sunfw/includes/recognization.php:48
9	SunFwRecognization::detect()	JROOT/plugins/system/sunfw/sunfw.php:215
8	PlgSystemSunFw->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:1122
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:196
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.31 ms After last query: 27.47 ms Query memory: 0.023 MB Memory before query: 3.334 MB Rows returned: 1

SELECT COUNT(*)

  FROM qtnm6_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/utils.php:81
12	SunFwUtils::checkSH404SEF()	JROOT/plugins/system/sunfw/includes/overwrite/overwrite.php:84
11	SunFwOverwrite::initialize()	JROOT/plugins/system/sunfw/includes/site.php:114
10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:217
8	PlgSystemSunFw->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:1122
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:196
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.31 ms After last query: 4.52 ms Query memory: 0.028 MB Memory before query: 3.362 MB Rows returned: 1

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

  FROM `qtnm6_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/sunfw/includes/site.php:120
10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:217
8	PlgSystemSunFw->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:1122
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:196
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: 6.48 ms After last query: 0.25 ms Query memory: 0.007 MB Memory before query: 3.355 MB

UPDATE `qtnm6_extensions`

  SET `params` = '{\"mediaversion\":\"2bf8409f8287edb7a41aea731af90df0\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.08 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	6.15 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/sunfw/includes/site.php:120
10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:217
8	PlgSystemSunFw->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:1122
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:196
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.68 ms After last query: 6.75 ms Query memory: 0.098 MB Memory before query: 3.442 MB Rows returned: 2

SELECT ss.*

  FROM qtnm6_sunfw_styles AS ss

  INNER JOIN qtnm6_template_styles AS ts 
  ON ts.id = ss.style_id

  WHERE ts.id = 35

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ts	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	ss	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.41 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/sunfw/includes/helper.php:253
11	SunFwHelper::getSunFwStyle()	JROOT/plugins/system/sunfw/includes/site.php:133
10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:217
8	PlgSystemSunFw->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:1122
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:196
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: 2.23 ms Query memory: 0.025 MB Memory before query: 3.731 MB Rows returned: 2

SELECT *

  FROM qtnm6_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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.80 ms After last query: 24.04 ms Query memory: 0.045 MB Memory before query: 4.076 MB Rows returned: 255

SELECT `config_key`,`config_value`

  FROM qtnm6_eb_configs

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	255	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
9	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:160
8	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:66
7	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/components/com_eventbooking/eventbooking.php:14
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:196
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: 22.19 ms Query memory: 0.027 MB Memory before query: 4.152 MB Rows returned: 1

SELECT *

  FROM qtnm6_eb_themes

  WHERE published = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:314
9	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/controller.php:99
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.95 ms After last query: 32.77 ms Query memory: 0.050 MB Memory before query: 4.326 MB Rows returned: 121

SHOW FULL COLUMNS 
  FROM `qtnm6_eb_events`

Explain

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

Profile

Status	Duration
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:79
13	RADModelList->__construct()	JROOT/components/com_eventbooking/model/list.php:116
12	EventbookingModelList->__construct()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:115
11	RADModel::getInstance()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:358
10	RADController->getModel()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:303
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.19 ms After last query: 2.11 ms Query memory: 0.025 MB Memory before query: 4.370 MB Rows returned: 1

SELECT COUNT(*)

  FROM qtnm6_eb_events AS tbl

  WHERE (DATE(tbl.event_date) >= '2019-06-16' OR DATE(tbl.cut_off_date) >= '2019-06-16') 
  AND tbl.published = 1 
  AND tbl.hidden = 0 
  AND tbl.access IN (1,1,5) 
  AND  tbl.id IN (SELECT event_id 
  FROM qtnm6_eb_event_categories 
  WHERE category_id = 10) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2019-06-16 22:51:29') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2019-06-16 22:51:29')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tbl	ref	PRIMARY,idx_access,idx_published	idx_published	5	const	43	100.00	Using index condition; Using where
1	SIMPLE	<subquery2>	eq_ref	<auto_key>	<auto_key>	5	fitsc3_gpsnew.tbl.id	1	100.00	NULL
2	MATERIALIZED	qtnm6_eb_event_categories	ref	idx_event_id,idx_category_id	idx_category_id	5	const	21	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.59 ms
end	0.01 ms
removing tmp table	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:202
14	RADModelList->getTotal()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:164
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:56
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/category/html.php:83
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.66 ms After last query: 0.12 ms Query memory: 0.071 MB Memory before query: 4.375 MB Rows returned: 6

SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2019-06-16 22:51:29') AS date_diff,DATEDIFF(tbl.event_date, '2019-06-16 22:51:29') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2019-06-16 22:51:29') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2019-06-16 22:51:29') AS event_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.registration_start_date, '2019-06-16 22:51:29') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2019-06-16 22:51:29') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants

  FROM qtnm6_eb_events AS tbl

  LEFT JOIN qtnm6_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3))))

  LEFT JOIN qtnm6_eb_locations AS c 
  ON tbl.location_id = c.id 

  WHERE (DATE(tbl.event_date) >= '2019-06-16' OR DATE(tbl.cut_off_date) >= '2019-06-16') 
  AND tbl.published = 1 
  AND tbl.hidden = 0 
  AND tbl.access IN (1,1,5) 
  AND  tbl.id IN (SELECT event_id 
  FROM qtnm6_eb_event_categories 
  WHERE category_id = 10) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2019-06-16 22:51:29') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2019-06-16 22:51:29')

  GROUP BY tbl.id

  ORDER BY tbl.event_date ASC 
  LIMIT 30

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	<subquery2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	0.00	Using where; Using temporary; Using filesort
1	SIMPLE	tbl	eq_ref	PRIMARY,idx_category_id,idx_location_id,idx_parent_id,idx_access,idx_published,idx_event_date,idx_event_end_date,idx_alias	PRIMARY	4	<subquery2>.event_id	1	100.00	Using where
1	SIMPLE	b	ref	idx_event_id,idx_published	idx_event_id	5	<subquery2>.event_id	1	100.00	Using where
1	SIMPLE	c	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	43	76.74	Using where; Using join buffer (Block Nested Loop)
2	MATERIALIZED	qtnm6_eb_event_categories	ref	idx_event_id,idx_category_id	idx_category_id	5	const	21	100.00	NULL

Profile

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.18 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.08 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	2.02 ms
Creating sort index	0.52 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:178
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:56
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/category/html.php:83
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.46 ms After last query: 7.71 ms Query memory: 0.043 MB Memory before query: 4.478 MB Rows returned: 45

SELECT *

  FROM qtnm6_eb_locations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_locations	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	43	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:549
16	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:141
15	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/list.php:191
14	EventbookingModelList->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:180
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:56
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/category/html.php:83
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.50 ms After last query: 0.24 ms Query memory: 0.029 MB Memory before query: 4.565 MB Rows returned: 26

SELECT a.id, a.name, a.alias, b.event_id

  FROM qtnm6_eb_categories AS a

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

  WHERE b.event_id IN (41,50,38,44,39,40)

  ORDER BY b.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	index	idx_event_id,idx_category_id	PRIMARY	4	NULL	132	19.70	Using where
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	fitsc3_gpsnew.b.category_id	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:576
16	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:141
15	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/list.php:191
14	EventbookingModelList->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:180
13	RADModelList->getData()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/list.php:56
12	RADViewList->prepareView()	JROOT/components/com_eventbooking/view/category/html.php:83
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 69.02 ms Query memory: 0.030 MB Memory before query: 4.969 MB Rows returned: 1

SELECT *

  FROM qtnm6_eb_categories

  WHERE id=10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/database.php:35
13	EventbookingHelperDatabase::getCategory()	JROOT/components/com_eventbooking/model/list.php:165
12	EventbookingModelList->getCategory()	JROOT/components/com_eventbooking/view/category/html.php:93
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.99 ms After last query: 1.35 ms Query memory: 0.030 MB Memory before query: 4.982 MB Rows returned: 19

SHOW FULL COLUMNS 
  FROM `qtnm6_eb_categories`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:79
13	RADModelList->__construct()	JROOT/components/com_eventbooking/model/categories.php:21
12	EventbookingModelCategories->__construct()	JROOT/components/com_eventbooking/view/category/html.php:108
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.32 ms Query memory: 0.029 MB Memory before query: 4.996 MB Rows returned: 0

SELECT tbl.*

  FROM qtnm6_eb_categories AS tbl

  WHERE tbl.published=1 
  AND tbl.parent=10 
  AND tbl.access IN (1,1,5)

  ORDER BY tbl.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tbl	ref	idx_parent,idx_access,idx_published	idx_parent	5	const	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:178
12	RADModelList->getData()	JROOT/components/com_eventbooking/view/category/html.php:118
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.42 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 5.005 MB Rows returned: 65

SELECT `message_key`,`message`

  FROM qtnm6_eb_messages

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_messages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	65	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
13	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:391
12	EventbookingHelper::getMessages()	JROOT/components/com_eventbooking/view/category/html.php:139
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 9.09 ms Query memory: 0.026 MB Memory before query: 5.129 MB Rows returned: 7

SELECT id, parent,`name` AS `name`

  FROM qtnm6_eb_categories

  WHERE published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_categories	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	7	85.71	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:505
14	EventbookingHelperData::getCategoriesBreadcrumb()	JROOT/components/com_eventbooking/view/category/html.php:350
13	EventbookingViewCategoryHtml->buildPathway()	JROOT/components/com_eventbooking/view/category/html.php:258
12	EventbookingViewCategoryHtml->prepareDocument()	JROOT/components/com_eventbooking/view/category/html.php:190
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.17 ms Query memory: 0.027 MB Memory before query: 5.137 MB Rows returned: 7

SELECT id, parent,alias

  FROM qtnm6_eb_categories

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qtnm6_eb_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/route.php:223
15	EventbookingHelperRoute::getCategoriesPath()	JROOT/components/com_eventbooking/helper/route.php:90
14	EventbookingHelperRoute::getCategoryRoute()	JROOT/components/com_eventbooking/view/category/html.php:355
13	EventbookingViewCategoryHtml->buildPathway()	JROOT/components/com_eventbooking/view/category/html.php:258
12	EventbookingViewCategoryHtml->prepareDocument()	JROOT/components/com_eventbooking/view/category/html.php:190
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 4.11 ms Query memory: 0.027 MB Memory before query: 5.214 MB Rows returned: 1

Duplicate queries: #30 #42 #99

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '6c5fe7d3dc96f0626f1c875799f8ddb1'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
20	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
14	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:520
13	RADViewHtml->addFeedLinks()	JROOT/components/com_eventbooking/view/category/html.php:266
12	EventbookingViewCategoryHtml->prepareDocument()	JROOT/components/com_eventbooking/view/category/html.php:190
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.39 ms Query memory: 0.027 MB Memory before query: 5.226 MB Rows returned: 1

Duplicate queries: #29 #42 #99

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '6c5fe7d3dc96f0626f1c875799f8ddb1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
20	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
14	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:522
13	RADViewHtml->addFeedLinks()	JROOT/components/com_eventbooking/view/category/html.php:266
12	EventbookingViewCategoryHtml->prepareDocument()	JROOT/components/com_eventbooking/view/category/html.php:190
11	EventbookingViewCategoryHtml->prepareView()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 1.33 ms Query memory: 0.029 MB Memory before query: 5.262 MB Rows returned: 45

SELECT id, name

  FROM qtnm6_eb_locations

  WHERE published = 1

  ORDER BY name

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/database.php:222
15	EventbookingHelperDatabase::getAllLocations()	JROOT/components/com_eventbooking/themes/default/common/search.php:21
14	include JROOT/components/com_eventbooking/themes/default/common/search.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:65
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 28.48 ms Query memory: 0.029 MB Memory before query: 5.344 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = 'daf92cd226dcc72d592234cd305000a7'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.55 ms Query memory: 0.030 MB Memory before query: 5.363 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '5ed038e1b30e988722e16573a66c7b01'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.52 ms Query memory: 0.029 MB Memory before query: 5.377 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '010fc70cc8e4c036b60262282603d065'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.50 ms Query memory: 0.029 MB Memory before query: 5.389 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = 'f2f7bc386210f3f0c2946edbe51a221e'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.51 ms Query memory: 0.029 MB Memory before query: 5.402 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '0c2a393b378741365c3dda5cf8c90905'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.51 ms Query memory: 0.029 MB Memory before query: 5.414 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = 'becfe53df8528cf1d84a163a9ef4bd00'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:767
15	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:29
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.56 ms Query memory: 0.028 MB Memory before query: 5.427 MB Rows returned: 1

Duplicate queries: #76

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = 'db2fdb0392c58f8966f4679fbe1ec98d'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
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:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:237
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.55 ms Query memory: 0.028 MB Memory before query: 5.440 MB Rows returned: 1

Duplicate queries: #85

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '3d0bdc25ae0b23e99ace6455419ece92'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
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:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:237
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.54 ms Query memory: 0.028 MB Memory before query: 5.452 MB Rows returned: 1

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '407dfea51a1c0b9b65d7fe920c7264fd'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
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:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:237
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 16.43 ms Query memory: 0.028 MB Memory before query: 5.572 MB Rows returned: 0

SELECT id, name

  FROM qtnm6_fields

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/eventbooking/userprofile/userprofile.php:279
18	plgEventbookingUserprofile::getUserFields()	JROOT/plugins/eventbooking/userprofile/userprofile.php:37
17	plgEventbookingUserprofile->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
16	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
15	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_eventbooking/themes/default/common/events_table.php:537
14	include JROOT/components/com_eventbooking/themes/default/common/events_table.php	JROOT/components/com_eventbooking/helper/html.php:183
13	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/category/table.php:81
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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: 15.86 ms Query memory: 0.027 MB Memory before query: 5.614 MB Rows returned: 1

Duplicate queries: #29 #30 #99

SELECT id

  FROM qtnm6_eb_urls

  WHERE md5_key = '6c5fe7d3dc96f0626f1c875799f8ddb1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/category/table.php:100
12	include JROOT/components/com_eventbooking/themes/default/category/table.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:249
11	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:133
10	RADViewHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
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:196
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.31 ms After last query: 7.83 ms Query memory: 0.024 MB Memory before query: 5.568 MB Rows returned: 1

SELECT params

  FROM qtnm6_extensions

  WHERE type = 'template' 
  AND element = 'jsn_meetup'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database

Narcotics

Upcoming Events

Thank You

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

99 Queries Logged 70.68 ms

16 duplicate found!