Script name: HotelBooking
Script version: 2.8.9
PHP version: 8.2.35

Total running time: 0.0361 sec.
Script running time: 0.01224 sec.
SQL running time: 0.02386 sec.

LOADED CLASSES:

Array
(
)

INCLUDED FILES:

Array
(
)

TEMPLATE FILES:

Array
(
)

$_GET:

Array
(
    [customer] => my_bookings
    [lang] => en
)

$_POST:

Array
(
)

$_FILES:

Array
(
)

$_COOKIE:

Array
(
)

$_SESSION:

Array
(
    [cmquueclqt] => Array
        (
            [token] => 630fe7d803cc4c6eff88af901ecdc49c
            [lang] => en
            [lang_dir] => ltr
            [lang_name] => English
            [lang_name_en] => English
            [lc_time_name] => en_US
        )

    [cmquueclqtreservation] => 
    [cmquueclqtreservation_info] => 
)

SQL running time: 0.02386 sec.

1. query | 0.00028 sec.
SET character_set_client=utf8;

2. query | 0.00012 sec.
SET character_set_server=utf8;

3. query | 0.00012 sec.
SET character_set_results=utf8;

4. query | 0.00011 sec.
SET character_set_database=utf8;

5. query | 0.0001 sec.
SET character_set_connection=utf8;

6. query | 0.00021 sec.
SET collation_server=utf8_unicode_ci;

7. query | 0.00014 sec.
SET collation_database=utf8_unicode_ci;

8. query | 0.00012 sec.
SET collation_connection=utf8_unicode_ci;

9. query | 9.0E-5 sec.
SET SESSION group_concat_max_len = 1024

10. select | total: 8 | 0.00032 sec.
SELECT name, module_type, is_installed FROM uhb_modules

11. select | total: 95 | 0.00128 sec.
SELECT ms.id, ms.module_name, ms.settings_key, ms.settings_value FROM uhb_modules m INNER JOIN uhb_modules_settings ms ON m.name = ms.module_name WHERE m.is_installed = 1

12. select | total: 1 | 0.00056 sec.
SELECT * , AES_DECRYPT(smtp_password, 'apphp_hotel_site') as smtp_password FROM uhb_settings

13. select | total: 1 | 0.0004 sec.
SELECT abbreviation FROM uhb_languages WHERE abbreviation = 'en' AND (used_on = 'global' || used_on = 'front-end') AND is_active = 1

14. select | total: 1 | 0.00026 sec.
SELECT * FROM uhb_languages WHERE abbreviation = 'en'

15. select | total: 1 | 0.00031 sec.
SELECT symbol, code, rate, decimals, symbol_placement FROM uhb_currencies WHERE is_default = 1 AND is_active = 1

16. select | total: 1 | 0.00027 sec.
SELECT * FROM uhb_site_description WHERE language_id = 'en'

17. select | total: 1 | 0.00046 sec.
SELECT hp.id, hp.property_code, hp.priority_order, hp.is_active, hpd.name FROM (uhb_hotels_property_types hp INNER JOIN uhb_hotels_property_types_description hpd ON hp.id = hpd.hotel_property_id AND hpd.language_id = 'en') WHERE hp.is_active = 1 ORDER BY hp.priority_order ASC

18. select | total: 2 | 0.00024 sec.
SELECT id, lang_name, lang_name_en, abbreviation, lc_time_name, lang_dir, icon_image, priority_order, used_on, is_default, is_active FROM uhb_languages

19. select | total: 4 | 0.00038 sec.
SELECT id, hotel_id, default_price, max_adults FROM uhb_rooms WHERE is_active = 1 ORDER BY priority_order ASC, id ASC

20. select | total: 1 | 0.00071 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 1

21. select | total: 1 | 0.0004 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 1 AND rp.is_default = 1

22. select | total: 1 | 0.00035 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 1 AND rp.is_default = 1

23. select | total: 1 | 0.00045 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

24. select | total: 1 | 0.00053 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 1 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

25. select | total: 1 | 0.0005 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 2

26. select | total: 1 | 0.00037 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 2 AND rp.is_default = 1

27. select | total: 1 | 0.00037 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 2 AND rp.is_default = 1

28. select | total: 1 | 0.00035 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

29. select | total: 1 | 0.00052 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 2 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

30. select | total: 1 | 0.00049 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 3

31. select | total: 1 | 0.00037 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 3 AND rp.is_default = 1

32. select | total: 1 | 0.00033 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 3 AND rp.is_default = 1

33. select | total: 1 | 0.00036 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

34. select | total: 1 | 0.0005 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 3 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

35. select | total: 1 | 0.00056 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 4

36. select | total: 1 | 0.00035 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 4 AND rp.is_default = 1

37. select | total: 1 | 0.00035 sec.
SELECT r.id, r.default_price, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 4 AND rp.is_default = 1

38. select | total: 1 | 0.00037 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

39. select | total: 1 | 0.00049 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 4 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

40. select | total: 1 | 0.00032 sec.
SELECT id, campaign_name, start_date, finish_date, discount_type, discount_value, is_active FROM uhb_campaigns WHERE campaign_type = 'standard' AND finish_date >= '2026-10-28' ORDER BY start_date ASC

41. select | total: 1 | 0.0003 sec.
SELECT MAX(finish_date) as f FROM uhb_campaigns WHERE is_active = 1 AND campaign_type = 'standard' AND discount_value > 0 AND finish_date >= '2026-10-28'

42. select | total: 1 | 0.00034 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-31' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-31' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-31' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

43. select | total: 5 | 0.00042 sec.
SELECT id, coupon_code, date_started, date_finished, discount_type, discount_value, is_active, comments, title FROM uhb_coupons WHERE date_finished >= '2026-10-28' ORDER BY id ASC

44. select | total: 1 | 0.00028 sec.
SELECT discount_night_type, discount_night_3, discount_night_4, discount_night_5, discount_guests_type, discount_guests_3, discount_guests_4, discount_guests_5 FROM uhb_rooms ORDER BY is_active DESC, priority_order ASC, id ASC LIMIT 1

45. select | total: 1 | 0.00027 sec.
SELECT * FROM uhb_languages WHERE abbreviation = 'en'

46. select | total: 1 | 0.00069 sec.
SELECT h.*, COALESCE( (SELECT d1.address FROM uhb_hotels_description d1 WHERE d1.hotel_id = h.id AND d1.language_id = 'en' AND d1.address <> '' LIMIT 1), (SELECT d2.address FROM uhb_hotels_description d2 WHERE d2.hotel_id = h.id AND d2.address <> '' ORDER BY d2.id ASC LIMIT 1), '' ) as sf_address, COALESCE( (SELECT n1.name FROM uhb_hotels_description n1 WHERE n1.hotel_id = h.id AND n1.language_id = 'en' AND n1.name <> '' LIMIT 1), (SELECT n2.name FROM uhb_hotels_description n2 WHERE n2.hotel_id = h.id AND n2.name <> '' ORDER BY n2.id ASC LIMIT 1), '' ) as sf_name FROM uhb_hotels h ORDER BY h.is_default DESC, h.id ASC LIMIT 1

47. select | total: 0 | 0.00038 sec.
SELECT cl.*, cd.name as country_name, c.vat_value FROM uhb_customers cl LEFT OUTER JOIN uhb_countries c ON cl.b_country = c.abbrv AND c.is_active = 1 LEFT OUTER JOIN uhb_countries_description cd ON c.id = cd.country_id AND cd.language_id = 'en' WHERE cl.id = 0

48. select | total: 0 | 0.00016 sec.
SELECT is_default FROM uhb_languages WHERE id = 0

49. select | total: 1 | 0.0002 sec.
SELECT COUNT(*) as cnt FROM uhb_languages WHERE is_active = 1 AND (used_on = 'global' OR used_on = 'front-end')

50. select | total: 2 | 0.00027 sec.
SELECT id, lang_name, lang_name_en, abbreviation, lc_time_name, lang_dir, is_default, icon_image, used_on, priority_order, is_active, IF(is_default = 1, "<span class=yes>Yes</span>", "No") as is_default_verb, IF(is_active = 1, "<span class=yes>Yes</span>", "<span class=no>No</span>") as is_active_verb FROM uhb_languages WHERE 1=1 AND is_active = 1 AND (used_on = 'global' OR used_on = 'front-end') ORDER BY priority_order ASC

51. select | total: 4 | 0.0003 sec.
SELECT id, hotel_id, default_price, max_adults FROM uhb_rooms WHERE is_active = 1 ORDER BY priority_order ASC, id ASC

52. select | total: 1 | 0.00053 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 1

53. select | total: 1 | 0.00038 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

54. select | total: 1 | 0.00047 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 1 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

55. select | total: 1 | 0.00052 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 2

56. select | total: 1 | 0.00035 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

57. select | total: 1 | 0.00051 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 2 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

58. select | total: 1 | 0.00048 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 3

59. select | total: 1 | 0.00036 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

60. select | total: 1 | 0.00049 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 3 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC

61. select | total: 1 | 0.0005 sec.
SELECT r.id, r.hotel_id, r.room_count, r.max_adults, r.max_children, r.beds, r.single_beds, r.double_beds, r.folding_sofa_single_beds, r.folding_sofa_double_beds, r.bathrooms, r.room_area, r.default_price, r.room_icon, r.room_picture_1, r.room_picture_2, r.room_picture_3, r.room_picture_4, r.room_picture_5, r.is_active, rd.room_type, rd.room_short_description, rd.room_long_description, hd.name as hotel_name FROM uhb_rooms r INNER JOIN uhb_rooms_description rd ON r.id = rd.room_id AND rd.language_id = 'en' INNER JOIN uhb_hotels_description hd ON r.hotel_id = hd.hotel_id AND hd.language_id = 'en' WHERE r.id = 4

62. select | total: 1 | 0.00036 sec.
SELECT id, hotel_id, discount_type, discount_value, apply_per, minimum_adults, maximum_adults, start_date, finish_date FROM uhb_campaigns WHERE group_id = IF(group_id > 0, 0, 0) AND ( ('2026-10-28' <= start_date AND '2026-10-29' > start_date) OR ('2026-10-28' < finish_date AND '2026-10-29' >= finish_date) OR ('2026-10-28' >= start_date AND '2026-10-29' < finish_date) ) AND is_active = 1 AND campaign_type = 'standard' ORDER BY start_date DESC

63. select | total: 1 | 0.00049 sec.
SELECT r.id, r.default_price, r.discount_night_type, r.discount_night_3, r.discount_night_4, r.discount_night_5, r.discount_guests_3, r.discount_guests_4, r.discount_guests_5, rp.adults, rp.children, rp.mon, rp.tue, rp.wed, rp.thu, rp.fri, rp.sat, rp.sun, rp.sun, rp.is_default FROM uhb_rooms r INNER JOIN uhb_rooms_prices rp ON r.id = rp.room_id WHERE r.id = 4 AND rp.adults >= 1 AND rp.children >= 0 AND ( (rp.date_from <= '2026-10-28' AND rp.date_to = '2026-10-28') OR (rp.date_from <= '2026-10-28' AND rp.date_to >= '2026-10-29') ) AND rp.is_default = 0 ORDER BY rp.adults ASC, rp.children ASC