[09/24/2023 12:48:54], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/30' , departure_date = '2023/12/01' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-24 12:48:54' , site_id = '' , country_code = '138' , city_code = '' , ratings = '5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/24/2023 12:48:56], [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/24_09_2023/request_availability_sqtech_12_48_54_1695559734_30.json', 'e1/24_09_2023/response_availability_sqtech_12_48_54_1695559734_30.json', 'e1/24_09_2023/response_header_availability_sqtech_12_48_54_1695559734_30.json', 'expedia', '2023-09-24 12:48:56', '', '78392420230912485451444097194', '0');
[09/24/2023 12:48:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78392420230912485451444097194&xml_user_id=7839&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-09-24 12:48:54.420'
            , 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.467'
            , error_description = ''
            , memory_used = '120933472'
            WHERE id = '6752';
[09/24/2023 12:48:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/24_09_2023/request_availability_sqtech_12_48_54_1695559734_20.json', 'e1p/24_09_2023/response_availability_sqtech_12_48_54_1695559734_20.json', 'e1p/24_09_2023/response_header_availability_sqtech_12_48_54_1695559734_20.json', 'expediapackage', '2023-09-24 12:48:57', '', '78392420230912485451444097194', '0');
[09/24/2023 12:48:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=78392420230912485451444097194&xml_user_id=7839&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-09-24 12:48:54.421'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.131'
            , error_description = ''
            , memory_used = '134986904'
            WHERE id = '6753';
[09/24/2023 12:48:58], [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/sqtech/24_09_2023/request_hotel_search_sqtech_12_48_58_1695559738_5441615.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/sqtech/24_09_2023/response_hotel_search_sqtech_12_48_58_1695559738_5441615.txt','7839','78392420230912485451444097194','0','2023-09-24 12:48:54','2023-09-24 12:48:58','hotel_search','','','4','0');
