[11/30/2023 10:00:48], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:00:48' WHERE id= '182';
[11/30/2023 10:00:48], [file name :-/home/otrams/public_html/beta/about_us.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2023-11-30 10:00:48', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 10:03:38], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 10:03:38',login_attempt=0 where id = '7864';
[11/30/2023 10:03:38], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'being_gajju', user_type = 'A', branch_id = '28', login_datetime = '2023-11-30 10:03:38', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 10:03:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:03:38' WHERE id= '163';
[11/30/2023 10:06:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 10:06:19',login_attempt=0 where id = '7857';
[11/30/2023 10:06:19], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-30 10:06:19', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 10:06:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:06:19' WHERE id= '180';
[11/30/2023 10:08:00], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:00' WHERE id= '180';
[11/30/2023 10:08:00], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 10:08:00',login_attempt=0 where id = '7857';
[11/30/2023 10:08:00], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-30 10:08:00', ip = '43.239.53.130', action = 'Login' ;
[11/30/2023 10:08:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:01' WHERE id= '180';
[11/30/2023 10:08:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:08' WHERE id= '180';
[11/30/2023 10:08:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:08' WHERE id= '180';
[11/30/2023 10:08:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:10' WHERE id= '180';
[11/30/2023 10:08:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:18' WHERE id= '180';
[11/30/2023 10:08:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/07' , departure_date = '2024/02/11' , nights = '4' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-30 10:08:18' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/30/2023 10:08:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:19' WHERE id= '180';
[11/30/2023 10:08:20], [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/30_11_2023/request_availability_Deepak_T_10_08_19_1701338899_92.json', 'e1/30_11_2023/response_availability_Deepak_T_10_08_19_1701338899_92.json', 'e1/30_11_2023/response_header_availability_Deepak_T_10_08_19_1701338899_92.json', 'expedia', '2023-11-30 10:08:20', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:19.661'
            , 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.673'
            , error_description = ''
            , memory_used = '17240040'
            WHERE id = '16335';
[11/30/2023 10:08:20], [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/30_11_2023/request_availability_Deepak_T_10_08_19_1701338899_80.json', 'e1/30_11_2023/response_availability_Deepak_T_10_08_19_1701338899_80.json', 'e1/30_11_2023/response_header_availability_Deepak_T_10_08_19_1701338899_80.json', 'expedia', '2023-11-30 10:08:20', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:20], [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/30_11_2023/request_availability_Deepak_T_10_08_19_1701338899_44.json', 'e1p/30_11_2023/response_availability_Deepak_T_10_08_19_1701338899_44.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_10_08_19_1701338899_44.json', 'expediapackage', '2023-11-30 10:08:20', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:19.661'
            , 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.018'
            , error_description = ''
            , memory_used = '17232048'
            WHERE id = '16337';
[11/30/2023 10:08:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:19.661'
            , 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.124'
            , error_description = ''
            , memory_used = '38518488'
            WHERE id = '16336';
[11/30/2023 10:08:20], [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/30_11_2023/request_availability_Deepak_T_10_08_19_1701338899_66.json', 'e1p/30_11_2023/response_availability_Deepak_T_10_08_19_1701338899_66.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_10_08_19_1701338899_66.json', 'expediapackage', '2023-11-30 10:08:20', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:19.661'
            , 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.630'
            , error_description = ''
            , memory_used = '41040976'
            WHERE id = '16338';
[11/30/2023 10:08:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:21' WHERE id= '180';
[11/30/2023 10:08:24], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:24' WHERE id= '180';
[11/30/2023 10:08:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:31' WHERE id= '180';
[11/30/2023 10:08:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/07' , departure_date = '2024/02/12' , nights = '5' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-30 10:08:31' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/30/2023 10:08:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:32' WHERE id= '180';
[11/30/2023 10:08:32], [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/30_11_2023/request_availability_Deepak_T_10_08_32_1701338912_10.json', 'e1/30_11_2023/response_availability_Deepak_T_10_08_32_1701338912_10.json', 'e1/30_11_2023/response_header_availability_Deepak_T_10_08_32_1701338912_10.json', 'expedia', '2023-11-30 10:08:32', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:32.416'
            , 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.713'
            , error_description = ''
            , memory_used = '18500296'
            WHERE id = '16339';
[11/30/2023 10:08:33], [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/30_11_2023/request_availability_Deepak_T_10_08_32_1701338912_1.json', 'e1/30_11_2023/response_availability_Deepak_T_10_08_32_1701338912_1.json', 'e1/30_11_2023/response_header_availability_Deepak_T_10_08_32_1701338912_1.json', 'expedia', '2023-11-30 10:08:33', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:33], [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/30_11_2023/request_availability_Deepak_T_10_08_32_1701338912_89.json', 'e1p/30_11_2023/response_availability_Deepak_T_10_08_32_1701338912_89.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_10_08_32_1701338912_89.json', 'expediapackage', '2023-11-30 10:08:33', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:32.416'
            , 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.251'
            , error_description = ''
            , memory_used = '41139704'
            WHERE id = '16340';
[11/30/2023 10:08:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:32.416'
            , 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.386'
            , error_description = ''
            , memory_used = '18779944'
            WHERE id = '16341';
[11/30/2023 10:08:33], [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/30_11_2023/request_availability_Deepak_T_10_08_32_1701338912_47.json', 'e1p/30_11_2023/response_availability_Deepak_T_10_08_32_1701338912_47.json', 'e1p/30_11_2023/response_header_availability_Deepak_T_10_08_32_1701338912_47.json', 'expediapackage', '2023-11-30 10:08:33', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:08:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:08:32.416'
            , 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.775'
            , error_description = ''
            , memory_used = '43506968'
            WHERE id = '16342';
[11/30/2023 10:08:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:34' WHERE id= '180';
[11/30/2023 10:08:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:36' WHERE id= '180';
[11/30/2023 10:08:44], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:44' WHERE id= '180';
[11/30/2023 10:08:44], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:08:44' WHERE id= '180';
[11/30/2023 10:08:44], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701338924','43.239.53.130');
[11/30/2023 10:08:45], [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/30_11_2023/request_valuation_Deepak_T_10_08_44_1701338924_46.json', 'e1p/30_11_2023/response_valuation_Deepak_T_10_08_44_1701338924_46.json', 'e1p/30_11_2023/response_header_valuation_Deepak_T_10_08_44_1701338924_46.json', 'expediapackage', '2023-11-30 10:08:45', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:09:07], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:09:07' WHERE id= '180';
[11/30/2023 10:09:07], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701338947','43.239.53.130');
[11/30/2023 10:09:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:09:07' WHERE id= '180';
[11/30/2023 10:09:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1146', create_date = '2023-11-30 10:09:08', agent_id = '7857', parent_agent_id = '7857', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '235.99', display_currency_code = 'USD', native_room_rate = '98.74', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/07', check_out_date = '2024/02/12', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2023-11-30 10:09:08';
[11/30/2023 10:09:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='130'
		;
[11/30/2023 10:09:08], [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('130','1146','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','5','2024/02/07','2024/02/12','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/30/2023 10:09:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '130', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:5:{i:0;a:2:{s:18:"displayNightlyRate";d:47.200000000000003;s:25:"displayNightlyRateDisplay";s:205:"Rate - 19.75, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.596 USD, Marketing Fee - 1.596  USD #expediapackage";}i:1;a:2:{s:18:"displayNightlyRate";d:47.200000000000003;s:25:"displayNightlyRateDisplay";s:205:"Rate - 19.75, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.596 USD, Marketing Fee - 1.596  USD #expediapackage";}i:2;a:2:{s:18:"displayNightlyRate";d:47.200000000000003;s:25:"displayNightlyRateDisplay";s:205:"Rate - 19.75, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.596 USD, Marketing Fee - 1.596  USD #expediapackage";}i:3;a:2:{s:18:"displayNightlyRate";d:47.200000000000003;s:25:"displayNightlyRateDisplay";s:205:"Rate - 19.75, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.596 USD, Marketing Fee - 1.596  USD #expediapackage";}i:4;a:2:{s:18:"displayNightlyRate";d:47.189999999999998;s:25:"displayNightlyRateDisplay";s:205:"Rate - 19.74, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.596 USD, Marketing Fee - 1.596  USD #expediapackage";}}', native_nightly_rates = 'a:5:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.75;}i:1;a:1:{s:17:"nativeNightlyRate";d:19.75;}i:2;a:1:{s:17:"nativeNightlyRate";d:19.75;}i:3;a:1:{s:17:"nativeNightlyRate";d:19.75;}i:4;a:1:{s:17:"nativeNightlyRate";d:19.739999999999998;}}', native_room_rate_total = '98.74', display_room_rate_total = '235.99', number_of_rooms = '1', room_category = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', meal_basis = 'Room Only';
[11/30/2023 10:09:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '130', booking_detail_id = '1', rid = '136', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[11/30/2023 10:09:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '130', booking_detail_id = '1', rid = '136', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/30/2023 10:09:09], [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/30_11_2023/request_reservation_Deepak_T_10_09_08_1701338948_23.json', 'e1p/30_11_2023/response_reservation_Deepak_T_10_09_08_1701338948_23.json', 'e1p/30_11_2023/response_header_reservation_Deepak_T_10_09_08_1701338948_23.json', 'expediapackage', '2023-11-30 10:09:09', '', '54f7bba823310b9bed5f1004c81040a30c35f21b9dedf3f44be487768a31be37', '0');
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7882906876449', confirmation_number = '7882906876449', display_discount = '0', cancellation_policy = 'Free cancellation up to  15:29:59 on  2024-02-05<br>If you cancel between 2024-02-05 15:30:00 and 2024-02-07 00:00:00 , you will be charged 47.2 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 15:30 on 5th of February 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-02-05 12:30: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 = 'b2btravel', sales_manager_id = '0', admin_booked = '0', email_id = 'bhavesh.gurav@qtechsoftware.com', leader_phone = '9876543212', 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 = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='139',  agent_markup='139',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='235.99',  applicable_service_tax='0',  supplier_rate='98.74',  uid='f33eb036009028b79cfd5c5abfc91b94'  where id='130';
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='130';
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('130','18.950835','72.837922');
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-30 10:09:09',`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;130\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -130 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='372', `entity`='BookingId', `value`='130' ;
[11/30/2023 10:09:09], [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 ('1146','130','confirmed','2023-11-30 10:09:09','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/30/2023 10:09:09], [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('130','2024-02-05 15:30:00','2024-02-05 15:30:00','2024-02-07 00:00:00','2024-02-07 00:00:00','19.75','47.2','0','2023-11-30 10:09:09','47.2');
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='130',status='1' where reservation_id='1146' and booking_id ='0';
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='130' where agent_logs_id='0' and source_type='expediapackage';
[11/30/2023 10:09:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='7.98',  commission_tax='',  booking_id ='130',  supplier_tax='10.75',  supplier_base_fare='87.99',  supplier_commissionable_fare='7.98'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-30 10:09:09';
[11/30/2023 10:45:15], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-30 10:45:15',login_attempt=0 where id = '7865';
[11/30/2023 10:45:15], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-30 10:45:15', ip = '42.106.240.192', action = 'Login' ;
[11/30/2023 10:45:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='42.106.240.192', agent_id='7863', session_id='8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f',create_date='2023-11-30 10:45:15', update_date='2023-11-30 10:45:15',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/30/2023 10:47:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:47:28' WHERE id= '183';
[11/30/2023 10:47:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:47:31' WHERE id= '183';
[11/30/2023 10:47:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:47:56' WHERE id= '183';
[11/30/2023 10:47:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '42.106.240.192' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/26' , departure_date = '2024/01/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-30 10:47:56' , 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 = '' ;
[11/30/2023 10:47:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:47:57' WHERE id= '183';
[11/30/2023 10:47:57], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_9.json', 'e1p/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_9.json', 'e1p/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_9.json', 'expediapackage', '2023-11-30 10:47:57', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:47:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.714'
            , 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.202'
            , error_description = ''
            , memory_used = '3412960'
            WHERE id = '16402';
[11/30/2023 10:47:57], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_43.json', 'e1/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_43.json', 'e1/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_43.json', 'expedia', '2023-11-30 10:47:57', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:47:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.714'
            , 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.215'
            , error_description = ''
            , memory_used = '3411696'
            WHERE id = '16403';
[11/30/2023 10:47:59], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_22.json', 'e1/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_22.json', 'e1/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_22.json', 'expedia', '2023-11-30 10:47:59', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:47:59], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_40.json', 'e1/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_40.json', 'e1/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_40.json', 'expedia', '2023-11-30 10:47:59', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:48:00], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_72.json', 'e1p/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_72.json', 'e1p/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_72.json', 'expediapackage', '2023-11-30 10:48:00', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:48:00], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_47_57_1701341277_49.json', 'e1p/30_11_2023/response_availability_Baysan_Tourism_wh_10_47_57_1701341277_49.json', 'e1p/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_47_57_1701341277_49.json', 'expediapackage', '2023-11-30 10:48:00', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:48:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.715'
            , 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.019'
            , error_description = ''
            , memory_used = '168189264'
            WHERE id = '16404';
[11/30/2023 10:48:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.715'
            , 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.394'
            , error_description = ''
            , memory_used = '192925504'
            WHERE id = '16405';
[11/30/2023 10:48:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.715'
            , 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.733'
            , error_description = ''
            , memory_used = '177016904'
            WHERE id = '16407';
[11/30/2023 10:48:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:47:57.715'
            , 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.979'
            , error_description = ''
            , memory_used = '205642688'
            WHERE id = '16406';
[11/30/2023 10:48:02], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:48:02' WHERE id= '183';
[11/30/2023 10:48:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:48:03' WHERE id= '183';
[11/30/2023 10:48:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:48:03' WHERE id= '183';
[11/30/2023 10:49:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:49:27' WHERE id= '183';
[11/30/2023 10:49:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '42.106.240.192' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/23' , departure_date = '2024/02/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-30 10:49:27' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/30/2023 10:49:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:49:28' WHERE id= '183';
[11/30/2023 10:49:30], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_49_29_1701341369_83.json', 'e1/30_11_2023/response_availability_Baysan_Tourism_wh_10_49_29_1701341369_83.json', 'e1/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_49_29_1701341369_83.json', 'expedia', '2023-11-30 10:49:30', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:49:30], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_49_28_1701341368_33.json', 'e1/30_11_2023/response_availability_Baysan_Tourism_wh_10_49_28_1701341368_33.json', 'e1/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_49_28_1701341368_33.json', 'expedia', '2023-11-30 10:49:30', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:49:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:49:28.959'
            , 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.097'
            , error_description = ''
            , memory_used = '95758736'
            WHERE id = '16408';
[11/30/2023 10:49:31], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_49_28_1701341368_44.json', 'e1p/30_11_2023/response_availability_Baysan_Tourism_wh_10_49_28_1701341368_44.json', 'e1p/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_49_28_1701341368_44.json', 'expediapackage', '2023-11-30 10:49:31', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:49:31], [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/30_11_2023/request_availability_Baysan_Tourism_wh_10_49_29_1701341369_18.json', 'e1p/30_11_2023/response_availability_Baysan_Tourism_wh_10_49_29_1701341369_18.json', 'e1p/30_11_2023/response_header_availability_Baysan_Tourism_wh_10_49_29_1701341369_18.json', 'expediapackage', '2023-11-30 10:49:31', '', '8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f', '0');
[11/30/2023 10:49:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:49:28.959'
            , 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.482'
            , error_description = ''
            , memory_used = '99691552'
            WHERE id = '16411';
[11/30/2023 10:49:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:49:28.959'
            , 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.526'
            , error_description = ''
            , memory_used = '204200904'
            WHERE id = '16409';
[11/30/2023 10:49:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=8202dd750bceaf1028a43f8b649c2f3bd9bdd0e5aa2c1bc1c6f1e682e2a3042f&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=42.106.240.192&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-30 10:49:28.959'
            , 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.213'
            , error_description = ''
            , memory_used = '219904328'
            WHERE id = '16410';
[11/30/2023 10:49:33], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:49:33' WHERE id= '183';
[11/30/2023 10:49:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:49:34' WHERE id= '183';
[11/30/2023 10:49:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-30 10:49:34' WHERE id= '183';
