[08/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Darmstadt' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Bad homburg vor der hohe' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Frankfurt' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Oberursel' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Dietzenbach' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Morfelden-walldorf' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Kronberg im Taunus' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:37], [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 = '194.146.12.172' , city = 'Offenbach' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:37' , 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/23/2023 04:53:38], [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/23_08_2023/request_hotel_search_Tripathon_04_53_38_1692766418_2512860.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_38_1692766418_2512860.txt','7858','78582320230804533746731849718','0','2023-08-23 04:53:37','2023-08-23 04:53:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:53:38], [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/23_08_2023/request_hotel_search_Tripathon_04_53_38_1692766418_4657576.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_38_1692766418_4657576.txt','7858','78582320230804533725415498118','0','2023-08-23 04:53:37','2023-08-23 04:53:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:53:38], [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 = '194.146.12.172' , city = 'Griesheim' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:38' , 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/23/2023 04:53:38], [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 = '194.146.12.172' , city = 'Hochheim am Main' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:38' , 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/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:53:39.1'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:53:39'
                , session_id = '78582320230804533776665449936'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:53:39.2'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:53:39'
                , session_id = '78582320230804533730250956683'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:53:39.17'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:53:39'
                , session_id = '78582320230804533729639934336'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:53:39.17'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:53:39'
                , session_id = '78582320230804533729639934336'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:53:39.17'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:53:39'
                , session_id = '78582320230804533729639934336'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_33.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_33.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_33.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533738778915728', '0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533738778915728&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.0'
            , 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.429'
            , error_description = ''
            , memory_used = '3237648'
            WHERE id = '4989';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_5443388.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_5443388.txt','7858','78582320230804533738778915728','0','2023-08-23 04:53:37','2023-08-23 04:53:39','hotel_search','','','2','0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_65.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_65.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_65.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533860054843317', '0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_40.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_40.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_40.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533738656797405', '0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533738656797405&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:38.999'
            , 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.460'
            , error_description = ''
            , memory_used = '2569376'
            WHERE id = '4991';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_9151318.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_9151318.txt','7858','78582320230804533738656797405','0','2023-08-23 04:53:37','2023-08-23 04:53:39','hotel_search','Total count zero','','2','0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_21.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_21.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_21.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533765883173517', '0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533860054843317&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.0'
            , 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.488'
            , error_description = ''
            , memory_used = '3303672'
            WHERE id = '4990';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_5350875.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_5350875.txt','7858','78582320230804533860054843317','0','2023-08-23 04:53:38','2023-08-23 04:53:39','hotel_search','','','1','0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_51.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_51.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_51.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533730250956683', '0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_9.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_9.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_9.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533821651764361', '0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533821651764361&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.5'
            , 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.508'
            , error_description = ''
            , memory_used = '2568936'
            WHERE id = '4994';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_4010643.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_4010643.txt','7858','78582320230804533821651764361','0','2023-08-23 04:53:38','2023-08-23 04:53:39','hotel_search','Total count zero','','1','0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533765883173517&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:38.999'
            , 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.530'
            , error_description = ''
            , memory_used = '5197256'
            WHERE id = '4992';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_1789017.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_1789017.txt','7858','78582320230804533765883173517','0','2023-08-23 04:53:37','2023-08-23 04:53:39','hotel_search','','','2','0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533730250956683&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.2'
            , 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.561'
            , error_description = ''
            , memory_used = '6660568'
            WHERE id = '4993';
[08/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_9233469.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_9233469.txt','7858','78582320230804533730250956683','0','2023-08-23 04:53:37','2023-08-23 04:53:39','hotel_search','','','2','0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_11.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_11.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_11.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533776665449936', '0');
[08/23/2023 04:53:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533776665449936&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.2'
            , 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.890'
            , error_description = ''
            , memory_used = '6097976'
            WHERE id = '4995';
[08/23/2023 04:53:39], [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 = '194.146.12.172' , city = 'Langen' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:39' , 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/23/2023 04:53:39], [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/23_08_2023/request_hotel_search_Tripathon_04_53_39_1692766419_9120975.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_39_1692766419_9120975.txt','7858','78582320230804533776665449936','0','2023-08-23 04:53:37','2023-08-23 04:53:39','hotel_search','','','2','0');
[08/23/2023 04:53:39], [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/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_11.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_11.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_11.json', 'expedia', '2023-08-23 04:53:39', '', '78582320230804533729639934336', '0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533729639934336&xml_user_id=7858&db_caching=1&erequest=1&total_request=2&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.17'
            , 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.095'
            , error_description = ''
            , memory_used = '25631112'
            WHERE id = '4996';
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_31.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_31.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_31.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804533915027584749', '0');
[08/23/2023 04:53:40], [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 = '194.146.12.172' , city = 'Kelsterbach' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:40' , 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/23/2023 04:53:40], [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 = '194.146.12.172' , city = 'Raunheim' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:40' , 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/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533915027584749&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.997'
            , 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.434'
            , error_description = ''
            , memory_used = '4552792'
            WHERE id = '4997';
[08/23/2023 04:53:40], [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 = '194.146.12.172' , city = 'Kelkheim' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:40' , 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/23/2023 04:53:40], [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 = '194.146.12.172' , city = 'Hanau' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:40' , 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/23/2023 04:53:40], [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/23_08_2023/request_hotel_search_Tripathon_04_53_40_1692766420_9860301.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_40_1692766420_9860301.txt','7858','78582320230804533915027584749','0','2023-08-23 04:53:39','2023-08-23 04:53:40','hotel_search','','','1','0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_39_1692766419_20.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_39_1692766419_20.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_39_1692766419_20.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804533729639934336', '0');
[08/23/2023 04:53:40], [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 = '194.146.12.172' , city = 'Hofheim am taunus' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:40' , 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/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_13.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_13.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_13.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804534085572135077', '0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_73.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_73.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_73.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804534037664488429', '0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804534085572135077&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:40.540'
            , 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.322'
            , error_description = ''
            , memory_used = '3176136'
            WHERE id = '4999';
[08/23/2023 04:53:40], [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/23_08_2023/request_hotel_search_Tripathon_04_53_40_1692766420_1743794.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_40_1692766420_1743794.txt','7858','78582320230804534085572135077','0','2023-08-23 04:53:40','2023-08-23 04:53:40','hotel_search','','','0','0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_50.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_50.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_50.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804534021394409060', '0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804534037664488429&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:40.520'
            , 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.380'
            , error_description = ''
            , memory_used = '4760416'
            WHERE id = '5000';
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_87.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_87.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_87.json', 'expedia', '2023-08-23 04:53:40', '', '78582320230804534045755205262', '0');
[08/23/2023 04:53:40], [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/23_08_2023/request_hotel_search_Tripathon_04_53_40_1692766420_7951224.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_40_1692766420_7951224.txt','7858','78582320230804534037664488429','0','2023-08-23 04:53:40','2023-08-23 04:53:40','hotel_search','','','0','0');
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804534021394409060&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:40.534'
            , 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.409'
            , error_description = ''
            , memory_used = '4574280'
            WHERE id = '5001';
[08/23/2023 04:53:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804534045755205262&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:40.558'
            , 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.401'
            , error_description = ''
            , memory_used = '3964776'
            WHERE id = '5002';
[08/23/2023 04:53:40], [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/23_08_2023/request_hotel_search_Tripathon_04_53_40_1692766420_5613942.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_40_1692766420_5613942.txt','7858','78582320230804534021394409060','0','2023-08-23 04:53:40','2023-08-23 04:53:40','hotel_search','','','0','0');
[08/23/2023 04:53:40], [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/23_08_2023/request_hotel_search_Tripathon_04_53_40_1692766420_5412339.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_40_1692766420_5412339.txt','7858','78582320230804534045755205262','0','2023-08-23 04:53:40','2023-08-23 04:53:40','hotel_search','','','0','0');
[08/23/2023 04:53:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804533729639934336&xml_user_id=7858&db_caching=1&erequest=0&total_request=2&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:39.17'
            , 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.007'
            , error_description = ''
            , memory_used = '71190984'
            WHERE id = '4998';
[08/23/2023 04:53:41], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/23_08_2023/request_availability_Tripathon_04_53_40_1692766420_90.json', 'e1/23_08_2023/response_availability_Tripathon_04_53_40_1692766420_90.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_53_40_1692766420_90.json', 'expedia', '2023-08-23 04:53:41', '', '78582320230804534022724116927', '0');
[08/23/2023 04:53:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804534022724116927&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:53:40.823'
            , 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.308'
            , error_description = ''
            , memory_used = '3243080'
            WHERE id = '5003';
[08/23/2023 04:53:41], [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/23_08_2023/request_hotel_search_Tripathon_04_53_41_1692766421_9821578.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_41_1692766421_9821578.txt','7858','78582320230804534022724116927','0','2023-08-23 04:53:40','2023-08-23 04:53:41','hotel_search','','','1','0');
[08/23/2023 04:53:41], [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/23_08_2023/request_hotel_search_Tripathon_04_53_41_1692766421_1463100.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_41_1692766421_1463100.txt','7858','78582320230804533729639934336','0','2023-08-23 04:53:37','2023-08-23 04:53:41','hotel_search','','','4','0');
[08/23/2023 04:53:45], [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 = '194.146.12.172' , city = 'Russelsheim' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:53:45' , 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/23/2023 04:53:45], [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/23_08_2023/request_hotel_search_Tripathon_04_53_45_1692766425_4796309.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_53_45_1692766425_4796309.txt','7858','78582320230804534579099598575','0','2023-08-23 04:53:45','2023-08-23 04:53:45','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Oberursel' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Dietzenbach' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Offenbach' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Hanau' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Kelsterbach' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Griesheim' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Hochheim am Main' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Langen' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Hofheim am taunus' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Morfelden-walldorf' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Raunheim' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Darmstadt' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Kronberg im Taunus' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Russelsheim' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Kelkheim' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Frankfurt' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54:37], [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 = '194.146.12.172' , city = 'Bad homburg vor der hohe' , service_name = 'adin' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/24' , departure_date = '2023/08/31' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-23 04:54:37' , 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/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_7298010.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_7298010.txt','7858','78582320230804543748100464749','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:54:37.260'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-23 04:54:37'
                , session_id = '78582320230804543762340890387'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538264';
[08/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_3763972.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_3763972.txt','7858','78582320230804543762340890387','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:54:37.401'
                , total_duration = '0.075'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-23 04:54:37'
                , session_id = '7858232023080454376948023671'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538608';
[08/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_1854483.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_1854483.txt','7858','7858232023080454374492372004','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_8649411.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_8649411.txt','7858','7858232023080454376948023671','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:54:37.490'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-23 04:54:37'
                , session_id = '78582320230804543748387461393'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538280';
[08/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_9138513.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_9138513.txt','7858','78582320230804543748387461393','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'm1/23_08_2023/request_availability_Tripathon_04_54_37_1692766477_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_37_1692766477_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_37_1692766477_.xml', 'miki', '2023-08-23 04:54:37', '', '78582320230804543758677756976', '0');
[08/23/2023 04:54:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543758677756976&city_code=5118&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-23 04:54:37.355'
            , 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.383'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '5007';
[08/23/2023 04:54: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/23_08_2023/request_hotel_search_Tripathon_04_54_37_1692766477_3989319.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_37_1692766477_3989319.txt','7858','78582320230804543758677756976','0','2023-08-23 04:54:37','2023-08-23 04:54:37','hotel_search','Total count zero','','0','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_37_1692766477_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_37_1692766477_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_37_1692766477_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543791599209141', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543791599209141&city_code=5210&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-23 04:54:37.402'
            , 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.690'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '5008';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_4265431.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_4265431.txt','7858','78582320230804543791599209141','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_3706387.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_3706387.txt','7858','78582320230804543782919179743','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_3728120.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_3728120.txt','7858','7858232023080454379235060037','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:54:38.543'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-23 04:54:38'
                , session_id = '78582320230804543779097405124'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_3189102.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_3189102.txt','7858','78582320230804543796641577873','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-23 04:54:38.610'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-23 04:54:38'
                , session_id = '78582320230804543720743907157'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538224';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_8311851.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_8311851.txt','7858','78582320230804543720743907157','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543731322250848', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543731322250848&city_code=75026&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-23 04:54:38.386'
            , 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.311'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '5011';
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543795807119552', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543795807119552&city_code=5061&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-23 04:54:38.467'
            , 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.241'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '5012';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_9944562.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_9944562.txt','7858','78582320230804543731322250848','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_6600195.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_6600195.txt','7858','78582320230804543795807119552','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543786326265057', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543786326265057&city_code=75164&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-23 04:54:38.504'
            , 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 = '1844592'
            WHERE id = '5013';
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543717860409485', '0');
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_7907659.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_7907659.txt','7858','78582320230804543786326265057','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543717860409485&city_code=5569&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-23 04:54:38.527'
            , 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.230'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '5014';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_4346372.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_4346372.txt','7858','78582320230804543717860409485','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543779097405124', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543779097405124&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-23 04:54:38.543'
            , 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.241'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '5015';
[08/23/2023 04:54:38], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_.xml', 'm1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_.xml', 'miki', '2023-08-23 04:54:38', '', '78582320230804543737105169246', '0');
[08/23/2023 04:54:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582320230804543737105169246&city_code=9483&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-23 04:54:38.557'
            , 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 = '1844592'
            WHERE id = '5016';
[08/23/2023 04:54:38], [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/23_08_2023/request_hotel_search_Tripathon_04_54_38_1692766478_2149782.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_38_1692766478_2149782.txt','7858','78582320230804543737105169246','0','2023-08-23 04:54:37','2023-08-23 04:54:38','hotel_search','Total count zero','','1','0');
[08/23/2023 04:54:39], [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/23_08_2023/request_availability_Tripathon_04_54_38_1692766478_75.json', 'e1/23_08_2023/response_availability_Tripathon_04_54_38_1692766478_75.json', 'e1/23_08_2023/response_header_availability_Tripathon_04_54_38_1692766478_75.json', 'expedia', '2023-08-23 04:54:39', '', '78582320230804543779097405124', '0');
[08/23/2023 04:54:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582320230804543779097405124&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=194.146.12.172&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-23 04:54:38.543'
            , 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.576'
            , error_description = ''
            , memory_used = '4929432'
            WHERE id = '5017';
[08/23/2023 04:54:39], [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/23_08_2023/request_hotel_search_Tripathon_04_54_39_1692766479_8089343.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/23_08_2023/response_hotel_search_Tripathon_04_54_39_1692766479_8089343.txt','7858','78582320230804543779097405124','0','2023-08-23 04:54:37','2023-08-23 04:54:39','hotel_search','','','2','0');
