[08/22/2023 11:02:36], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//22_08_2023/request_hotel_search__11_02_36_1692702156_9508818.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//22_08_2023/response_hotel_search__11_02_36_1692702156_9508818.txt','','','0','2023-08-22 11:02:36','2023-08-22 11:02:36','hotel_search','Username and Password must Required ','','0','');
[08/22/2023 11:18:14], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '3.128.191.50' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:18:14' , site_id = '' , country_code = '60' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:18:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:18:15.231'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:18:15'
                , session_id = '78582220230811181468559266117'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743800';
[08/22/2023 11:18:15], [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', 'm1/22_08_2023/request_availability_Tripathon_11_18_15_1692703095_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_18_15_1692703095_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_18_15_1692703095_.xml', 'miki', '2023-08-22 11:18:15', '', '78582220230811181468559266117', '0');
[08/22/2023 11:18:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811181468559266117&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:18:15.232'
            , 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.266'
            , error_description = ''
            , memory_used = '1841120'
            WHERE id = '4682';
[08/22/2023 11:18:15], [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/22_08_2023/request_availability_Tripathon_11_18_15_1692703095_28.json', 'e1/22_08_2023/response_availability_Tripathon_11_18_15_1692703095_28.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_18_15_1692703095_28.json', 'expedia', '2023-08-22 11:18:15', '', '78582220230811181468559266117', '0');
[08/22/2023 11:18:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811181468559266117&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:18:15.232'
            , 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.577'
            , error_description = ''
            , memory_used = '4052104'
            WHERE id = '4683';
[08/22/2023 11:18:15], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_18_15_1692703095_1363956.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_18_15_1692703095_1363956.txt','7858','78582220230811181468559266117','0','2023-08-22 11:18:14','2023-08-22 11:18:15','hotel_search','','','1','0');
[08/22/2023 11:19:04], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '3.128.191.50' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:19:04' , site_id = '' , country_code = '60' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:19:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:19:04.595'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:19:04'
                , session_id = '78582220230811190429582112568'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743800';
[08/22/2023 11:19:04], [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', 'm1/22_08_2023/request_availability_Tripathon_11_19_04_1692703144_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_19_04_1692703144_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_19_04_1692703144_.xml', 'miki', '2023-08-22 11:19:04', '', '78582220230811190429582112568', '0');
[08/22/2023 11:19:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811190429582112568&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:19:04.595'
            , 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.243'
            , error_description = ''
            , memory_used = '1841120'
            WHERE id = '4685';
[08/22/2023 11:19:04], [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/22_08_2023/request_availability_Tripathon_11_19_04_1692703144_97.json', 'e1/22_08_2023/response_availability_Tripathon_11_19_04_1692703144_97.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_19_04_1692703144_97.json', 'expedia', '2023-08-22 11:19:04', '', '78582220230811190429582112568', '0');
[08/22/2023 11:19:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811190429582112568&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:19:04.595'
            , 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.436'
            , error_description = ''
            , memory_used = '4051800'
            WHERE id = '4686';
[08/22/2023 11:19:05], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_19_05_1692703145_5243681.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_19_05_1692703145_5243681.txt','7858','78582220230811190429582112568','0','2023-08-22 11:19:04','2023-08-22 11:19:05','hotel_search','','','1','0');
[08/22/2023 11:19:13], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '3.128.191.50' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:19:13' , site_id = '' , country_code = '60' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:19:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:19:13.172'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:19:13'
                , session_id = '78582220230811191364987386813'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743800';
[08/22/2023 11:19: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', 'm1/22_08_2023/request_availability_Tripathon_11_19_13_1692703153_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_19_13_1692703153_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_19_13_1692703153_.xml', 'miki', '2023-08-22 11:19:13', '', '78582220230811191364987386813', '0');
[08/22/2023 11:19:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811191364987386813&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:19:13.172'
            , 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.237'
            , error_description = ''
            , memory_used = '1841120'
            WHERE id = '4688';
[08/22/2023 11:19: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', 'e1/22_08_2023/request_availability_Tripathon_11_19_13_1692703153_23.json', 'e1/22_08_2023/response_availability_Tripathon_11_19_13_1692703153_23.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_19_13_1692703153_23.json', 'expedia', '2023-08-22 11:19:13', '', '78582220230811191364987386813', '0');
[08/22/2023 11:19:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811191364987386813&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:19:13.173'
            , 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.296'
            , error_description = ''
            , memory_used = '4051856'
            WHERE id = '4689';
[08/22/2023 11:19:13], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_19_13_1692703153_1511758.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_19_13_1692703153_1511758.txt','7858','78582220230811191364987386813','0','2023-08-22 11:19:13','2023-08-22 11:19:13','hotel_search','','','0','0');
[08/22/2023 11:33:28], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_33_28_1692704008_2077617.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_33_28_1692704008_2077617.txt','','','0','2023-08-22 11:33:28','2023-08-22 11:33:28','hotel_search','The IP [43.239.53.130] does not have permission to access this Webservice','','0','');
[08/22/2023 11:33:37], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_33_37_1692704017_5003654.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_33_37_1692704017_5003654.txt','','','0','2023-08-22 11:33:37','2023-08-22 11:33:37','hotel_search','The IP [43.239.53.130] does not have permission to access this Webservice','','0','');
[08/22/2023 11:35:48], [file name :-/home/otrams/public_html/beta/tms/authenticate_web_service.php],update agents set web_service='1' , ws_customer_type= 'external' , allow_iprange= '', allow_encoding= '', web_service_ip= '3.128.191.50,194.146.12.172,43.239.53.130' , web_service_only_mapped_hotels='0' where id= '7858';
[08/22/2023 11:35:53], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:35:53' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:35:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:35:53.843'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:35:53'
                , session_id = '78582220230811355334780078387'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743824';
[08/22/2023 11:35:54], [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/22_08_2023/request_availability_Tripathon_11_35_53_1692704153_23.json', 'e1/22_08_2023/response_availability_Tripathon_11_35_53_1692704153_23.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_35_53_1692704153_23.json', 'expedia', '2023-08-22 11:35:54', '', '78582220230811355334780078387', '0');
[08/22/2023 11:35:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811355334780078387&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:35:53.843'
            , 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.390'
            , error_description = ''
            , memory_used = '4052744'
            WHERE id = '4691';
[08/22/2023 11:35:54], [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', 'm1/22_08_2023/request_availability_Tripathon_11_35_53_1692704153_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_35_53_1692704153_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_35_53_1692704153_.xml', 'miki', '2023-08-22 11:35:54', '', '78582220230811355334780078387', '0');
[08/22/2023 11:35:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811355334780078387&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:35:53.843'
            , 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.809'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4692';
[08/22/2023 11:35:54], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_35_54_1692704154_2812561.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_35_54_1692704154_2812561.txt','7858','78582220230811355334780078387','0','2023-08-22 11:35:53','2023-08-22 11:35:54','hotel_search','','','1','0');
[08/22/2023 11:39:21], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:39:21' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:39:21], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:39:21.867'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:39:21'
                , session_id = '78582220230811392125385058818'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 11:39:22], [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/22_08_2023/request_availability_Tripathon_11_39_21_1692704361_94.json', 'e1/22_08_2023/response_availability_Tripathon_11_39_21_1692704361_94.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_39_21_1692704361_94.json', 'expedia', '2023-08-22 11:39:22', '', '78582220230811392125385058818', '0');
[08/22/2023 11:39:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811392125385058818&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:39:21.867'
            , 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.302'
            , error_description = ''
            , memory_used = '4052968'
            WHERE id = '4694';
[08/22/2023 11:39:22], [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', 'm1/22_08_2023/request_availability_Tripathon_11_39_21_1692704361_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_39_21_1692704361_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_39_21_1692704361_.xml', 'miki', '2023-08-22 11:39:22', '', '78582220230811392125385058818', '0');
[08/22/2023 11:39:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811392125385058818&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:39:21.867'
            , 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.580'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4695';
[08/22/2023 11:39:22], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_39_22_1692704362_1948872.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_39_22_1692704362_1948872.txt','7858','78582220230811392125385058818','0','2023-08-22 11:39:21','2023-08-22 11:39:22','hotel_search','','','1','0');
[08/22/2023 11:39:48], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:39:48' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:39:48], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:39:48.154'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:39:48'
                , session_id = '78582220230811394815140575458'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 11:39:48], [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', 'm1/22_08_2023/request_availability_Tripathon_11_39_48_1692704388_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_39_48_1692704388_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_39_48_1692704388_.xml', 'miki', '2023-08-22 11:39:48', '', '78582220230811394815140575458', '0');
[08/22/2023 11:39:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811394815140575458&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:39:48.154'
            , 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.236'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4697';
[08/22/2023 11:39:48], [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/22_08_2023/request_availability_Tripathon_11_39_48_1692704388_18.json', 'e1/22_08_2023/response_availability_Tripathon_11_39_48_1692704388_18.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_39_48_1692704388_18.json', 'expedia', '2023-08-22 11:39:48', '', '78582220230811394815140575458', '0');
[08/22/2023 11:39:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811394815140575458&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:39:48.154'
            , 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.445'
            , error_description = ''
            , memory_used = '4052592'
            WHERE id = '4698';
[08/22/2023 11:39:48], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_39_48_1692704388_5406210.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_39_48_1692704388_5406210.txt','7858','78582220230811394815140575458','0','2023-08-22 11:39:48','2023-08-22 11:39:48','hotel_search','','','0','0');
[08/22/2023 11:43:33], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:43:33' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:43:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:43:33.581'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:43:33'
                , session_id = '7858222023081143336606194432'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743776';
[08/22/2023 11:43: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/22_08_2023/request_availability_Tripathon_11_43_33_1692704613_40.json', 'e1/22_08_2023/response_availability_Tripathon_11_43_33_1692704613_40.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_43_33_1692704613_40.json', 'expedia', '2023-08-22 11:43:33', '', '7858222023081143336606194432', '0');
[08/22/2023 11:43:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7858222023081143336606194432&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:43:33.581'
            , 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.390'
            , error_description = ''
            , memory_used = '4053088'
            WHERE id = '4700';
[08/22/2023 11:43:34], [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', 'm1/22_08_2023/request_availability_Tripathon_11_43_33_1692704613_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_43_33_1692704613_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_43_33_1692704613_.xml', 'miki', '2023-08-22 11:43:34', '', '7858222023081143336606194432', '0');
[08/22/2023 11:43:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023081143336606194432&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:43:33.581'
            , 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.097'
            , error_description = ''
            , memory_used = '1841792'
            WHERE id = '4701';
[08/22/2023 11:43:34], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_43_34_1692704614_5189860.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_43_34_1692704614_5189860.txt','7858','7858222023081143336606194432','0','2023-08-22 11:43:33','2023-08-22 11:43:34','hotel_search','','','1','0');
[08/22/2023 11:47:11], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:47:11' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:47:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:47:11.479'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:47:11'
                , session_id = '78582220230811471137188141566'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743824';
[08/22/2023 11:47: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/22_08_2023/request_availability_Tripathon_11_47_11_1692704831_57.json', 'e1/22_08_2023/response_availability_Tripathon_11_47_11_1692704831_57.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_47_11_1692704831_57.json', 'expedia', '2023-08-22 11:47:11', '', '78582220230811471137188141566', '0');
[08/22/2023 11:47: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', 'm1/22_08_2023/request_availability_Tripathon_11_47_11_1692704831_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_47_11_1692704831_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_47_11_1692704831_.xml', 'miki', '2023-08-22 11:47:11', '', '78582220230811471137188141566', '0');
[08/22/2023 11:47:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811471137188141566&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:47:11.479'
            , 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.252'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4704';
[08/22/2023 11:47:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811471137188141566&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:47:11.479'
            , 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.272'
            , error_description = ''
            , memory_used = '4052744'
            WHERE id = '4703';
[08/22/2023 11:47:11], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_47_11_1692704831_5598593.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_47_11_1692704831_5598593.txt','7858','78582220230811471137188141566','0','2023-08-22 11:47:11','2023-08-22 11:47:11','hotel_search','','','0','0');
[08/22/2023 11:53:17], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 11:53:17' , site_id = '' , country_code = '60' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/22/2023 11:53:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 11:53:17.672'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 11:53:17'
                , session_id = '78582220230811531777231244512'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 11:53:18], [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/22_08_2023/request_availability_Tripathon_11_53_17_1692705197_47.json', 'e1/22_08_2023/response_availability_Tripathon_11_53_17_1692705197_47.json', 'e1/22_08_2023/response_header_availability_Tripathon_11_53_17_1692705197_47.json', 'expedia', '2023-08-22 11:53:18', '', '78582220230811531777231244512', '0');
[08/22/2023 11:53:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230811531777231244512&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 11:53:17.672'
            , 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.587'
            , error_description = ''
            , memory_used = '4052968'
            WHERE id = '4706';
[08/22/2023 11:53:18], [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', 'm1/22_08_2023/request_availability_Tripathon_11_53_17_1692705197_.xml', 'm1/22_08_2023/response_availability_Tripathon_11_53_17_1692705197_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_11_53_17_1692705197_.xml', 'miki', '2023-08-22 11:53:18', '', '78582220230811531777231244512', '0');
[08/22/2023 11:53:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230811531777231244512&city_code=5089&country_code=DE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-22 11:53:17.672'
            , 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.964'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4707';
[08/22/2023 11:53:18], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_11_53_18_1692705198_2822198.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_11_53_18_1692705198_2822198.txt','7858','78582220230811531777231244512','0','2023-08-22 11:53:17','2023-08-22 11:53:18','hotel_search','','','1','0');
