Vandelia - Bed & Brekfast

Fig Tree Room

Is strictly forbidden to smoke in our rooms.

This room is equipped with:

Pet Friendly zone (small pets are allowed) Supplement € 10
Air conditioner and heating
Free Wi-fi
TV Led 32”
Simmons Mattresses and pillows
Private Bathroom
Hair dryer
Botanica courtesy line
Hydro-massage shower

Request Information

Starting From € 75 for night

camera / room / habitación

Amenities

Availability Calendar

Available Not Available

Select a check-in and check-out date

I bambini fino a 1 anno di età che dormono in culla pagano € 5,00 a notte.

Vandelia Bed & Breakfast - Molfetta

Corso Umberto I, 98 - 70056 Molfetta (Bari)
Pino +39 340 9782 849 - Rosalba +39 347 223 1855
info@vandeliabeb.com
CIN: IT0702029B40027063

Book Now

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1769290458,
                "last": 1769290458,
                "now": 1769290458
            },
            "token": "iT3EIiagbOlh4n6E4BzRJ2nKqOOP39KY"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "com_rsfirewall": {
            "geoip": {
                "216.73.216.190": "US"
            }
        },
        "vbuseragent": "computer",
        "vboTFP": "0411a114a7fcc6e3a8b594068aff62a1",
        "vboTidentifier": 1769290458,
        "vboTreferrer": "",
        "vbgetTimeOpenStore": [
            "57600",
            "37800"
        ],
        "vboreqinfo5": 993
    }
}

Profile Information

Time

Memory

Time: 39.85 ms / 39.85 ms Memory: 0.431 MB / 0.78 MB Application: afterLoad

Time: 174.48 ms / 214.33 ms Memory: 1.863 MB / 2.64 MB Application: afterInitialise

Time: 56.29 ms / 270.62 ms Memory: 1.011 MB / 3.65 MB Application: afterRoute

Time: 3.97 ms / 274.59 ms Memory: 0.030 MB / 3.68 MB Application: beforeRenderComponent com_vikbooking

Time: 268.33 ms / 542.92 ms Memory: 6.128 MB / 9.81 MB Application: afterRenderComponent com_vikbooking

Time: 6.96 ms / 549.87 ms Memory: 0.110 MB / 9.92 MB Application: afterDispatch

Time: 14.28 ms / 564.15 ms Memory: 0.485 MB / 10.41 MB Application: beforeRenderModule mod_custom (Footer Vandelia)

Time: 2.22 ms / 566.37 ms Memory: 0.006 MB / 10.41 MB Application: afterRenderModule mod_custom (Footer Vandelia)

Time: 10.33 ms / 576.70 ms Memory: 0.034 MB / 10.45 MB Application: beforeRenderModule mod_languages (Lingua)

Time: 6.03 ms / 582.74 ms Memory: 0.020 MB / 10.47 MB Application: afterRenderModule mod_languages (Lingua)

Time: 0.05 ms / 582.79 ms Memory: -0.001 MB / 10.47 MB Application: beforeRenderModule mod_custom (Book Now)

Time: 4.23 ms / 587.02 ms Memory: 0.014 MB / 10.48 MB Application: afterRenderModule mod_custom (Book Now)

Time: 2.09 ms / 589.11 ms Memory: 0.017 MB / 10.50 MB Application: beforeRenderModule mod_custom (Logo small)

Time: 1.60 ms / 590.71 ms Memory: 0.004 MB / 10.50 MB Application: afterRenderModule mod_custom (Logo small)

Time: 1.08 ms / 591.78 ms Memory: 0.003 MB / 10.50 MB Application: beforeRenderModule mod_menu (Main menu en-GB)

Time: 6.97 ms / 598.75 ms Memory: 0.064 MB / 10.57 MB Application: afterRenderModule mod_menu (Main menu en-GB)

Time: 9.99 ms / 608.74 ms Memory: 0.061 MB / 10.63 MB Application: beforeRenderModule mod_menu (Footer Menu EN)

Time: 4.31 ms / 613.05 ms Memory: 0.031 MB / 10.66 MB Application: afterRenderModule mod_menu (Footer Menu EN)

Time: 3.00 ms / 616.06 ms Memory: 0.001 MB / 10.66 MB Application: beforeRenderModule mod_menu (Offcanvas Menu EN)

Time: 4.73 ms / 620.78 ms Memory: 0.006 MB / 10.67 MB Application: afterRenderModule mod_menu (Offcanvas Menu EN)

Time: 0.05 ms / 620.83 ms Memory: -0.002 MB / 10.66 MB Application: beforeRenderModule mod_languages (Lingua)

Time: 4.05 ms / 624.89 ms Memory: 0.004 MB / 10.67 MB Application: afterRenderModule mod_languages (Lingua)

Time: 0.05 ms / 624.94 ms Memory: -0.000 MB / 10.67 MB Application: beforeRenderModule mod_custom (Book Now)

Time: 2.15 ms / 627.08 ms Memory: 0.004 MB / 10.67 MB Application: afterRenderModule mod_custom (Book Now)

Time: 17.84 ms / 644.93 ms Memory: 0.264 MB / 10.93 MB Application: afterRender

Database queries total: 73.71 ms

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

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

EXPLAIN not possible on query: INSERT INTO `exeju_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6437337569656274766b7668713376356876366b76686a336e6d', 1, 1769290458, 0, '', 0)

Profile

Status	Duration
starting	0.06 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
After table lock	0.01 ms
init	0.02 ms
update	0.14 ms
end	0.02 ms
query end	0.66 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.43 ms After last query: 5.06 ms Query memory: 0.040 MB Memory before query: 1.102 MB Rows returned: 43

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

  FROM `exeju_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	exeju_extensions	ref	extension	extension	82	const	43	Using index condition; Using where

Profile

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

Call Stack

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

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

Query Time: 0.64 ms After last query: 6.09 ms Query memory: 0.021 MB Memory before query: 1.136 MB Rows returned: 5

SELECT id, rules

  FROM `exeju_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.25 ms Query memory: 0.021 MB Memory before query: 1.148 MB Rows returned: 2

SELECT b.id

  FROM exeju_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

Query Time: 2.29 ms After last query: 0.70 ms Query memory: 0.030 MB Memory before query: 1.169 MB Rows returned: 104

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

  FROM exeju_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_extensions	ref	extension	extension	82	const	126	Using index condition; 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
After table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.96 ms
Sending data	0.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 11.67 ms Query memory: 0.021 MB Memory before query: 1.456 MB Rows returned: 3

SELECT `path`

  FROM exeju_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:56
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:41
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 1.462 MB Rows returned: 0

SELECT `file`

  FROM exeju_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.51 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:63
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:41
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 1.467 MB Rows returned: 68

SELECT *

  FROM exeju_rsfirewall_configuration

Explain

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

Profile

Status	Duration
starting	0.05 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
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:71
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:41
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.88 ms After last query: 6.39 ms Query memory: 0.024 MB Memory before query: 1.704 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `exeju_rsfirewall_logs`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.72 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.16 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.16 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:38
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:31
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:84
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:60
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.94 ms After last query: 9.26 ms Query memory: 0.097 MB Memory before query: 1.767 MB Rows returned: 69

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

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.08 ms
executing	0.01 ms
Sorting result	0.73 ms
Sending data	1.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
11	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
10	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jmap/jmap.php:1535
7	plgSystemJMap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 17.88 ms Query memory: 0.021 MB Memory before query: 2.371 MB Rows returned: 3

SELECT *

  FROM exeju_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 2.380 MB Rows returned: 6

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

  FROM `exeju_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 61.57 ms Query memory: 0.025 MB Memory before query: 2.624 MB Rows returned: 1

SELECT id,template 
  FROM exeju_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 18.81 ms Query memory: 0.021 MB Memory before query: 3.248 MB Rows returned: 4

SELECT *

  FROM exeju_rsfirewall_hashes

  WHERE (`type`='3.10.12' OR `type`='protect') 
  AND (`flag`!='C' OR `flag` IS NULL)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1109
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 1.12 ms Query memory: 0.021 MB Memory before query: 3.257 MB Rows returned: 0

SELECT *

  FROM exeju_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1132
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.265 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM exeju_rsfirewall_lists

  WHERE (`ip`='216.73.216.190' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_rsfirewall_lists	ref	published,type,ip	type	1	const	7	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:175
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:154
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1168
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 3.272 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM exeju_rsfirewall_lists

  WHERE (`ip`='216.73.216.190' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_rsfirewall_lists	ALL	published,type,ip	NO INDEX KEY COULD BE USED	NULL	NULL	423	Using where

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:175
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1172
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 14.57 ms Query memory: 0.021 MB Memory before query: 3.532 MB Rows returned: 0

SELECT *

  FROM exeju_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:760
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1309
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 14.11 ms Query memory: 0.022 MB Memory before query: 3.618 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM exeju_template_styles as s

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

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

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 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.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
12	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_widgetkit/widgetkit.php:43
11	plgSystemWidgetkit->{closure}()	Same as call in the line below.
10	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
9	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:132
8	YOOtheme\Framework\Application->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/JoomlaPlugin.php:141
7	YOOtheme\Framework\Joomla\JoomlaPlugin->init()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 6.33 ms Query memory: 0.022 MB Memory before query: 3.672 MB Rows returned: 1

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

  FROM `exeju_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.88 ms After last query: 0.23 ms Query memory: 0.005 MB Memory before query: 3.662 MB

UPDATE `exeju_extensions`

  SET `params` = '{\"mediaversion\":\"3d249a5660b28336fbe861a8fd0ef844\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `exeju_extensions` SET `params` = '{\"mediaversion\":\"3d249a5660b28336fbe861a8fd0ef844\"}' 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.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.07 ms
Updating	0.08 ms
end	0.01 ms
query end	0.54 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.76 ms After last query: 37.86 ms Query memory: 0.005 MB Memory before query: 6.180 MB


  SET SQL_BIG_SELECTS=1

Explain

EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

Profile

Status	Duration
starting	0.04 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_vikbooking/helpers/jv_helper.php:384
8	VboApplication->normalizeDbDriver()	JROOT/administrator/components/com_vikbooking/helpers/jv_helper.php:76
7	VboApplication->normalizeExecution()	JROOT/components/com_vikbooking/vikbooking.php:38
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 2.78 ms Query memory: 0.022 MB Memory before query: 6.244 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'bootstrap' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
10	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
9	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
8	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1654
7	VikBooking::loadBootstrap()	JROOT/components/com_vikbooking/vikbooking.php:42
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 6.252 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'usefa' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
11	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
10	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
9	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:111
8	VikBooking::isFontAwesomeEnabled()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:116
7	VikBooking::loadFontAwesome()	JROOT/components/com_vikbooking/vikbooking.php:46
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 7.21 ms Query memory: 0.022 MB Memory before query: 6.357 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'appearance_pref' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
10	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
9	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13390
8	VikBooking::getAppearancePref()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13413
7	VikBooking::loadAppearancePreferenceAssets()	JROOT/components/com_vikbooking/vikbooking.php:55
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 6.364 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'appearance_front' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
10	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
9	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
8	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13430
7	VikBooking::loadAppearancePreferenceAssets()	JROOT/components/com_vikbooking/vikbooking.php:55
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 24.04 ms Query memory: 0.023 MB Memory before query: 7.779 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'trkenabled' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	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_vikbooking/helpers/src/config/registry/database.php:75
13	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
12	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
11	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/tracker.php:158
10	VikBookingTracker->getFingerprint()	JROOT/components/com_vikbooking/helpers/tracker.php:115
9	VikBookingTracker->__construct()	JROOT/components/com_vikbooking/helpers/tracker.php:131
8	VikBookingTracker::getInstance()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1717
7	VikBooking::getTracker()	JROOT/components/com_vikbooking/vikbooking.php:68
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 7.785 MB Rows returned: 1

Duplicate queries: #30

SELECT `param`, `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param` IN ('trkcampaigns');

Explain

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

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/tracker.php:1215
12	VikBookingTracker::loadSettings()	JROOT/components/com_vikbooking/helpers/tracker.php:1239
11	VikBookingTracker::loadCampaigns()	JROOT/components/com_vikbooking/helpers/tracker.php:327
10	VikBookingTracker->getReferrer()	JROOT/components/com_vikbooking/helpers/tracker.php:118
9	VikBookingTracker->__construct()	JROOT/components/com_vikbooking/helpers/tracker.php:131
8	VikBookingTracker::getInstance()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1717
7	VikBooking::getTracker()	JROOT/components/com_vikbooking/vikbooking.php:68
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 7.791 MB Rows returned: 1

Duplicate queries: #29

SELECT `param`, `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param` IN ('trkcampaigns');

Explain

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

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/tracker.php:1219
12	VikBookingTracker::loadSettings()	JROOT/components/com_vikbooking/helpers/tracker.php:1239
11	VikBookingTracker::loadCampaigns()	JROOT/components/com_vikbooking/helpers/tracker.php:327
10	VikBookingTracker->getReferrer()	JROOT/components/com_vikbooking/helpers/tracker.php:118
9	VikBookingTracker->__construct()	JROOT/components/com_vikbooking/helpers/tracker.php:131
8	VikBookingTracker::getInstance()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1717
7	VikBooking::getTracker()	JROOT/components/com_vikbooking/vikbooking.php:68
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 7.797 MB Rows returned: 1

Duplicate queries: #32

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='pref_colors';

Explain

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

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13170
8	VikBooking::getPreferredColors()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13194
7	VikBooking::loadPreferredColorStyles()	JROOT/components/com_vikbooking/vikbooking.php:69
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 7.802 MB Rows returned: 1

Duplicate queries: #31

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='pref_colors';

Explain

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

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13172
8	VikBooking::getPreferredColors()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13194
7	VikBooking::loadPreferredColorStyles()	JROOT/components/com_vikbooking/vikbooking.php:69
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.88 ms After last query: 18.03 ms Query memory: 0.023 MB Memory before query: 8.730 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_rooms` 
  WHERE `id`='5' 
  AND `avail`='1';

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:25
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 8.743 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'multilang' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
16	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
15	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
14	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1659
13	VikBooking::allowMultiLanguage()	JROOT/components/com_vikbooking/helpers/translator.php:817
12	VikBookingTranslator->allowMultiLanguage()	JROOT/components/com_vikbooking/helpers/translator.php:542
11	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:27
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.55 ms After last query: 1.34 ms Query memory: 0.022 MB Memory before query: 8.754 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_rooms' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (5);

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
11	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:27
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 8.765 MB Rows returned: 1

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='dateformat' 
  LIMIT 0, 1

Explain

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

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.00 ms
Table lock	0.00 ms
After table lock	0.00 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	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2789
11	VikBooking::getDateFormat()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:35
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 8.773 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'timeopenstore' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
13	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
12	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2547
11	VikBooking::getTimeOpenStore()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:41
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 8.780 MB Rows returned: 1

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='datesep' 
  LIMIT 0, 1

Explain

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

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2823
12	VikBooking::getDateSeparator()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3383
11	VikBooking::getDateTimestamp()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:50
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 8.786 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_dispcost` 
  WHERE `idroom`='5' 
  ORDER BY `exeju_vikbooking_dispcost`.`days` ASC, `exeju_vikbooking_dispcost`.`cost` ASC 
  LIMIT 0, 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:57
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 8.797 MB Rows returned: 0

SELECT * 
  FROM `exeju_vikbooking_seasons` 
  WHERE ((`
  from` <= 1987200 
  AND `to` >= 2073600) OR (`
  from` <= 1987200 
  AND `to` >= 1987200) OR (`
  from` <= 2073600 
  AND `to` >= 2073600) OR (`
  from` >= 1987200 
  AND `
  from` <= 2073600 
  AND `to` >= 1987200 
  AND `to` <= 2073600) OR (`
  from` <= 1987200 
  AND `
  from` <= 2073600 
  AND `to` < 1987200 
  AND `to` < 2073600 
  AND `
  from` > `to`) OR (`
  from` > 1987200 
  AND `
  from` > 2073600 
  AND `to` >= 1987200 
  AND `to` >= 2073600 
  AND `
  from` > `to`) OR (`
  from` >= 1987200 
  AND `
  from` < 2073600 
  AND `to` < 1987200 
  AND `to` < 2073600 
  AND `
  from` > `to`) OR (`
  from` > 1987200 
  AND `
  from` > 2073600 
  AND `to` >= 1987200 
  AND `to` < 2073600 
  AND `
  from` > `to`)) 
  ORDER BY `exeju_vikbooking_seasons`.`promo` ASC;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:8146
11	VikBooking::applySeasonsRoom()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:65
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 8.803 MB Rows returned: 0

SELECT * 
  FROM `exeju_vikbooking_seasons` 
  WHERE ((`
  from` = 0 
  AND `to` = 0) OR (`
  from` IS NULL 
  AND `to` IS NULL));

Explain

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

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:7185
12	VikBooking::getWdaySeasonRecords()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:8698
11	VikBooking::applySeasonsRoom()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:65
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.96 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 8.807 MB Rows returned: 25

SELECT * 
  FROM `exeju_vikbooking_busy` 
  WHERE `idroom`='5' 
  AND (`checkin`>=1767225600 OR `checkout`>=1767225600);

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:75
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.18 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 8.827 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_custfields` 
  WHERE `type`='checkbox' 
  AND `required`=1 
  ORDER BY `exeju_vikbooking_custfields`.`ordering` ASC 
  LIMIT 0, 2

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:176
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.39 ms Query memory: 0.022 MB Memory before query: 8.836 MB Rows returned: 0

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_custfields' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (12);

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
11	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:178
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 8.845 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'theme' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
13	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
12	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:1542
11	VikBooking::getTheme()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:220
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 9.38 ms Query memory: 0.025 MB Memory before query: 9.052 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'firstwday' 
  LIMIT 1

Explain

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

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
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
18	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
17	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
16	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2385
15	VikBooking::getFirstWeekDay()	JROOT/administrator/components/com_vikbooking/helpers/jv_helper.php:2428
14	VboApplication->loadDatePicker()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:14
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 9.059 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'autodefcalnights' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
17	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
16	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
15	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2064
14	VikBooking::getDefaultNightsCalendar()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:23
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 9.068 MB Rows returned: 1

Duplicate queries: #49

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='mindaysadvance';

Explain

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

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2022
14	VikBooking::getMinDaysAdvance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:41
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 9.075 MB Rows returned: 1

Duplicate queries: #48

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='mindaysadvance';

Explain

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

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2023
14	VikBooking::getMinDaysAdvance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:41
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 9.083 MB Rows returned: 1

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='closingdates';

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2596
15	VikBooking::getClosingDates()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2034
14	VikBooking::getMinDaysAdvance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:41
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 9.094 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'room_5_max_adv_notice' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
16	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
15	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2213
14	VikBooking::getMaxDateFuture()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:42
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 9.103 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'maxdate' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
17	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
16	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2211
15	VikBooking::getMaxDateFuture()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2219
14	VikBooking::getMaxDateFuture()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:42
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.50 ms After last query: 67.14 ms Query memory: 0.024 MB Memory before query: 9.156 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_restrictions` 
  WHERE (`dto` = 0 OR `dto` >= 1769212800) 
  AND (`allrooms` = 1 OR (`allrooms` = 0 
  AND (`idrooms` LIKE '%-5-%'))) 
  ORDER BY `id` ASC;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_vikbooking_restrictions	index	NULL	PRIMARY	4	NULL	10	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:448
14	VikBooking::loadRestrictions()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:170
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 2.74 ms Query memory: 0.026 MB Memory before query: 9.241 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'currencysymb' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
18	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
17	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2962
16	VikBooking::getCurrencySymb()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:16
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.59 ms After last query: 4.65 ms Query memory: 0.035 MB Memory before query: 9.352 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `exeju_content`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	1.22 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.04 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
17	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:101
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.17 ms After last query: 8.70 ms Query memory: 0.027 MB Memory before query: 9.569 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 exeju_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_vikbooking.roomdetails' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	vandelia_mit74.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.group_id	1	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.01 ms
Creating tmp table	0.53 ms
Copying to tmp table	0.05 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	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:322
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:194
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()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:106
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 4.30 ms Query memory: 0.026 MB Memory before query: 9.587 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'numberformat' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
19	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
18	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3048
17	VikBooking::getNumberFormatData()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3076
16	VikBooking::numberFormat()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:137
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 9.598 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'noemptydecimals' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
19	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
18	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3069
17	VikBooking::hideEmptyDecimals()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3079
16	VikBooking::numberFormat()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:137
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 9.609 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'currencypos' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
19	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
18	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2983
17	VikBooking::getCurrencyPosition()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3019
16	VikBooking::formatCurrencyNumber()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:137
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 3.85 ms Query memory: 0.027 MB Memory before query: 9.745 MB Rows returned: 1

Duplicate queries: #61

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='gmapskey';

Explain

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

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13116
21	VikBooking::getGoogleMapsKey()	JROOT/administrator/components/com_vikbooking/helpers/geocoding.php:56
20	VikBookingHelperGeocoding->__construct()	JROOT/administrator/components/com_vikbooking/helpers/geocoding.php:69
19	VikBookingHelperGeocoding::getInstance()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13061
18	VikBooking::getGeocodingInstance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_geomap.php:25
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_geomap.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:165
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 9.756 MB Rows returned: 1

Duplicate queries: #60

SELECT `setting` 
  FROM `exeju_vikbooking_config` 
  WHERE `param`='gmapskey';

Explain

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

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13118
21	VikBooking::getGoogleMapsKey()	JROOT/administrator/components/com_vikbooking/helpers/geocoding.php:56
20	VikBookingHelperGeocoding->__construct()	JROOT/administrator/components/com_vikbooking/helpers/geocoding.php:69
19	VikBookingHelperGeocoding::getInstance()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:13061
18	VikBooking::getGeocodingInstance()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_geomap.php:25
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_geomap.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:165
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.78 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 9.727 MB Rows returned: 5

SELECT *

  FROM `exeju_vikbooking_characteristics`

  WHERE `id` IN (1, 2, 3, 4, 5)

  ORDER BY `ordering` ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:4473
17	VikBooking::loadRoomAmenities()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:4485
16	VikBooking::getRoomCaratOriz()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:168
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.32 ms Query memory: 0.026 MB Memory before query: 9.742 MB Rows returned: 5

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_characteristics' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (1,2,3,4,5);

Explain

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

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
18	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:4475
17	VikBooking::loadRoomAmenities()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:4485
16	VikBooking::getRoomCaratOriz()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:168
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 4.17 ms Query memory: 0.027 MB Memory before query: 9.855 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'showpartlyreserved' 
  LIMIT 1

Explain

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

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.00 ms
Table lock	0.00 ms
After 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.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
21	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
20	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
19	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2398
18	VikBooking::showPartlyReserved()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php:20
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:187
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.13 ms Query memory: 0.033 MB Memory before query: 9.876 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'showcheckinoutonly' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
21	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
20	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
19	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2405
18	VikBooking::showStatusCheckinoutOnly()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php:21
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:187
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'numcalendars' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
21	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
20	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
19	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2372
18	VikBooking::numCalendars()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php:23
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_avcalendars.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:187
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 22.99 ms Query memory: 0.027 MB Memory before query: 9.934 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'allowbooking' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
20	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
19	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2715
18	VikBooking::allowBooking()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:96
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.33 ms Query memory: 0.027 MB Memory before query: 9.948 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'showchildren' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
21	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
20	VBOConfigRegistry->get()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:129
19	VBOConfigRegistry->__call()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2703
18	VikBooking::showChildrenFront()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:125
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 9.959 MB Rows returned: 1

SELECT `setting`

  FROM `exeju_vikbooking_config`

  WHERE `param` = 'guests_label' 
  LIMIT 1

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry/database.php:75
19	VBOConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikbooking/helpers/src/config/registry.php:75
18	VBOConfigRegistry->get()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:126
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.70 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 9.969 MB Rows returned: 1

Duplicate queries: #71

SELECT `id`,`setting` 
  FROM `exeju_vikbooking_texts` 
  WHERE `param`='intromain';

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3268
18	VikBooking::getIntroMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:404
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 9.979 MB Rows returned: 1

Duplicate queries: #70

SELECT `id`,`setting` 
  FROM `exeju_vikbooking_texts` 
  WHERE `param`='intromain';

Explain

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

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3269
18	VikBooking::getIntroMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:404
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.70 ms Query memory: 0.027 MB Memory before query: 9.993 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_texts' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (4);

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
19	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3273
18	VikBooking::getIntroMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:404
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 10.002 MB Rows returned: 1

SELECT `id`,`setting`

  FROM `exeju_vikbooking_texts`

  WHERE `param` = 'guests_allowed_policy'

Explain

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

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2752
18	VikBooking::getGuestsAllowedPolicy()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:426
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 10.015 MB Rows returned: 0

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_texts' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (17);

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
19	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:2769
18	VikBooking::getGuestsAllowedPolicy()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:426
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 10.022 MB Rows returned: 1

Duplicate queries: #76

SELECT `id`,`setting` 
  FROM `exeju_vikbooking_texts` 
  WHERE `param`='closingmain';

Explain

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

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3281
18	VikBooking::getClosingMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:433
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 10.032 MB Rows returned: 1

Duplicate queries: #75

SELECT `id`,`setting` 
  FROM `exeju_vikbooking_texts` 
  WHERE `param`='closingmain';

Explain

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

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3282
18	VikBooking::getClosingMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:433
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.57 ms Query memory: 0.027 MB Memory before query: 10.046 MB Rows returned: 1

SELECT * 
  FROM `exeju_vikbooking_translations` 
  WHERE `table`='#__vikbooking_texts' 
  AND `lang`='en-GB' 
  AND `reference_id` IN (5);

Explain

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_vikbooking/helpers/translator.php:566
19	VikBookingTranslator->translateContents()	JROOT/components/com_vikbooking/helpers/lib.vikbooking.php:3286
18	VikBooking::getClosingMain()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php:433
17	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_bookingform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php:190
15	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default_classic.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php:804
13	include JROOT/components/com_vikbooking/views/roomdetails/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikbooking/views/roomdetails/view.html.php:228
10	VikbookingViewRoomdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikbooking/controller.php:42
8	VikBookingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikbooking/vikbooking.php:74
6	require_once JROOT/components/com_vikbooking/vikbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 9.816 MB Rows returned: 4

SELECT language,id

  FROM `exeju_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	exeju_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	114	Using where

Profile

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

Call Stack

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

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

Query Time: 2.68 ms After last query: 17.44 ms Query memory: 0.027 MB Memory before query: 10.391 MB Rows returned: 10

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

  FROM exeju_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-01-24 21:34:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-24 21:34:18') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 417 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.32 ms
Sending data	0.50 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_chester/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_chester/layouts/theme.config.php:26
10	include JROOT/templates/yoo_chester/layouts/theme.config.php	JROOT/templates/yoo_chester/layouts/theme.php:10
9	include JROOT/templates/yoo_chester/layouts/theme.php	JROOT/templates/yoo_chester/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_chester/index.php:16
7	require JROOT/templates/yoo_chester/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.54 ms After last query: 19.90 ms Query memory: 0.029 MB Memory before query: 10.484 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 exeju_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	vandelia_mit74.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	vandelia_mit74.a.group_id	1	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.52 ms
Copying to tmp table	0.05 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.02 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_chester/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_chester/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_chester/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_chester/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_chester/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_chester/layouts/theme.php:30
9	include JROOT/templates/yoo_chester/layouts/theme.php	JROOT/templates/yoo_chester/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_chester/index.php:16
7	require JROOT/templates/yoo_chester/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 45.86 ms Query memory: 0.022 MB Memory before query: 10.630 MB Rows returned: 0

SELECT *
 
  FROM exeju_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.vandeliabeb.com/en/component/vikbooking/?Itemid=417&roomid=5&view=roomdetails'
 
  AND `published` = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.44 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 10.636 MB Rows returned: 0

SELECT *
 
  FROM exeju_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.vandeliabeb.com/en/component/vikbooking/?Itemid=417&roomid=5&view=roomdetails'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.67 ms After last query: 7.15 ms Query memory: 0.020 MB Memory before query: 10.848 MB Rows returned: 0

SELECT *
 
  FROM exeju_jmap_headings
 
  WHERE `linkurl` = 'https://www.vandeliabeb.com/en/component/vikbooking/?Itemid=417&roomid=5&view=roomdetails'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.54 ms After last query: 0.09 ms Query memory: 0.020 MB Memory before query: 10.852 MB Rows returned: 0

SELECT
 `original_text`,
 `target_text`,
 `original_text_regex`,
 `target_text_regex`
 
  FROM
 `exeju_jmap_text_replacements`
 
  WHERE
`published` = 1

Explain

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

Profile

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

Call Stack

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

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

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

31 × SELECT `setting` 
  FROM `exeju_vikbooking_config`

6 × SELECT * 
  FROM `exeju_vikbooking_translations`

5 × SELECT `id`,`setting` 
  FROM `exeju_vikbooking_texts`

2 × SELECT `ip`,`reason` 
  FROM exeju_rsfirewall_lists

2 × SELECT * 
  FROM `exeju_vikbooking_seasons`

2 × SELECT `param`, `setting` 
  FROM `exeju_vikbooking_config`

2 × 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 exeju_fields AS a 
  LEFT JOIN `exeju_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN exeju_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN exeju_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN exeju_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN exeju_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT language,id 
  FROM `exeju_menu`

1 × SELECT * 
  FROM `exeju_vikbooking_characteristics`

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

1 × SELECT * 
  FROM `exeju_vikbooking_restrictions`

1 × SELECT * 
  FROM `exeju_vikbooking_custfields`

1 × SELECT * 
  FROM `exeju_vikbooking_busy`

1 × SELECT *  
  FROM exeju_jmap_metainfo

1 × SELECT *  
  FROM exeju_jmap_canonicals

1 × SELECT * 
  FROM `exeju_vikbooking_dispcost`

1 × SELECT *  
  FROM exeju_jmap_headings

1 × SELECT `session_id` 
  FROM `exeju_session`

1 × SELECT * 
  FROM `exeju_vikbooking_rooms`

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

1 × SELECT * 
  FROM exeju_rsfirewall_exceptions

1 × SELECT * 
  FROM exeju_rsfirewall_snapshots

1 × SELECT * 
  FROM exeju_rsfirewall_hashes

1 × SELECT id,template 
  FROM exeju_template_styles

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

```
1 × SELECT * 
  FROM exeju_languages
```

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

1 × SELECT * 
  FROM exeju_rsfirewall_configuratio

1 × SELECT `file` 
  FROM exeju_rsfirewall_hashes

1 × SELECT `path` 
  FROM exeju_rsfirewall_ignored

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

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

1 × SELECT id, rules 
  FROM `exeju_viewlevels

1 × SELECT  `original_text`,  `target_text`,  `original_text_regex`,  `target_text_regex`  
  FROM  `exeju_jmap_text_replacements`

OTHER Tables:

1 × INSERT INTO `exeju_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6437337569656274766b7668713376356876366b76686a336e6d', 1, 1769290458, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `exeju_rsfirewall_logs

1 × UPDATE `exeju_extensions` 
  SET `params` = '{\"mediaversion\":\"3d249a5660b28336fbe861a8fd0ef844\"}'

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × SHOW FULL COLUMNS 
  FROM `exeju_content

Vandelia Bed & Breakfast - Molfetta Bari

Fig Tree Room

Request Information for Fig Tree Room

Amenities

Availability Calendar

Select a check-in and check-out date

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

84 Queries Logged 73.71 ms

12 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

January 2026
Mon	Tue	Wed	Thu	Fri	Sat	Sun
			01	02	03	04
05	06	07	08	09	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

February 2026
Mon	Tue	Wed	Thu	Fri	Sat	Sun
						01
02	03	04	05	06	07	08
09	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28

March 2026
Mon	Tue	Wed	Thu	Fri	Sat	Sun
						01
02	03	04	05	06	07	08
09	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31