Kasteel de Essenburgh

Zuiderzeestraatweg 199, 3849 AE, Hierden, Gelderland, Nederland

Zeer god

35 beoordelingen

8,0

Kasteel de Essenburgh bevindt zich in een unieke omgeving rond een nog unieker kasteel, midden in het groene hart van de Veluwe. Op het landgoed vindt u een oase van rust. Het hotel is omringt met bossen en uitgestrekte heidevelden. De routes en paden uit de omgeving zijn een aanrader voor zowel de fietser als de wandelaar. Voor een dagje uit kunt u een bezoek brengen aan het Dolfinarium of Walibi Holland. Beide toeristische trekpleisters liggen op minder dan een half uurtje rijden van het hotel verwijderd. Voor een dagje winkelen kunt u een bezoek brengen aan de bijna achthonderd jaar oude stad Harderwijk, gelegen op ongeveer vijf kilometer afstand. Harderwijk is met haar rijke historie en bruisende centrum een bezoek meer dan waard.

In Kasteel de Essenburgh is gratis WiFi beschikbaar in de openbare ruimtes. Het kasteel beschikt over 37 kamers welke zijn onderverdeelt in 31 standaard kamers en 6 kasteelkamers. De standaard kamers bevinden zich in de aanbouw van het kasteel of in het bijgebouw de Hoeve en beschikken over eigen badkamer. De kasteelkamers zijn gesitueerd in het kasteel en de toiletten en douches zijn nabij de kamers gelegen. Kasteelkamers zijn enkel op aanvraag en op basis van beschikbaarheid, vraagt u naar de mogelijkheden.

minder
Kasteel de Essenburgh bevindt zich in een unieke omgeving rond een nog unieker kasteel, midden in het groene hart van de Veluwe. Op het landgoed vindt u een oase van rust. Het hotel is omringt met bossen en uitgestrekte heidevelden. De routes en paden uit de omgeving zijn een aanrader voor zowel de fietser als de wandelaar. Voor een dagje uit kunt u een bezoek brengen aan het Dolfinarium of Walibi Holland. Beide toeristische trekpleisters liggen op minder dan een half uurtje rijden... Lees meer

Beoordeling van Kasteel de Essenburgh

8,0

Algemene waardering

7,8

Ligging

9,0

Service

8,3

Verhouding prijs/kwaliteit

7,8

Eten

8,4

Kamers

6,5

Beoordelingen zijn geschreven door gasten na hun verblijf bij Kasteel de Essenburgh.

donderdag 23 januari 2025 : Aantal nachten:1, personen:2
 
 
Kamer 1
personen
2

Logies & ontbijt

  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijtbuffet
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis WiFi (in openbare ruimtes)
  • Gratis parkeren
Read more

Min. nachten: 1

vanaf
€62,00
per persoon
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking

2-daags halfpension arrangement

  • 1x overnachting inclusief uitgebreid ontbijtbuffet
  • 1x heerlijk 3-gangen diner
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis WiFi (in openbare ruimtes)
  • Gratis parkeren
Read more

Min. nachten: 1

vanaf
€84,50
per persoon
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking

3-daags diner arrangement

  • 2x overnachting inclusief uitgebreid ontbijtbuffet
  • 1x heerlijk 3-gangen diner
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis WiFi (in openbare ruimtes)
  • Gratis parkeren
Read more

Min. nachten: 2

vanaf
€152,50
per persoon
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 0,95 p.p.p.n. & reserveringskosten € 9,50 per boeking

Algemene informatie

 Inchecken

vanaf 14:00 uur

 Uitchecken

tot 11:00 uur

 Verblijfsbelasting

€ 0,95 p.p.p.n

 Aantal kamers

37

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren niet toegestaan

 Mindervaliden

Geen aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

 Annuleringsvoorwaarden

Op alle reserveringen zijn de Uniforme Voorwaarden Horeca (UVH) van toepassing. Gratis annuleren tot 1 dag voor aankomst. Voor groepsboekingen vanaf 10 personen gelden andere condities.

 Kinderen

Er zijn geen kinderkortingen van toepassing.

Faciliteiten

Algemeen
  • Draadloos Internet
Wellness
  • Turks stoombad
Fietsen
  • Fietsenstalling (afgesloten)
  • Fietsverhuur
Eten en drinken
  • Bar
  • Brasserie
  • Restaurant
  • Terras
Parkeergelegenheid
  • Parkeren op eigen terrein (gratis)

Amenities

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren niet toegestaan

 Mindervaliden

Geen aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

 Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

Show all amenities

Beoordeling van Kasteel de Essenburgh

8,0

Algemene waardering

7,8

Ligging

9,0

Service

8,3

Verhouding prijs/kwaliteit

7,8

Eten

8,4

Kamers

6,5

Beoordelingen zijn geschreven door gasten na hun verblijf bij Kasteel de Essenburgh.

Bezienswaardigheden & attracties

Uw selectie

donderdag 23 januari 2025

Leaflet | © OpenStreetMap contributors
38.765MBMemory Usage566msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templatej-travel
Database
Server
mysql
Version
10.6.19-MariaDB-log
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "minNights" => "1" ]
$_POST
[]
$_SESSION
array:2 [ "userData" => {#912 +"searchType": "" +"keyword": "" +"start_date": "2025-01...
$_COOKIE
[]
$_SERVER
array:110 [ "USER" => "goedve01" "HOME" => "/var/www/vhosts/goedverblijf.nl" "SCRIPT_NAME" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1737607843 "last" => 1737607843...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "nl-NL" ]
  • afterLoad (4.2MB) (38.01ms)
  • afterInitialise (13.86MB) (141ms)
  • afterRoute (2.03MB) (27.18ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (5.42ms)
  • Before Access::preloadComponents (all components) (8.77MB) (239ms)
  • After Access::preloadComponents (all components) (150.39KB) (621μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (22μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (474μs)
  • afterRenderComponent com_jhotelreservation (1.03MB) (18.9ms)
  • afterDispatch (120.73KB) (2.09ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (44.14ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (20.59ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (13μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (3.95ms)
  • afterRender (1.7MB) (23.13ms)
  • 1 x Before Access::preloadComponents (all components) (8.77MB) (42.13%)
    238.66ms
    1 x afterInitialise (13.86MB) (24.95%)
    141.34ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (7.79%)
    44.14ms
    1 x afterLoad (4.2MB) (6.71%)
    38.01ms
    1 x afterRoute (2.03MB) (4.8%)
    27.18ms
    1 x afterRender (1.7MB) (4.08%)
    23.13ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (3.64%)
    20.59ms
    1 x afterRenderComponent com_jhotelreservation (1.03MB) (3.34%)
    18.90ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.96%)
    5.42ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (0.7%)
    3.95ms
    1 x afterDispatch (120.73KB) (0.37%)
    2.09ms
    1 x After Access::preloadComponents (all components) (150.39KB) (0.11%)
    621μs
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.08%)
    474μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0%)
    22μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    13μs
198 statements were executed, 139 of which were duplicates, 59 unique166ms2.81MB
  • SELECT @@SESSION.sql_mode;132μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?841μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1156μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.21ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1123μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`64μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest80μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`114μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1302μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC127μs2.25KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `jos_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 162μs1.11KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.49ms184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas110μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'72μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'kasteel-de-essenburgh' LIMIT 1542μs7.34KB/plugins/system/hotelurltranslator/jhprouter.php:132Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `jos_menu` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id231μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'kasteel-de-essenburgh' LIMIT 1109μs9.84KB/plugins/system/hotelurltranslator/jhprouter.php:132Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1207μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'99μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `jos_menu` AS `c` INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `jos_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id96μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT h.*, c1.country_name, c2.description AS hotel_currency, c2.currency_symbol AS currency_symbol FROM jos_hotelreservation_hotels h LEFT JOIN jos_hotelreservation_countries c1 USING (country_id) LEFT JOIN jos_hotelreservation_currencies c2 USING (currency_id) WHERE h.hotel_id = 289 AND h.is_available = 1370μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`513μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=289 and language_tag='nl-NL'244μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 289 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id228μs1.17KB/components/com_jhotelreservation/classes/services/HotelService.php:149Copy
  • SELECT hf.*, fc.id as categoryId, fc.name AS categoryName, fc.ordering AS categoryOrdering, fc.icon as categoryIcon FROM jos_hotelreservation_hotel_facilities hf INNER JOIN jos_hotelreservation_hotel_facility_relation hfc ON hf.id = hfc.facilityId INNER JOIN jos_hotelreservation_facility_categories fc ON hf.category_id = fc.id WHERE hfc.hotelId = 289 ORDER BY fc.ordering, hf.name;322μs1.33KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=5 and language_tag='nl-NL'69μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=9 and language_tag='nl-NL'65μs1.08KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'82μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'58μs12.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=3 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT hf.* FROM jos_hotelreservation_hotel_types hf inner join jos_hotelreservation_hotel_type_relation hfc on hf.id = hfc.typeId WHERE hfc.hotelId = 289 ORDER BY hf.name187μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 289193μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 289294μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest`513μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from( select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county, 111.1111 * DEGREES(ACOS(COS(RADIANS(52.359091)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.6981060000000525 - poi_longitude)) + SIN(RADIANS(52.359091)) * SIN(RADIANS(poi_latitude)))) AS distance from jos_hotelreservation_points_of_interest where publish = 1 ) a where a.distance <= a.activity_radius order by name asc1.06ms2.23KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=1 and language_tag='nl-NL'63μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest_pictures`443μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=1 ORDER BY id asc75μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=278 and language_tag='nl-NL'61μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=278 ORDER BY id asc59μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=272 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=272 ORDER BY id asc65μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=417 and language_tag='nl-NL'68μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=417 ORDER BY id asc57μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=127 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=127 ORDER BY id asc59μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=138 and language_tag='nl-NL'65μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=138 ORDER BY id asc58μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=108 and language_tag='nl-NL'156μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=108 ORDER BY id asc87μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=61 and language_tag='nl-NL'65μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=61 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=47 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=47 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=24 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=24 ORDER BY id asc59μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=3 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=3 ORDER BY id asc61μs1.09KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_review_answers`448μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select rq.review_question_id,rq.review_question_desc as question, avg(rs.weight) as average from jos_hotelreservation_review_answers ra inner join jos_hotelreservation_review_customers rc on ra.review_id = rc.review_id inner join jos_hotelreservation_review_questions rq on ra.review_question_id = rq.review_question_id inner join jos_hotelreservation_review_rating_scale rs on rs.rating_scale_id = ra.rating_scale_id where rc.hotel_id = 289 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr917μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'71μs9.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`459μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.97 and max_rate>=7.97139μs912B/administrator/components/com_jhotelreservation/tables/ratingclassifications.php:49Copy
  • select * from jos_hotelreservation_language_translations where type=21 and object_id=2 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotel_informations`581μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=289235μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=289 and language_tag='nl-NL'235μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=289 and language_tag='nl-NL'180μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=289 and language_tag='nl-NL'197μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=289 and language_tag='nl-NL'180μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=289 and language_tag='nl-NL'171μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_payment_options hpo inner join jos_hotelreservation_hotel_payment_option_relation hpor on hpo.id=hpor.paymentOptionId where hotelId=289169μs1.03KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:37Copy
  • select SQL_CALC_FOUND_ROWS rc.*,hc.*, avg(rs.weight) as average from jos_hotelreservation_review_answers ra inner join jos_hotelreservation_review_customers rc on ra.review_id = rc.review_id inner join jos_hotelreservation_review_questions rq on ra.review_question_id = rq.review_question_id inner join jos_hotelreservation_review_rating_scale rs on rs.rating_scale_id = ra.rating_scale_id inner join jos_hotelreservation_confirmations hc on rc.confirmation_id=hc.confirmation_id where rc.hotel_id = 289 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 5015.28ms36.58KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount81μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`601μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT h.*,hotel_picture_path, min(hp.hotel_picture_id), 1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((52.359091 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(52.359091 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.6981060000000525 - h.hotel_longitude) * pi()/180 / 2), 2) )) as distance, hlt.content as hotel_description FROM jos_hotelreservation_hotels h left join jos_hotelreservation_hotel_pictures hp on h.hotel_id=hp.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = '' )as hlt on hlt.object_id = h.hotel_id where h.is_available =1 and h.hotel_id not in (289) group by h.hotel_id having distance < 10000 ORDER BY distance asc19.48ms271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=289 and language_tag='nl-NL'287μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`662μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_rate_prices`474μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_room_availability`450μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_pictures`459μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select o.* ,hrc.country_id,hc.currency_id,hc.currency_symbol,ot.*, ot.id as rate_id,rp.offer_room_pictures, IFNULL(r.room_id,ot.room_id) room_id,r.room_name,r.room_description,r.is_available,IFNULL(r.max_adults,ot.base_adults) max_adults,IF(0=1,r.room_capacity,IFNULL(r.max_adults,ot.base_adults)) as room_capacity, oftr.offerTags,rtr.roomTags,GROUP_CONCAT(hov.voucher) as vouchers, r.availability as availability, rr.id as room_rate_id from jos_hotelreservation_offers o inner join jos_hotelreservation_offers_rates ot ON ot.offer_id = o.offer_id left join jos_hotelreservation_offers_rooms hor ON ot.offer_id = hor.offer_id and ot.room_id = hor.room_id left join (select * from jos_hotelreservation_rooms where 1 and is_available = 1) r ON hor.room_id = r.room_id left join jos_hotelreservation_rooms_rates rr on r.room_id = rr.room_id left join (SELECT room_id,GROUP_CONCAT(room_picture_path) as offer_room_pictures FROM jos_hotelreservation_rooms_pictures WHERE room_picture_enable = 1 group by room_id ORDER BY room_picture_id) rp on rp.room_id = r.room_id left join jos_hotelreservation_offers_vouchers hov on hov.offerId = o.offer_id left join jos_hotelreservation_hotels h ON h.hotel_id = o.hotel_id left join jos_hotelreservation_currencies hc on h.currency_id= hc.currency_id left join jos_hotelreservation_countries hrc on h.country_id= hrc.country_id left join (select distinct oftr.offerId, GROUP_CONCAT(oft.name order by oftr.ordering asc SEPARATOR '||') as offerTags from jos_hotelreservation_offers_tags_relation oftr left join jos_hotelreservation_offers_tags oft ON oft.id = oftr.tagId group by oftr.offerId order by oftr.ordering ) oftr ON oftr.offerId = o.offer_id left join (select rtr.roomId, GROUP_CONCAT(DISTINCT rt.name order by rtr.ordering) as roomTags from jos_hotelreservation_rooms_tags_relation rtr left join jos_hotelreservation_rooms_tags rt ON rt.id = rtr.tagId group by rtr.roomId ) rtr ON rtr.roomId = hor.room_id where o.hotel_id = 289 and o.is_available = 1 and o.public = 1 and IF(o.offer_datasf <> '0000-00-00' AND o.offer_dataef <> '0000-00-00', DATE(now()) BETWEEN o.offer_datasf AND o.offer_dataef, IF(o.offer_datasf <> '0000-00-00', DATE(now()) >= o.offer_datasf, DATE(now()) <=o.offer_dataef ) ) group by o.offer_id,ot.id order by o.ordering12.43ms22.66KB/administrator/components/com_jhotelreservation/tables/offers.php:324Copy
  • select * from jos_hotelreservation_language_translations where type=14 and language_tag = 'nl-NL'169μs29.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=2 and language_tag = 'nl-NL'245μs105.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select h.*,c.*,c2.description as hotel_currency from jos_hotelreservation_hotels h left join jos_hotelreservation_countries c on h.country_id=c.country_id left join jos_hotelreservation_currencies c2 using (currency_id) where h.hotel_id=289344μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 3475 and '2025-01-23'<= date and date<='2025-01-24'3.1ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 476 and date between '2025-01-23' and '2025-01-24' order by date asc2.57ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3234 and language_tag = 'nl-NL'24.79ms1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3234 AND offer_picture_enable = 1 ORDER BY offer_picture_id919μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 6220 and '2025-01-23'<= date and date<='2025-01-24'2.76ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 476 and date between '2025-01-23' and '2025-01-24' order by date asc70μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=5412 and language_tag = 'nl-NL'22.07ms1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 5412 AND offer_picture_enable = 1 ORDER BY offer_picture_id290μs1.13KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11770 and '2025-01-23'<= date and date<='2025-01-24'4.24ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 476 and date between '2025-01-23' and '2025-01-24' order by date asc65μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8340 and language_tag = 'nl-NL'21.63ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8340 AND offer_picture_enable = 1 ORDER BY offer_picture_id1.02ms1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_discounts`566μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT discount_id, hotel_id, discount_name, discount_datas, discount_datae, if(price_type = 1 , discount_value * 2 , discount_value) as discount_value, percent, discount_room_ids, minimum_number_days, minimum_number_persons, maximum_number_days, reservation_cost_discount, check_full_code, price_type, code FROM `jos_hotelreservation_discounts` WHERE `is_available` = 1 AND IF(hotel_id != 0, FIND_IN_SET( 3234, offer_ids ), 1 ) AND (hotel_id = 289 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(289, discount_hotel_ids)))) AND '2025-01-23' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,169,169) , 1 ) ORDER BY discount_datas315μs2.23KB/administrator/components/com_jhotelreservation/tables/roomdiscounts.php:317Copy
  • SELECT discount_id, hotel_id, discount_name, discount_datas, discount_datae, if(price_type = 1 , discount_value * 2 , discount_value) as discount_value, percent, discount_room_ids, minimum_number_days, minimum_number_persons, maximum_number_days, reservation_cost_discount, check_full_code, price_type, code FROM `jos_hotelreservation_discounts` WHERE `is_available` = 1 AND IF(hotel_id != 0, FIND_IN_SET( 5412, offer_ids ), 1 ) AND (hotel_id = 289 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(289, discount_hotel_ids)))) AND '2025-01-23' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,152.5,152.5) , 1 ) ORDER BY discount_datas257μs2.23KB/administrator/components/com_jhotelreservation/tables/roomdiscounts.php:317Copy
  • SELECT discount_id, hotel_id, discount_name, discount_datas, discount_datae, if(price_type = 1 , discount_value * 2 , discount_value) as discount_value, percent, discount_room_ids, minimum_number_days, minimum_number_persons, maximum_number_days, reservation_cost_discount, check_full_code, price_type, code FROM `jos_hotelreservation_discounts` WHERE `is_available` = 1 AND IF(hotel_id != 0, FIND_IN_SET( 8340, offer_ids ), 1 ) AND (hotel_id = 289 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(289, discount_hotel_ids)))) AND '2025-01-23' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,124,124) , 1 ) ORDER BY discount_datas247μs2.23KB/administrator/components/com_jhotelreservation/tables/roomdiscounts.php:317Copy
  • select h.*,c.*,c2.description as hotel_currency from jos_hotelreservation_hotels h left join jos_hotelreservation_countries c on h.country_id=c.country_id left join jos_hotelreservation_currencies c2 using (currency_id) where h.hotel_id=289150μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select c.confirmation_id,hcr.room_id,hcr.offer_id,c.start_date, c.end_date from jos_hotelreservation_confirmations_rooms hcr inner join jos_hotelreservation_confirmations c on c.confirmation_id= hcr.confirmation_id where (c.start_date <'2025-01-24' and c.end_date >='2025-01-23') and c.reservation_status <> 2 and c.hotel_id = 289330μs1.05KB/components/com_jhotelreservation/classes/services/BookingService.php:56Copy
  • SELECT h.*, c1.country_name, c2.description AS hotel_currency, c2.currency_symbol AS currency_symbol FROM jos_hotelreservation_hotels h LEFT JOIN jos_hotelreservation_countries c1 USING (country_id) LEFT JOIN jos_hotelreservation_currencies c2 USING (currency_id) WHERE h.hotel_id = 289 AND h.is_available = 1122μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=289 and language_tag='nl-NL'68μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 289 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id60μs1.17KB/components/com_jhotelreservation/classes/services/HotelService.php:149Copy
  • SELECT hf.*, fc.id as categoryId, fc.name AS categoryName, fc.ordering AS categoryOrdering, fc.icon as categoryIcon FROM jos_hotelreservation_hotel_facilities hf INNER JOIN jos_hotelreservation_hotel_facility_relation hfc ON hf.id = hfc.facilityId INNER JOIN jos_hotelreservation_facility_categories fc ON hf.category_id = fc.id WHERE hfc.hotelId = 289 ORDER BY fc.ordering, hf.name;78μs1.33KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=5 and language_tag='nl-NL'59μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=9 and language_tag='nl-NL'59μs1.08KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'66μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=3 and language_tag='nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT hf.* FROM jos_hotelreservation_hotel_types hf inner join jos_hotelreservation_hotel_type_relation hfc on hf.id = hfc.typeId WHERE hfc.hotelId = 289 ORDER BY hf.name54μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 28987μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 28949μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • select * from( select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county, 111.1111 * DEGREES(ACOS(COS(RADIANS(52.359091)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.6981060000000525 - poi_longitude)) + SIN(RADIANS(52.359091)) * SIN(RADIANS(poi_latitude)))) AS distance from jos_hotelreservation_points_of_interest where publish = 1 ) a where a.distance <= a.activity_radius order by name asc72μs2.23KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=1 and language_tag='nl-NL'60μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=1 ORDER BY id asc73μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=278 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=278 ORDER BY id asc59μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=272 and language_tag='nl-NL'87μs17.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=272 ORDER BY id asc59μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=417 and language_tag='nl-NL'60μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=417 ORDER BY id asc59μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=127 and language_tag='nl-NL'61μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=127 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=138 and language_tag='nl-NL'60μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=138 ORDER BY id asc58μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=108 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=108 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=61 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=61 ORDER BY id asc59μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=47 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=47 ORDER BY id asc62μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=24 and language_tag='nl-NL'66μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=24 ORDER BY id asc59μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=3 and language_tag='nl-NL'66μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=3 ORDER BY id asc59μs1.09KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select rq.review_question_id,rq.review_question_desc as question, avg(rs.weight) as average from jos_hotelreservation_review_answers ra inner join jos_hotelreservation_review_customers rc on ra.review_id = rc.review_id inner join jos_hotelreservation_review_questions rq on ra.review_question_id = rq.review_question_id inner join jos_hotelreservation_review_rating_scale rs on rs.rating_scale_id = ra.rating_scale_id where rc.hotel_id = 289 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr60μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'62μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.97 and max_rate>=7.9774μs912B/administrator/components/com_jhotelreservation/tables/ratingclassifications.php:49Copy
  • select * from jos_hotelreservation_language_translations where type=21 and object_id=2 and language_tag='nl-NL'69μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=289117μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=289 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=289 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=289 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=289 and language_tag='nl-NL'70μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=289 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_payment_options hpo inner join jos_hotelreservation_hotel_payment_option_relation hpor on hpo.id=hpor.paymentOptionId where hotelId=28956μs1.03KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:37Copy
  • select SQL_CALC_FOUND_ROWS rc.*,hc.*, avg(rs.weight) as average from jos_hotelreservation_review_answers ra inner join jos_hotelreservation_review_customers rc on ra.review_id = rc.review_id inner join jos_hotelreservation_review_questions rq on ra.review_question_id = rq.review_question_id inner join jos_hotelreservation_review_rating_scale rs on rs.rating_scale_id = ra.rating_scale_id inner join jos_hotelreservation_confirmations hc on rc.confirmation_id=hc.confirmation_id where rc.hotel_id = 289 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50215μs36.58KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount77μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SELECT h.*,hotel_picture_path, min(hp.hotel_picture_id), 1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((52.359091 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(52.359091 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.6981060000000525 - h.hotel_longitude) * pi()/180 / 2), 2) )) as distance, hlt.content as hotel_description FROM jos_hotelreservation_hotels h left join jos_hotelreservation_hotel_pictures hp on h.hotel_id=hp.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = '' )as hlt on hlt.object_id = h.hotel_id where h.is_available =1 and h.hotel_id not in (289) group by h.hotel_id having distance < 10000 ORDER BY distance asc583μs271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=289 and language_tag='nl-NL'85μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT htr.typeId, ht.name FROM jos_hotelreservation_hotel_type_relation as htr LEFT JOIN jos_hotelreservation_hotel_types as ht on ht.Id = htr.typeId where htr.hotelId=289202μs912B/administrator/components/com_jhotelreservation/tables/hotels.php:728Copy
  • SELECT hrr.regionId, hr.name FROM jos_hotelreservation_hotel_region_relation as hrr LEFT JOIN jos_hotelreservation_hotel_regions as hr on hr.Id = hrr.regionId where hrr.hotelId=289147μs928B/administrator/components/com_jhotelreservation/tables/hotels.php:719Copy
  • SELECT count(hotel_id) as cityCount FROM jos_hotelreservation_hotels where hotel_city = 'Hierden'413μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:764Copy
  • SELECT count(hrr.hotelId) as regionCount FROM jos_hotelreservation_hotel_region_relation as hrr LEFT JOIN jos_hotelreservation_hotels as h on h.hotel_id = hrr.hotelId where h.is_available=1 and regionId=659μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:742Copy
  • SELECT count(htr.hotelId) as typeCount FROM jos_hotelreservation_hotel_type_relation as htr LEFT JOIN jos_hotelreservation_hotels as h on h.hotel_id = htr.hotelId where h.is_available=1 and typeId=6277μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:756Copy
  • SELECT h.* FROM jos_hotelreservation_currencies h ORDER BY description asc76μs976B/components/com_jhotelreservation/classes/services/CurrencyService.php:14Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45)154μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray2,:preparedArray3) ORDER BY `m`.`position`,`m`.`ordering`819μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 079μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'91μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'78μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'100μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'96μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'101μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'132μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'91μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'97μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT h.*, min(hp.hotel_picture_id), hotel_picture_path FROM jos_hotelreservation_hotels h left join jos_hotelreservation_hotel_pictures hp on h.hotel_id=hp.hotel_id WHERE h.is_available=1 and LENGTH(h.hotel_latitude) > 3 group by h.hotel_id642μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'877μs425.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select distinct c.country_name,hotel_county,hr.name as region_name from jos_hotelreservation_hotels h inner join jos_hotelreservation_countries c on h.country_id=c.country_id inner join jos_hotelreservation_hotel_region_relation hrr on h.hotel_id = hrr.hotelId inner join jos_hotelreservation_hotel_regions hr on hr.id = hrr.regionId order by c.country_name,h.hotel_county,hr.name104μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'89μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'91μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'74μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'80μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'73μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'73μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'79μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'91μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'75μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'82μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'104μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?181μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.77ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy