[09/04/2023 06:05:55], [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 = 'Dubai' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/09/21' , departure_date = '2023/09/22' , nights = '1' , nationality = '109' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-04 06:05:55' , site_id = '' , country_code = '138' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558240';
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558448';
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558448';
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1550488';
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558448';
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:05:56.218'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:05:56'
                , session_id = '78580420230906055544442487979'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558448';
[09/04/2023 06:05: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', 'm1/04_09_2023/request_availability_Tripathon_06_05_56_1693807556_.xml', 'm1/04_09_2023/response_availability_Tripathon_06_05_56_1693807556_.xml', 'm1/04_09_2023/response_header_availability_Tripathon_06_05_56_1693807556_.xml', 'miki', '2023-09-04 06:05:56', '', '78580420230906055544442487979', '0');
[09/04/2023 06:05:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78580420230906055544442487979&city_code=97001&country_code=AE&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-09-04 06:05:56.218'
            , 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.290'
            , error_description = ''
            , memory_used = '1390608'
            WHERE id = '5811';
[09/04/2023 06:05:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/04_09_2023/request_availability_Tripathon_06_05_56_1693807556_51.json', 'e1/04_09_2023/response_availability_Tripathon_06_05_56_1693807556_51.json', 'e1/04_09_2023/response_header_availability_Tripathon_06_05_56_1693807556_51.json', 'expedia', '2023-09-04 06:05:57', '', '78580420230906055544442487979', '0');
[09/04/2023 06:05:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78580420230906055544442487979&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-09-04 06:05:56.218'
            , 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.138'
            , error_description = ''
            , memory_used = '106544432'
            WHERE id = '5812';
[09/04/2023 06:05:58], [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/04_09_2023/request_availability_Tripathon_06_05_56_1693807556_98.json', 'e1/04_09_2023/response_availability_Tripathon_06_05_56_1693807556_98.json', 'e1/04_09_2023/response_header_availability_Tripathon_06_05_56_1693807556_98.json', 'expedia', '2023-09-04 06:05:58', '', '78580420230906055544442487979', '0');
[09/04/2023 06:05:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78580420230906055544442487979&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-09-04 06:05:56.218'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.537'
            , error_description = ''
            , memory_used = '188366000'
            WHERE id = '5813';
[09/04/2023 06:06:00], [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/04_09_2023/request_hotel_search_Tripathon_06_06_00_1693807560_8684921.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/04_09_2023/response_hotel_search_Tripathon_06_06_00_1693807560_8684921.txt','7858','78580420230906055544442487979','0','2023-09-04 06:05:55','2023-09-04 06:06:00','hotel_search','','','5','0');
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '194.146.12.172' , city = 'Dubai' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/09/21' , departure_date = '2023/09/22' , nights = '1' , nationality = '109' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-04 06:06:14' , site_id = '' , country_code = '138' , city_code = '' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548328';
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548328';
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548352';
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548352';
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548352';
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-04 06:06:14.180'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-04 06:06:14'
                , session_id = '78580420230906061414173038126'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548488';
[09/04/2023 06:06:14], [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/04_09_2023/request_availability_Tripathon_06_06_14_1693807574_.xml', 'm1/04_09_2023/response_availability_Tripathon_06_06_14_1693807574_.xml', 'm1/04_09_2023/response_header_availability_Tripathon_06_06_14_1693807574_.xml', 'miki', '2023-09-04 06:06:14', '', '78580420230906061414173038126', '0');
[09/04/2023 06:06:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78580420230906061414173038126&city_code=97001&country_code=AE&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-09-04 06:06:14.180'
            , 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.224'
            , error_description = ''
            , memory_used = '1214840'
            WHERE id = '5820';
[09/04/2023 06:06:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/04_09_2023/request_availability_Tripathon_06_06_14_1693807574_50.json', 'e1/04_09_2023/response_availability_Tripathon_06_06_14_1693807574_50.json', 'e1/04_09_2023/response_header_availability_Tripathon_06_06_14_1693807574_50.json', 'expedia', '2023-09-04 06:06:15', '', '78580420230906061414173038126', '0');
[09/04/2023 06:06:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78580420230906061414173038126&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-09-04 06:06:14.180'
            , 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.270'
            , error_description = ''
            , memory_used = '99016008'
            WHERE id = '5821';
[09/04/2023 06:06:17], [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/04_09_2023/request_availability_Tripathon_06_06_14_1693807574_67.json', 'e1/04_09_2023/response_availability_Tripathon_06_06_14_1693807574_67.json', 'e1/04_09_2023/response_header_availability_Tripathon_06_06_14_1693807574_67.json', 'expedia', '2023-09-04 06:06:17', '', '78580420230906061414173038126', '0');
[09/04/2023 06:06:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78580420230906061414173038126&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-09-04 06:06:14.180'
            , 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.292'
            , error_description = ''
            , memory_used = '176998424'
            WHERE id = '5822';
[09/04/2023 06:06:18], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/04_09_2023/request_hotel_search_Tripathon_06_06_18_1693807578_5376965.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/04_09_2023/response_hotel_search_Tripathon_06_06_18_1693807578_5376965.txt','7858','78580420230906061414173038126','0','2023-09-04 06:06:14','2023-09-04 06:06:18','hotel_search','','','4','0');
