		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_12_22_15_1692706935_7714574.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_15_1692706935_7714574.txt','7858','78582220230812221595778769534','0','2023-08-22 12:22:15','2023-08-22 12:22:15','hotel_search','Total count zero','','0','0');
[08/22/2023 12:22:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:22:15.926'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:22:15'
                , session_id = '78582220230812221541045014472'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538136';
[08/22/2023 12:22:15], [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_12_22_15_1692706935_5637775.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_15_1692706935_5637775.txt','7858','78582220230812221541045014472','0','2023-08-22 12:22:15','2023-08-22 12:22:15','hotel_search','Total count zero','','0','0');
[08/22/2023 12:22:15], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:22:15.932'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:22:15'
                , session_id = '78582220230812221557832521902'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538136';
[08/22/2023 12:22:15], [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_12_22_15_1692706935_3134577.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_15_1692706935_3134577.txt','7858','78582220230812221557832521902','0','2023-08-22 12:22:15','2023-08-22 12:22:15','hotel_search','Total count zero','','0','0');
[08/22/2023 12:22: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', 'm1/22_08_2023/request_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:15', '', '78582220230812221522896604107', '0');
[08/22/2023 12:22:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221522896604107&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-22 12:22:15.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.326'
            , error_description = ''
            , memory_used = '1844080'
            WHERE id = '4909';
[08/22/2023 12:22:15], [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_12_22_15_1692706935_8618968.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_15_1692706935_8618968.txt','7858','78582220230812221522896604107','0','2023-08-22 12:22:15','2023-08-22 12:22:15','hotel_search','Total count zero','','0','0');
[08/22/2023 12:22: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', 'm1/22_08_2023/request_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:15', '', '78582220230812221585303525628', '0');
[08/22/2023 12:22:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221585303525628&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-22 12:22:15.716'
            , 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.285'
            , error_description = ''
            , memory_used = '1841440'
            WHERE id = '4910';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_6551063.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_6551063.txt','7858','78582220230812221585303525628','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221540599680465', '0');
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221540599680465&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-22 12:22:15.799'
            , 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.303'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4911';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_8912658.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_8912658.txt','7858','78582220230812221540599680465','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221565474340462', '0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221512528534987', '0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221589274807694', '0');
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221565474340462&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 12:22:15.745'
            , 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.381'
            , error_description = ''
            , memory_used = '1844080'
            WHERE id = '4912';
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221512528534987&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-22 12:22:15.781'
            , 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.345'
            , error_description = ''
            , memory_used = '1844080'
            WHERE id = '4913';
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221589274807694&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-22 12:22:15.796'
            , 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.336'
            , error_description = ''
            , memory_used = '1841576'
            WHERE id = '4914';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_3486037.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_3486037.txt','7858','78582220230812221512528534987','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_16_1692706936_4980102.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_4980102.txt','7858','78582220230812221589274807694','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221522385217955', '0');
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221522385217955&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-22 12:22:15.927'
            , 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.272'
            , error_description = ''
            , memory_used = '1844080'
            WHERE id = '4915';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_8574836.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_8574836.txt','7858','78582220230812221522385217955','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_.xml', 'miki', '2023-08-22 12:22:16', '', '78582220230812221555260678897', '0');
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812221555260678897&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-22 12:22:15.816'
            , 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.623'
            , error_description = ''
            , memory_used = '1844080'
            WHERE id = '4916';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_5257074.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_5257074.txt','7858','78582220230812221555260678897','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','Total count zero','','1','0');
[08/22/2023 12:22:16], [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_12_22_15_1692706935_83.json', 'e1/22_08_2023/response_availability_Tripathon_12_22_15_1692706935_83.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_22_15_1692706935_83.json', 'expedia', '2023-08-22 12:22:16', '', '78582220230812221565474340462', '0');
[08/22/2023 12:22:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812221565474340462&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-22 12:22:15.745'
            , 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.927'
            , error_description = ''
            , memory_used = '5421080'
            WHERE id = '4917';
[08/22/2023 12:22:16], [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_12_22_16_1692706936_9831393.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_22_16_1692706936_9831393.txt','7858','78582220230812221565474340462','0','2023-08-22 12:22:15','2023-08-22 12:22:16','hotel_search','','','1','0');
[08/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:32:20' , 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/22/2023 12:32:20], [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_12_32_20_1692707540_4100901.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_20_1692707540_4100901.txt','7858','78582220230812322094226563489','0','2023-08-22 12:32:20','2023-08-22 12:32:20','hotel_search','Total count zero','','0','0');
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:32:20.755'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:32:20'
                , session_id = '78582220230812322045665687747'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/22/2023 12:32:20], [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_12_32_20_1692707540_64.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_64.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_64.json', 'expedia', '2023-08-22 12:32:20', '', '78582220230812322085209126120', '0');
[08/22/2023 12:32:20], [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_12_32_20_1692707540_6638697.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_20_1692707540_6638697.txt','7858','7858222023081232204373291796','0','2023-08-22 12:32:20','2023-08-22 12:32:20','hotel_search','Total count zero','','0','0');
[08/22/2023 12:32:20], [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_12_32_20_1692707540_5750899.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_20_1692707540_5750899.txt','7858','78582220230812322062375842783','0','2023-08-22 12:32:20','2023-08-22 12:32:20','hotel_search','Total count zero','','0','0');
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322085209126120&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-22 12:32:20.563'
            , 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.291'
            , error_description = ''
            , memory_used = '2568944'
            WHERE id = '4919';
[08/22/2023 12:32:20], [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_12_32_20_1692707540_1068909.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_20_1692707540_1068909.txt','7858','78582220230812322085209126120','0','2023-08-22 12:32:20','2023-08-22 12:32:20','hotel_search','Total count zero','','0','0');
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:32:20.901'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:32:20'
                , session_id = '78582220230812322025043337147'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:32:20.929'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:32:20'
                , session_id = '78582220230812322058187635293'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:32:20.929'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:32:20'
                , session_id = '78582220230812322058187635293'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/22/2023 12:32:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:32:20.929'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:32:20'
                , session_id = '78582220230812322058187635293'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/22/2023 12:32:20], [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_12_32_20_1692707540_89.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_89.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_89.json', 'expedia', '2023-08-22 12:32:20', '', '78582220230812322048257383523', '0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_1.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_1.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_1.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322072062586017', '0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322048257383523&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-22 12:32:20.518'
            , 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.504'
            , error_description = ''
            , memory_used = '3243104'
            WHERE id = '4924';
[08/22/2023 12:32:21], [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_12_32_20_1692707540_41.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_41.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_41.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322084881167534', '0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_14.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_14.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_14.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322095129736606', '0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_24.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_24.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_24.json', 'expedia', '2023-08-22 12:32:21', '', '7858222023081232204133647363', '0');
[08/22/2023 12:32:21], [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_12_32_21_1692707541_9749976.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_9749976.txt','7858','78582220230812322048257383523','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322095129736606&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-22 12:32:20.585'
            , 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.461'
            , error_description = ''
            , memory_used = '2569112'
            WHERE id = '4927';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_2131407.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_2131407.txt','7858','78582220230812322095129736606','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','Total count zero','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322072062586017&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-22 12:32:20.551'
            , 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.518'
            , error_description = ''
            , memory_used = '4572624'
            WHERE id = '4925';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_8324165.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_8324165.txt','7858','78582220230812322072062586017','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322084881167534&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-22 12:32:20.730'
            , 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.364'
            , error_description = ''
            , memory_used = '3175752'
            WHERE id = '4926';
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7858222023081232204133647363&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-22 12:32:20.636'
            , 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.461'
            , error_description = ''
            , memory_used = '3917568'
            WHERE id = '4928';
[08/22/2023 12:32:21], [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_12_32_20_1692707540_37.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_37.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_37.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322073663125050', '0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_11.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_11.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_11.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322080816501753', '0');
[08/22/2023 12:32:21], [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_12_32_21_1692707541_8786618.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_8786618.txt','7858','78582220230812322084881167534','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_100.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_100.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_100.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322022895449081', '0');
[08/22/2023 12:32:21], [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_12_32_21_1692707541_6634669.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_6634669.txt','7858','7858222023081232204133647363','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_89.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_89.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_89.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322032691594499', '0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_22.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_22.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_22.json', 'expedia', '2023-08-22 12:32:21', '', '7858222023081232204204232301', '0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322022895449081&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-22 12:32:20.643'
            , 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.527'
            , error_description = ''
            , memory_used = '4586536'
            WHERE id = '4931';
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322080816501753&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-22 12:32:20.848'
            , 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.337'
            , error_description = ''
            , memory_used = '3303552'
            WHERE id = '4930';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_2544609.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_2544609.txt','7858','78582220230812322022895449081','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322073663125050&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-22 12:32:20.732'
            , 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.453'
            , error_description = ''
            , memory_used = '4696576'
            WHERE id = '4929';
[08/22/2023 12:32:21], [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_12_32_20_1692707540_56.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_56.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_56.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322045665687747', '0');
[08/22/2023 12:32:21], [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_12_32_21_1692707541_6948546.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_6948546.txt','7858','78582220230812322080816501753','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322032691594499&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-22 12:32:20.546'
            , 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.661'
            , error_description = ''
            , memory_used = '3238152'
            WHERE id = '4932';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_4897514.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_4897514.txt','7858','78582220230812322073663125050','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [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_12_32_21_1692707541_9401304.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_9401304.txt','7858','78582220230812322032691594499','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7858222023081232204204232301&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-22 12:32:20.843'
            , 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.390'
            , error_description = ''
            , memory_used = '5373576'
            WHERE id = '4933';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_1306839.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_1306839.txt','7858','7858222023081232204204232301','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322045665687747&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-22 12:32:20.758'
            , 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.495'
            , error_description = ''
            , memory_used = '5907616'
            WHERE id = '4934';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_6989498.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_6989498.txt','7858','78582220230812322045665687747','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_55.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_55.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_55.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322025043337147', '0');
[08/22/2023 12:32:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322025043337147&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-22 12:32:20.899'
            , 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.442'
            , error_description = ''
            , memory_used = '6662376'
            WHERE id = '4935';
[08/22/2023 12:32:21], [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_12_32_21_1692707541_8939861.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_21_1692707541_8939861.txt','7858','78582220230812322025043337147','0','2023-08-22 12:32:20','2023-08-22 12:32:21','hotel_search','','','1','0');
[08/22/2023 12:32:21], [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_12_32_20_1692707540_30.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_30.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_30.json', 'expedia', '2023-08-22 12:32:21', '', '78582220230812322058187635293', '0');
[08/22/2023 12:32:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322058187635293&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-22 12:32:20.929'
            , 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.142'
            , error_description = ''
            , memory_used = '24313744'
            WHERE id = '4936';
[08/22/2023 12:32:22], [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_12_32_20_1692707540_86.json', 'e1/22_08_2023/response_availability_Tripathon_12_32_20_1692707540_86.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_32_20_1692707540_86.json', 'expedia', '2023-08-22 12:32:22', '', '78582220230812322058187635293', '0');
[08/22/2023 12:32:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812322058187635293&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-22 12:32:20.929'
            , 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.975'
            , error_description = ''
            , memory_used = '73512568'
            WHERE id = '4937';
[08/22/2023 12:32:23], [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_12_32_23_1692707543_5956225.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_32_23_1692707543_5956225.txt','7858','78582220230812322058187635293','0','2023-08-22 12:32:20','2023-08-22 12:32:23','hotel_search','','','3','0');
[08/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:22], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:22' , 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/22/2023 12:33:23], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:23' , 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/22/2023 12:33:23], [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/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:33:23' , 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/22/2023 12:33:23], [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_12_33_23_1692707603_4833167.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_4833167.txt','7858','7858222023081233223166384539','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:33:23.126'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:33:23'
                , session_id = '7858222023081233225220203017'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538608';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_9132769.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_9132769.txt','7858','78582220230812332258098028185','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_6997885.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_6997885.txt','7858','7858222023081233225220203017','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:33:23.184'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:33:23'
                , session_id = '78582220230812332294452985376'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538264';
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:33:23.194'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:33:23'
                , session_id = '78582220230812332269929349937'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_2877413.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_2877413.txt','7858','78582220230812332294452985376','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_5587073.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_5587073.txt','7858','78582220230812332257113380222','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332277230122082', '0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_8196543.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_8196543.txt','7858','78582220230812332252594853476','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332277230122082&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-22 12:33:23.66'
            , 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.303'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4941';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_1254234.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_1254234.txt','7858','78582220230812332277230122082','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_3309089.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_3309089.txt','7858','78582220230812332318795300469','0','2023-08-22 12:33:23','2023-08-22 12:33:23','hotel_search','Total count zero','','0','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:33:23.371'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:33:23'
                , session_id = '78582220230812332240969150146'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538280';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_5085860.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_5085860.txt','7858','78582220230812332240969150146','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:33:23.403'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:33:23'
                , session_id = '78582220230812332341385202767'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538216';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_5629546.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_5629546.txt','7858','78582220230812332341385202767','0','2023-08-22 12:33:23','2023-08-22 12:33:23','hotel_search','Total count zero','','0','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332269929349937', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332269929349937&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 12:33:23.193'
            , 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.352'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4944';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_39.json', 'e1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_39.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_39.json', 'expedia', '2023-08-22 12:33:23', '', '78582220230812332269929349937', '0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332289221962449', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332289221962449&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-22 12:33:23.249'
            , 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 = '4946';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_4831218.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_4831218.txt','7858','78582220230812332289221962449','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332232707871643', '0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '7858222023081233221258684425', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332232707871643&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-22 12:33:23.246'
            , 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.346'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4947';
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023081233221258684425&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-22 12:33:23.248'
            , 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.349'
            , error_description = ''
            , memory_used = '1841536'
            WHERE id = '4948';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_1555486.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_1555486.txt','7858','78582220230812332232707871643','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_5128270.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_5128270.txt','7858','7858222023081233221258684425','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812332269929349937&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-22 12:33:23.194'
            , 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.421'
            , error_description = ''
            , memory_used = '5421792'
            WHERE id = '4945';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_5932227.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_5932227.txt','7858','78582220230812332269929349937','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332280004716713', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332280004716713&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-22 12:33:23.389'
            , 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.280'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4949';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_6855102.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_6855102.txt','7858','78582220230812332280004716713','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332270141513089', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332270141513089&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-22 12:33:23.255'
            , 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.562'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4950';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_8469482.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_8469482.txt','7858','78582220230812332270141513089','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:33:23], [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_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_33_23_1692707603_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_33_23_1692707603_.xml', 'miki', '2023-08-22 12:33:23', '', '78582220230812332248560452932', '0');
[08/22/2023 12:33:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812332248560452932&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-22 12:33:23.363'
            , 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.624'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4951';
[08/22/2023 12:33:23], [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_12_33_23_1692707603_2156456.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_33_23_1692707603_2156456.txt','7858','78582220230812332248560452932','0','2023-08-22 12:33:22','2023-08-22 12:33:23','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34: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 = '194.146.12.172' , city = 'Russelsheim' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Hofheim am taunus' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Raunheim' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Kelsterbach' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Darmstadt' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Kronberg im Taunus' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Hanau' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Dietzenbach' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Offenbach' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Langen' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Frankfurt' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Kelkheim' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34: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 = '194.146.12.172' , city = 'Bad homburg vor der hohe' , service_name = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:05' , 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/22/2023 12:34:06], [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 = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:06' , 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/22/2023 12:34:06], [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 = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:06' , 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/22/2023 12:34:06], [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 = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:06' , 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/22/2023 12:34:06], [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 = 'adina' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:34:06' , 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/22/2023 12:34:06], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:34:06.239'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:34:06'
                , session_id = '78582220230812340646169229695'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538216';
[08/22/2023 12:34:06], [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_12_34_06_1692707646_8665281.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_8665281.txt','7858','78582220230812340646169229695','0','2023-08-22 12:34:05','2023-08-22 12:34:06','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34:06], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:34:06.319'
                , total_duration = '0.029'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:34:06'
                , session_id = '78582220230812340653289487496'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538216';
[08/22/2023 12:34:06], [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_12_34_06_1692707646_8964887.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_8964887.txt','7858','78582220230812340699806461622','0','2023-08-22 12:34:06','2023-08-22 12:34:06','hotel_search','Total count zero','','0','0');
[08/22/2023 12:34:06], [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_12_34_06_1692707646_4924444.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_4924444.txt','7858','78582220230812340653289487496','0','2023-08-22 12:34:06','2023-08-22 12:34:06','hotel_search','Total count zero','','0','0');
[08/22/2023 12:34:06], [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_12_34_06_1692707646_6666566.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_6666566.txt','7858','78582220230812340527116579383','0','2023-08-22 12:34:05','2023-08-22 12:34:06','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34:06], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:34:06.454'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:34:06'
                , session_id = '78582220230812340567189062576'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538232';
[08/22/2023 12:34:06], [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_12_34_06_1692707646_2513920.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_2513920.txt','7858','78582220230812340567189062576','0','2023-08-22 12:34:05','2023-08-22 12:34:06','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34: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', 'm1/22_08_2023/request_availability_Tripathon_12_34_06_1692707646_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_06_1692707646_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_06_1692707646_.xml', 'miki', '2023-08-22 12:34:06', '', '78582220230812340591365594045', '0');
[08/22/2023 12:34:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340591365594045&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-22 12:34:06.387'
            , 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.273'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4955';
[08/22/2023 12:34:06], [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_12_34_06_1692707646_6038450.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_6038450.txt','7858','78582220230812340591365594045','0','2023-08-22 12:34:05','2023-08-22 12:34:06','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34: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', 'm1/22_08_2023/request_availability_Tripathon_12_34_06_1692707646_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_06_1692707646_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_06_1692707646_.xml', 'miki', '2023-08-22 12:34:06', '', '78582220230812340518435609721', '0');
[08/22/2023 12:34:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340518435609721&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-22 12:34:06.417'
            , 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.532'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4956';
[08/22/2023 12:34:06], [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_12_34_06_1692707646_3502453.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_06_1692707646_3502453.txt','7858','78582220230812340518435609721','0','2023-08-22 12:34:05','2023-08-22 12:34:06','hotel_search','Total count zero','','1','0');
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_5123593.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_5123593.txt','7858','78582220230812340568435632021','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_4809905.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_4809905.txt','7858','78582220230812340598699914151','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_7564532.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_7564532.txt','7858','7858222023081234055727504342','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:34:07.362'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:34:07'
                , session_id = '78582220230812340545127965655'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:34:07.400'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 12:34:07'
                , session_id = '78582220230812340598133553611'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538224';
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_1809637.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_1809637.txt','7858','78582220230812340598133553611','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '7858222023081234057211878485', '0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023081234057211878485&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-22 12:34:07.179'
            , 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.252'
            , error_description = ''
            , memory_used = '1841504'
            WHERE id = '4959';
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_9837846.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_9837846.txt','7858','7858222023081234057211878485','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '78582220230812340536129515345', '0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340536129515345&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-22 12:34:07.281'
            , 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.236'
            , error_description = ''
            , memory_used = '1841536'
            WHERE id = '4960';
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_5052452.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_5052452.txt','7858','78582220230812340536129515345','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '78582220230812340545127965655', '0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340545127965655&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 12:34:07.362'
            , 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.231'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4961';
[08/22/2023 12:34:07], [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_12_34_07_1692707647_30.json', 'e1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_30.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_30.json', 'expedia', '2023-08-22 12:34:07', '', '78582220230812340545127965655', '0');
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '78582220230812340532169200300', '0');
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '78582220230812340612818648907', '0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340532169200300&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-22 12:34:07.471'
            , 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 = '4963';
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340612818648907&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-22 12:34:07.482'
            , 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 = '1844720'
            WHERE id = '4964';
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_4461338.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_4461338.txt','7858','78582220230812340532169200300','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_7610964.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_7610964.txt','7858','78582220230812340612818648907','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812340545127965655&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-22 12:34:07.363'
            , 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.376'
            , error_description = ''
            , memory_used = '4929328'
            WHERE id = '4962';
[08/22/2023 12:34:07], [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_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_34_07_1692707647_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_34_07_1692707647_.xml', 'miki', '2023-08-22 12:34:07', '', '78582220230812340520846979141', '0');
[08/22/2023 12:34:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812340520846979141&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-22 12:34:07.499'
            , 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.255'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4965';
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_2903703.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_2903703.txt','7858','78582220230812340545127965655','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','','','2','0');
[08/22/2023 12:34: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/22_08_2023/request_hotel_search_Tripathon_12_34_07_1692707647_7744126.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_34_07_1692707647_7744126.txt','7858','78582220230812340520846979141','0','2023-08-22 12:34:05','2023-08-22 12:34:07','hotel_search','Total count zero','','2','0');
[08/22/2023 12:39:10], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:39:10' , 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/22/2023 12:39:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:39:11.66'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:39:11'
                , session_id = '7858222023081239106630880907'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743776';
[08/22/2023 12:39:11], [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_12_39_11_1692707951_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_39_11_1692707951_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_39_11_1692707951_.xml', 'miki', '2023-08-22 12:39:11', '', '7858222023081239106630880907', '0');
[08/22/2023 12:39:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023081239106630880907&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 12:39:11.66'
            , 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.256'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4967';
[08/22/2023 12:39:11], [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_12_39_11_1692707951_24.json', 'e1/22_08_2023/response_availability_Tripathon_12_39_11_1692707951_24.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_39_11_1692707951_24.json', 'expedia', '2023-08-22 12:39:11', '', '7858222023081239106630880907', '0');
[08/22/2023 12:39:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7858222023081239106630880907&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:39:11.66'
            , 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.594'
            , error_description = ''
            , memory_used = '4052240'
            WHERE id = '4968';
[08/22/2023 12:39:11], [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_12_39_11_1692707951_5533847.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_39_11_1692707951_5533847.txt','7858','7858222023081239106630880907','0','2023-08-22 12:39:10','2023-08-22 12:39:11','hotel_search','','','1','0');
[08/22/2023 12:40:35], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:40:35' , 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/22/2023 12:40:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:40:35.330'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:40:35'
                , session_id = '78582220230812403589927566052'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 12:40:35], [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_12_40_35_1692708035_71.json', 'e1/22_08_2023/response_availability_Tripathon_12_40_35_1692708035_71.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_40_35_1692708035_71.json', 'expedia', '2023-08-22 12:40:35', '', '78582220230812403589927566052', '0');
[08/22/2023 12:40:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812403589927566052&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:40:35.330'
            , 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.346'
            , error_description = ''
            , memory_used = '4052248'
            WHERE id = '4970';
[08/22/2023 12:40:35], [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_12_40_35_1692708035_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_40_35_1692708035_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_40_35_1692708035_.xml', 'miki', '2023-08-22 12:40:35', '', '78582220230812403589927566052', '0');
[08/22/2023 12:40:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812403589927566052&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 12:40:35.330'
            , 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.497'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4971';
[08/22/2023 12:40:35], [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_12_40_35_1692708035_6780104.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_40_35_1692708035_6780104.txt','7858','78582220230812403589927566052','0','2023-08-22 12:40:35','2023-08-22 12:40:35','hotel_search','','','0','0');
[08/22/2023 12:41:03], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:41:03' , 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/22/2023 12:41:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:41:03.768'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:41:03'
                , session_id = '78582220230812410324772829569'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 12:41:04], [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_12_41_03_1692708063_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_41_03_1692708063_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_41_03_1692708063_.xml', 'miki', '2023-08-22 12:41:04', '', '78582220230812410324772829569', '0');
[08/22/2023 12:41:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812410324772829569&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 12:41:03.769'
            , 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.255'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4973';
[08/22/2023 12:41:04], [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_12_41_03_1692708063_51.json', 'e1/22_08_2023/response_availability_Tripathon_12_41_03_1692708063_51.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_41_03_1692708063_51.json', 'expedia', '2023-08-22 12:41:04', '', '78582220230812410324772829569', '0');
[08/22/2023 12:41:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812410324772829569&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:41:03.768'
            , 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.369'
            , error_description = ''
            , memory_used = '4052272'
            WHERE id = '4974';
[08/22/2023 12:41:04], [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_12_41_04_1692708064_7556006.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_41_04_1692708064_7556006.txt','7858','78582220230812410324772829569','0','2023-08-22 12:41:03','2023-08-22 12:41:04','hotel_search','','','1','0');
[08/22/2023 12:43:17], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:43:17' , 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/22/2023 12:43:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:43:17.319'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:43:17'
                , session_id = '78582220230812431761751434350'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743824';
[08/22/2023 12:43: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', 'm1/22_08_2023/request_availability_Tripathon_12_43_17_1692708197_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_43_17_1692708197_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_43_17_1692708197_.xml', 'miki', '2023-08-22 12:43:17', '', '78582220230812431761751434350', '0');
[08/22/2023 12:43:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812431761751434350&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 12:43:17.318'
            , 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.252'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4976';
[08/22/2023 12:43: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/22_08_2023/request_availability_Tripathon_12_43_17_1692708197_11.json', 'e1/22_08_2023/response_availability_Tripathon_12_43_17_1692708197_11.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_43_17_1692708197_11.json', 'expedia', '2023-08-22 12:43:17', '', '78582220230812431761751434350', '0');
[08/22/2023 12:43:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812431761751434350&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:43:17.319'
            , 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.298'
            , error_description = ''
            , memory_used = '4052032'
            WHERE id = '4977';
[08/22/2023 12:43:17], [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_12_43_17_1692708197_8116206.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_43_17_1692708197_8116206.txt','7858','78582220230812431761751434350','0','2023-08-22 12:43:17','2023-08-22 12:43:17','hotel_search','','','0','0');
[08/22/2023 12:53:33], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:53:33' , 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/22/2023 12:53:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:53:33.537'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:53:33'
                , session_id = '78582220230812533330056601257'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 12:53:33], [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_12_53_33_1692708813_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_53_33_1692708813_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_53_33_1692708813_.xml', 'miki', '2023-08-22 12:53:33', '', '78582220230812533330056601257', '0');
[08/22/2023 12:53:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812533330056601257&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 12:53:33.537'
            , 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.276'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4979';
[08/22/2023 12:53:34], [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_12_53_33_1692708813_61.json', 'e1/22_08_2023/response_availability_Tripathon_12_53_33_1692708813_61.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_53_33_1692708813_61.json', 'expedia', '2023-08-22 12:53:34', '', '78582220230812533330056601257', '0');
[08/22/2023 12:53:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812533330056601257&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:53:33.537'
            , 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.712'
            , error_description = ''
            , memory_used = '4052032'
            WHERE id = '4980';
[08/22/2023 12:53:34], [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_12_53_34_1692708814_4104429.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_53_34_1692708814_4104429.txt','7858','78582220230812533330056601257','0','2023-08-22 12:53:33','2023-08-22 12:53:34','hotel_search','','','1','0');
[08/22/2023 12:55:30], [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 = '43.239.53.130' , city = 'Frankfurt' , service_name = 'Adina Apartment Hotel Frankfurt Westend' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-22 12:55:30' , 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/22/2023 12:55:30], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 12:55:30.630'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 12:55:30'
                , session_id = '78582220230812553099098860146'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743512';
[08/22/2023 12:55:31], [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_12_55_30_1692708930_.xml', 'm1/22_08_2023/response_availability_Tripathon_12_55_30_1692708930_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_12_55_30_1692708930_.xml', 'miki', '2023-08-22 12:55:31', '', '78582220230812553099098860146', '0');
[08/22/2023 12:55:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230812553099098860146&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 12:55:30.630'
            , 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.529'
            , error_description = ''
            , memory_used = '1844720'
            WHERE id = '4982';
[08/22/2023 12:55:34], [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_12_55_30_1692708930_63.json', 'e1/22_08_2023/response_availability_Tripathon_12_55_30_1692708930_63.json', 'e1/22_08_2023/response_header_availability_Tripathon_12_55_30_1692708930_63.json', 'expedia', '2023-08-22 12:55:34', '', '78582220230812553099098860146', '0');
[08/22/2023 12:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230812553099098860146&xml_user_id=7858&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=43.239.53.130&browser=GoogleChrome%2F113.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-22 12:55:30.630'
            , 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.460'
            , error_description = ''
            , memory_used = '4052248'
            WHERE id = '4983';
[08/22/2023 12:55:34], [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_12_55_34_1692708934_5838741.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_12_55_34_1692708934_5838741.txt','7858','78582220230812553099098860146','0','2023-08-22 12:55:30','2023-08-22 12:55:34','hotel_search','','','4','0');
