[08/22/2023 09:29:19], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2023-08-22 09:29:19', ip = '52.167.144.163', action = 'Login' ;
[08/22/2023 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54:07], [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 09:54:07' , 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 09:54: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_09_54_07_1692698047_1452097.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_07_1692698047_1452097.txt','7858','78582220230809540786229900737','0','2023-08-22 09:54:07','2023-08-22 09:54:07','hotel_search','Total count zero','','0','0');
[08/22/2023 09:54:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:07.697'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:07'
                , session_id = '78582220230809540716332677806'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/22/2023 09:54:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:07.597'
                , total_duration = '0.129'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:07'
                , session_id = '78582220230809540788300393569'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/22/2023 09:54: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_09_54_07_1692698047_4568289.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_07_1692698047_4568289.txt','7858','78582220230809540756878541833','0','2023-08-22 09:54:07','2023-08-22 09:54:07','hotel_search','Total count zero','','0','0');
[08/22/2023 09:54: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_09_54_07_1692698047_5251251.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_07_1692698047_5251251.txt','7858','78582220230809540724454953482','0','2023-08-22 09:54:07','2023-08-22 09:54:07','hotel_search','Total count zero','','0','0');
[08/22/2023 09:54:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:07.715'
                , total_duration = '0.039'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:07'
                , session_id = '78582220230809540725942207135'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743568';
[08/22/2023 09:54:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:07.715'
                , total_duration = '0.041'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:07'
                , session_id = '78582220230809540725942207135'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/22/2023 09:54:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:07.715'
                , total_duration = '0.043'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:07'
                , session_id = '78582220230809540725942207135'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743664';
[08/22/2023 09:54:08], [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_09_54_07_1692698047_85.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_85.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_85.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540785743641295', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_80.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_80.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_80.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540710368551974', '0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540710368551974&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 09:54:07.762'
            , 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.324'
            , error_description = ''
            , memory_used = '2569376'
            WHERE id = '4493';
[08/22/2023 09:54:08], [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_09_54_07_1692698047_66.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_66.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_66.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540785430154764', '0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_4382433.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_4382433.txt','7858','78582220230809540710368551974','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_70.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_70.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_70.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540724993416488', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_27.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_27.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_27.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540776708268329', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_8.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_8.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_8.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540734769844875', '0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540785743641295&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 09:54:07.567'
            , 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.564'
            , error_description = ''
            , memory_used = '3303816'
            WHERE id = '4492';
[08/22/2023 09:54:08], [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_09_54_07_1692698047_7.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_7.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_7.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540712481255139', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_20.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_20.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_20.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540712508823871', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_61.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_61.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_61.json', 'expedia', '2023-08-22 09:54:08', '', '7858222023080954072232993217', '0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540712481255139&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 09:54:07.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.597'
            , error_description = ''
            , memory_used = '2569040'
            WHERE id = '4498';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_1168553.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_1168553.txt','7858','78582220230809540785743641295','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540785430154764&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 09:54:07.762'
            , 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.387'
            , error_description = ''
            , memory_used = '3238160'
            WHERE id = '4494';
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540724993416488&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 09:54:07.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.406'
            , error_description = ''
            , memory_used = '3242904'
            WHERE id = '4495';
[08/22/2023 09:54:08], [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_09_54_07_1692698047_82.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_82.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_82.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540744894877966', '0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_4631933.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_4631933.txt','7858','78582220230809540712481255139','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_3319381.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_3319381.txt','7858','78582220230809540785430154764','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_4842728.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_4842728.txt','7858','78582220230809540724993416488','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540776708268329&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 09:54:07.777'
            , 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.400'
            , error_description = ''
            , memory_used = '5373776'
            WHERE id = '4496';
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540734769844875&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 09:54:07.550'
            , 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.642'
            , error_description = ''
            , memory_used = '4592304'
            WHERE id = '4497';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_6858606.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_6858606.txt','7858','78582220230809540776708268329','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540712508823871&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 09:54:07.575'
            , 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 = '3918328'
            WHERE id = '4499';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_9997444.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_9997444.txt','7858','78582220230809540734769844875','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7858222023080954072232993217&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 09:54:07.725'
            , 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.487'
            , error_description = ''
            , memory_used = '3174952'
            WHERE id = '4500';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_6643766.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_6643766.txt','7858','78582220230809540712508823871','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_8492532.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_8492532.txt','7858','7858222023080954072232993217','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540744894877966&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 09:54:07.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.493'
            , error_description = ''
            , memory_used = '4572120'
            WHERE id = '4501';
[08/22/2023 09:54:08], [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_09_54_07_1692698047_21.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_21.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_21.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540788300393569', '0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_97.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_97.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_97.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540771564357870', '0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_9237007.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_9237007.txt','7858','78582220230809540744894877966','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_23.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_23.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_23.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540716332677806', '0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540771564357870&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 09:54:07.550'
            , 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.747'
            , error_description = ''
            , memory_used = '4586960'
            WHERE id = '4503';
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540788300393569&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 09:54:07.598'
            , 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.701'
            , error_description = ''
            , memory_used = '6662120'
            WHERE id = '4502';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_6360942.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_6360942.txt','7858','78582220230809540771564357870','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [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_09_54_08_1692698048_4349681.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_4349681.txt','7858','78582220230809540788300393569','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540716332677806&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 09:54:07.698'
            , 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.645'
            , error_description = ''
            , memory_used = '5907728'
            WHERE id = '4504';
[08/22/2023 09:54:08], [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_09_54_08_1692698048_1614860.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_08_1692698048_1614860.txt','7858','78582220230809540716332677806','0','2023-08-22 09:54:07','2023-08-22 09:54:08','hotel_search','','','1','0');
[08/22/2023 09:54:08], [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_09_54_07_1692698047_42.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_42.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_42.json', 'expedia', '2023-08-22 09:54:08', '', '78582220230809540725942207135', '0');
[08/22/2023 09:54:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540725942207135&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 09:54:07.715'
            , 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.012'
            , error_description = ''
            , memory_used = '24602552'
            WHERE id = '4505';
[08/22/2023 09:54:09], [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_09_54_07_1692698047_80.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_07_1692698047_80.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_07_1692698047_80.json', 'expedia', '2023-08-22 09:54:09', '', '78582220230809540725942207135', '0');
[08/22/2023 09:54:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809540725942207135&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 09:54:07.715'
            , 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.963'
            , error_description = ''
            , memory_used = '74609480'
            WHERE id = '4506';
[08/22/2023 09:54:09], [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_09_54_09_1692698049_2806403.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_09_1692698049_2806403.txt','7858','78582220230809540725942207135','0','2023-08-22 09:54:07','2023-08-22 09:54:09','hotel_search','','','2','0');
[08/22/2023 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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 09:54:57' , 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 09:54:57], [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_09_54_57_1692698097_6531919.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_57_1692698097_6531919.txt','7858','7858222023080954578530295789','0','2023-08-22 09:54:57','2023-08-22 09:54:57','hotel_search','Total count zero','','0','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_4490860.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_4490860.txt','7858','78582220230809545736232677760','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:58.0'
                , total_duration = '0.029'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:54:58'
                , session_id = '78582220230809545798495822260'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538232';
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:58.5'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:54:58'
                , session_id = '78582220230809545727712244128'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538280';
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_2505784.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_2505784.txt','7858','78582220230809545798495822260','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_7751332.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_7751332.txt','7858','78582220230809545727712244128','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:58.61'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:54:58'
                , session_id = '7858222023080954575067070815'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538608';
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_6153391.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_6153391.txt','7858','7858222023080954575067070815','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'm1/22_08_2023/request_availability_Tripathon_09_54_58_1692698098_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_58_1692698098_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_58_1692698098_.xml', 'miki', '2023-08-22 09:54:58', '', '7858222023080954571047436949', '0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023080954571047436949&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 09:54:57.998'
            , 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.314'
            , error_description = ''
            , memory_used = '1841576'
            WHERE id = '4510';
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_4912983.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_4912983.txt','7858','7858222023080954571047436949','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'm1/22_08_2023/request_availability_Tripathon_09_54_58_1692698098_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_58_1692698098_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_58_1692698098_.xml', 'miki', '2023-08-22 09:54:58', '', '78582220230809545710461778854', '0');
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545710461778854&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 09:54:58.81'
            , 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.537'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4511';
[08/22/2023 09:54:58], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_54_58_1692698098_5713671.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_58_1692698098_5713671.txt','7858','78582220230809545710461778854','0','2023-08-22 09:54:57','2023-08-22 09:54:58','hotel_search','Total count zero','','1','0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_2907110.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_2907110.txt','7858','7858222023080954576526514478','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_8656740.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_8656740.txt','7858','78582220230809545713836942901','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_3048799.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_3048799.txt','7858','78582220230809545721439446051','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:59.502'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:54:59'
                , session_id = '785822202308095457457032547'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1537936';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_8192862.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_8192862.txt','7858','785822202308095457457032547','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:54:59.534'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:54:59'
                , session_id = '78582220230809545779510678818'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743440';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '78582220230809545768758009842', '0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '7858222023080954579535731197', '0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '78582220230809545771994654976', '0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545768758009842&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 09:54:59.500'
            , 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 = '4514';
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023080954579535731197&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 09:54:59.500'
            , 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.232'
            , error_description = ''
            , memory_used = '1841504'
            WHERE id = '4515';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '78582220230809545775609054558', '0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545771994654976&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 09:54:59.501'
            , 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.232'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4516';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '78582220230809545748590433742', '0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_3425292.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_3425292.txt','7858','78582220230809545768758009842','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_4468795.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_4468795.txt','7858','7858222023080954579535731197','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545775609054558&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 09:54:59.500'
            , 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.251'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4517';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_9036428.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_9036428.txt','7858','78582220230809545771994654976','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545748590433742&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 09:54:59.502'
            , 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.254'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4518';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_.xml', 'miki', '2023-08-22 09:54:59', '', '78582220230809545779510678818', '0');
[08/22/2023 09:54:59], [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_09_54_59_1692698099_6079072.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_6079072.txt','7858','78582220230809545775609054558','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809545779510678818&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 09:54:59.532'
            , 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.238'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4519';
[08/22/2023 09:54:59], [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_09_54_59_1692698099_7705922.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_54_59_1692698099_7705922.txt','7858','78582220230809545748590433742','0','2023-08-22 09:54:57','2023-08-22 09:54:59','hotel_search','Total count zero','','2','0');
[08/22/2023 09:55:00], [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_09_54_59_1692698099_90.json', 'e1/22_08_2023/response_availability_Tripathon_09_54_59_1692698099_90.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_54_59_1692698099_90.json', 'expedia', '2023-08-22 09:55:00', '', '78582220230809545779510678818', '0');
[08/22/2023 09:55:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809545779510678818&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 09:54:59.532'
            , 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.525'
            , error_description = ''
            , memory_used = '5421592'
            WHERE id = '4520';
[08/22/2023 09:55:00], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/request_hotel_search_Tripathon_09_55_00_1692698100_7578076.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_00_1692698100_7578076.txt','7858','78582220230809545779510678818','0','2023-08-22 09:54:57','2023-08-22 09:55:00','hotel_search','','','3','0');
[08/22/2023 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55: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 = '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 09:55: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 09:55:33], [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_09_55_33_1692698133_6977236.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_6977236.txt','7858','7858222023080955337347687575','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:55:33.470'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:55:33'
                , session_id = '7858222023080955334930110098'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538608';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_7118695.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_7118695.txt','7858','7858222023080955334930110098','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55: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 = '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 09:55: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 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:55:33.606'
                , total_duration = '0.034'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:55:33'
                , session_id = '78582220230809553366178531249'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_9980569.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_9980569.txt','7858','78582220230809553336324842746','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [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_09_55_33_1692698133_1743005.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_1743005.txt','7858','78582220230809553348371265321','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:55:33.677'
                , total_duration = '0.070'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:55:33'
                , session_id = '7858222023080955335356810297'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538368';
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:55:33.681'
                , total_duration = '0.066'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:55:33'
                , session_id = '78582220230809553314154123290'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538280';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_6195185.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_6195185.txt','7858','7858222023080955335356810297','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [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_09_55_33_1692698133_4021893.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_4021893.txt','7858','78582220230809553314154123290','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [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_09_55_33_1692698133_8358099.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_8358099.txt','7858','78582220230809553334844863467','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [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_09_55_33_1692698133_4002305.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_4002305.txt','7858','78582220230809553310767580624','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:55:33.786'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'miki'
                , create_date = '2023-08-22 09:55:33'
                , session_id = '78582220230809553319019916661'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1538264';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_2951573.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_2951573.txt','7858','78582220230809553319019916661','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55: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_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:33', '', '78582220230809553366178531249', '0');
[08/22/2023 09:55: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_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:33', '', '78582220230809553312969378018', '0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553366178531249&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 09:55:33.606'
            , 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.293'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4526';
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553312969378018&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 09:55:33.578'
            , 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.325'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4527';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_3540427.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_3540427.txt','7858','78582220230809553312969378018','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55: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', 'e1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_1.json', 'e1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_1.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_1.json', 'expedia', '2023-08-22 09:55:33', '', '78582220230809553366178531249', '0');
[08/22/2023 09:55: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_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:33', '', '78582220230809553338204499619', '0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553338204499619&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 09:55:33.627'
            , 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.347'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4529';
[08/22/2023 09:55:33], [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_09_55_33_1692698133_2817331.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_33_1692698133_2817331.txt','7858','78582220230809553338204499619','0','2023-08-22 09:55:33','2023-08-22 09:55:33','hotel_search','Total count zero','','0','0');
[08/22/2023 09:55:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809553366178531249&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 09:55:33.606'
            , 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.393'
            , error_description = ''
            , memory_used = '5421480'
            WHERE id = '4528';
[08/22/2023 09: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_09_55_34_1692698134_5137151.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_5137151.txt','7858','78582220230809553366178531249','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','','','1','0');
[08/22/2023 09: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', 'm1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:34', '', '78582220230809553362024932824', '0');
[08/22/2023 09: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', 'm1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:34', '', '78582220230809553375924281871', '0');
[08/22/2023 09:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553375924281871&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 09:55:33.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.242'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4531';
[08/22/2023 09:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553362024932824&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 09:55:33.782'
            , 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.257'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4530';
[08/22/2023 09: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_09_55_34_1692698134_2708633.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_2708633.txt','7858','78582220230809553375924281871','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','Total count zero','','1','0');
[08/22/2023 09: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', 'm1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:34', '', '78582220230809553352986429543', '0');
[08/22/2023 09: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_09_55_34_1692698134_5036043.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_5036043.txt','7858','78582220230809553362024932824','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','Total count zero','','1','0');
[08/22/2023 09:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553352986429543&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 09:55:33.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.543'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4532';
[08/22/2023 09: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_09_55_34_1692698134_9190454.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_9190454.txt','7858','78582220230809553352986429543','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','Total count zero','','1','0');
[08/22/2023 09: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', 'm1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:34', '', '7858222023080955338218001164', '0');
[08/22/2023 09:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=7858222023080955338218001164&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 09:55:33.668'
            , 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.579'
            , error_description = ''
            , memory_used = '1841576'
            WHERE id = '4533';
[08/22/2023 09: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_09_55_34_1692698134_2409019.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_2409019.txt','7858','7858222023080955338218001164','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','Total count zero','','1','0');
[08/22/2023 09: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', 'm1/22_08_2023/request_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_55_33_1692698133_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_55_33_1692698133_.xml', 'miki', '2023-08-22 09:55:34', '', '78582220230809553317385907898', '0');
[08/22/2023 09:55:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809553317385907898&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 09:55:33.776'
            , 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.533'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4534';
[08/22/2023 09: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_09_55_34_1692698134_6514324.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_55_34_1692698134_6514324.txt','7858','78582220230809553317385907898','0','2023-08-22 09:55:33','2023-08-22 09:55:34','hotel_search','Total count zero','','1','0');
[08/22/2023 09:56:11], [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 09:56:11' , 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 09:56:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:56:11.939'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:56:11'
                , session_id = '78582220230809561119260510344'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 09:56:12], [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_09_56_11_1692698171_72.json', 'e1/22_08_2023/response_availability_Tripathon_09_56_11_1692698171_72.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_56_11_1692698171_72.json', 'expedia', '2023-08-22 09:56:12', '', '78582220230809561119260510344', '0');
[08/22/2023 09:56:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809561119260510344&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 09:56:11.939'
            , 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.360'
            , error_description = ''
            , memory_used = '5421832'
            WHERE id = '4536';
[08/22/2023 09:56:12], [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_09_56_11_1692698171_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_56_11_1692698171_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_56_11_1692698171_.xml', 'miki', '2023-08-22 09:56:12', '', '78582220230809561119260510344', '0');
[08/22/2023 09:56:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809561119260510344&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 09:56:11.939'
            , 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.419'
            , error_description = ''
            , memory_used = '1844728'
            WHERE id = '4537';
[08/22/2023 09:56:12], [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_09_56_12_1692698172_1935290.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_56_12_1692698172_1935290.txt','7858','78582220230809561119260510344','0','2023-08-22 09:56:11','2023-08-22 09:56:12','hotel_search','','','1','0');
[08/22/2023 09:56:40], [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 09:56:40' , 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 09:56:40], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:56:40.599'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:56:40'
                , session_id = '78582220230809564063682451521'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 09:56:40], [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_09_56_40_1692698200_4.json', 'e1/22_08_2023/response_availability_Tripathon_09_56_40_1692698200_4.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_56_40_1692698200_4.json', 'expedia', '2023-08-22 09:56:40', '', '78582220230809564063682451521', '0');
[08/22/2023 09:56:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809564063682451521&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 09:56:40.599'
            , 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.343'
            , error_description = ''
            , memory_used = '5420648'
            WHERE id = '4539';
[08/22/2023 09:56:41], [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_09_56_40_1692698200_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_56_40_1692698200_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_56_40_1692698200_.xml', 'miki', '2023-08-22 09:56:41', '', '78582220230809564063682451521', '0');
[08/22/2023 09:56:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809564063682451521&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 09:56:40.599'
            , 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.528'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4540';
[08/22/2023 09:56:41], [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_09_56_41_1692698201_9045533.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_56_41_1692698201_9045533.txt','7858','78582220230809564063682451521','0','2023-08-22 09:56:40','2023-08-22 09:56:41','hotel_search','','','1','0');
[08/22/2023 09:56:48], [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 09:56:48' , 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 09:56:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:56:49.57'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:56:49'
                , session_id = '78582220230809564817740017090'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743416';
[08/22/2023 09:56:49], [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_09_56_49_1692698209_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_56_49_1692698209_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_56_49_1692698209_.xml', 'miki', '2023-08-22 09:56:49', '', '78582220230809564817740017090', '0');
[08/22/2023 09:56:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809564817740017090&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 09:56:49.57'
            , 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.238'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4542';
[08/22/2023 09:56:49], [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_09_56_49_1692698209_40.json', 'e1/22_08_2023/response_availability_Tripathon_09_56_49_1692698209_40.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_56_49_1692698209_40.json', 'expedia', '2023-08-22 09:56:49', '', '78582220230809564817740017090', '0');
[08/22/2023 09:56:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809564817740017090&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 09:56:49.58'
            , 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.467'
            , error_description = ''
            , memory_used = '5422008'
            WHERE id = '4543';
[08/22/2023 09:56:49], [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_09_56_49_1692698209_3666010.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_56_49_1692698209_3666010.txt','7858','78582220230809564817740017090','0','2023-08-22 09:56:48','2023-08-22 09:56:49','hotel_search','','','1','0');
[08/22/2023 09:56:59], [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 09:56:59' , 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 09:56:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-22 09:56:59.169'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-22 09:56:59'
                , session_id = '78582220230809565965285838585'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743440';
[08/22/2023 09:56:59], [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_09_56_59_1692698219_.xml', 'm1/22_08_2023/response_availability_Tripathon_09_56_59_1692698219_.xml', 'm1/22_08_2023/response_header_availability_Tripathon_09_56_59_1692698219_.xml', 'miki', '2023-08-22 09:56:59', '', '78582220230809565965285838585', '0');
[08/22/2023 09:56:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582220230809565965285838585&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 09:56:59.170'
            , 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.247'
            , error_description = ''
            , memory_used = '1844592'
            WHERE id = '4545';
[08/22/2023 09:56:59], [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_09_56_59_1692698219_12.json', 'e1/22_08_2023/response_availability_Tripathon_09_56_59_1692698219_12.json', 'e1/22_08_2023/response_header_availability_Tripathon_09_56_59_1692698219_12.json', 'expedia', '2023-08-22 09:56:59', '', '78582220230809565965285838585', '0');
[08/22/2023 09:56:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582220230809565965285838585&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 09:56:59.170'
            , 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.325'
            , error_description = ''
            , memory_used = '5422232'
            WHERE id = '4546';
[08/22/2023 09:56:59], [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_09_56_59_1692698219_1004020.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/22_08_2023/response_hotel_search_Tripathon_09_56_59_1692698219_1004020.txt','7858','78582220230809565965285838585','0','2023-08-22 09:56:59','2023-08-22 09:56:59','hotel_search','','','0','0');
