Westcord Hotel de Veluwe

Oud Milligenseweg 62, 3886 MJ, Garderen, Gelderland, Nederland

Zeer god

51 beoordelingen

8,2

WestCord Hotel De Veluwe is prachtig gelegen te midden van de Veluwse bossen in het dorp Garderen. Hotel De Veluwe ligt centraal tussen Amersfoort en Apeldoorn, op slechts 3 minuten per auto vanaf de A1. Het hotel heeft 97 comfortabele en sfeervol ingerichte hotelkamers welke allen zijn voorzien van gratis WiFi. Daarnaast biedt het hotel een grand café, restaurant en terrassen. Na een lange actieve dag kunt u gebruik maken van de wellnessfaciliteiten en het verwarmde buitenzwembad.

De Veluwe biedt verschillende wandel- en fietstochten door de rustgevende en ongerepte natuur. Tijdens een tocht, vroeg in de ochtend, heeft u kans dat u wilde herten of zwijnen tegen komt. In de nabij gelegen grote steden, Apeldoorn of Amersfoort, kunt u verschillende musea bezoeken of winkelen.

minder
WestCord Hotel De Veluwe is prachtig gelegen te midden van de Veluwse bossen in het dorp Garderen. Hotel De Veluwe ligt centraal tussen Amersfoort en Apeldoorn, op slechts 3 minuten per auto vanaf de A1. Het hotel heeft 97 comfortabele en sfeervol ingerichte hotelkamers welke allen zijn voorzien van gratis WiFi. Daarnaast biedt het hotel een grand café, restaurant en terrassen. Na een lange actieve dag kunt u gebruik maken van de wellnessfaciliteiten en het verwarmde... Lees meer

Beoordeling van Westcord Hotel de Veluwe

8,2

Algemene waardering

8,1

Ligging

8,5

Service

8,3

Verhouding prijs/kwaliteit

8,3

Eten

7,8

Kamers

7,9
51 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Westcord Hotel de Veluwe.

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

2-daags Oud & Nieuw arrangement

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

Min. nachten: 1

vanaf
€74,50
per persoon
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
vanaf
€ 169,50
per persoon

3-daags Veluwe arrangement

  • 2x overnachting inclusief uitgebreid ontbijtbuffet
  • 2x heerlijk 3-gangen verrassingsdiner
  • Gratis koffie- & theefaciliteiten op de kamer
  • Fietskaart van de Veluwe
  • Gratis wandel- & fietsroutes
  • Gratis WiFi & parkeren
Read more

Min. nachten: 2

vanaf
€169,50
per persoon
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
Tweepersoonskamer (feestdagen)
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
€114,75
per persoon

Deze kamer is voorzien van double of twin bedden, zitje, flatscreen tv, kluisje, bureau, gratis koffie- & theefaciliteiten, gratis WiFi & koelkast. De badkamer beschikt over douche & toilet.

Tweepersoonskamer
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
€169,50
per persoon

incl. ontbijt

Deze kamer is voorzien van double of twin bedden, zitje, flatscreen tv, kluisje, bureau, gratis koffie- & theefaciliteiten, gratis WiFi & koelkast. De badkamer beschikt over douche & toilet.

Op 31 december is zowel het restaurant als de bar gesloten, er kan op deze dag geen gebruik gemaakt worden van het diner.

Tweepersoonskamer (arrangement)
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
€179,50
per persoon
Comfortkamer met bad
Min. aantal nachten: 2
Kamer
personen
aantal gasten:
Beschikbaar v.a.
€179,50
per persoon
vanaf
€ 9.999,00
per persoon

3-daags Logies & ontbijt arrangement

  • 2x overnachting
  • Dagelijks uitgebreid ontbijtbuffet
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis WiFi & parkeren
Read more

Min. nachten: 2

vanaf
€9.999,00
per persoon
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
vanaf
€ 14.998,50
per persoon

4-daags Logies & ontbijt arrangement

  • 3x overnachting
  • Dagelijks uitgebreid ontbijtbuffet
  • Gratis koffie- & theefaciliteiten op de kamer
  • Gratis WiFi & parkeren
Read more

Min. nachten: 3

vanaf
€14.998,50
per persoon
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking
excl. verblijfsbelasting à € 1,50 p.p.p.n. & reserveringskosten € 9,50 per boeking

Algemene informatie

 Inchecken

vanaf 15:00 uur

 Uitchecken

tot 11:00 uur

 Verblijfsbelasting

€ 1,50 p.p.p.n

 Aantal kamers

97

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren niet toegestaan

 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 tot 3 jaar gratis | 3 t/m 12 jaar 50% korting

Faciliteiten

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

Amenities

 Parkeren

Parkeergelegenheid beschikbaar (gratis)

 WiFi

WiFi beschikbaar (gratis)

 Huisdieren

Huisdieren niet toegestaan

 Mindervaliden

Aangepaste kamers beschikbaar

 Openbaar vervoer

Bereikbaar per openbaar vervoer

 Betalingsmogelijkheden in het hotel

Contant, Pin, Credit Card

Show all amenities

Beoordeling van Westcord Hotel de Veluwe

8,2

Algemene waardering

8,1

Ligging

8,5

Service

8,3

Verhouding prijs/kwaliteit

8,3

Eten

7,8

Kamers

7,9
51 beoordelingen

Beoordelingen zijn geschreven door gasten na hun verblijf bij Westcord Hotel de Veluwe.

Bezienswaardigheden & attracties

Mariahoeve Boerderij Putten

Mariahoeve

Kiefveldersteeg, 11, 3882 RG, Putten, Gelderland
Afstand van het hotel (hemelsbreed): 12,22 km
Bezichtig een boerderij uit de vorige eeuw. De huizen hadden een aantal hectare grond voor het verbouwen van mais, graan en aardappelen, of…
veluwe

Nationaal Park de Hoge Veluwe

Houtkampweg, 9, 6731 AV, Otterlo, Gelderland
Afstand van het hotel (hemelsbreed): 13,69 km
Ontdek de prachtige natuur van Het Nationale Park De Hoge Veluwe. Kom tot rust in dit prachtige natuurgebied, wandel of fiets door de…
paleishetloo2

Paleis Het Loo

Koninklijk Park, 1, 7315 JA, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 15,39 km
Door de ANWB benoemd voor een zilveren medaille in de provincie Gelderland, voor het Leukste uitje in 2016 van Nederland. Aan de rand van…
fundusty paintball

Strandhorst paintball

Palmbosweg, 8, Ermelo, Gelderland
Afstand van het hotel (hemelsbreed): 14,76 km
Een dagje rennen, duiken en springen op het strand. Bezoek dan eens Paintball strand bij Harderwijk voor een spectaculaire middag…
walibi

Walibi Holland

Spijkweg, 30, 8256 RJ, Biddinghuizen, Flevoland
Afstand van het hotel (hemelsbreed): 24,55 km
Bezoek Walibi Holland en beleef een dag vol spanning en sensatie. Het park heft de hoogste en snelste achtbaan van de Benelux. Met een…
zandsculpturengarderen

Zandsculpturen Festijn

Oude Barnevelderweg, 5, 3886 PT, Garderen, Gelderland
Afstand van het hotel (hemelsbreed): 0,99 km
Ontdek de prachtige zandsculpturen op de Veluwe. Van 15 april t/m 29 oktober kunt u de kunstwerken bewonderen. Ruim 20 kunstenaars brachten…
Zwaluwhoevehierden

Zwaluwhoeve

Zuiderzeestraatweg, 108, 3849 AJ, Hierden, Gelderland
Afstand van het hotel (hemelsbreed): 15,27 km
Een heerlijk dag ontspannen bij de Zwaluwhoeve, geniet van heerlijke sauna’s en behandelingen. Bij de Zwaluwehoeve kunt u zelf…
Apenheul

Apenheul

J.C. Wilslaan, 21, 7313 HK, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 14,01 km
Neem een kijkje bij de apen in Apeldoorn. Er zijn in dit groene dierenpark bijna 300 apen te zien, waarvan de helft gewoon tussen de…
Dolfinarium

Dolfinarium

Strandboulevard Oost, 1, 3841 AB, Harderwijk, Gelderland
Afstand van het hotel (hemelsbreed): 16,40 km
Breng een dag door bij het Dolfinarium, ontdek de dolfijnen, walrussen, zeeleeuwen en andere zoogdieren. Bij het Dolfinarium kunt u zelf…
KrollerMollerMuseum

Het Kröller-Möller Museum

Houtkampweg, 6, 6731 AW, Otterlo, Gelderland
Afstand van het hotel (hemelsbreed): 15,37 km
Ontdek het levenswerk van Helene Kröller-Müller. Zij heeft samen met haar man Anton Kröller tussen 1907 en 1922 meer dan 11.000…

Het Veluwemeer

Strandboulevard, 3, 3882 RN, Putten, Gelderland
Afstand van het hotel (hemelsbreed): 13,95 km
Het Veluwemeer is een meer tussen de Veluwe en Flevoland. In het zuidwesten grenst het aan het Wolderwijd. In het noordoosten grenst het aan…
Kijktuinen Nunspeet Tuin

Kijktuinen Nunspeet

Kienschulpenweg, 26, 8071 ZK, Nunspeet, Gelderland
Afstand van het hotel (hemelsbreed): 16,89 km
Bijna 5 hectare voorbeeldtuinen, Maisdoolhof en Blote Voetenpad. Door deze unieke combinatie zeer geschikt voor een dagje uit met het hele…
julianatoren

Koning Juliana Toren

Amersfoortseweg, 35, 7313 AC, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 13,34 km
Bezoek het leukste familiepret park van Nederland. Julianatoren in Apeldoorn heeft meer dan 60 spectaculaire attracties, van een snelle…
Mariahoeve Boerderij Putten

Mariahoeve

Kiefveldersteeg, 11, 3882 RG, Putten, Gelderland
Afstand van het hotel (hemelsbreed): 12,22 km
Bezichtig een boerderij uit de vorige eeuw. De huizen hadden een aantal hectare grond voor het verbouwen van mais, graan en aardappelen, of…
veluwe

Nationaal Park de Hoge Veluwe

Houtkampweg, 9, 6731 AV, Otterlo, Gelderland
Afstand van het hotel (hemelsbreed): 13,69 km
Ontdek de prachtige natuur van Het Nationale Park De Hoge Veluwe. Kom tot rust in dit prachtige natuurgebied, wandel of fiets door de…
paleishetloo2

Paleis Het Loo

Koninklijk Park, 1, 7315 JA, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 15,39 km
Door de ANWB benoemd voor een zilveren medaille in de provincie Gelderland, voor het Leukste uitje in 2016 van Nederland. Aan de rand van…
fundusty paintball

Strandhorst paintball

Palmbosweg, 8, Ermelo, Gelderland
Afstand van het hotel (hemelsbreed): 14,76 km
Een dagje rennen, duiken en springen op het strand. Bezoek dan eens Paintball strand bij Harderwijk voor een spectaculaire middag…
walibi

Walibi Holland

Spijkweg, 30, 8256 RJ, Biddinghuizen, Flevoland
Afstand van het hotel (hemelsbreed): 24,55 km
Bezoek Walibi Holland en beleef een dag vol spanning en sensatie. Het park heft de hoogste en snelste achtbaan van de Benelux. Met een…
zandsculpturengarderen

Zandsculpturen Festijn

Oude Barnevelderweg, 5, 3886 PT, Garderen, Gelderland
Afstand van het hotel (hemelsbreed): 0,99 km
Ontdek de prachtige zandsculpturen op de Veluwe. Van 15 april t/m 29 oktober kunt u de kunstwerken bewonderen. Ruim 20 kunstenaars brachten…
Zwaluwhoevehierden

Zwaluwhoeve

Zuiderzeestraatweg, 108, 3849 AJ, Hierden, Gelderland
Afstand van het hotel (hemelsbreed): 15,27 km
Een heerlijk dag ontspannen bij de Zwaluwhoeve, geniet van heerlijke sauna’s en behandelingen. Bij de Zwaluwehoeve kunt u zelf…
Apenheul

Apenheul

J.C. Wilslaan, 21, 7313 HK, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 14,01 km
Neem een kijkje bij de apen in Apeldoorn. Er zijn in dit groene dierenpark bijna 300 apen te zien, waarvan de helft gewoon tussen de…
Dolfinarium

Dolfinarium

Strandboulevard Oost, 1, 3841 AB, Harderwijk, Gelderland
Afstand van het hotel (hemelsbreed): 16,40 km
Breng een dag door bij het Dolfinarium, ontdek de dolfijnen, walrussen, zeeleeuwen en andere zoogdieren. Bij het Dolfinarium kunt u zelf…
KrollerMollerMuseum

Het Kröller-Möller Museum

Houtkampweg, 6, 6731 AW, Otterlo, Gelderland
Afstand van het hotel (hemelsbreed): 15,37 km
Ontdek het levenswerk van Helene Kröller-Müller. Zij heeft samen met haar man Anton Kröller tussen 1907 en 1922 meer dan 11.000…

Het Veluwemeer

Strandboulevard, 3, 3882 RN, Putten, Gelderland
Afstand van het hotel (hemelsbreed): 13,95 km
Het Veluwemeer is een meer tussen de Veluwe en Flevoland. In het zuidwesten grenst het aan het Wolderwijd. In het noordoosten grenst het aan…
Kijktuinen Nunspeet Tuin

Kijktuinen Nunspeet

Kienschulpenweg, 26, 8071 ZK, Nunspeet, Gelderland
Afstand van het hotel (hemelsbreed): 16,89 km
Bijna 5 hectare voorbeeldtuinen, Maisdoolhof en Blote Voetenpad. Door deze unieke combinatie zeer geschikt voor een dagje uit met het hele…
julianatoren

Koning Juliana Toren

Amersfoortseweg, 35, 7313 AC, Apeldoorn, Gelderland
Afstand van het hotel (hemelsbreed): 13,34 km
Bezoek het leukste familiepret park van Nederland. Julianatoren in Apeldoorn heeft meer dan 60 spectaculaire attracties, van een snelle…
Mariahoeve Boerderij Putten

Mariahoeve

Kiefveldersteeg, 11, 3882 RG, Putten, Gelderland
Afstand van het hotel (hemelsbreed): 12,22 km
Bezichtig een boerderij uit de vorige eeuw. De huizen hadden een aantal hectare grond voor het verbouwen van mais, graan en aardappelen, of…

Uw selectie

vrijdag 4 april 2025

+−
Leaflet | © OpenStreetMap contributors
J! InfoRequestSessionProfileQueries277Log
40.933MBMemory Usage631msRequest 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" => "offerDiv4486" ]
$_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" => 1743738369 "last" => 1743738369...
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) (32.6ms)
  • afterInitialise (13.86MB) (137ms)
  • afterRoute (2.03MB) (27.29ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (5.04ms)
  • Before Access::preloadComponents (all components) (10.16MB) (316ms)
  • After Access::preloadComponents (all components) (134.39KB) (832μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (486μs)
  • afterRenderComponent com_jhotelreservation (1.24MB) (19.19ms)
  • afterDispatch (120.19KB) (2.04ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.22MB) (42.1ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (17.79ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (14μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (4.14ms)
  • afterRender (1.91MB) (24.48ms)
  • 1 x Before Access::preloadComponents (all components) (10.16MB) (50.08%)
    315.99ms
    1 x afterInitialise (13.86MB) (21.77%)
    137.37ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.22MB) (6.67%)
    42.10ms
    1 x afterLoad (4.2MB) (5.17%)
    32.60ms
    1 x afterRoute (2.03MB) (4.33%)
    27.29ms
    1 x afterRender (1.91MB) (3.88%)
    24.48ms
    1 x afterRenderComponent com_jhotelreservation (1.24MB) (3.04%)
    19.19ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (387.63KB) (2.82%)
    17.79ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (0.8%)
    5.04ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (396.83KB) (0.66%)
    4.14ms
    1 x afterDispatch (120.19KB) (0.32%)
    2.04ms
    1 x After Access::preloadComponents (all components) (134.39KB) (0.13%)
    832μs
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.08%)
    486μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0%)
    25μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    14μs
277 statements were executed, 210 of which were duplicates, 67 unique230ms2.97MB
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 70Duplicates 71Duplicates 72Duplicates 73Duplicates 74
  • SELECT @@SESSION.sql_mode;123μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?342μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1268μ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)2.17ms944BParams/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` = 181μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`66μ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` = :guest64μ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`81μ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` ASC112μs2.25KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `jos_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 162μs1.11KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`2.08ms184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas118μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'68μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'westcord-hotel-de-veluwe' LIMIT 1629μ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` = :id80μs1.69KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * from jos_hotelreservation_hotels h WHERE h.hotel_alias = 'westcord-hotel-de-veluwe' LIMIT 1109μs9.84KB/plugins/system/hotelurltranslator/jhprouter.php:132Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1214μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'117μ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` = :id97μ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 = 328 AND h.is_available = 1445μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`499μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=328 and language_tag='nl-NL'309μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 328 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id374μ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 = 328 ORDER BY fc.ordering, hf.name;397μs1.36KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=5 and language_tag='nl-NL'78μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=8 and language_tag='nl-NL'59μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=9 and language_tag='nl-NL'67μ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'68μ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=7 and language_tag='nl-NL'72μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'57μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'56μ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'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'64μ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'66μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=3 and language_tag='nl-NL'96μ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 = 328 ORDER BY hf.name232μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 328164μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 328373μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest`544μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from( select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county, 111.1111 * DEGREES(ACOS(COS(RADIANS(52.220752)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.721066999999948 - poi_longitude)) + SIN(RADIANS(52.220752)) * 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.08ms2.27KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=1 and language_tag='nl-NL'67μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_points_of_interest_pictures`498μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=1 ORDER BY id asc77μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=278 and language_tag='nl-NL'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=278 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=122 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=122 ORDER BY id asc58μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=417 and language_tag='nl-NL'61μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=417 ORDER BY id asc118μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=127 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=127 ORDER BY id asc66μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=138 and language_tag='nl-NL'72μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=138 ORDER BY id asc61μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=108 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=108 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=54 and language_tag='nl-NL'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=54 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=61 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=61 ORDER BY id asc59μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=47 and language_tag='nl-NL'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=47 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=24 and language_tag='nl-NL'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=24 ORDER BY id asc83μs9.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=8 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=8 ORDER BY id asc67μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=3 and language_tag='nl-NL'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=3 ORDER BY id asc75μs1.09KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_review_answers`449μ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 = 328 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr1.24ms1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'73μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_rating_classification`468μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=8.15 and max_rate>=8.1564μ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'60μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotel_informations`506μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=328251μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=328 and language_tag='nl-NL'219μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=328 and language_tag='nl-NL'182μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=328 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=328 and language_tag='nl-NL'173μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=328 and language_tag='nl-NL'202μ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=328184μ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 = 328 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 5036.99ms36.83KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount93μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`610μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT h.*,hotel_picture_path, min(hp.hotel_picture_id), 1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((52.220752 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(52.220752 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.721066999999948 - 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 (328) group by h.hotel_id having distance < 10000 ORDER BY distance asc20.02ms271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=328 and language_tag='nl-NL'248μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`552μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_rate_prices`463μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_room_availability`427μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers_pictures`407μ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 = 328 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.31ms42.86KB/administrator/components/com_jhotelreservation/tables/offers.php:324Copy
  • select * from jos_hotelreservation_language_translations where type=14 and language_tag = 'nl-NL'172μs29.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=2 and language_tag = 'nl-NL'208μ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=328329μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 8378 and '2025-04-04'<= date and date<='2025-04-05'4.04ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 526 and date between '2025-04-04' and '2025-04-05' order by date asc3.67ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4220 and language_tag = 'nl-NL'21.06ms1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4220 AND offer_picture_enable = 1 ORDER BY offer_picture_id269μs1.09KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 8934 and '2025-04-04'<= date and date<='2025-04-05'2.67ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 988 and date between '2025-04-04' and '2025-04-05' order by date asc4.22ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4220 and language_tag = 'nl-NL'91μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4220 AND offer_picture_enable = 1 ORDER BY offer_picture_id67μs1.09KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 8935 and '2025-04-04'<= date and date<='2025-04-05'1.57ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7272 and date between '2025-04-04' and '2025-04-05' order by date asc3.61ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4220 and language_tag = 'nl-NL'71μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4220 AND offer_picture_enable = 1 ORDER BY offer_picture_id76μs1.09KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 8983 and '2025-04-04'<= date and date<='2025-04-05'1.2ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1012 and date between '2025-04-04' and '2025-04-05' order by date asc3.24ms928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4220 and language_tag = 'nl-NL'85μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4220 AND offer_picture_enable = 1 ORDER BY offer_picture_id61μs1.09KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 6907 and '2025-04-04'<= date and date<='2025-04-05'1.78ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 526 and date between '2025-04-04' and '2025-04-05' order by date asc60μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4486 and language_tag = 'nl-NL'19.89ms1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4486 AND offer_picture_enable = 1 ORDER BY offer_picture_id279μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 7464 and '2025-04-04'<= date and date<='2025-04-05'1.65ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1012 and date between '2025-04-04' and '2025-04-05' order by date asc58μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4486 and language_tag = 'nl-NL'80μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4486 AND offer_picture_enable = 1 ORDER BY offer_picture_id66μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 8930 and '2025-04-04'<= date and date<='2025-04-05'1.54ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 988 and date between '2025-04-04' and '2025-04-05' order by date asc68μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4486 and language_tag = 'nl-NL'69μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4486 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 = 8931 and '2025-04-04'<= date and date<='2025-04-05'1.69ms2.14KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7272 and date between '2025-04-04' and '2025-04-05' order by date asc55μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=4486 and language_tag = 'nl-NL'69μs1.09KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 4486 AND offer_picture_enable = 1 ORDER BY offer_picture_id59μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11971 and '2025-04-04'<= date and date<='2025-04-05'2.03ms18.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 526 and date between '2025-04-04' and '2025-04-05' order by date asc54μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8401 and language_tag = 'nl-NL'19.8ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8401 AND offer_picture_enable = 1 ORDER BY offer_picture_id232μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11972 and '2025-04-04'<= date and date<='2025-04-05'982μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 988 and date between '2025-04-04' and '2025-04-05' order by date asc60μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8401 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 = 8401 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 = 11973 and '2025-04-04'<= date and date<='2025-04-05'755μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1012 and date between '2025-04-04' and '2025-04-05' order by date asc70μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8401 and language_tag = 'nl-NL'58μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8401 AND offer_picture_enable = 1 ORDER BY offer_picture_id60μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11974 and '2025-04-04'<= date and date<='2025-04-05'1.18ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7272 and date between '2025-04-04' and '2025-04-05' order by date asc66μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8401 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 = 8401 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 = 11975 and '2025-04-04'<= date and date<='2025-04-05'1.25ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 526 and date between '2025-04-04' and '2025-04-05' order by date asc63μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8402 and language_tag = 'nl-NL'19.88ms1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8402 AND offer_picture_enable = 1 ORDER BY offer_picture_id225μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • select * from jos_hotelreservation_offers_rate_prices r where rate_id = 11976 and '2025-04-04'<= date and date<='2025-04-05'883μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 988 and date between '2025-04-04' and '2025-04-05' order by date asc56μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8402 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 = 8402 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 = 11977 and '2025-04-04'<= date and date<='2025-04-05'769μs2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 1012 and date between '2025-04-04' and '2025-04-05' order by date asc58μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8402 and language_tag = 'nl-NL'57μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8402 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 = 11978 and '2025-04-04'<= date and date<='2025-04-05'1.42ms2.11KB/administrator/components/com_jhotelreservation/tables/offerrateprices.php:50Copy
  • SELECT date,availability FROM jos_hotelreservation_room_availability where room_id = 7272 and date between '2025-04-04' and '2025-04-05' order by date asc54μs928B/administrator/components/com_jhotelreservation/tables/roomavailability.php:44Copy
  • select * from jos_hotelreservation_language_translations where object_id=8402 and language_tag = 'nl-NL'56μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:74Copy
  • SELECT * FROM jos_hotelreservation_offers_pictures WHERE offer_id = 8402 AND offer_picture_enable = 1 ORDER BY offer_picture_id70μs1.08KB/administrator/components/com_jhotelreservation/tables/offerpictures.php:38Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_discounts`544μ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( 4220, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,149,149) , 1 ) ORDER BY discount_datas298μ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( 4220, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,159,159) , 1 ) ORDER BY discount_datas320μ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( 4220, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,159,159) , 1 ) ORDER BY discount_datas84μ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( 4220, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,135,135) , 1 ) ORDER BY discount_datas244μ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( 4486, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,169.5,169.5) , 1 ) ORDER BY discount_datas247μ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( 4486, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,172.125,172.125) , 1 ) ORDER BY discount_datas238μ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( 4486, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,179.5,179.5) , 1 ) ORDER BY discount_datas241μ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( 4486, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,179.5,179.5) , 1 ) ORDER BY discount_datas81μ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( 8401, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas237μ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( 8401, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas84μ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( 8401, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas88μ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( 8401, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas81μ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( 8402, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas349μ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( 8402, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas81μ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( 8402, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas84μ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( 8402, offer_ids ), 1 ) AND (hotel_id = 328 OR (hotel_id = 0 AND (discount_hotel_ids IS NULL OR discount_hotel_ids = '' OR FIND_IN_SET(328, discount_hotel_ids)))) AND '2025-04-04' BETWEEN discount_datas AND discount_datae AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 ) AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 ) AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,9999,9999) , 1 ) ORDER BY discount_datas96μ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=328134μs7.78KB/components/com_jhotelreservation/helpers/utils.php:1356Copy
  • select c.confirmation_id,hcr.room_id,hcr.offer_id,c.start_date, c.end_date from jos_hotelreservation_confirmations_rooms hcr inner join jos_hotelreservation_confirmations c on c.confirmation_id= hcr.confirmation_id where (c.start_date <'2025-04-05' and c.end_date >='2025-04-04') and c.reservation_status <> 2 and c.hotel_id = 328420μ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 = 328 AND h.is_available = 1132μs7.44KB/components/com_jhotelreservation/classes/services/HotelService.php:120Copy
  • select * from jos_hotelreservation_language_translations where type=1 and object_id=328 and language_tag='nl-NL'87μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM jos_hotelreservation_hotel_pictures WHERE hotel_id = 328 AND hotel_picture_enable = 1 ORDER BY hotel_picture_id63μ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 = 328 ORDER BY fc.ordering, hf.name;65μs1.36KB/components/com_jhotelreservation/classes/services/HotelService.php:159Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=5 and language_tag='nl-NL'64μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=8 and language_tag='nl-NL'65μ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'68μ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'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'62μ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'71μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=7 and language_tag='nl-NL'61μ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'58μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=4 and language_tag='nl-NL'57μ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'59μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=3 and language_tag='nl-NL'60μ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 = 328 ORDER BY hf.name54μs912B/components/com_jhotelreservation/classes/services/HotelService.php:178Copy
  • SELECT * from jos_hotelreservation_hotel_channel_manager where hotel_id = 32871μs2.05KB/components/com_jhotelreservation/classes/services/HotelService.php:184Copy
  • SELECT hc.booking_email from jos_hotelreservation_hotel_contacts as hc where hotel_id = 32850μs856B/components/com_jhotelreservation/classes/services/HotelService.php:189Copy
  • select * from( select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county, 111.1111 * DEGREES(ACOS(COS(RADIANS(52.220752)) * COS(RADIANS(poi_latitude)) * COS(RADIANS(5.721066999999948 - poi_longitude)) + SIN(RADIANS(52.220752)) * 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 asc73μs2.27KB/administrator/components/com_jhotelreservation/tables/poi.php:98Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=1 and language_tag='nl-NL'94μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=1 ORDER BY id asc59μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=278 and language_tag='nl-NL'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=278 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=122 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=122 ORDER BY id asc58μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=417 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=417 ORDER BY id asc58μs1.05KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=127 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=127 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=138 and language_tag='nl-NL'65μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=138 ORDER BY id asc73μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=108 and language_tag='nl-NL'72μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=108 ORDER BY id asc70μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=54 and language_tag='nl-NL'69μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=54 ORDER BY id asc59μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=61 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=61 ORDER BY id asc57μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=47 and language_tag='nl-NL'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=47 ORDER BY id asc58μs1.08KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=24 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=24 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=8 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=8 ORDER BY id asc56μs1.06KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select * from jos_hotelreservation_language_translations where type=20 and object_id=3 and language_tag='nl-NL'57μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • SELECT * FROM `jos_hotelreservation_points_of_interest_pictures` WHERE poi_picture_enable = 1 AND poid=3 ORDER BY id asc58μs1.09KB/administrator/components/com_jhotelreservation/tables/poipictures.php:45Copy
  • select rq.review_question_id,rq.review_question_desc as question, avg(rs.weight) as average from jos_hotelreservation_review_answers ra inner join jos_hotelreservation_review_customers rc on ra.review_id = rc.review_id inner join jos_hotelreservation_review_questions rq on ra.review_question_id = rq.review_question_id inner join jos_hotelreservation_review_rating_scale rs on rs.rating_scale_id = ra.rating_scale_id where rc.hotel_id = 328 and rs.weight<>0 group by rq.review_question_id ORDER BY rq.review_question_nr59μs1.03KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:48Copy
  • select * from jos_hotelreservation_language_translations where type=13 and language_tag = 'nl-NL'61μs1.13KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:59Copy
  • SELECT id,name FROM `jos_hotelreservation_rating_classification` WHERE min_rate<=8.15 and max_rate>=8.1552μ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'79μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * FROM jos_hotelreservation_hotel_informations where hotel_id=32897μs4.09KB/administrator/components/com_jhotelreservation/tables/hotelinformations.php:28Copy
  • select * from jos_hotelreservation_language_translations where type=11 and object_id=328 and language_tag='nl-NL'75μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=24 and object_id=328 and language_tag='nl-NL'59μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=25 and object_id=328 and language_tag='nl-NL'66μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=26 and object_id=328 and language_tag='nl-NL'56μs1.06KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:52Copy
  • select * from jos_hotelreservation_language_translations where type=12 and object_id=328 and language_tag='nl-NL'60μ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=32858μ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 = 328 and rc.published=1 and rs.weight<>0 group by rc.review_id ORDER BY rc.review_id desc LIMIT 50239μs36.83KB/administrator/components/com_jhotelreservation/tables/reviewanswers.php:62Copy
  • SELECT FOUND_ROWS() as totalReviewsCount83μs856B/administrator/components/com_jhotelreservation/tables/reviewanswers.php:66Copy
  • SELECT h.*,hotel_picture_path, min(hp.hotel_picture_id), 1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((52.220752 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(52.220752 * pi()/180 ) * COS( abs(h.hotel_latitude) * pi()/180) * POWER(SIN((5.721066999999948 - 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 (328) group by h.hotel_id having distance < 10000 ORDER BY distance asc637μs271.45KB/administrator/components/com_jhotelreservation/tables/hotels.php:709Copy
  • select * from jos_hotelreservation_language_translations where type=23 and object_id=328 and language_tag='nl-NL'70μ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=328262μ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=328175μs928B/administrator/components/com_jhotelreservation/tables/hotels.php:719Copy
  • SELECT count(hotel_id) as cityCount FROM jos_hotelreservation_hotels where hotel_city = 'Garderen'371μ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=6516μ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=454μs856B/administrator/components/com_jhotelreservation/tables/hotels.php:756Copy
  • SELECT h.* FROM jos_hotelreservation_currencies h ORDER BY description asc56μ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)282μ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`741μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 086μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'126μ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'78μ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'141μ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'110μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'94μs65.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 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_id401μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'649μ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.name103μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • 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'83μ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'75μ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'89μ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'86μ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'75μ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'73μ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 `session_id` FROM `jos_session` WHERE `session_id` = ?212μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.55ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy