[08/22/2023 05:32:26], [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/22' , departure_date = '2023/08/29' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 05:32:26' , 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 05:32:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 05:32:27.662'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 05:32:27'
                , session_id = '78582220230805322662043179668'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743800';
[08/22/2023 05:32:28], [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_05_32_27_1692682347_.xml', 'm1/22_08_2023/response_availability_Tripathon_05_32_27_1692682347_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_05_32_27_1692682347_.xml', 'miki', '2023-08-22 05:32:28', '', '78582220230805322662043179668', '0');
[08/22/2023 05:32:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230805322662043179668&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 05:32:27.662'
            , 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.526'
            , error_description = ''
            , memory_used = '1841120'
            WHERE id = '4478';
[08/22/2023 05:32:28], [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_05_32_27_1692682347_70.json', 'e1/22_08_2023/response_availability_Tripathon_05_32_27_1692682347_70.json', 'e1/22_08_2023/response_header_availability_Tripathon_05_32_27_1692682347_70.json', 'expedia', '2023-08-22 05:32:28', '', '78582220230805322662043179668', '0');
[08/22/2023 05:32:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230805322662043179668&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 05:32:27.662'
            , 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.882'
            , error_description = ''
            , memory_used = '4051424'
            WHERE id = '4479';
[08/22/2023 05:32: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_05_32_28_1692682348_7914841.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_05_32_28_1692682348_7914841.txt','7858','78582220230805322662043179668','0','2023-08-22 05:32:26','2023-08-22 05:32:28','hotel_search','','','2','0');
