Hotel Schaepkens van Sint Fijt

Nieuweweg 40-44, 6301 EV, Valkenburg, Limburg, Nederland

Zeer god

32 beoordelingen

7,6

In het pittoreske Valkenburg aan de Geul, op slechts een paar honderd meter afstand van het centrum, ligt het sfeervolle 3-sterren  Hotel Schaepkens van St. Fijt. Dit familiehotel met prachtige ligging behoort tot 1 van de meest bekende hotels in deze Zuid-Limburgse trekpleister. Het hotel beschikt over een uitstekend restaurant, sfeervolle bar en een prachtige tuin met groot terras. Als gast van dit hotel kunt u bovendien gratis het nabijgelegen recreatiecentrum de `Polfermolen` bezoeken. Hier vindt u een binnenzwembad, buitenzwembad (alleen in de zomermaanden), fitness, sauna en tevens een sporthal.

minder
In het pittoreske Valkenburg aan de Geul, op slechts een paar honderd meter afstand van het centrum, ligt het sfeervolle 3-sterren  Hotel Schaepkens van St. Fijt. Dit familiehotel met prachtige ligging behoort tot 1 van de meest bekende hotels in deze Zuid-Limburgse trekpleister. Het hotel beschikt over een uitstekend restaurant, sfeervolle bar en een prachtige tuin met groot terras. Als gast van dit hotel kunt u bovendien gratis het nabijgelegen recreatiecentrum de `Polfermolen`... Lees meer

Beoordeling van Hotel Schaepkens van Sint Fijt

7,6

Algemene waardering

7,5

Ligging

8,1

Service

7,8

Verhouding prijs/kwaliteit

7,3

Eten

7,7

Kamers

7,2
32 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Hotel Schaepkens van Sint Fijt.

donderdag 3 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
  • Gratis entree Holland Casino
  • Gratis stadsplattegrond
  • Gratis wandel- & fietsroutes
  • Gratis WiFi & parkeren
Read more

Min. nachten: 1

vanaf
€4.999,50
per persoon
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking
Comfort kamer
Niet beschikbaar
0
Kamer
personen
aantal gasten:

incl. ontbijt

De comfort kamer heeft aparte bedden, toilet en douche op de badkamer. Verder beschikt deze kamer over een tv, gratis kluisje, telefoon en gratis WIFI. De comfort kamers beschikken over een tapijt of flexi vloer.

Comfort kamer
Niet beschikbaar
0
Kamer
personen
aantal gasten:
Superior kamer
Niet beschikbaar
0
Kamer
personen
aantal gasten:
Superior +
Niet beschikbaar
0
Kamer
personen
aantal gasten:
Comfort kamer met balkon
Niet beschikbaar
0
Kamer
personen
aantal gasten:
vanaf
€ 4.999,50
per persoon

Halfpension arrangement

  • 1 of meerdere overnachtingen
  • Dagelijks uitgebreid ontbijtbuffet
  • Iedere avond een heerlijk 3-gangen diner of dinerbuffet
  • Gratis entree Holland Casino
  • Gratis stadsplattegrond
  • Gratis wandel- & fietsroutes
  • Gratis WiFi & parkeren
Read more

Min. nachten: 1

vanaf
€4.999,50
per persoon
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 3,00 p.p.p.n. & reserveringskosten € 9,50 per boeking

Algemene informatie

 Inchecken

vanaf 15:00 uur

 Uitchecken

tot 11:00 uur

 Verblijfsbelasting

€ 3,00 p.p.p.n

 Aantal kamers

130

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan (gratis)

 Mindervaliden

Aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

 Annuleringsvoorwaarden

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

 Kinderen

0-2 jaar gratis, 3 tot 6 jaar 50% korting, 7 tot 12 jaar 20% korting.

Faciliteiten

Fietsen
  • Fietsenstalling
Eten en drinken
  • Bar
  • Restaurant
  • Terras
Parkeergelegenheid
  • Gratis parkeren

Amenities

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren toegestaan (gratis)

 Mindervaliden

Aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

 Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

Show all amenities

Beoordeling van Hotel Schaepkens van Sint Fijt

7,6

Algemene waardering

7,5

Ligging

8,1

Service

7,8

Verhouding prijs/kwaliteit

7,3

Eten

7,7

Kamers

7,2
32 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Hotel Schaepkens van Sint Fijt.

Bezienswaardigheden & attracties

Pietersheimkinderboerderij

Kinderboerderij van Pietersheim

Neerharenweg, 12, 3620, Lanaken, Vlaanderen
Afstand van het hotel (hemelsbreed): 12,98 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): 10,54 km
Bezoek de stad aan de Maas en de hoofdstad van Limburg, Maastricht. Liefhebbers van cultuur en kunst kunnen in Maastricht zich heerlijk…
Mondo Verde

Mondo Verde

Groene Wereld, 10, 6372 PW, Landgraaf, Limburg
Afstand van het hotel (hemelsbreed): 13,71 km
Mondo Verde is een uniek park met verschillende thema's en een ware belevenis voor elke bezoeker, jong en oud. Kinderen kunnen zich heerlijk…
HogeKempen

Nationaal Park Hoge Kempen

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

SnowWorldlandgraaf

Witte Wereld, 1, 6372 VG, Landgraaf, Limburg
Afstand van het hotel (hemelsbreed): 13,15 km
Bij SnowWorld Landgraaf kunt u het hele jaar door skiën, snowboarden en natuurlijk Après-skiën. Met jaarlijks 750.000 bezoekers was…
DSC 5773

Thermae 2000

Cauberg, 25, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 1,24 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): 0,15 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): 10,45 km
Breng een bezoek aan het grootste en bekendste plein van Maastricht. Bekend van de vele monumenten, culturele voorzieningen en evenementen…
Bovenzicht

Abdij Val Dieu

Val Dieu, 225, 4880, Herve, Wallonie
Afstand van het hotel (hemelsbreed): 19,11 km
De abdij Onze Lieve Vrouw van Val-Dieu is een haven van vrede in het bisdom Luik. De abdij is een Cisterciënzer klooster van de Orde van…

Brand Bierbrouwerij

Brouwerijstraat, 2, 6321 AG, Wijlre, Limburg
Afstand van het hotel (hemelsbreed): 5,93 km
Neem een kijkje bij de oudste bierbrouwerij van Nederland, gelegen op een geweldige locatie in Zuid-Limburg. Wanneer u een rondleiding volgt…
drielandenpunt

Drielandenpunt

Viergrenzenweg, 97, 6291 BM, Vaals, Limburg
Afstand van het hotel (hemelsbreed): 17,23 km
Bekijk drie landen op één punt. Dit kan bij het drielandenpunt in Limburg. U kijkt over Nederland, Duitsland en België geniet van een…
fluwelengrot

Fluweelengrot Valkenburg

Daalhemerweg, 27, 6301 BJ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 0,91 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…
Giraffen

GaiaZOO

Dentgenbachweg, 105, 6468 PG, Kerkrade, Limburg
Afstand van het hotel (hemelsbreed): 14,85 km
GaiaZOO biedt een overweldigende beleving van dier en natuur. De Zuid-Limburgse dierentuin werd door onder andere een nieuw en uniek…
holland casino

Holland Casino Valkenburg

Cauberg, 28, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 1,06 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): 0,79 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): 12,98 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): 10,54 km
Bezoek de stad aan de Maas en de hoofdstad van Limburg, Maastricht. Liefhebbers van cultuur en kunst kunnen in Maastricht zich heerlijk…
Mondo Verde

Mondo Verde

Groene Wereld, 10, 6372 PW, Landgraaf, Limburg
Afstand van het hotel (hemelsbreed): 13,71 km
Mondo Verde is een uniek park met verschillende thema's en een ware belevenis voor elke bezoeker, jong en oud. Kinderen kunnen zich heerlijk…
HogeKempen

Nationaal Park Hoge Kempen

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

SnowWorldlandgraaf

Witte Wereld, 1, 6372 VG, Landgraaf, Limburg
Afstand van het hotel (hemelsbreed): 13,15 km
Bij SnowWorld Landgraaf kunt u het hele jaar door skiën, snowboarden en natuurlijk Après-skiën. Met jaarlijks 750.000 bezoekers was…
DSC 5773

Thermae 2000

Cauberg, 25, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 1,24 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): 0,15 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): 10,45 km
Breng een bezoek aan het grootste en bekendste plein van Maastricht. Bekend van de vele monumenten, culturele voorzieningen en evenementen…
Bovenzicht

Abdij Val Dieu

Val Dieu, 225, 4880, Herve, Wallonie
Afstand van het hotel (hemelsbreed): 19,11 km
De abdij Onze Lieve Vrouw van Val-Dieu is een haven van vrede in het bisdom Luik. De abdij is een Cisterciënzer klooster van de Orde van…

Brand Bierbrouwerij

Brouwerijstraat, 2, 6321 AG, Wijlre, Limburg
Afstand van het hotel (hemelsbreed): 5,93 km
Neem een kijkje bij de oudste bierbrouwerij van Nederland, gelegen op een geweldige locatie in Zuid-Limburg. Wanneer u een rondleiding volgt…
drielandenpunt

Drielandenpunt

Viergrenzenweg, 97, 6291 BM, Vaals, Limburg
Afstand van het hotel (hemelsbreed): 17,23 km
Bekijk drie landen op één punt. Dit kan bij het drielandenpunt in Limburg. U kijkt over Nederland, Duitsland en België geniet van een…
fluwelengrot

Fluweelengrot Valkenburg

Daalhemerweg, 27, 6301 BJ, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 0,91 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…
Giraffen

GaiaZOO

Dentgenbachweg, 105, 6468 PG, Kerkrade, Limburg
Afstand van het hotel (hemelsbreed): 14,85 km
GaiaZOO biedt een overweldigende beleving van dier en natuur. De Zuid-Limburgse dierentuin werd door onder andere een nieuw en uniek…
holland casino

Holland Casino Valkenburg

Cauberg, 28, 6301 BT, Valkenburg, Limburg
Afstand van het hotel (hemelsbreed): 1,06 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): 0,79 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): 12,98 km
Deze kinderboerderij is niet zomaar een kinderboerderij. Bij Pietersheim kunnen de kinderen zich de hele dag vermaken. Naast de dieren heeft…

Uw selectie

donderdag 3 april 2025

+−
Leaflet | © OpenStreetMap contributors
J! InfoRequestSessionProfileQueries241Log
39.609MBMemory Usage829msRequest 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" => "offerDiv7261" ]
$_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" => 1743678183 "last" => 1743678183...
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) (34.46ms)
  • afterInitialise (13.86MB) (147ms)
  • afterRoute (2.03MB) (32.35ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (6.65ms)
  • Before Access::preloadComponents (all components) (9.26MB) (463ms)
  • After Access::preloadComponents (all components) (150.39KB) (1.16ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (24μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (457μs)
  • afterRenderComponent com_jhotelreservation (1.14MB) (27.8ms)
  • afterDispatch (120.19KB) (3.11ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (44.7ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (388.88KB) (36.98ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (18μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (4.52ms)
  • afterRender (1.8MB) (25.15ms)
  • 1 x Before Access::preloadComponents (all components) (9.26MB) (55.86%)
    463.23ms
    1 x afterInitialise (13.86MB) (17.74%)
    147.15ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.16MB) (5.39%)
    44.70ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (388.88KB) (4.46%)
    36.98ms
    1 x afterLoad (4.2MB) (4.16%)
    34.46ms
    1 x afterRoute (2.03MB) (3.9%)
    32.35ms
    1 x afterRenderComponent com_jhotelreservation (1.14MB) (3.35%)
    27.80ms
    1 x afterRender (1.8MB) (3.03%)
    25.15ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.8%)
    6.65ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (0.54%)
    4.52ms
    1 x afterDispatch (120.19KB) (0.38%)
    3.11ms
    1 x After Access::preloadComponents (all components) (150.39KB) (0.14%)
    1.16ms
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.06%)
    457μ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%)
    18μs
241 statements were executed, 184 of which were duplicates, 57 unique377ms2.87MB
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 61Duplicates 62Duplicates 63Duplicates 64Duplicates 65Duplicates 66Duplicates 67Duplicates 68Duplicates 69Duplicates 70
  • SELECT @@SESSION.sql_mode;137μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?195μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1157μ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.39ms944BParams/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` = 1115μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`62μ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` = :guest86μ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`95μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1215μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC258μ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` = 179μ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`561μs184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas116μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'77μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'hotel-schaepkens-van-sint-fijt' LIMIT 1899μ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` = :id572μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'hotel-schaepkens-van-sint-fijt' LIMIT 1160μ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` = 1286μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'398μ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` = :id150μ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 = 57 AND h.is_available = 1453μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`566μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=57 and language_tag='nl-NL'374μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 57 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id467μs1.36KB/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 = 57 ORDER BY fc.ordering, hf.name;362μs1.25KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'226μ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'186μ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'61μ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'60μ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'196μ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 = 57 ORDER BY hf.name213μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 57266μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 57296μs11.84KB/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest`517μ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.8687557)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.834812300000067 - poi_longitude)) + SIN(RADIANS(50.8687557)) * 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.17ms2.3KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=337 and language_tag='nl-NL'2.36ms1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest_pictures`711μ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=337 ORDER BY id asc331μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=176 and language_tag='nl-NL'205μ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=176 ORDER BY id asc318μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=276 and language_tag='nl-NL'238μ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=276 ORDER BY id asc427μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=264 and language_tag='nl-NL'187μ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 asc269μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=334 and language_tag='nl-NL'490μ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=334 ORDER BY id asc360μs1.08KB/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'202μ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 asc270μ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'182μ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 asc275μ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'185μ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 asc250μ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'1.42ms1.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 asc282μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=336 and language_tag='nl-NL'208μ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=336 ORDER BY id asc297μ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'226μ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 asc411μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=51 and language_tag='nl-NL'271μ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=51 ORDER BY id asc303μ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'184μ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 asc254μ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'236μ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 asc244μ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'251μs9.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 asc302μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_review_answers`985μ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 = 57 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr12.34ms1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'289μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`577μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.58 and max_rate>=7.58242μ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'231μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotel_informations`648μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=57281μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=57 and language_tag='nl-NL'223μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=57 and language_tag='nl-NL'263μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=57 and language_tag='nl-NL'184μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=57 and language_tag='nl-NL'181μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=57 and language_tag='nl-NL'2.51ms1.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=57198μ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 = 57 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50151ms36.45KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount77μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`679μ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.8687557 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(50.8687557 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.834812300000067 - 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 (57) group by h.hotel_id having distance < 10000 ORDER BY distance asc20.46ms271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=57 and language_tag='nl-NL'230μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`629μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_rate_prices`646μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_room_availability`436μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_pictures`501μ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 = 57 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.ordering20.86ms22.77KB/administrator/components/com_jhotelreservation/tables/offers.php:324Copy
  • select * from jos_hotelreservation_language_translations where type=14 and language_tag = 'nl-NL'3.17ms29.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=2 and language_tag = 'nl-NL'2.45ms105.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=57486μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 9006 and '2025-04-03'<= date and date<='2025-04-04'5.3ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 102 and date between '2025-04-03' and '2025-04-04' order by date asc3.56ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7261 and language_tag = 'nl-NL'22.19ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7261 AND offer_picture_enable = 1 ORDER BY offer_picture_id3.91ms1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 10624 and '2025-04-03'<= date and date<='2025-04-04'4.44ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7575 and date between '2025-04-03' and '2025-04-04' order by date asc2.12ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7261 and language_tag = 'nl-NL'95μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7261 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 = 10625 and '2025-04-03'<= date and date<='2025-04-04'4.76ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7576 and date between '2025-04-03' and '2025-04-04' order by date asc1.89ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7261 and language_tag = 'nl-NL'65μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7261 AND offer_picture_enable = 1 ORDER BY offer_picture_id68μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 12148 and '2025-04-03'<= date and date<='2025-04-04'3.86ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7577 and date between '2025-04-03' and '2025-04-04' order by date asc1.65ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7261 and language_tag = 'nl-NL'2.61ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7261 AND offer_picture_enable = 1 ORDER BY offer_picture_id64μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 12149 and '2025-04-03'<= date and date<='2025-04-04'4.46ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7762 and date between '2025-04-03' and '2025-04-04' order by date asc2.38ms896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7261 and language_tag = 'nl-NL'81μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7261 AND offer_picture_enable = 1 ORDER BY offer_picture_id85μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 9498 and '2025-04-03'<= date and date<='2025-04-04'1.98ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 102 and date between '2025-04-03' and '2025-04-04' order by date asc63μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7439 and language_tag = 'nl-NL'24.1ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7439 AND offer_picture_enable = 1 ORDER BY offer_picture_id235μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 10621 and '2025-04-03'<= date and date<='2025-04-04'1.92ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7575 and date between '2025-04-03' and '2025-04-04' order by date asc57μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7439 and language_tag = 'nl-NL'69μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7439 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 = 10622 and '2025-04-03'<= date and date<='2025-04-04'954μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7576 and date between '2025-04-03' and '2025-04-04' order by date asc69μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7439 and language_tag = 'nl-NL'60μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7439 AND offer_picture_enable = 1 ORDER BY offer_picture_id58μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 12146 and '2025-04-03'<= date and date<='2025-04-04'2.63ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7577 and date between '2025-04-03' and '2025-04-04' order by date asc67μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7439 and language_tag = 'nl-NL'66μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7439 AND offer_picture_enable = 1 ORDER BY offer_picture_id69μs17.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 12147 and '2025-04-03'<= date and date<='2025-04-04'229μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7762 and date between '2025-04-03' and '2025-04-04' order by date asc57μs896B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=7439 and language_tag = 'nl-NL'59μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 7439 AND offer_picture_enable = 1 ORDER BY offer_picture_id58μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_discounts`752μ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( 7261, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas530μ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( 7261, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas123μ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( 7261, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas129μ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( 7261, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas111μ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( 7261, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas110μ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( 7439, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas373μ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( 7439, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas125μ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( 7439, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas113μ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( 7439, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas123μ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( 7439, offer_ids ), 1 ) AND (hotel_id = 57 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(57, discount_hotel_ids)))) AND '2025-04-03' 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_datas111μ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=57203μ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-04' and c.end_date >='2025-04-03') and c.reservation_status <> 2 and c.hotel_id = 57407μ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 = 57 AND h.is_available = 1185μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=57 and language_tag='nl-NL'84μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 57 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id81μs1.36KB/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 = 57 ORDER BY fc.ordering, hf.name;84μs1.25KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'80μ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'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'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'93μ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 = 57 ORDER BY hf.name71μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 5793μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 5766μ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.8687557)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.834812300000067 - poi_longitude)) + SIN(RADIANS(50.8687557)) * 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 asc102μs2.3KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=337 and language_tag='nl-NL'83μ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=337 ORDER BY id asc82μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=176 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=176 ORDER BY id asc79μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=276 and language_tag='nl-NL'76μ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=276 ORDER BY id asc79μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=264 and language_tag='nl-NL'74μ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 asc90μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=334 and language_tag='nl-NL'75μ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=334 ORDER BY id asc78μs1.08KB/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'76μ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 asc81μ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'76μ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 asc78μ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'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=134 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=110 and language_tag='nl-NL'76μ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 asc77μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=336 and language_tag='nl-NL'76μ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=336 ORDER BY id asc77μ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'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=89 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=51 and language_tag='nl-NL'55μ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=51 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=335 and language_tag='nl-NL'73μ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 asc58μ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'55μ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 asc57μ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'55μ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 asc59μ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 = 57 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr58μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'60μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=7.58 and max_rate>=7.5853μ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'71μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=57112μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=57 and language_tag='nl-NL'60μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=57 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=57 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=57 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=57 and language_tag='nl-NL'55μ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=5756μ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 = 57 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50210μs36.45KB/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.8687557 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(50.8687557 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.834812300000067 - 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 (57) group by h.hotel_id having distance < 10000 ORDER BY distance asc504μs271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=57 and language_tag='nl-NL'74μ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=57233μ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=57151μs928B/administrator/components/com_jhotelreservation/tables/hotels.php:719Copy
  • SELECT count(hotel_id) as cityCount FROM jos_hotelreservation_hotels where hotel_city = 'Valkenburg'381μ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=10497μ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=4446μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:756Copy
  • SELECT h.* FROM jos_hotelreservation_currencies h ORDER BY description asc124μ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)605μ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`813μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0607μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'123μ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'96μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • 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'121μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'101μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'98μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'140μ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 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_id10.33ms271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'4.67ms425.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.name5.24ms2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'124μ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'94μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'74μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'85μ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'81μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'74μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'88μ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'77μ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'104μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?333μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.37ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy