Geen resultaten gevonden
donderdag 3 april 2025 Tot vrijdag 4 april 2025
Aantal personen: 2, Aantal Kamers: 1
Geen record gevonden
J! InfoRequestSessionProfileQueries73Log
33.355MBMemory Usage506msRequest 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
[]
$_POST
[]
$_SESSION
array:2 [ "userData" => {#1011 +"searchType": "" +"keyword": "" +"start_date": "2025-0...
$_COOKIE
[]
$_SERVER
array:109 [ "USER" => "goedve01" "HOME" => "/var/www/vhosts/goedverblijf.nl" "SCRIPT_NAME" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743678183 "last" => 1743678183...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "nl-NL" ]
  • afterLoad (4.2MB) (34.22ms)
  • afterInitialise (13.86MB) (146ms)
  • afterRoute (1.99MB) (47.17ms)
  • beforeRenderComponent com_jhotelreservation (508.19KB) (5.24ms)
  • Before Access::preloadComponents (all components) (3.49MB) (48.74ms)
  • After Access::preloadComponents (all components) (110.93KB) (8.41ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (28μs)
  • After Access::getAssetRules (id:1 name:root.1) (29.45KB) (541μs)
  • beforeRenderRawModule mod_jhotelreservation (JHotelReservation) (466.62KB) (85.54ms)
  • afterRenderRawModule mod_jhotelreservation (JHotelReservation) (512.28KB) (25.08ms)
  • beforeRenderModule mod_jhotelreservation (JHotelReservation) (736B) (19μs)
  • afterRenderModule mod_jhotelreservation (JHotelReservation) (389.3KB) (2.48ms)
  • afterRenderComponent com_jhotelreservation (406.38KB) (8.13ms)
  • afterDispatch (115.63KB) (2.48ms)
  • beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.09MB) (46.64ms)
  • afterRenderRawModule mod_jhotelreservation (Hotel top search) (303.86KB) (15.49ms)
  • beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (14μs)
  • afterRenderModule mod_jhotelreservation (Hotel top search) (350.14KB) (3.99ms)
  • afterRender (1.46MB) (23.79ms)
  • 1 x afterInitialise (13.86MB) (28.8%)
    145.67ms
    1 x beforeRenderRawModule mod_jhotelreservation (JHotelReservation) (466.62KB) (16.91%)
    85.54ms
    1 x Before Access::preloadComponents (all components) (3.49MB) (9.64%)
    48.74ms
    1 x afterRoute (1.99MB) (9.33%)
    47.17ms
    1 x beforeRenderRawModule mod_jhotelreservation (Hotel top search) (3.09MB) (9.22%)
    46.64ms
    1 x afterLoad (4.2MB) (6.77%)
    34.22ms
    1 x afterRenderRawModule mod_jhotelreservation (JHotelReservation) (512.28KB) (4.96%)
    25.08ms
    1 x afterRender (1.46MB) (4.7%)
    23.79ms
    1 x afterRenderRawModule mod_jhotelreservation (Hotel top search) (303.86KB) (3.06%)
    15.49ms
    1 x After Access::preloadComponents (all components) (110.93KB) (1.66%)
    8.41ms
    1 x afterRenderComponent com_jhotelreservation (406.38KB) (1.61%)
    8.13ms
    1 x beforeRenderComponent com_jhotelreservation (508.19KB) (1.04%)
    5.24ms
    1 x afterRenderModule mod_jhotelreservation (Hotel top search) (350.14KB) (0.79%)
    3.99ms
    1 x afterDispatch (115.63KB) (0.49%)
    2.48ms
    1 x afterRenderModule mod_jhotelreservation (JHotelReservation) (389.3KB) (0.49%)
    2.48ms
    1 x After Access::getAssetRules (id:1 name:root.1) (29.45KB) (0.11%)
    541μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.73KB) (0.01%)
    28μs
    1 x beforeRenderModule mod_jhotelreservation (JHotelReservation) (736B) (0%)
    19μs
    1 x beforeRenderModule mod_jhotelreservation (Hotel top search) (736B) (0%)
    14μs
73 statements were executed, 36 of which were duplicates, 37 unique104ms4.2MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
  • SELECT @@SESSION.sql_mode;149μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?221μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1182μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.9ms944BParams/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` = 185μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`65μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest86μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`95μs3.02KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `jos_template_styles` WHERE `client_id` = 0 AND `home` = 1255μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1320Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC113μ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` = 174μ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.01ms184.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT fas.* FROM jos_hotelreservation_application_settings fas399μs2.8KB/components/com_jhotelreservation/helpers/utils.php:81Copy
  • SELECT fas.* FROM jos_hotelreservation_date_formats fas WHERE fas.id ='3'95μs1.06KB/components/com_jhotelreservation/helpers/utils.php:92Copy
  • select * from jos_hotelreservation_offers off inner join jos_hotelreservation_offers_vouchers hov on off.offer_id = hov.offerId where REPLACE(hov.voucher,'-',' ') = 'Den Bosch' group by off.offer_id LIMIT 114.76ms7.73KB/plugins/system/hotelurltranslator/jhprouter.php:264Copy
  • SELECT * FROM `jos_hotelreservation_hotels` WHERE REPLACE(hotel_city,'-',' ') = 'Den Bosch'844μs7.34KB/plugins/system/hotelurltranslator/jhprouter.php:168Copy
  • select * from jos_hotelreservation_offers off inner join jos_hotelreservation_offers_vouchers hov on off.offer_id = hov.offerId where REPLACE(hov.voucher,'-',' ') = 'Den Bosch' group by off.offer_id LIMIT 1138μs10.23KB/plugins/system/hotelurltranslator/jhprouter.php:264Copy
  • SELECT * FROM `jos_hotelreservation_hotels` WHERE REPLACE(hotel_city,'-',' ') = 'Den Bosch'109μs7.34KB/plugins/system/hotelurltranslator/jhprouter.php:168Copy
  • 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` = 1263μs129.42KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'111μ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` = :id95μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM jos_hotelreservation_hotel_facilities ORDER BY name86μs2.19KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_types ORDER BY name55μs1.06KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_accommodation_types ORDER BY name53μs1.38KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_environments ORDER BY name50μs1KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_hotel_regions ORDER BY name75μs2.38KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jos_hotelreservation_offers_themes ORDER BY name75μs1.5KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_hotels`640μs2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SET SESSION group_concat_max_len = 100000055μs0B/administrator/components/com_jhotelreservation/tables/hotels.php:477Copy
  • select h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_short_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude, h.hotel_stars as hstars,hinf.city_tax,hinf.city_tax_percent,hh10.room_min_rate lowest_hotel_price ,hh10.totalRoomsAvailable,hh10.searchRoomIds,hc.totalReserved, (hh10.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft, currency_symbol, hc.noBookings, noReviews, c1.country_name, c2.description AS hotel_currency, hotel_picture_path,hotel_picture_info,hotel_pictures_count, hlt.content as hotel_description, accommodationTypes, regions,themes,noReviews,facilities,types from jos_hotelreservation_hotels as h left join jos_hotelreservation_hotel_informations hinf on h.hotel_id = hinf.hotel_id left join (select hotelId, GROUP_CONCAT(facilityId) as facilities from jos_hotelreservation_hotel_facility_relation where 1 group by hotelId ) as fr on h.hotel_id = fr.hotelId left join (select atr.hotelId, GROUP_CONCAT(atr.accommodationTypeId) as accommodationTypes from jos_hotelreservation_hotel_accommodation_type_relation atr left join jos_hotelreservation_hotel_accommodation_types as hat on hat.id = atr.accommodationtypeId where 1 group by atr.hotelId ) as atr on h.hotel_id = atr.hotelId left join ( select rl.hotelId, GROUP_CONCAT(rl.regionId) as regions from jos_hotelreservation_hotel_region_relation as rl left join jos_hotelreservation_hotel_regions as hr on hr.id = rl.regionId where 1 group by hotelId ) as rl on h.hotel_id=rl.hotelId left join (select hotelId, GROUP_CONCAT(tr.typeId) as types from jos_hotelreservation_hotel_type_relation as tr left join jos_hotelreservation_hotel_types ht on ht.id=tr.typeId where 1 group by hotelId ) tr on h.hotel_id = tr.hotelId left join ( select hotel_id, GROUP_CONCAT(hotr.themeId) as themes from jos_hotelreservation_offers hof left join jos_hotelreservation_offers_themes_relation hotr on hotr.offerId=hof.offer_id left join jos_hotelreservation_offers_themes hot on hot.id = hotr.themeId where 1 group by hotel_id ) hof on h.hotel_id = hof.hotel_id left join (select hotel_id, count(hrt.review_id) as noReviews from jos_hotelreservation_review_customers hrt where hrt.published = 1 group by hotel_id ) as hrc on h.hotel_id = hrc.hotel_id left join jos_hotelreservation_countries c1 USING (country_id) left join jos_hotelreservation_currencies c2 USING (currency_id) left join ( select hc.hotel_id,count(hcr.confirmation_room_id) as totalReserved,count(distinct hc.confirmation_id) as noBookings from jos_hotelreservation_confirmations hc inner join jos_hotelreservation_confirmations_rooms hcr on hc.confirmation_id = hcr.confirmation_id where ((hc.start_date <'2025-04-04' and '2025-04-04' <= hc.end_date) or (hc.start_date <='2025-04-03' and '2025-04-03' < hc.end_date)) and hc.reservation_status NOT IN (2) group by hc.hotel_id )as hc on h.hotel_id=hc.hotel_id left join ( select a.hotel_id,a.hotel_picture_path, a.hotel_picture_info,b.hotel_pictures_count from jos_hotelreservation_hotel_pictures a inner join (SELECT hp.hotel_id, min(hp.hotel_picture_id) as hotel_main_picture_id, count(hp.hotel_picture_id) as hotel_pictures_count FROM jos_hotelreservation_hotel_pictures AS hp group by hotel_id ) b on a.hotel_picture_id = b.hotel_main_picture_id )as hh12 on hh12.hotel_id = h.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = 'nl-NL' )as hlt on hlt.object_id = h.hotel_id left join ( select hotel_id, 1 as room_available, min(room_rate) as room_min_rate, GROUP_CONCAT(hh110.room_id) as searchRoomIds, sum(hh110.availability) as totalRoomsAvailable, GROUP_CONCAT(room_name,'|',room_id,'|',room_rate) as room_details from ( select hr.room_name, hr.room_id, hr.hotel_id, max(IFNULL(hrrp.rate_closed,0)) rate_closed, sum(IFNULL(hra.availability,hr.availability*1)) availability, if(min(hrrp.price), min(hrrp.price), min(least(hrr.price_1, hrr.price_2, hrr.price_3, hrr.price_4, hrr.price_5, hrr.price_6, hrr.price_7))) as room_rate from jos_hotelreservation_rooms as hr left join jos_hotelreservation_rooms_rates as hrr on hr.room_id=hrr.room_id left join (select room_id,availability from jos_hotelreservation_room_availability where date between '2025-04-03' and '2025-04-03') hra on hr.room_id = hra.room_id left join (select rate_id,rate_closed,price from jos_hotelreservation_rooms_rate_prices where date between '2025-04-03' and '2025-04-03') as hrrp on hrr.id=hrrp.rate_id where hr.is_available=1 group by hr.room_id having rate_closed<>1 ) hh110 group by hotel_id ) as hh10 on h.hotel_id=hh10.hotel_id WHERE 1 and h.is_available = 1 and h.hotel_city = 'DenBosch' order by noBookings desc LIMIT 1003.74ms7.42KB/administrator/components/com_jhotelreservation/tables/hotels.php:485Copy
  • 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)3.5ms8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_language_translations`584μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `jos_hotelreservation_offers`801μs13.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select * from jos_hotelreservation_language_translations where type=6 and language_tag = 'nl-NL'32.1ms1.25MB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=17 and language_tag = 'nl-NL'24.91ms249.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select * from jos_hotelreservation_language_translations where type=23 and language_tag = 'nl-NL'219μs1.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • select h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_short_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude, h.hotel_stars as hstars,hinf.city_tax,hinf.city_tax_percent,hh10.room_min_rate lowest_hotel_price ,hh10.totalRoomsAvailable,hh10.searchRoomIds,hc.totalReserved, (hh10.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft, currency_symbol, hc.noBookings, noReviews, c1.country_name, c2.description AS hotel_currency, hotel_picture_path,hotel_picture_info,hotel_pictures_count, hlt.content as hotel_description, accommodationTypes, regions,themes,noReviews,facilities,types from jos_hotelreservation_hotels as h left join jos_hotelreservation_hotel_informations hinf on h.hotel_id = hinf.hotel_id left join (select hotelId, GROUP_CONCAT(facilityId) as facilities from jos_hotelreservation_hotel_facility_relation where 1 group by hotelId ) as fr on h.hotel_id = fr.hotelId left join (select atr.hotelId, GROUP_CONCAT(atr.accommodationTypeId) as accommodationTypes from jos_hotelreservation_hotel_accommodation_type_relation atr left join jos_hotelreservation_hotel_accommodation_types as hat on hat.id = atr.accommodationtypeId where 1 group by atr.hotelId ) as atr on h.hotel_id = atr.hotelId left join ( select rl.hotelId, GROUP_CONCAT(rl.regionId) as regions from jos_hotelreservation_hotel_region_relation as rl left join jos_hotelreservation_hotel_regions as hr on hr.id = rl.regionId where 1 group by hotelId ) as rl on h.hotel_id=rl.hotelId left join (select hotelId, GROUP_CONCAT(tr.typeId) as types from jos_hotelreservation_hotel_type_relation as tr left join jos_hotelreservation_hotel_types ht on ht.id=tr.typeId where 1 group by hotelId ) tr on h.hotel_id = tr.hotelId left join ( select hotel_id, GROUP_CONCAT(hotr.themeId) as themes from jos_hotelreservation_offers hof left join jos_hotelreservation_offers_themes_relation hotr on hotr.offerId=hof.offer_id left join jos_hotelreservation_offers_themes hot on hot.id = hotr.themeId where 1 group by hotel_id ) hof on h.hotel_id = hof.hotel_id left join (select hotel_id, count(hrt.review_id) as noReviews from jos_hotelreservation_review_customers hrt where hrt.published = 1 group by hotel_id ) as hrc on h.hotel_id = hrc.hotel_id left join jos_hotelreservation_countries c1 USING (country_id) left join jos_hotelreservation_currencies c2 USING (currency_id) left join ( select hc.hotel_id,count(hcr.confirmation_room_id) as totalReserved,count(distinct hc.confirmation_id) as noBookings from jos_hotelreservation_confirmations hc inner join jos_hotelreservation_confirmations_rooms hcr on hc.confirmation_id = hcr.confirmation_id where ((hc.start_date <'2025-04-04' and '2025-04-04' <= hc.end_date) or (hc.start_date <='2025-04-03' and '2025-04-03' < hc.end_date)) and hc.reservation_status NOT IN (2) group by hc.hotel_id )as hc on h.hotel_id=hc.hotel_id left join ( select a.hotel_id,a.hotel_picture_path, a.hotel_picture_info,b.hotel_pictures_count from jos_hotelreservation_hotel_pictures a inner join (SELECT hp.hotel_id, min(hp.hotel_picture_id) as hotel_main_picture_id, count(hp.hotel_picture_id) as hotel_pictures_count FROM jos_hotelreservation_hotel_pictures AS hp group by hotel_id ) b on a.hotel_picture_id = b.hotel_main_picture_id )as hh12 on hh12.hotel_id = h.hotel_id left join ( select * from jos_hotelreservation_language_translations where type = 1 and language_tag = 'nl-NL' )as hlt on hlt.object_id = h.hotel_id left join ( select hotel_id, 1 as room_available, min(room_rate) as room_min_rate, GROUP_CONCAT(hh110.room_id) as searchRoomIds, sum(hh110.availability) as totalRoomsAvailable, GROUP_CONCAT(room_name,'|',room_id,'|',room_rate) as room_details from ( select hr.room_name, hr.room_id, hr.hotel_id, max(IFNULL(hrrp.rate_closed,0)) rate_closed, sum(IFNULL(hra.availability,hr.availability*1)) availability, if(min(hrrp.price), min(hrrp.price), min(least(hrr.price_1, hrr.price_2, hrr.price_3, hrr.price_4, hrr.price_5, hrr.price_6, hrr.price_7))) as room_rate from jos_hotelreservation_rooms as hr left join jos_hotelreservation_rooms_rates as hrr on hr.room_id=hrr.room_id left join (select room_id,availability from jos_hotelreservation_room_availability where date between '2025-04-03' and '2025-04-03') hra on hr.room_id = hra.room_id left join (select rate_id,rate_closed,price from jos_hotelreservation_rooms_rate_prices where date between '2025-04-03' and '2025-04-03') as hrrp on hrr.id=hrrp.rate_id where hr.is_available=1 group by hr.room_id having rate_closed<>1 ) hh110 group by hotel_id ) as hh10 on h.hotel_id=hh10.hotel_id WHERE 1 and h.is_available = 1 and h.hotel_city = 'DenBosch' order by noBookings desc2.67ms7.42KB/administrator/components/com_jhotelreservation/tables/hotels.php:497Copy
  • 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`932μs2.2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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_id495μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'4.65ms425.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.name124μs2.94KB/administrator/components/com_jhotelreservation/tables/hotels.php:100Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'372μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'85μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'141μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'99μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `language`,`id` FROM `jos_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 089μs960B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'159μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'115μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'104μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'98μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'122μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'103μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'105μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'133μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'151μ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_id722μs271.39KB/modules/mod_jhotelreservation/helper.php:41Copy
  • select * from jos_hotelreservation_language_translations where type=1 and language_tag = 'nl-NL'625μs425.05KB/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:66Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'106μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'93μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'80μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'147μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'109μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'113μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'107μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'81μs41.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'89μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'87μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'79μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'71μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `jos_template_styles` WHERE `client_id` = 0 AND `id` = '26'121μs33.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?146μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.72ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy