[12/08/2023 06:01:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:01:46' WHERE id= '207';
[12/08/2023 06:02:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:02:09' WHERE id= '207';
[12/08/2023 06:02:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2023/12/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-08 06:02:09' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/08/2023 06:02:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:02:09' WHERE id= '207';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.036'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1657560';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.036'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1657536';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.036'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1657536';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.036'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1650000';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.036'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1657536';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:02:10.202'
                , total_duration = '0.037'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:02:10'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1657536';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_7.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_7.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_7.json', 'expedia', '2023-12-08 06:02:10', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.242'
            , error_description = ''
            , memory_used = '1387280'
            WHERE id = '17920';
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_90.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_90.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_90.json', 'expediapackage', '2023-12-08 06:02:10', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.484'
            , error_description = ''
            , memory_used = '1386680'
            WHERE id = '17921';
[12/08/2023 06:02:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_91.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_91.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_91.json', 'expedia', '2023-12-08 06:02:11', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_75.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_75.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_75.json', 'expedia', '2023-12-08 06:02:11', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_59.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_59.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_59.json', 'expediapackage', '2023-12-08 06:02:12', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_02_10_1702015330_44.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_02_10_1702015330_44.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_02_10_1702015330_44.json', 'expediapackage', '2023-12-08 06:02:12', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:02:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.444'
            , error_description = ''
            , memory_used = '98341192'
            WHERE id = '17922';
[12/08/2023 06:02:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.614'
            , error_description = ''
            , memory_used = '110283160'
            WHERE id = '17923';
[12/08/2023 06:02:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '5.123'
            , error_description = ''
            , memory_used = '101130544'
            WHERE id = '17925';
[12/08/2023 06:02:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:02:10.202'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '5.173'
            , error_description = ''
            , memory_used = '114515320'
            WHERE id = '17924';
[12/08/2023 06:02:16], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:02:16' WHERE id= '207';
[12/08/2023 06:02:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:02:16' WHERE id= '207';
[12/08/2023 06:07:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:07' WHERE id= '207';
[12/08/2023 06:07:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2023/12/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-08 06:07:07' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/08/2023 06:07:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:08' WHERE id= '207';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.632'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647248';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.667'
                , total_duration = '0.169'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.670'
                , total_duration = '0.167'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.676'
                , total_duration = '0.168'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.666'
                , total_duration = '0.192'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:09.674'
                , total_duration = '0.213'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:09'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:10], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_09_1702015629_50.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_09_1702015629_50.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_09_1702015629_50.json', 'expedia', '2023-12-08 06:07:10', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_09_1702015629_9.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_09_1702015629_9.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_09_1702015629_9.json', 'expedia', '2023-12-08 06:07:11', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:09.669'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.547'
            , error_description = ''
            , memory_used = '55772368'
            WHERE id = '17932';
[12/08/2023 06:07:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:09.673'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.485'
            , error_description = ''
            , memory_used = '125162464'
            WHERE id = '17933';
[12/08/2023 06:07:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_09_1702015629_55.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_09_1702015629_55.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_09_1702015629_55.json', 'expediapackage', '2023-12-08 06:07:12', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:09.668'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.503'
            , error_description = ''
            , memory_used = '57700480'
            WHERE id = '17934';
[12/08/2023 06:07:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_09_1702015629_99.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_09_1702015629_99.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_09_1702015629_99.json', 'expediapackage', '2023-12-08 06:07:13', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:09.670'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.654'
            , error_description = ''
            , memory_used = '129512656'
            WHERE id = '17935';
[12/08/2023 06:07:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:14' WHERE id= '207';
[12/08/2023 06:07:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:15' WHERE id= '207';
[12/08/2023 06:07:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:15' WHERE id= '207';
[12/08/2023 06:07:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:30' WHERE id= '207';
[12/08/2023 06:07:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2023/12/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-08 06:07:30' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/08/2023 06:07:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:32' WHERE id= '207';
[12/08/2023 06:07:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:33.882'
                , total_duration = '0.160'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:34'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647248';
[12/08/2023 06:07:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:34.112'
                , total_duration = '0.393'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:34'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647248';
[12/08/2023 06:07:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_34_1702015654_7.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_34_1702015654_7.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_34_1702015654_7.json', 'expedia', '2023-12-08 06:07:35', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:33.922'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.306'
            , error_description = ''
            , memory_used = '55795768'
            WHERE id = '17938';
[12/08/2023 06:07:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_34_1702015654_22.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_34_1702015654_22.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_34_1702015654_22.json', 'expediapackage', '2023-12-08 06:07:37', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:33.882'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.622'
            , error_description = ''
            , memory_used = '128955352'
            WHERE id = '17939';
[12/08/2023 06:07:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:34.895'
                , total_duration = '3.800'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:38'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:34.623'
                , total_duration = '4.134'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:38'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:35.94'
                , total_duration = '3.823'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:38'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647128';
[12/08/2023 06:07:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-12-08 06:07:34.593'
                , total_duration = '4.341'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-12-08 06:07:38'
                , session_id = '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1647248';
[12/08/2023 06:07:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_38_1702015658_45.json', 'e1/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_38_1702015658_45.json', 'e1/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_38_1702015658_45.json', 'expedia', '2023-12-08 06:07:40', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/08_12_2023/request_availability_Baysan_Tourism_wh_06_07_39_1702015659_99.json', 'e1p/08_12_2023/response_availability_Baysan_Tourism_wh_06_07_39_1702015659_99.json', 'e1p/08_12_2023/response_header_availability_Baysan_Tourism_wh_06_07_39_1702015659_99.json', 'expediapackage', '2023-12-08 06:07:41', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:07:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:35.146'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.287'
            , error_description = ''
            , memory_used = '57694456'
            WHERE id = '17945';
[12/08/2023 06:07:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=AppleSafari%2F604.1%28mac%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-08 06:07:35.34'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.985'
            , error_description = ''
            , memory_used = '124870928'
            WHERE id = '17944';
[12/08/2023 06:07:44], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:44' WHERE id= '207';
[12/08/2023 06:07:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:45' WHERE id= '207';
[12/08/2023 06:07:45], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:45' WHERE id= '207';
[12/08/2023 06:07:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:48' WHERE id= '207';
[12/08/2023 06:07:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:07:52' WHERE id= '207';
[12/08/2023 06:08:04], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:08:04' WHERE id= '207';
[12/08/2023 06:08:18], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:08:18' WHERE id= '207';
[12/08/2023 06:09:14], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:09:14' WHERE id= '207';
[12/08/2023 06:11:21], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:11:21' WHERE id= '207';
[12/08/2023 06:11:22], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:11:22' WHERE id= '207';
[12/08/2023 06:11:22], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702015882','43.239.53.130');
[12/08/2023 06:11:22], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/08_12_2023/request_valuation_Baysan_Tourism_wh_06_11_22_1702015882_70.json', 'e1p/08_12_2023/response_valuation_Baysan_Tourism_wh_06_11_22_1702015882_70.json', 'e1p/08_12_2023/response_header_valuation_Baysan_Tourism_wh_06_11_22_1702015882_70.json', 'expediapackage', '2023-12-08 06:11:22', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:11:24], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:11:24' WHERE id= '207';
[12/08/2023 06:11:24], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:11:24' WHERE id= '207';
[12/08/2023 06:11:24], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702015884','43.239.53.130');
[12/08/2023 06:11:25], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/08_12_2023/request_valuation_Baysan_Tourism_wh_06_11_24_1702015884_87.json', 'e1p/08_12_2023/response_valuation_Baysan_Tourism_wh_06_11_24_1702015884_87.json', 'e1p/08_12_2023/response_header_valuation_Baysan_Tourism_wh_06_11_24_1702015884_87.json', 'expediapackage', '2023-12-08 06:11:25', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:11:47], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:11:47' WHERE id= '207';
[12/08/2023 06:12:30], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:12:30' WHERE id= '207';
[12/08/2023 06:12:30], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:12:30' WHERE id= '207';
[12/08/2023 06:14:46], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:14:46' WHERE id= '207';
[12/08/2023 06:14:46], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:14:46' WHERE id= '207';
[12/08/2023 06:14:46], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702016086','43.239.53.130');
[12/08/2023 06:14:47], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/08_12_2023/request_valuation_Baysan_Tourism_wh_06_14_46_1702016086_75.json', 'e1p/08_12_2023/response_valuation_Baysan_Tourism_wh_06_14_46_1702016086_75.json', 'e1p/08_12_2023/response_header_valuation_Baysan_Tourism_wh_06_14_46_1702016086_75.json', 'expediapackage', '2023-12-08 06:14:47', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:15:20], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:15:20' WHERE id= '207';
[12/08/2023 06:15:21], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:15:21' WHERE id= '207';
[12/08/2023 06:15:21], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702016121','43.239.53.130');
[12/08/2023 06:15:21], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/08_12_2023/request_valuation_Baysan_Tourism_wh_06_15_21_1702016121_9.json', 'e1p/08_12_2023/response_valuation_Baysan_Tourism_wh_06_15_21_1702016121_9.json', 'e1p/08_12_2023/response_header_valuation_Baysan_Tourism_wh_06_15_21_1702016121_9.json', 'expediapackage', '2023-12-08 06:15:21', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:16:05], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:16:05' WHERE id= '207';
[12/08/2023 06:16:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702016165','43.239.53.130');
[12/08/2023 06:16:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/08_12_2023/request_valuation_Baysan_Tourism_wh_06_16_05_1702016165_29.json', 'e1p/08_12_2023/response_valuation_Baysan_Tourism_wh_06_16_05_1702016165_29.json', 'e1p/08_12_2023/response_header_valuation_Baysan_Tourism_wh_06_16_05_1702016165_29.json', 'expediapackage', '2023-12-08 06:16:05', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:17:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:17:22' WHERE id= '207';
[12/08/2023 06:17:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:17:25' WHERE id= '207';
[12/08/2023 06:17:55], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:17:55' WHERE id= '207';
[12/08/2023 06:17:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1702016275','43.239.53.130');
[12/08/2023 06:17:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-12-08 06:17:56' WHERE id= '207';
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1285', create_date = '2023-12-08 06:17:57', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '119.71', display_currency_code = 'USD', native_room_rate = '119.71', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2023/12/29', check_out_date = '2023/12/30', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Rajendra', leader_last_name = 'Chaurasia', status_date = '2023-12-08 06:17:57';
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('143','HAFEZ HOTEL APARTMENTS','Hafez Hotel Apartments','10257665','OT000427756','dubai','expediapackage',NOW());
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='143'
		;
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('143','1285','','1','2','0','-','','','10257665','Hafez Hotel Apartments','Next to E NBD Bank Bldg, Al Ras Opp. Metro & Fire Station, Deira','9718000178152','3.0','1','2023/12/29','2023/12/30','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzExMDAwMDAwLzEwMjYwMDAwLzEwMjU3NzAwLzEwMjU3NjY1LzE4ZWY1NjliX2IuanBn');
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '143', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'KingBed Double or Twin Studio Apartment(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 King Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:119.70999999999999;s:25:"displayNightlyRateDisplay";s:155:"Rate - 119.71,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 6.02 USD, Marketing Fee - 6.02  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:120.31;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:119.70999999999999;}}', native_room_rate_total = '119.71', wh_room_rate_total = '120.31', display_room_rate_total = '119.71', number_of_rooms = '1';
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '143', booking_detail_id = '1', rid = '142', room = '0', salutations = 'Mr', first_name = 'Rajendra', last_name = 'Chaurasia', passenger_type = 'adult', age = '';
[12/08/2023 06:17:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '143', booking_detail_id = '1', rid = '142', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/08_12_2023/request_reservation_Baysan_Tourism_wh_06_17_57_1702016277_97.json', 'e1p/08_12_2023/response_reservation_Baysan_Tourism_wh_06_17_57_1702016277_97.json', 'e1p/08_12_2023/response_header_reservation_Baysan_Tourism_wh_06_17_57_1702016277_97.json', 'expediapackage', '2023-12-08 06:17:58', '', '2b26b09dd8c55fbe8d7b9c1adbe5ced2b005f4cad56232b08e4288ba50576153', '0');
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7975353989262', confirmation_number = '7975353989262', display_discount = '0', cancellation_policy = 'Free cancellation up to  21:59:59 on  2023-12-26<br>If you cancel between 2023-12-26 22:00:00 and 2023-12-29 00:00:00 , you will be charged 120.31 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 22:00 on 26th of December 2023.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2023-12-27 10:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'rajendra@qtechsoftware.com', leader_phone = '9004780225', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='120.31',  wh_sub_agent_rate='0',  wh_parent_agent_id='7866',  wh_agent_id='7866',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='119.71',  applicable_service_tax='0',  supplier_rate='119.71',  uid='f09d65a717713166655585c63a4573c9'  where id='143';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='143';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '143' , sr_id = '2' ;
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('143','25.267547','55.294095');
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-12-08 06:17:58',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;143\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -143 And Booking Status - confirmed',`ip`= '43.239.53.130';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='402', `entity`='BookingId', `value`='143' ;
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1285','143','confirmed','2023-12-08 06:17:58','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('143','2023-12-26 22:00:00','2023-12-26 22:00:00','2023-12-29 00:00:00','2023-12-29 00:00:00','119.71','120.31','','2023-12-08 06:17:58','120.31');
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='143',status='1' where reservation_id='1285' and booking_id ='0';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='143' where agent_logs_id='0' and source_type='expediapackage';
[12/08/2023 06:17:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='6.02',  commission_tax='',  booking_id ='143',  supplier_tax='36.14',  supplier_base_fare='83.57',  supplier_commissionable_fare='6.02'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-12-08 06:17:58';
