Martin's Rentmeesterij

Kasteelstraat 2, 3740, Bilzen, Vlaanderen, België

Fabulos

1 beoordeling

10,0

Martin’s Rentmeesterij biedt u een exclusieve belevenis waarin cultuur, gastronomie en ontspanning samenkomen. Het hotel is gevestigd in de “Rentmeesterwoning” van het domein (13de eeuw). Met 69 kamers, restaurant AKKO, terras en bar, is het hotel perfect voor een ontspannen verblijf.

De Rentmeesterij is een toeristische bezienswaardigheid op zich. De Landcommanderij werd tussen de 13de en 18de eeuw door de Duitse Ridderorde gebouwd. De gebouwen staan sinds 2000 geklasseerd als beschermd erfgoed. De Waterburcht en de verschillende bijgebouwen liggen op wandelafstand van Martin’s Rentmeesterij en zijn eenvoudig te bereiken door de tuinen.

Het hotel bevindt zich net naast het kasteel van Alden Biesen, dat het vertrekpunt is van verschillende mooie wandel- en fietsroutes. Samen met de wellness is het hotel uitermate geschikt voor een ontspannen verblijf. Alle kamers zijn ingericht in warme kleuren en met luxueuze stoffen. Ze beschikken over een flatscreen-tv met kabelkanalen, een minibar, koffie- en theefaciliteiten en een moderne badkamer. De badkamer is voorzien van een regendouche of bad. Het ontbijt wordt elke dag geserveerd in het restaurant met zicht op de boomgaard en prairietuin. Zelfs in de winter kunt u kasteel van Alden Biesen bewonderen vanuit het restaurant.

In de omgeving valt ook genoeg te beleven! Natuurliefhebbers kunnen hun hart ophalen in de vele natuurparken, boomgaarden en fietspaden. Daarnaast kunt u vanaf het hotel gemakkelijk Maasmechelen Village bezoeken voor een dagje shoppen. Op slechts 10 minuten ligt Maastricht en Luik, Tongeren en Hasselt liggen op slechts 30 minuten afstand. Het hotel is ook eenvoudig te bereiken vanuit Keulen, Bonn, Düsseldorf of Eindhoven (anderhalf uur met de auto).

minder
Martin’s Rentmeesterij biedt u een exclusieve belevenis waarin cultuur, gastronomie en ontspanning samenkomen. Het hotel is gevestigd in de “Rentmeesterwoning” van het domein (13de eeuw). Met 69 kamers, restaurant AKKO, terras en bar, is het hotel perfect voor een ontspannen verblijf. De Rentmeesterij is een toeristische bezienswaardigheid op zich. De Landcommanderij werd tussen de 13de en 18de eeuw door de Duitse Ridderorde gebouwd. De gebouwen staan sinds 2000... Lees meer

Beoordeling van Martin's Rentmeesterij

10,0

Algemene waardering

10,0

Ligging

10,0

Service

10,0

Verhouding prijs/kwaliteit

10,0

Eten

10,0

Kamers

10,0
1 beoordeling

Beoordelingen zijn geschreven door gasten na hun verblijf bij Martin's Rentmeesterij.

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

Logies & ontbijt

  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijtbuffet
  • Late check-out tot 13.00 uur (niet mogelijk op zaterdag)
  • Gratis WiFi & parkeren
Read more

Min. nachten: 1

vanaf
€4.999,50
per persoon
excl. reserveringskosten € 9,50 per boeking
excl. reserveringskosten € 9,50 per boeking
vanaf
€ 4.999,50
per persoon

Romantisch arrangement

  • 1x overnachting inclusief uitgebreid ontbijt
  • Rozenblaadjes op bed
  • Gratis WiFi & parkeren
Read more

Min. nachten: 1

vanaf
€4.999,50
per persoon
excl. reserveringskosten € 9,50 per boeking
excl. reserveringskosten € 9,50 per boeking
vanaf
€ 4.999,50
per persoon

Wellness arrangement

  • 1x overnachting inclusief uitgebreid ontbijt
  • 1 uur gebruik van de wellnessfaciliteiten
  • Gratis WiFi & parkeren
Read more

Min. nachten: 1

vanaf
€4.999,50
per persoon
excl. reserveringskosten € 9,50 per boeking
excl. reserveringskosten € 9,50 per boeking

Algemene informatie

 Inchecken

vanaf 15:00 uur

 Uitchecken

tot 11:00 uur

 Verblijfsbelasting

€ 0,00 p.p.p.n

 Aantal kamers

72

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan € 30,00 per nacht

 Mindervaliden

Aangepaste kamers beschikbaar

 Openbaar vervoer

Niet bereikbaar per openbaar vervoer

Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

 Annuleringsvoorwaarden

Gratis annuleren tot 2 dagen voor aankomst. Voor groepsboekingen vanaf 10 personen gelden andere condities.

 Kinderen

Bijzetbed op de kamer à € 40.00 per nacht

Faciliteiten

Algemeen
  • Airconditioning
Wellness
  • Zwembad (binnen)
  • Sauna
  • Turks stoombad
Fietsen
  • Fietsenstalling
Toegankelijkheid
  • LNG_LNG_ROLSTOELTOEGANKELIJK
Eten en drinken
  • Bar
  • Restaurant
  • Terras
Parkeergelegenheid
  • Parkeren op eigen terrein (gratis)

Amenities

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan € 30,00
per nacht

 Mindervaliden

Aangepaste kamers beschikbaar

 Openbaar vervoer

Niet bereikbaar per openbaar vervoer

 Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

Show all amenities

Beoordeling van Martin's Rentmeesterij

10,0

Algemene waardering

10,0

Ligging

10,0

Service

10,0

Verhouding prijs/kwaliteit

10,0

Eten

10,0

Kamers

10,0
1 beoordeling

Beoordelingen zijn geschreven door gasten na hun verblijf bij Martin's Rentmeesterij.

Bezienswaardigheden & attracties

Maastricht

Maastricht

Vrijthof, 25, 6211 LE, Maastricht, Limburg
Afstand van het hotel (hemelsbreed): 11,82 km
Bezoek de stad aan de Maas en de hoofdstad van Limburg, Maastricht. Liefhebbers van cultuur en kunst kunnen in Maastricht zich heerlijk…
HogeKempen

Nationaal Park Hoge Kempen

Winterslagstraat, 87, 3600, Genk, Vlaanderen
Afstand van het hotel (hemelsbreed): 14,09 km
Bezoek het eerste nationaal park dat door de Vlaamse overheid is opgericht. In het park komt u een diversiteit van natuurgebieden tegen. De…
DSC 5773

Thermae 2000

Cauberg, 25, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,42 km
Op de top van de Cauberg ligt Thermae 2OOO verscholen in het groen. Het bijzondere thermale water is goed voor spieren en gewrichten en heeft…
Valkenburg

Valkenburg

Stationsstraat, 6301 EZ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 22,18 km
Breng een bezoek aan het Zuid-Limburgse Valkenburg aan de Geul! Dit toeristisch stadje heeft vele bezienswaardigheden. De Cauberg is één…
vrijthof

Vrijthof

Vrijthof, Maastricht, Limburg
Afstand van het hotel (hemelsbreed): 11,91 km
Breng een bezoek aan het grootste en bekendste plein van Maastricht. Bekend van de vele monumenten, culturele voorzieningen en evenementen…
fluwelengrot

Fluweelengrot Valkenburg

Daalhemerweg, 27, 6301 BJ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,90 km
Bezoek het gangenstelsel onder de kasteelruïne in Valkenburg. Rond de 11de of 12de eeuw is de grot ontstaan, een gids vertelt u alles over…
holland casino

Holland Casino Valkenburg

Cauberg, 28, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,44 km
Bezoek het Holland Casino Valkenburg voor een spannende middag of avond. Het casino heeft een divers spelaanbod, speel aan de roulettetafels…
KasteelRuineValkenburg

Kasteelruïne Valkenburg

Grendelplein, 13, 6301 BS, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,93 km
Terug naar de tijd van de middeleeuwen, neem een kijkje bij de Kasteelruïne in Valkenburg. U kunt de Kasteelruïne op eigen gelegenheid…
Pietersheimkinderboerderij

Kinderboerderij van Pietersheim

Neerharenweg, 12, 3620, Lanaken, Vlaanderen
Afstand van het hotel (hemelsbreed): 11,83 km
Deze kinderboerderij is niet zomaar een kinderboerderij. Bij Pietersheim kunnen de kinderen zich de hele dag vermaken. Naast de dieren heeft…
Maastricht

Maastricht

Vrijthof, 25, 6211 LE, Maastricht, Limburg
Afstand van het hotel (hemelsbreed): 11,82 km
Bezoek de stad aan de Maas en de hoofdstad van Limburg, Maastricht. Liefhebbers van cultuur en kunst kunnen in Maastricht zich heerlijk…
HogeKempen

Nationaal Park Hoge Kempen

Winterslagstraat, 87, 3600, Genk, Vlaanderen
Afstand van het hotel (hemelsbreed): 14,09 km
Bezoek het eerste nationaal park dat door de Vlaamse overheid is opgericht. In het park komt u een diversiteit van natuurgebieden tegen. De…
DSC 5773

Thermae 2000

Cauberg, 25, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,42 km
Op de top van de Cauberg ligt Thermae 2OOO verscholen in het groen. Het bijzondere thermale water is goed voor spieren en gewrichten en heeft…
Valkenburg

Valkenburg

Stationsstraat, 6301 EZ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 22,18 km
Breng een bezoek aan het Zuid-Limburgse Valkenburg aan de Geul! Dit toeristisch stadje heeft vele bezienswaardigheden. De Cauberg is één…
vrijthof

Vrijthof

Vrijthof, Maastricht, Limburg
Afstand van het hotel (hemelsbreed): 11,91 km
Breng een bezoek aan het grootste en bekendste plein van Maastricht. Bekend van de vele monumenten, culturele voorzieningen en evenementen…
fluwelengrot

Fluweelengrot Valkenburg

Daalhemerweg, 27, 6301 BJ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,90 km
Bezoek het gangenstelsel onder de kasteelruïne in Valkenburg. Rond de 11de of 12de eeuw is de grot ontstaan, een gids vertelt u alles over…
holland casino

Holland Casino Valkenburg

Cauberg, 28, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,44 km
Bezoek het Holland Casino Valkenburg voor een spannende middag of avond. Het casino heeft een divers spelaanbod, speel aan de roulettetafels…
KasteelRuineValkenburg

Kasteelruïne Valkenburg

Grendelplein, 13, 6301 BS, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 21,93 km
Terug naar de tijd van de middeleeuwen, neem een kijkje bij de Kasteelruïne in Valkenburg. U kunt de Kasteelruïne op eigen gelegenheid…
Pietersheimkinderboerderij

Kinderboerderij van Pietersheim

Neerharenweg, 12, 3620, Lanaken, Vlaanderen
Afstand van het hotel (hemelsbreed): 11,83 km
Deze kinderboerderij is niet zomaar een kinderboerderij. Bij Pietersheim kunnen de kinderen zich de hele dag vermaken. Naast de dieren heeft…
Maastricht

Maastricht

Vrijthof, 25, 6211 LE, Maastricht, Limburg
Afstand van het hotel (hemelsbreed): 11,82 km
Bezoek de stad aan de Maas en de hoofdstad van Limburg, Maastricht. Liefhebbers van cultuur en kunst kunnen in Maastricht zich heerlijk…

Uw selectie

dinsdag 1 april 2025

+−
Leaflet | © OpenStreetMap contributors
J! InfoRequestSessionProfileQueries207Log
38.39MBMemory Usage585msRequest 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
[]
$_POST
[]
$_SESSION
array:2 [ "userData" => {#912 +"searchType": "" +"keyword": "" +"start_date": "2025-04...
$_COOKIE
[]
$_SERVER
array:109 [ "USER" => "goedve01" "HOME" => "/var/www/vhosts/goedverblijf.nl" "SCRIPT_NAME" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743538568 "last" => 1743538568...
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) (46.15ms)
  • afterInitialise (13.86MB) (146ms)
  • afterRoute (2.01MB) (32.62ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (5.52ms)
  • Before Access::preloadComponents (all components) (8.21MB) (234ms)
  • After Access::preloadComponents (all components) (150.39KB) (781μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (24μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (421μs)
  • afterRenderComponent com_jhotelreservation (1.08MB) (21.03ms)
  • afterDispatch (120.05KB) (2.09ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (45.3ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (18.95ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (12μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (4.09ms)
  • afterRender (1.76MB) (24.64ms)
  • 1 x Before Access::preloadComponents (all components) (8.21MB) (40.05%)
    234.22ms
    1 x afterInitialise (13.86MB) (25.03%)
    146.41ms
    1 x afterLoad (4.2MB) (7.89%)
    46.15ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (7.75%)
    45.30ms
    1 x afterRoute (2.01MB) (5.58%)
    32.62ms
    1 x afterRender (1.76MB) (4.21%)
    24.64ms
    1 x afterRenderComponent com_jhotelreservation (1.08MB) (3.6%)
    21.03ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (3.24%)
    18.95ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.94%)
    5.52ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (0.7%)
    4.09ms
    1 x afterDispatch (120.05KB) (0.36%)
    2.09ms
    1 x After Access::preloadComponents (all components) (150.39KB) (0.13%)
    781μs
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.07%)
    421μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0%)
    24μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    12μs
207 statements were executed, 154 of which were duplicates, 53 unique147ms2.79MB
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 55Duplicates 56Duplicates 57Duplicates 58Duplicates 59Duplicates 60Duplicates 61
  • SELECT @@SESSION.sql_mode;136μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?228μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1201μ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.42ms944BParams/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` = 191μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`61μ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` = :guest82μ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`115μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1251μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC116μ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` = 161μ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`421μs184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas166μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'81μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'martins-rentmeesterij' LIMIT 11.17ms7.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` = :id134μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'martins-rentmeesterij' LIMIT 1189μ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` = 1258μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'109μ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 = 1075 AND h.is_available = 1450μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`603μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=1075 and language_tag='nl-NL'297μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 1075 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id419μs1.67KB/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 = 1075 ORDER BY fc.ordering, hf.name;554μ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'81μ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'86μ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'75μ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'73μ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'74μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=6 and language_tag='nl-NL'86μ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'76μ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'70μ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'74μ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'73μ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 = 1075 ORDER BY hf.name300μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 1075207μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 1075466μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest`828μ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(50.84190349999999)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.5199440000000095 - poi_longitude)) + SIN(RADIANS(50.84190349999999)) * 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.67ms2.2KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=264 and language_tag='nl-NL'93μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest_pictures`743μ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=264 ORDER BY id asc84μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=222 and language_tag='nl-NL'81μ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=222 ORDER BY id asc104μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=129 and language_tag='nl-NL'80μ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=129 ORDER BY id asc81μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=134 and language_tag='nl-NL'107μ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=134 ORDER BY id asc107μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=110 and language_tag='nl-NL'96μ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=110 ORDER BY id asc80μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=89 and language_tag='nl-NL'78μ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=89 ORDER BY id asc120μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=335 and language_tag='nl-NL'77μ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=335 ORDER BY id asc104μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=34 and language_tag='nl-NL'82μ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=34 ORDER BY id asc77μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=28 and language_tag='nl-NL'82μ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=28 ORDER BY id asc85μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_review_answers`759μ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 = 1075 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr493μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'88μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`717μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=10 and max_rate>=10224μs912B/administrator/components/com_jhotelreservation/tables/ratingclassifications.php:49Copy
  • select * from jos_hotelreservation_language_translations where type=21 and object_id=1 and language_tag='nl-NL'424μs9.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotel_informations`525μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=1075470μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=645 and language_tag='nl-NL'226μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=645 and language_tag='nl-NL'270μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=645 and language_tag='nl-NL'209μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=645 and language_tag='nl-NL'170μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=645 and language_tag='nl-NL'221μ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=1075201μ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 = 1075 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50638μs19.97KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount68μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`570μ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((50.84190349999999 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(50.84190349999999 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.5199440000000095 - 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 (1075) group by h.hotel_id having distance < 10000 ORDER BY distance asc18.24ms271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=1075 and language_tag='nl-NL'325μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`592μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_rate_prices`483μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_room_availability`440μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_pictures`430μ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 = 1075 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.ordering9.28ms22.7KB/administrator/components/com_jhotelreservation/tables/offers.php:324Copy
  • select * from jos_hotelreservation_language_translations where type=14 and language_tag = 'nl-NL'173μs29.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=2 and language_tag = 'nl-NL'209μ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=1075373μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13124 and '2025-04-01'<= date and date<='2025-04-02'2.55ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1263 and date between '2025-04-01' and '2025-04-02' order by date asc2.89ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8778 and language_tag = 'nl-NL'22.37ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8778 AND offer_picture_enable = 1 ORDER BY offer_picture_id398μs1.06KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13125 and '2025-04-01'<= date and date<='2025-04-02'949μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7906 and date between '2025-04-01' and '2025-04-02' order by date asc2.66ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8778 and language_tag = 'nl-NL'70μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8778 AND offer_picture_enable = 1 ORDER BY offer_picture_id88μs1.06KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13126 and '2025-04-01'<= date and date<='2025-04-02'1.47ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1263 and date between '2025-04-01' and '2025-04-02' order by date asc74μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8779 and language_tag = 'nl-NL'21.82ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8779 AND offer_picture_enable = 1 ORDER BY offer_picture_id264μs1.06KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13127 and '2025-04-01'<= date and date<='2025-04-02'304μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7906 and date between '2025-04-01' and '2025-04-02' order by date asc59μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8779 and language_tag = 'nl-NL'67μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8779 AND offer_picture_enable = 1 ORDER BY offer_picture_id76μs1.06KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13129 and '2025-04-01'<= date and date<='2025-04-02'1.56ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1263 and date between '2025-04-01' and '2025-04-02' order by date asc67μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8780 and language_tag = 'nl-NL'22.04ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8780 AND offer_picture_enable = 1 ORDER BY offer_picture_id405μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 13130 and '2025-04-01'<= date and date<='2025-04-02'280μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7906 and date between '2025-04-01' and '2025-04-02' order by date asc65μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8780 and language_tag = 'nl-NL'61μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8780 AND offer_picture_enable = 1 ORDER BY offer_picture_id73μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_discounts`551μ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( 8778, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas364μ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( 8778, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas96μ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( 8779, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas316μ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( 8779, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas99μ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( 8780, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas256μ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( 8780, offer_ids ), 1 ) AND (hotel_id = 1075 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(1075, discount_hotel_ids)))) AND '2025-04-01' 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,9999,9999) , 1 ) ORDER BY discount_datas82μ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=1075127μ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-02' and c.end_date >='2025-04-01') and c.reservation_status <> 2 and c.hotel_id = 1075442μ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 = 1075 AND h.is_available = 1128μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=1075 and language_tag='nl-NL'86μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 1075 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id77μs1.67KB/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 = 1075 ORDER BY fc.ordering, hf.name;71μ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'82μ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'72μ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'61μ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=7 and language_tag='nl-NL'75μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=6 and language_tag='nl-NL'82μs17.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'121μ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'84μ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'89μ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'83μ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 = 1075 ORDER BY hf.name87μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 107590μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 107573μ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(50.84190349999999)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.5199440000000095 - poi_longitude)) + SIN(RADIANS(50.84190349999999)) * 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 asc77μs2.2KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=264 and language_tag='nl-NL'67μ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=264 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=222 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=222 ORDER BY id asc61μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=129 and language_tag='nl-NL'62μ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=129 ORDER BY id asc76μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=134 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=134 ORDER BY id asc170μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=110 and language_tag='nl-NL'143μ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=110 ORDER BY id asc81μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=89 and language_tag='nl-NL'88μ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=89 ORDER BY id asc81μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=335 and language_tag='nl-NL'79μ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=335 ORDER BY id asc80μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=34 and language_tag='nl-NL'70μ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=34 ORDER BY id asc110μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=28 and language_tag='nl-NL'80μ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=28 ORDER BY id asc84μs1.06KB/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 = 1075 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr66μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'63μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=10 and max_rate>=1053μs912B/administrator/components/com_jhotelreservation/tables/ratingclassifications.php:49Copy
  • select * from jos_hotelreservation_language_translations where type=21 and object_id=1 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=1075135μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=645 and language_tag='nl-NL'85μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=645 and language_tag='nl-NL'76μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=645 and language_tag='nl-NL'81μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=645 and language_tag='nl-NL'62μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=645 and language_tag='nl-NL'58μ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=107559μ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 = 1075 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50178μs19.97KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount74μ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((50.84190349999999 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(50.84190349999999 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.5199440000000095 - 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 (1075) group by h.hotel_id having distance < 10000 ORDER BY distance asc549μs271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=1075 and language_tag='nl-NL'72μ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=1075293μ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=1075168μs944B/administrator/components/com_jhotelreservation/tables/hotels.php:719Copy
  • SELECT count(hotel_id) as cityCount FROM jos_hotelreservation_hotels where hotel_city = 'Bilzen'437μ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=10510μ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=6261μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:756Copy
  • SELECT h.* FROM jos_hotelreservation_currencies h ORDER BY description asc57μ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)168μ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`871μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 078μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'98μ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'83μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'88μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'171μ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'110μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'105μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'118μ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_id681μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'587μ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.name92μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'93μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'90μ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'76μ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 * 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'77μ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'80μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • 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'77μ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'99μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'115μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?199μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.54ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy