Badhotel Renesse

Laone 2, 4325 EK, Renesse, Zeeland, Nederland

Zeer god

279 beoordelingen

8,0

Badhotel Renesse is een charmant hotel gelegen achter de Zeeuwse duinen en de brede stranden van Renesse. De Zeeuwse omgeving biedt kilometers lange stranden waar u lekker uit kunt waaien tijdens een verfrissende wandeling. De omgeving leent zich ook bijzonder goed voor het maken van fietstochten door de duinen. Een bezoek aan de plaatsen Middelburg, Veere, Zierikzee of Goes behoort eveneens tot de mogelijkheden. Indrukwekkend is Neeltje Jans. Dit voormalige werkeiland biedt nu ruimte aan de natuur. Er zitten veel meeuwen en zangvogels en er is een breed en rustig strand.

De kamers zijn modern ingericht en aangenaam gelegen op de begane grond of de eerste etage. Zij zijn voorzien van een ligbad met douche, toilet, kleurentelevisie, safe en telefoon. Een aantal kamers hebben een balkon of een dakterras. Het is ook mogelijk om te overnachten in een familiestudio die luxe is ingericht met een woon-zitkamer, volledig uitgeruste keuken en een balkon of tuinterras. De helft van alle hotelkamers bevindt zich op de begane grond, die volledig drempelloos is.

Naast een stijlvol restaurant en gezellige Engelse pub beschikt het hotel ook over een sauna en solarium. Het hotel is met het openbaar vervoer te bereiken. Er is een bushalte op ca. 1 kilometer afstand van het hotel.

minder
Badhotel Renesse is een charmant hotel gelegen achter de Zeeuwse duinen en de brede stranden van Renesse. De Zeeuwse omgeving biedt kilometers lange stranden waar u lekker uit kunt waaien tijdens een verfrissende wandeling. De omgeving leent zich ook bijzonder goed voor het maken van fietstochten door de duinen. Een bezoek aan de plaatsen Middelburg, Veere, Zierikzee of Goes behoort eveneens tot de mogelijkheden. Indrukwekkend is Neeltje Jans. Dit voormalige werkeiland biedt nu... Lees meer

Beoordeling van Badhotel Renesse

8,0

Algemene waardering

8,0

Ligging

8,3

Service

8,2

Verhouding prijs/kwaliteit

8,0

Eten

8,5

Kamers

7,2
279 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Badhotel Renesse.

vrijdag 4 april 2025 : Aantal nachten:1, personen:2
 
 
Kamer 1
personen
2
Verwijder kamer
Voeg een kamer toe
vanaf
€ 136,50
per persoon

3-daags halfpension arrangement

  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijtbuffet
  • Gratis gebruik van buitenzwembad
  • Gratis gebruik van de buitenjacuzzi
  • Gratis wandel- & fietsroutes
  • Gratis WiFi
Read more

Min. nachten: 1

vanaf
€136,50
per persoon
excl. verblijfsbelasting à € 2,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 2,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
vanaf
€ 315,50
per persoon

3-daags Renesse arrangement

  • Ontvangst met koffie of thee en stukje patisserie
  • 2x overnachting inclusief uitgebreid ontbijtbuffet
  • 1x heerlijk 3-gangen keuzediner in Brasserie Bries
  • Gratis gebruik van buitenzwembad
  • Gratis gebruik van de buitenjacuzzi
  • 1 dag fietshuur
  • Gratis wandel- & fietsroutes
  • Gratis WiFi
Read more

Min. nachten: 2

vanaf
€315,50
per persoon
excl. verblijfsbelasting à € 2,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 2,95 p.p.p.n. & reserveringskosten € 9,50 per boeking
Cosy double room
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.

Dit is een tweepersoonskamer gelegen op de 2e etage

Comfort kamer
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
Comfort terras/balkon kamer
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
Comfort kamer zwembadzicht
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
Junior Suite Noordzee
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
Wellness Suite Noordzee
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.

Algemene informatie

 Inchecken

vanaf 15:00 uur

 Uitchecken

tot 11:00 uur

 Verblijfsbelasting

€ 2,95 p.p.p.n

 Aantal kamers

48

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan € 25,00 per hond per nacht. Bij boeking met hond wordt een familiestudio gereserveerd (tegen toeslag).

 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 14 dagen voor aankomst. Voor groepsboekingen vanaf 10 personen gelden andere condities.

 Kinderen

Kinderen tot 4 jaar verblijven gratis, kinderen van 5 tot 10 jaar ontvangen 50% korting op het arrangement. Bij een verblijf van meer dan 2 personen wordt automatisch een familiekamer gereserveerd.

Faciliteiten

Algemeen
  • Draadloos Internet
Wellness
  • Zwembad (buiten)
  • Sauna
  • Turks stoombad
Fietsen
  • Fietsenstalling
  • Fietsverhuur
Eten en drinken
  • Bar
  • Restaurant
  • Terras
Parkeergelegenheid
  • Gratis parkeren
  • Parkeren op eigen terrein (gratis)

Amenities

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan € 25,00
per hond per nacht. Bij boeking met hond wordt een familiestudio gereserveerd (tegen toeslag).

 Mindervaliden

Geen aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

 Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

Show all amenities

Beoordeling van Badhotel Renesse

8,0

Algemene waardering

8,0

Ligging

8,3

Service

8,2

Verhouding prijs/kwaliteit

8,0

Eten

8,5

Kamers

7,2
279 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Badhotel Renesse.

Bezienswaardigheden & attracties

Neeltje Jans

Neeltje Jans

Faelweg, 4354 RB , Vrouwenpolder, Zeeland
Afstand van het hotel (hemelsbreed): 12,99 km
De wereld beroemde deltawerken, gebouwd om herhaling van de watersnoodramp te voorkomen. Bij Deltapark Neeltje Jans kunt u de geschiedenis…

Oosterschelde stormvloedkering

Faelweg 1, 4675 RB, Vrouwenpolder, Zeeland
Afstand van het hotel (hemelsbreed): 12,99 km
De Oosterscheldekering is een waterkering en is het beroemdste Deltawerk. Het is een 9 km lange stormvloedkering die de Oosterschelde afsluit…

Plompe toren

Koudekerkseweg, 12, 4328 NP, Burgh-Haamstede, Zeeland
Afstand van het hotel (hemelsbreed): 5,60 km
De Plompe Toren is het laatste restant van Koudekerke. De gerestaureerde toren is nu een informatiecentrum over de streek. Neem een bezoek…

Zeehondensafari - Frisia rondvaarten

Bronsgeestweg 16, 4697 RT, Sint-Annaland, Zeeland
Afstand van het hotel (hemelsbreed): 27,70 km
In de Oosterschelde is een grote groep zeehonden neergestreken waar u met laag tij heel dichtbij kunt komen. Tijdens een zeehondensafari kunt…

Aqua Mundo Port Zélande

Port Zelande 2, 3253 MG, Ouddorp, Zuid-Holland
Afstand van het hotel (hemelsbreed): 6,34 km
Beleef veel plezier in het Aqua Mundo in Port Zélande! Dit tropische zwemparadijs is ideaal voor een dagje uit. Glijd door de Turbo Tunnel…
Middelburg

Middelburg

Lange Noordstraat 1, 4331 CB, Middelburg, Zeeland
Afstand van het hotel (hemelsbreed): 28,50 km
Middelburg, de hoofdstad van Zeeland heeft een rijke geschiedenis die nog steeds zichtbaar is. Intieme pleintjes, leuke straatjes en…
Nationaal Park Oosterschelde

Nationaal park Oosterschelde

Klein Frankrijk, 1, 4461 ZN, Goes, Zeeland
Afstand van het hotel (hemelsbreed): 26,11 km
Ontdek de variatie van het grootste nationaal park van Nederland. In het park vind je een grote veelzijdigheid aan planten en dieren. Je zult…
Neeltje Jans

Neeltje Jans

Faelweg, 4354 RB , Vrouwenpolder, Zeeland
Afstand van het hotel (hemelsbreed): 12,99 km
De wereld beroemde deltawerken, gebouwd om herhaling van de watersnoodramp te voorkomen. Bij Deltapark Neeltje Jans kunt u de geschiedenis…

Oosterschelde stormvloedkering

Faelweg 1, 4675 RB, Vrouwenpolder, Zeeland
Afstand van het hotel (hemelsbreed): 12,99 km
De Oosterscheldekering is een waterkering en is het beroemdste Deltawerk. Het is een 9 km lange stormvloedkering die de Oosterschelde afsluit…

Plompe toren

Koudekerkseweg, 12, 4328 NP, Burgh-Haamstede, Zeeland
Afstand van het hotel (hemelsbreed): 5,60 km
De Plompe Toren is het laatste restant van Koudekerke. De gerestaureerde toren is nu een informatiecentrum over de streek. Neem een bezoek…

Zeehondensafari - Frisia rondvaarten

Bronsgeestweg 16, 4697 RT, Sint-Annaland, Zeeland
Afstand van het hotel (hemelsbreed): 27,70 km
In de Oosterschelde is een grote groep zeehonden neergestreken waar u met laag tij heel dichtbij kunt komen. Tijdens een zeehondensafari kunt…

Aqua Mundo Port Zélande

Port Zelande 2, 3253 MG, Ouddorp, Zuid-Holland
Afstand van het hotel (hemelsbreed): 6,34 km
Beleef veel plezier in het Aqua Mundo in Port Zélande! Dit tropische zwemparadijs is ideaal voor een dagje uit. Glijd door de Turbo Tunnel…
Middelburg

Middelburg

Lange Noordstraat 1, 4331 CB, Middelburg, Zeeland
Afstand van het hotel (hemelsbreed): 28,50 km
Middelburg, de hoofdstad van Zeeland heeft een rijke geschiedenis die nog steeds zichtbaar is. Intieme pleintjes, leuke straatjes en…
Nationaal Park Oosterschelde

Nationaal park Oosterschelde

Klein Frankrijk, 1, 4461 ZN, Goes, Zeeland
Afstand van het hotel (hemelsbreed): 26,11 km
Ontdek de variatie van het grootste nationaal park van Nederland. In het park vind je een grote veelzijdigheid aan planten en dieren. Je zult…
Neeltje Jans

Neeltje Jans

Faelweg, 4354 RB , Vrouwenpolder, Zeeland
Afstand van het hotel (hemelsbreed): 12,99 km
De wereld beroemde deltawerken, gebouwd om herhaling van de watersnoodramp te voorkomen. Bij Deltapark Neeltje Jans kunt u de geschiedenis…

Uw selectie

vrijdag 4 april 2025

+−
Leaflet | © OpenStreetMap contributors
J! InfoRequestSessionProfileQueries231Log
39.964MBMemory Usage683msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.32
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 [ "divIdentifier" => "offerDiv4444" ]
$_POST
[]
$_SESSION
array:2 [ "userData" => {#912 +"searchType": "" +"keyword": "" +"start_date": "2025-04...
$_COOKIE
[]
$_SERVER
array:110 [ "USER" => "goedve01" "HOME" => "/var/www/vhosts/goedverblijf.nl" "SCRIPT_NAME" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743751908 "last" => 1743751908...
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) (36.93ms)
  • afterInitialise (13.86MB) (147ms)
  • afterRoute (2.03MB) (28.62ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (4.72ms)
  • Before Access::preloadComponents (all components) (9.64MB) (357ms)
  • After Access::preloadComponents (all components) (134.39KB) (651μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (29μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (501μs)
  • afterRenderComponent com_jhotelreservation (1.13MB) (17.85ms)
  • afterDispatch (120.19KB) (2.04ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (41.28ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (16.73ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (12μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (3.8ms)
  • afterRender (1.8MB) (23.17ms)
  • 1 x Before Access::preloadComponents (all components) (9.64MB) (52.33%)
    357.50ms
    1 x afterInitialise (13.86MB) (21.51%)
    146.99ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (6.04%)
    41.28ms
    1 x afterLoad (4.2MB) (5.41%)
    36.93ms
    1 x afterRoute (2.03MB) (4.19%)
    28.62ms
    1 x afterRender (1.8MB) (3.39%)
    23.17ms
    1 x afterRenderComponent com_jhotelreservation (1.13MB) (2.61%)
    17.85ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (2.45%)
    16.73ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.69%)
    4.72ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (0.56%)
    3.80ms
    1 x afterDispatch (120.19KB) (0.3%)
    2.04ms
    1 x After Access::preloadComponents (all components) (134.39KB) (0.1%)
    651μs
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.07%)
    501μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0%)
    29μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    12μs
231 statements were executed, 160 of which were duplicates, 71 unique276ms2.88MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7Duplicates 8Duplicates 9Duplicates 10Duplicates 11Duplicates 12Duplicates 13Duplicates 14Duplicates 15Duplicates 16Duplicates 17Duplicates 18Duplicates 19Duplicates 20Duplicates 21Duplicates 22Duplicates 23Duplicates 24Duplicates 25Duplicates 26Duplicates 27Duplicates 28Duplicates 29Duplicates 30Duplicates 31Duplicates 32Duplicates 33Duplicates 34Duplicates 35Duplicates 36Duplicates 37Duplicates 38Duplicates 39Duplicates 40Duplicates 41Duplicates 42Duplicates 43Duplicates 44Duplicates 45Duplicates 46Duplicates 47Duplicates 48Duplicates 49Duplicates 50Duplicates 51Duplicates 52Duplicates 53Duplicates 54Duplicates 55
  • SELECT @@SESSION.sql_mode;123μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?374μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1203μ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)4.93ms944BParams/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` = 1112μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`74μ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` = :guest75μ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`118μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1250μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC94μ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` = 160μ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`399μs184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas194μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'69μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'badhotel-renesse' LIMIT 1583μ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` = :id92μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'badhotel-renesse' LIMIT 1132μ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` = 1231μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'112μ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` = :id99μ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 = 258 AND h.is_available = 1310μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`481μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=258 and language_tag='nl-NL'336μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 258 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id297μs1.42KB/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 = 258 ORDER BY fc.ordering, hf.name;658μs1.36KB/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'62μ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'73μs1.08KB/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=9 and language_tag='nl-NL'67μ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'59μ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'58μ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'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'73μs12.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=3 and language_tag='nl-NL'134μs1.05KB/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'61μ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 = 258 ORDER BY hf.name287μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 258344μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 258296μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest`515μ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(51.73376)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(3.776010000000042 - poi_longitude)) + SIN(RADIANS(51.73376)) * 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.22ms2.17KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=404 and language_tag='nl-NL'235μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest_pictures`458μ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=404 ORDER BY id asc341μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=104 and language_tag='nl-NL'214μ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=104 ORDER BY id asc401μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=87 and language_tag='nl-NL'385μ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=87 ORDER BY id asc289μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=78 and language_tag='nl-NL'363μ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=78 ORDER BY id asc411μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=409 and language_tag='nl-NL'190μ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=409 ORDER BY id asc423μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=407 and language_tag='nl-NL'300μ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=407 ORDER BY id asc252μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=405 and language_tag='nl-NL'176μ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=405 ORDER BY id asc283μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_review_answers`478μ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 = 258 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr4.44ms1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'106μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`542μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.98 and max_rate>=7.98139μ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'61μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotel_informations`550μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=258238μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=258 and language_tag='nl-NL'297μs9.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=258 and language_tag='nl-NL'211μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=258 and language_tag='nl-NL'224μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=258 and language_tag='nl-NL'263μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=258 and language_tag='nl-NL'268μ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=258303μ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 = 258 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50115ms36.83KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount136μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`653μ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((51.73376 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(51.73376 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((3.776010000000042 - 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 (258) group by h.hotel_id having distance < 10000 ORDER BY distance asc20.3ms271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=258 and language_tag='nl-NL'418μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`617μ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`466μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_pictures`481μ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 = 258 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.97ms42.8KB/administrator/components/com_jhotelreservation/tables/offers.php:324Copy
  • select * from jos_hotelreservation_language_translations where type=14 and language_tag = 'nl-NL'191μs29.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=2 and language_tag = 'nl-NL'224μ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=258438μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 7098 and '2025-04-04'<= date and date<='2025-04-05'1.83ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 417 and date between '2025-04-04' and '2025-04-05' order by date asc3.03ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'22.3ms1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id416μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11067 and '2025-04-04'<= date and date<='2025-04-05'2.2ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1259 and date between '2025-04-04' and '2025-04-05' order by date asc2.4ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'73μs1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id76μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11068 and '2025-04-04'<= date and date<='2025-04-05'1.61ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7642 and date between '2025-04-04' and '2025-04-05' order by date asc2.94ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'76μs1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id70μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11069 and '2025-04-04'<= date and date<='2025-04-05'1.59ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7643 and date between '2025-04-04' and '2025-04-05' order by date asc2.68ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'71μs1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id63μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11070 and '2025-04-04'<= date and date<='2025-04-05'1.41ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7644 and date between '2025-04-04' and '2025-04-05' order by date asc2.99ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'84μs1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id65μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11071 and '2025-04-04'<= date and date<='2025-04-05'1.51ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7645 and date between '2025-04-04' and '2025-04-05' order by date asc1.35ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=3002 and language_tag = 'nl-NL'67μs1.11KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 3002 AND offer_picture_enable = 1 ORDER BY offer_picture_id60μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 4920 and '2025-04-04'<= date and date<='2025-04-05'1.79ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 417 and date between '2025-04-04' and '2025-04-05' order by date asc60μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'19.81ms1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id421μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11062 and '2025-04-04'<= date and date<='2025-04-05'1.76ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1259 and date between '2025-04-04' and '2025-04-05' order by date asc81μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'65μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id71μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11063 and '2025-04-04'<= date and date<='2025-04-05'1.24ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7642 and date between '2025-04-04' and '2025-04-05' order by date asc57μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'59μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id59μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11064 and '2025-04-04'<= date and date<='2025-04-05'1.57ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7643 and date between '2025-04-04' and '2025-04-05' order by date asc72μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'70μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id92μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11065 and '2025-04-04'<= date and date<='2025-04-05'1.69ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7644 and date between '2025-04-04' and '2025-04-05' order by date asc73μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'77μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id61μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11066 and '2025-04-04'<= date and date<='2025-04-05'1.3ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7645 and date between '2025-04-04' and '2025-04-05' order by date asc94μs16.91KB/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4444 and language_tag = 'nl-NL'78μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4444 AND offer_picture_enable = 1 ORDER BY offer_picture_id92μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_discounts`540μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,283,283) , 1 ) ORDER BY discount_datas497μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,273,273) , 1 ) ORDER BY discount_datas620μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,328,328) , 1 ) ORDER BY discount_datas259μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,363,363) , 1 ) ORDER BY discount_datas538μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,303,303) , 1 ) ORDER BY discount_datas276μ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( 3002, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,323,323) , 1 ) ORDER BY discount_datas292μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,325.5,325.5) , 1 ) ORDER BY discount_datas741μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,315.5,315.5) , 1 ) ORDER BY discount_datas728μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,370.5,370.5) , 1 ) ORDER BY discount_datas272μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,405.5,405.5) , 1 ) ORDER BY discount_datas242μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,345.5,345.5) , 1 ) ORDER BY discount_datas820μ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( 4444, offer_ids ), 1 ) AND (hotel_id = 258 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(258, discount_hotel_ids)))) AND '2025-04-04' 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,365.5,365.5) , 1 ) ORDER BY discount_datas453μ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=258143μ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-04-05' and c.end_date >='2025-04-04') and c.reservation_status <> 2 and c.hotel_id = 258473μ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 = 258 AND h.is_available = 1156μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=258 and language_tag='nl-NL'66μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 258 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id76μs1.42KB/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 = 258 ORDER BY fc.ordering, hf.name;98μs1.36KB/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'70μ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'58μs1.08KB/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'58μs1.08KB/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'57μ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'59μ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'55μ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'55μ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'69μ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'57μs1.05KB/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 = 258 ORDER BY hf.name53μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 25865μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 25866μ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(51.73376)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(3.776010000000042 - poi_longitude)) + SIN(RADIANS(51.73376)) * 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 asc70μs2.17KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=404 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=404 ORDER BY id asc64μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=104 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=104 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=87 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=87 ORDER BY id asc57μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=78 and language_tag='nl-NL'69μ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=78 ORDER BY id asc57μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=409 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=409 ORDER BY id asc58μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=407 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=407 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=405 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=405 ORDER BY id asc58μs1.05KB/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 = 258 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'70μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.98 and max_rate>=7.9852μ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'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=25897μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=258 and language_tag='nl-NL'63μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=258 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=258 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=258 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=258 and language_tag='nl-NL'56μ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=25857μ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 = 258 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50207μs36.83KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount80μ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((51.73376 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(51.73376 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((3.776010000000042 - 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 (258) group by h.hotel_id having distance < 10000 ORDER BY distance asc502μs271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=258 and language_tag='nl-NL'88μ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=258216μ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=258190μs928B/administrator/components/com_jhotelreservation/tables/hotels.php:719Copy
  • SELECT count(hotel_id) as cityCount FROM jos_hotelreservation_hotels where hotel_city = 'Renesse'562μ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=14555μ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=455μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:756Copy
  • SELECT h.* FROM jos_hotelreservation_currencies h ORDER BY description asc58μ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)181μ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`142μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 087μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'115μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'84μ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 * 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'111μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'109μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'128μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'116μ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 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_id534μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'529μ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.name91μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'95μ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'78μ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'97μ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'75μ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'82μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'77μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'76μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'76μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'87μ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 `session_id` FROM `jos_session` WHERE `session_id` = ?209μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.42ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy