- Pool Cars

BMW i3 GX20KJY

BMW i3, 5 door hatchback and 100% electric and zero emission. Great to drive will travel 140 miles on a full charge. Rear seats fold to give a versatile car with lots of boot space or will hold 5 adults. You will need to plan your journey PLEASE NOTE: Driver familiarisation is ...

Make a Reservation

BMW i 3 GX 20 KKJ

BMW i3 auto 5 door Reg LC16WVW, 5 door hatchback and 100% electric and zero emission. Great to drive will travel 120 miles on a full charge. Rear seats fold to give a versatile car with lots of boot space or will hold 5 adults. You will need to plan your journey PLEASE ...

Make a Reservation

Renault Zoe RJ 72 OAA

Renault Zoe, 5 door hatchback and 100% electric and zero emission. Great to drive will travel up to 238 miles on a full charge. Rear seats fold to give a versatile car with lots of boot space or will hold 4 adults. You will need to plan your journey PLEASE NOTE: Driver ...

Make a Reservation

Renault Zoe RJ 72 OJW

Make a Reservation

Renault Zoe RJ 72 OJD

Renault Zoe EV auto 5 door hatchback and 100% electric and zero emission. Great to drive will travel up to 238 miles on a full charge. Rear seats fold to give a versatile car with lots of boot space or will hold 4 adults. You will need to plan your journey PLEASE NOTE: Driver ...

Make a Reservation

Folding Cycle - Free loan cycle

A unisex folding bike, ideal for a short journey

Make a Reservation

Mountain Bike - Unisex - Free loan

Make a Reservation

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701698034,
                "last": 1701698034,
                "now": 1701698034
            },
            "token": "OQ8HVSRlttCqsGWWlfFdWueqUrlooQTs"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3d3dy5wb29sY2Fycy5jby8%2F"
            }
        },
        "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
        }
    }
}

Profile Information

Memory Usage

Database Queries

44 Queries Logged 32.21 ms

Query Time: 0.85 ms Query memory: 0.021 MB Memory before query: 4.606 MB Rows returned: 0

SELECT `data`

  FROM `wdbov6quv_jos_session`

  WHERE `session_id` = X'316d6e3669753367336a6b716938623533393435646331373030'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_session	const	PRIMARY	PRIMARY	766	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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.25 ms After last query: 1.03 ms Query memory: 0.013 MB Memory before query: 4.780 MB Rows returned: 0

SELECT `session_id`

  FROM `wdbov6quv_jos_session`

  WHERE `session_id` = X'316d6e3669753367336a6b716938623533393435646331373030' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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: 0.59 ms After last query: 0.09 ms Query memory: 0.010 MB Memory before query: 4.797 MB

INSERT INTO `wdbov6quv_jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'316d6e3669753367336a6b716938623533393435646331373030', 1, 1701698034, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `wdbov6quv_jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'316d6e3669753367336a6b716938623533393435646331373030', 1, 1701698034, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
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: 0.70 ms After last query: 2.07 ms Query memory: 0.023 MB Memory before query: 5.132 MB Rows returned: 41

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

  FROM `wdbov6quv_jos_extensions`

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

Explain

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

Profile

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

Call Stack

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

SELECT id, rules

  FROM `wdbov6quv_jos_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.55 ms After last query: 0.09 ms Query memory: 0.015 MB Memory before query: 5.469 MB Rows returned: 2

SELECT b.id

  FROM wdbov6quv_jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.57 ms After last query: 0.55 ms Query memory: 0.019 MB Memory before query: 5.572 MB Rows returned: 97

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

  FROM wdbov6quv_jos_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

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

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

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

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

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php: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.33 ms After last query: 6.75 ms Query memory: 0.020 MB Memory before query: 8.691 MB Rows returned: 1

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

  FROM `wdbov6quv_jos_extensions`

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

Explain

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

Profile

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

Call Stack

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

UPDATE `wdbov6quv_jos_extensions`

  SET `params` = '{\"mediaversion\":\"6c566abbe33b324cef50a672342a63c8\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.55 ms After last query: 1.56 ms Query memory: 0.014 MB Memory before query: 9.059 MB Rows returned: 1

SELECT *

  FROM wdbov6quv_jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

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

SELECT id, home, template, s.params

  FROM wdbov6quv_jos_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	4	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.86 ms After last query: 14.91 ms Query memory: 0.033 MB Memory before query: 12.253 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_article`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_booking/tables/article.php:22
19	TableArticle->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:969
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_booking/models/article.php:49
14	BookingModelArticle->getItem()	JROOT/administrator/components/com_booking/helpers/config.php:522
13	BookingConfig->init()	JROOT/administrator/components/com_booking/helpers/config.php:233
12	BookingConfig->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:45
11	AFactory::getConfig()	JROOT/administrator/components/com_booking/defines.php:65
10	include_once JROOT/administrator/components/com_booking/defines.php	JROOT/administrator/components/com_booking/helpers/importer.php:72
9	AImporter::importFile()	JROOT/administrator/components/com_booking/helpers/importer.php:150
8	AImporter::defines()	JROOT/administrator/components/com_booking/booking.php:48
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.38 ms After last query: 1.01 ms Query memory: 0.025 MB Memory before query: 12.325 MB Rows returned: 1

SELECT *

  FROM wdbov6quv_jos_booking_article

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:974
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_booking/models/article.php:49
14	BookingModelArticle->getItem()	JROOT/administrator/components/com_booking/helpers/config.php:522
13	BookingConfig->init()	JROOT/administrator/components/com_booking/helpers/config.php:233
12	BookingConfig->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:45
11	AFactory::getConfig()	JROOT/administrator/components/com_booking/defines.php:65
10	include_once JROOT/administrator/components/com_booking/defines.php	JROOT/administrator/components/com_booking/helpers/importer.php:72
9	AImporter::importFile()	JROOT/administrator/components/com_booking/helpers/importer.php:150
8	AImporter::defines()	JROOT/administrator/components/com_booking/booking.php:48
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.53 ms Query memory: 0.025 MB Memory before query: 12.350 MB Rows returned: 1

SELECT *

  FROM wdbov6quv_jos_booking_article

  WHERE `id` = '2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:974
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_booking/models/article.php:49
14	BookingModelArticle->getItem()	JROOT/administrator/components/com_booking/helpers/config.php:524
13	BookingConfig->init()	JROOT/administrator/components/com_booking/helpers/config.php:233
12	BookingConfig->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:45
11	AFactory::getConfig()	JROOT/administrator/components/com_booking/defines.php:65
10	include_once JROOT/administrator/components/com_booking/defines.php	JROOT/administrator/components/com_booking/helpers/importer.php:72
9	AImporter::importFile()	JROOT/administrator/components/com_booking/helpers/importer.php:150
8	AImporter::defines()	JROOT/administrator/components/com_booking/booking.php:48
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.40 ms After last query: 1.04 ms Query memory: 0.019 MB Memory before query: 12.402 MB Rows returned: 5

SELECT `id`,`title` 
  FROM `wdbov6quv_jos_viewlevels` 
  ORDER BY `ordering`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/administrator/components/com_booking/helpers/model.php:641
11	AModel::getAccesList()	JROOT/administrator/components/com_booking/defines.php:156
10	include_once JROOT/administrator/components/com_booking/defines.php	JROOT/administrator/components/com_booking/helpers/importer.php:72
9	AImporter::importFile()	JROOT/administrator/components/com_booking/helpers/importer.php:150
8	AImporter::defines()	JROOT/administrator/components/com_booking/booking.php:48
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.31 ms After last query: 19.63 ms Query memory: 0.036 MB Memory before query: 16.013 MB Rows returned: 34

SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_subject`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_booking/tables/subject.php:477
19	TableSubject->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_booking/models/subjects.php:36
15	BookingModelSubjects->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
14	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
13	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
12	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.61 ms After last query: 0.58 ms Query memory: 0.034 MB Memory before query: 16.173 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_template`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
21	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_booking/tables/template.php:58
20	TableTemplate->__construct()	JROOT/libraries/src/Table/Table.php:312
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_booking/models/template.php:32
16	BookingModelTemplate->__construct()	JROOT/administrator/components/com_booking/helpers/template.php:56
15	ATemplateHelper->loadTemplates()	JROOT/administrator/components/com_booking/helpers/template.php:34
14	ATemplateHelper->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:30
13	AFactory->getTemplateHelper()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:191
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.34 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 16.209 MB Rows returned: 1

SELECT COUNT(`id`) 
  FROM `wdbov6quv_jos_booking_template`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_template	index	NULL	PRIMARY	4	NULL	14	Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_booking/models/template.php:120
16	BookingModelTemplate->loadList()	JROOT/administrator/components/com_booking/helpers/template.php:57
15	ATemplateHelper->loadTemplates()	JROOT/administrator/components/com_booking/helpers/template.php:34
14	ATemplateHelper->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:30
13	AFactory->getTemplateHelper()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:191
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.06 ms Query memory: 0.026 MB Memory before query: 16.232 MB Rows returned: 15

SELECT * 
  FROM `wdbov6quv_jos_booking_template` 
  LIMIT 0, 100

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_booking/models/template.php:123
16	BookingModelTemplate->loadList()	JROOT/administrator/components/com_booking/helpers/template.php:57
15	ATemplateHelper->loadTemplates()	JROOT/administrator/components/com_booking/helpers/template.php:34
14	ATemplateHelper->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:30
13	AFactory->getTemplateHelper()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:191
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.56 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 16.272 MB Rows returned: 140

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_booking/helpers/model.php:497
19	AModel->tableExists()	JROOT/administrator/components/com_booking/helpers/booking.php:2873
18	BookingHelper->joomFishIsActive()	JROOT/administrator/components/com_booking/helpers/template.php:264
17	ATemplate->translateParam()	JROOT/administrator/components/com_booking/helpers/template.php:220
16	ATemplate->init()	JROOT/administrator/components/com_booking/helpers/template.php:64
15	ATemplateHelper->loadTemplates()	JROOT/administrator/components/com_booking/helpers/template.php:34
14	ATemplateHelper->__construct()	JROOT/administrator/components/com_booking/helpers/factory.php:30
13	AFactory->getTemplateHelper()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:191
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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: 0.79 ms Query memory: 0.029 MB Memory before query: 16.407 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_subject` 
  WHERE `access` IN (1,1) 
  AND `id` = 0 
  AND (`publish_up` <= '2023-12-04 13:53:54' OR `publish_up` = '0000-00-00 00:00:00') 
  AND (`publish_down` >= '2023-12-04 13:53:54' OR `publish_down` = '0000-00-00 00:00:00') 
  AND `state` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_booking/models/subject.php:53
13	BookingModelSubject->getObject()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:242
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.30 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 16.440 MB Rows returned: 2

SELECT DISTINCT `template` 
  FROM `wdbov6quv_jos_booking_subject` 
  WHERE `state` = 1 
  AND `access` IN (1,1) 
  AND `parent` = 0 
  AND (`publish_up` <= '2023-12-04 13:53:54' OR `publish_up` = '0000-00-00 00:00:00') 
  AND (`publish_down` >= '2023-12-04 13:53:54' OR `publish_down` = '0000-00-00 00:00:00')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_booking/models/subjects.php:270
13	BookingModelSubjects->getAvailableTemplates()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:268
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.09 ms After last query: 1.13 ms Query memory: 0.024 MB Memory before query: 16.634 MB Rows returned: 7

SELECT s.id, s.title, s.alias, s.featured, s.template, s.introtext, s.params, COUNT(k.id) AS children 
  FROM wdbov6quv_jos_booking_subject AS s 
  LEFT JOIN wdbov6quv_jos_booking_subject AS k 
  ON k.parent = s.id  
  WHERE s.state = 1 
  AND s.access IN (1,1) 
  AND k.id IS NULL 
  AND (s.publish_up <= '2023-12-04 13:53:54' OR s.publish_up = '0000-00-00 00:00:00') 
  AND (s.publish_down >= '2023-12-04 13:53:54' OR s.publish_down = '0000-00-00 00:00:00') 
  GROUP BY s.id  
  ORDER BY s.featured DESC, s.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Using temporary; Using filesort
1	SIMPLE	k	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Not exists; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/administrator/components/com_booking/models/subjects.php:102
14	BookingModelSubjects->getTotal()	JROOT/administrator/components/com_booking/helpers/model.php:261
13	AModel->getPagination()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:308
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.63 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 16.658 MB Rows returned: 7

SELECT s.id, s.title, s.alias, s.featured, s.template, s.introtext, s.params, COUNT(k.id) AS children 
  FROM wdbov6quv_jos_booking_subject AS s 
  LEFT JOIN wdbov6quv_jos_booking_subject AS k 
  ON k.parent = s.id  
  WHERE s.state = 1 
  AND s.access IN (1,1) 
  AND k.id IS NULL 
  AND (s.publish_up <= '2023-12-04 13:53:54' OR s.publish_up = '0000-00-00 00:00:00') 
  AND (s.publish_down >= '2023-12-04 13:53:54' OR s.publish_down = '0000-00-00 00:00:00') 
  GROUP BY s.id  
  ORDER BY s.featured DESC, s.ordering ASC 
  LIMIT 0, 40

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Using temporary; Using filesort
1	SIMPLE	k	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Not exists; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_booking/models/subjects.php:59
13	BookingModelSubjects->getData()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:309
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.75 ms After last query: 1.45 ms Query memory: 0.038 MB Memory before query: 16.911 MB Rows returned: 4

SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_occupancy_type`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_booking/tables/occupancytype.php:45
23	TableOccupancyType->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_booking/models/occupancytypes.php:35
19	BookingModelOccupancyTypes->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
18	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.73 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 16.955 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 14

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.37 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 16.968 MB Rows returned: 2

SELECT `parent`, COUNT(`id`) 
  FROM `wdbov6quv_jos_booking_subject` 
  GROUP BY `parent`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
17	JDatabaseDriver->loadRowList()	JROOT/administrator/components/com_booking/models/subject.php:531
16	BookingModelSubject->haveChilds()	JROOT/components/com_booking/views/subjects/tmpl/default.php:112
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.16 ms After last query: 0.57 ms Query memory: 0.024 MB Memory before query: 16.999 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 14

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.53 ms After last query: 1.38 ms Query memory: 0.028 MB Memory before query: 17.062 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 16

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.26 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 17.077 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 16

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.32 ms After last query: 0.56 ms Query memory: 0.028 MB Memory before query: 17.113 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 19

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.29 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 17.128 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 19

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.70 ms After last query: 1.18 ms Query memory: 0.028 MB Memory before query: 17.165 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 20

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.29 ms After last query: 0.46 ms Query memory: 0.024 MB Memory before query: 17.179 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 20

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.35 ms After last query: 1.13 ms Query memory: 0.028 MB Memory before query: 17.215 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 21

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.52 ms Query memory: 0.024 MB Memory before query: 17.230 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 21

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.45 ms After last query: 0.58 ms Query memory: 0.028 MB Memory before query: 17.266 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 23

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.30 ms After last query: 0.80 ms Query memory: 0.024 MB Memory before query: 17.280 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 23

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.51 ms After last query: 1.61 ms Query memory: 0.028 MB Memory before query: 17.317 MB Rows returned: 0

SELECT *

  FROM wdbov6quv_jos_booking_occupancy_type

  WHERE subject = 24

  ORDER BY type

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	wdbov6quv_jos_booking_occupancy_type	ref	subject_id	subject_id	4	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_booking/models/occupancytypes.php:41
18	BookingModelOccupancyTypes->getData()	JROOT/administrator/components/com_booking/tables/subject.php:654
17	TableSubject->prepare()	JROOT/administrator/components/com_booking/tables/subject.php:591
16	TableSubject->bind()	JROOT/components/com_booking/views/subjects/tmpl/default.php:109
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.26 ms After last query: 0.43 ms Query memory: 0.024 MB Memory before query: 17.331 MB Rows returned: 0

SELECT * 
  FROM `wdbov6quv_jos_booking_template_2` 
  WHERE `id` = 24

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/administrator/components/com_booking/helpers/template.php:249
16	ATemplate->loadObjectParams()	JROOT/components/com_booking/views/subjects/tmpl/default.php:175
15	include JROOT/components/com_booking/views/subjects/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_booking/views/subjects/view.html.php:357
12	BookingViewSubjects->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_booking/controllers/controller.php:56
10	BookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_booking/helpers/controller.php:45
8	AController->execute()	JROOT/administrator/components/com_booking/booking.php:95
7	include_once JROOT/administrator/components/com_booking/booking.php	JROOT/components/com_booking/booking.php:18
6	require_once JROOT/components/com_booking/booking.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.12 ms After last query: 5.94 ms Query memory: 0.022 MB Memory before query: 17.699 MB Rows returned: 7

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

  FROM wdbov6quv_jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-04 13:53:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-04 13:53:54') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	26	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	poolcars_db1.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	poolcars_db1.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:100
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.63 ms After last query: 6.41 ms Query memory: 0.022 MB Memory before query: 18.014 MB Rows returned: 0

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `wdbov6quv_jos_contentitem_tag_map` AS `m`

  INNER JOIN `wdbov6quv_jos_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `wdbov6quv_jos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2023-12-04 13:53:54') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2023-12-04 13:53:54')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_core_content_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	poolcars_db1.m.core_content_id	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	poolcars_db1.m.tag_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
14	ModTagsPopularHelper::getList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:592
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.61 ms After last query: 11.68 ms Query memory: 0.036 MB Memory before query: 18.936 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM wdbov6quv_jos_fields AS a

  LEFT JOIN `wdbov6quv_jos_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN wdbov6quv_jos_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN wdbov6quv_jos_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN wdbov6quv_jos_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN wdbov6quv_jos_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	poolcars_db1.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	poolcars_db1.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	poolcars_db1.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	poolcars_db1.a.group_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT * 
  FROM wdbov6quv_jos_booking_occupancy_type

7 × SELECT * 
  FROM `wdbov6quv_jos_booking_template_2`

2 × SELECT s.id, s.title, s.alias, s.featured, s.template, s.introtext, s.params, COUNT(k.id) AS children 
  FROM wdbov6quv_jos_booking_subject AS s 
  LEFT JOIN wdbov6quv_jos_booking_subject AS k 
  ON k.parent = s.id

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

2 × SELECT * 
  FROM wdbov6quv_jos_booking_article

1 × SELECT DISTINCT `template` 
  FROM `wdbov6quv_jos_booking_subject`

1 × SELECT * 
  FROM `wdbov6quv_jos_booking_subject`

1 × SELECT `parent`, COUNT(`id`) 
  FROM `wdbov6quv_jos_booking_subject` 
  GROUP BY `parent

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `wdbov6quv_jos_contentitem_tag_map` AS `m` 
  INNER JOIN `wdbov6quv_jos_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `wdbov6quv_jos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

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

1 × SELECT * 
  FROM `wdbov6quv_jos_booking_template` 
  LIMIT 0, 10

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM wdbov6quv_jos_fields AS a 
  LEFT JOIN `wdbov6quv_jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN wdbov6quv_jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN wdbov6quv_jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN wdbov6quv_jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN wdbov6quv_jos_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `id`,`title` 
  FROM `wdbov6quv_jos_viewlevels`

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

1 × SELECT id, rules 
  FROM `wdbov6quv_jos_viewlevels

1 × SELECT `session_id` 
  FROM `wdbov6quv_jos_session`

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

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

1 × SELECT `data` 
  FROM `wdbov6quv_jos_session`

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

1 × SELECT * 
  FROM wdbov6quv_jos_languages

1 × SELECT COUNT(`id`) 
  FROM `wdbov6quv_jos_booking_template

OTHER Tables:

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_occupancy_type

1 × SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_template

1 × SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_subject

1 × UPDATE `wdbov6quv_jos_extensions` 
  SET `params` = '{\"mediaversion\":\"6c566abbe33b324cef50a672342a63c8\"}'

1 × SHOW FULL COLUMNS 
  FROM `wdbov6quv_jos_booking_article

1 × INSERT INTO `wdbov6quv_jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'316d6e3669753367336a6b716938623533393435646331373030', 1, 1701698034, 0, '', 0