[09/18/2023 07:12:24], [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 = 'Shanghai' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/09/29' , departure_date = '2023/10/05' , nights = '6' , nationality = '109' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-18 07:12:24' , site_id = '' , country_code = '103' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1551040';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:12:25.493'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:12:25'
                , session_id = '78581820230907122427705183539'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1558736';
[09/18/2023 07:12:25], [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/18_09_2023/request_availability_Tripathon_07_12_25_1695021145_62.json', 'e1/18_09_2023/response_availability_Tripathon_07_12_25_1695021145_62.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_12_25_1695021145_62.json', 'expedia', '2023-09-18 07:12:25', '', '78581820230907122427705183539', '0');
[09/18/2023 07:12:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907122427705183539&xml_user_id=7858&db_caching=1&erequest=2&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:12:25.493'
            , 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.484'
            , error_description = ''
            , memory_used = '1267256'
            WHERE id = '6168';
[09/18/2023 07:12:26], [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/18_09_2023/request_availability_Tripathon_07_12_25_1695021145_28.json', 'e1/18_09_2023/response_availability_Tripathon_07_12_25_1695021145_28.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_12_25_1695021145_28.json', 'expedia', '2023-09-18 07:12:26', '', '78581820230907122427705183539', '0');
[09/18/2023 07:12:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907122427705183539&xml_user_id=7858&db_caching=1&erequest=1&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:12:25.493'
            , 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.812'
            , error_description = ''
            , memory_used = '47320008'
            WHERE id = '6169';
[09/18/2023 07:12:27], [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/18_09_2023/request_availability_Tripathon_07_12_25_1695021145_46.json', 'e1/18_09_2023/response_availability_Tripathon_07_12_25_1695021145_46.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_12_25_1695021145_46.json', 'expedia', '2023-09-18 07:12:27', '', '78581820230907122427705183539', '0');
[09/18/2023 07:12:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907122427705183539&xml_user_id=7858&db_caching=1&erequest=0&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:12:25.493'
            , 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.412'
            , error_description = ''
            , memory_used = '71120984'
            WHERE id = '6170';
[09/18/2023 07:12: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/18_09_2023/request_hotel_search_Tripathon_07_12_28_1695021148_4965795.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/18_09_2023/response_hotel_search_Tripathon_07_12_28_1695021148_4965795.txt','7858','78581820230907122427705183539','0','2023-09-18 07:12:24','2023-09-18 07:12:28','hotel_search','','','4','0');
[09/18/2023 07:13:05], [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 = 'Shanghai' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/09/29' , departure_date = '2023/10/05' , nights = '6' , nationality = '109' , room_types = '1, 1' , room_type='[{"numberOfAdults":1},{"numberOfAdults":1}]' , available='1' , create_date = '2023-09-18 07:13:05' , site_id = '' , country_code = '103' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.009'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548272';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-18 07:13:05.651'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-18 07:13:05'
                , session_id = '78581820230907130599612196302'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1548296';
[09/18/2023 07:13:05], [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/18_09_2023/request_availability_Tripathon_07_13_05_1695021185_20.json', 'e1/18_09_2023/response_availability_Tripathon_07_13_05_1695021185_20.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_13_05_1695021185_20.json', 'expedia', '2023-09-18 07:13:05', '', '78581820230907130599612196302', '0');
[09/18/2023 07:13:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907130599612196302&xml_user_id=7858&db_caching=1&erequest=2&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:13:05.651'
            , 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.286'
            , error_description = ''
            , memory_used = '1256936'
            WHERE id = '6179';
[09/18/2023 07:13:06], [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/18_09_2023/request_availability_Tripathon_07_13_05_1695021185_85.json', 'e1/18_09_2023/response_availability_Tripathon_07_13_05_1695021185_85.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_13_05_1695021185_85.json', 'expedia', '2023-09-18 07:13:06', '', '78581820230907130599612196302', '0');
[09/18/2023 07:13:06], [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/18_09_2023/request_availability_Tripathon_07_13_05_1695021185_61.json', 'e1/18_09_2023/response_availability_Tripathon_07_13_05_1695021185_61.json', 'e1/18_09_2023/response_header_availability_Tripathon_07_13_05_1695021185_61.json', 'expedia', '2023-09-18 07:13:06', '', '78581820230907130599612196302', '0');
[09/18/2023 07:13:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907130599612196302&xml_user_id=7858&db_caching=1&erequest=1&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:13:05.651'
            , 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.313'
            , error_description = ''
            , memory_used = '47094312'
            WHERE id = '6180';
[09/18/2023 07:13:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78581820230907130599612196302&xml_user_id=7858&db_caching=1&erequest=0&total_request=3&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-09-18 07:13:05.651'
            , 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.727'
            , error_description = ''
            , memory_used = '71110824'
            WHERE id = '6181';
[09/18/2023 07:13:07], [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/18_09_2023/request_hotel_search_Tripathon_07_13_07_1695021187_1061387.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/18_09_2023/response_hotel_search_Tripathon_07_13_07_1695021187_1061387.txt','7858','78581820230907130599612196302','0','2023-09-18 07:13:05','2023-09-18 07:13:07','hotel_search','','','2','0');
