[09/30/2024 01:09:44], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/04' , departure_date = '2024/11/11' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:09:44' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:09:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913094472986816338', session_id='12843020240913094472986816338', Collection_create_time='2024-09-30 13:09:45';
[09/30/2024 01:10:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_46_172770178611.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178611.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_46_172770178611.json', 'ratehawk', '2024-09-30 01:10:01', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178611.json');
[09/30/2024 01:10:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '49'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.663'
        , request_start_time = '0.621'
        , parsing_start_time = '14.748'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.107'
        , search_end_time = '0.118'
        , total_duration = '15.646'
        , error_description = ''
        , memory_used = '26633752'
        WHERE id = '189168409';
[09/30/2024 01:10:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_46_172770178612.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178612.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_46_172770178612.json', 'ratehawk', '2024-09-30 01:10:01', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178612.json');
[09/30/2024 01:10:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.664'
        , request_start_time = '0.623'
        , parsing_start_time = '15.312'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.020'
        , search_end_time = '0.001'
        , total_duration = '16.001'
        , error_description = ''
        , memory_used = '2655816'
        WHERE id = '189168410';
[09/30/2024 01:10:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017850.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017850.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017850.json', 'ratehawk', '2024-09-30 01:10:01', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017850.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_46_172770178610.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178610.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_46_172770178610.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_46_172770178610.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017857.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017857.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017857.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017857.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017851.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017851.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017851.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017851.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017853.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017853.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017853.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017853.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_46_17277017868.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_46_17277017868.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_46_17277017868.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_46_17277017868.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_46_17277017869.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_46_17277017869.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_46_17277017869.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_46_17277017869.json');
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '57'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.632'
        , request_start_time = '0.092'
        , parsing_start_time = '16.134'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.333'
        , search_end_time = '0.106'
        , total_duration = '16.734'
        , error_description = ''
        , memory_used = '50433968'
        WHERE id = '189168411';
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '54'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.659'
        , request_start_time = '0.535'
        , parsing_start_time = '15.775'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.275'
        , search_end_time = '0.123'
        , total_duration = '16.764'
        , error_description = ''
        , memory_used = '32886080'
        WHERE id = '189168412';
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '60'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.653'
        , request_start_time = '0.373'
        , parsing_start_time = '16.084'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.219'
        , search_end_time = '0.093'
        , total_duration = '16.829'
        , error_description = ''
        , memory_used = '34882216'
        WHERE id = '189168416';
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.655'
        , request_start_time = '0.255'
        , parsing_start_time = '16.159'
        , mapping_complete_time = '0.082'
        , mongo_start_time = '0.237'
        , search_end_time = '0.146'
        , total_duration = '16.858'
        , error_description = ''
        , memory_used = '53816784'
        WHERE id = '189168413';
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.657'
        , request_start_time = '0.404'
        , parsing_start_time = '16.072'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.260'
        , search_end_time = '0.120'
        , total_duration = '16.913'
        , error_description = ''
        , memory_used = '50664928'
        WHERE id = '189168417';
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.632'
        , request_start_time = '0.165'
        , parsing_start_time = '16.273'
        , mapping_complete_time = '0.122'
        , mongo_start_time = '0.343'
        , search_end_time = '0.150'
        , total_duration = '17.022'
        , error_description = ''
        , memory_used = '66616792'
        WHERE id = '189168414';
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017852.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017852.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017852.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017852.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017854.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017854.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017854.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017854.json');
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017855.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017855.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017855.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017855.json');
[09/30/2024 01:10:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '117'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.639'
        , request_start_time = '0.255'
        , parsing_start_time = '16.210'
        , mapping_complete_time = '0.190'
        , mongo_start_time = '0.523'
        , search_end_time = '0.242'
        , total_duration = '17.305'
        , error_description = ''
        , memory_used = '107490096'
        WHERE id = '189168415';
[09/30/2024 01:10:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_09_45_17277017856.json', 'rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017856.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_09_45_17277017856.json', 'ratehawk', '2024-09-30 01:10:02', '', '12843020240913094472986816338', '16617755', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_09_45_17277017856.json');
[09/30/2024 01:10:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '110'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.634'
        , request_start_time = '0.137'
        , parsing_start_time = '16.872'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.343'
        , search_end_time = '0.191'
        , total_duration = '17.614'
        , error_description = ''
        , memory_used = '74765536'
        WHERE id = '189168428';
[09/30/2024 01:10:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.649'
        , request_start_time = '0.192'
        , parsing_start_time = '17.097'
        , mapping_complete_time = '0.103'
        , mongo_start_time = '0.347'
        , search_end_time = '0.185'
        , total_duration = '17.892'
        , error_description = ''
        , memory_used = '85221536'
        WHERE id = '189168451';
[09/30/2024 01:10:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '131'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.645'
        , request_start_time = '0.131'
        , parsing_start_time = '16.981'
        , mapping_complete_time = '0.165'
        , mongo_start_time = '0.529'
        , search_end_time = '0.564'
        , total_duration = '18.290'
        , error_description = ''
        , memory_used = '117961552'
        WHERE id = '189168440';
[09/30/2024 01:10:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '139'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913094472986816338&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:09:45.645'
        , request_start_time = '0.192'
        , parsing_start_time = '17.023'
        , mapping_complete_time = '0.173'
        , mongo_start_time = '0.582'
        , search_end_time = '0.447'
        , total_duration = '18.359'
        , error_description = ''
        , memory_used = '138814544'
        WHERE id = '189168445';
[09/30/2024 01:10:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1035',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913094472986816338',
        duration = '20.182',
        merge_duration = '0.067',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.70',
        system_load_5_min = '10.60',
        system_load_15_min = '7.18',
        system_memory_usage = '27.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16617755') + '6044280',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16617755';
[09/30/2024 01:14:52], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/04' , departure_date = '2024/11/11' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:14:52' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:14:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913145251676845182', session_id='12843020240913145251676845182', Collection_create_time='2024-09-30 13:14:53';
[09/30/2024 01:14:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_172770209412.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209412.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_172770209412.json', 'ratehawk', '2024-09-30 01:14:57', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209412.json');
[09/30/2024 01:14:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.977'
        , request_start_time = '0.601'
        , parsing_start_time = '3.292'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.019'
        , search_end_time = '0.001'
        , total_duration = '3.945'
        , error_description = ''
        , memory_used = '2655936'
        WHERE id = '189171423';
[09/30/2024 01:15:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020940.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020940.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020940.json', 'ratehawk', '2024-09-30 01:15:01', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020940.json');
[09/30/2024 01:15:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '57'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.952'
        , request_start_time = '0.145'
        , parsing_start_time = '6.869'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.172'
        , search_end_time = '0.121'
        , total_duration = '7.360'
        , error_description = ''
        , memory_used = '50208464'
        WHERE id = '189171424';
[09/30/2024 01:15:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020941.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020941.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020941.json', 'ratehawk', '2024-09-30 01:15:01', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020941.json');
[09/30/2024 01:15:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '92'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.952'
        , request_start_time = '0.135'
        , parsing_start_time = '7.378'
        , mapping_complete_time = '0.080'
        , mongo_start_time = '0.373'
        , search_end_time = '0.150'
        , total_duration = '8.094'
        , error_description = ''
        , memory_used = '67539744'
        WHERE id = '189171425';
[09/30/2024 01:15:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_172770209411.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209411.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_172770209411.json', 'ratehawk', '2024-09-30 01:15:02', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209411.json');
[09/30/2024 01:15:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '49'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.974'
        , request_start_time = '0.590'
        , parsing_start_time = '7.601'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.110'
        , search_end_time = '0.129'
        , total_duration = '8.474'
        , error_description = ''
        , memory_used = '26181672'
        WHERE id = '189171426';
[09/30/2024 01:15:02], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020947.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020947.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020947.json', 'ratehawk', '2024-09-30 01:15:02', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020947.json');
[09/30/2024 01:15:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.969'
        , request_start_time = '0.206'
        , parsing_start_time = '8.451'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.211'
        , search_end_time = '0.128'
        , total_duration = '9.048'
        , error_description = ''
        , memory_used = '56266960'
        WHERE id = '189171427';
[09/30/2024 01:15:03], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_172770209410.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209410.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_172770209410.json', 'ratehawk', '2024-09-30 01:15:03', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_172770209410.json');
[09/30/2024 01:15:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '54'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.971'
        , request_start_time = '0.470'
        , parsing_start_time = '9.084'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.132'
        , search_end_time = '0.126'
        , total_duration = '9.859'
        , error_description = ''
        , memory_used = '34941768'
        WHERE id = '189171428';
[09/30/2024 01:15:04], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020946.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020946.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020946.json', 'ratehawk', '2024-09-30 01:15:04', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020946.json');
[09/30/2024 01:15:04], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020943.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020943.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020943.json', 'ratehawk', '2024-09-30 01:15:04', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020943.json');
[09/30/2024 01:15:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.962'
        , request_start_time = '0.208'
        , parsing_start_time = '9.864'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.336'
        , search_end_time = '0.169'
        , total_duration = '10.638'
        , error_description = ''
        , memory_used = '86918400'
        WHERE id = '189171429';
[09/30/2024 01:15:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '117'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.962'
        , request_start_time = '0.196'
        , parsing_start_time = '10.068'
        , mapping_complete_time = '0.132'
        , mongo_start_time = '0.419'
        , search_end_time = '0.251'
        , total_duration = '11.002'
        , error_description = ''
        , memory_used = '110074504'
        WHERE id = '189171430';
[09/30/2024 01:15:10], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020948.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020948.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020948.json', 'ratehawk', '2024-09-30 01:15:10', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020948.json');
[09/30/2024 01:15:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '60'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.969'
        , request_start_time = '0.301'
        , parsing_start_time = '15.708'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.129'
        , search_end_time = '0.094'
        , total_duration = '16.277'
        , error_description = ''
        , memory_used = '35532992'
        WHERE id = '189171452';
[09/30/2024 01:15:10], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020942.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020942.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020942.json', 'ratehawk', '2024-09-30 01:15:10', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020942.json');
[09/30/2024 01:15:10], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020949.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020949.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020949.json', 'ratehawk', '2024-09-30 01:15:10', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020949.json');
[09/30/2024 01:15:10], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020945.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020945.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020945.json', 'ratehawk', '2024-09-30 01:15:10', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020945.json');
[09/30/2024 01:15:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.972'
        , request_start_time = '0.390'
        , parsing_start_time = '16.152'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.346'
        , search_end_time = '0.117'
        , total_duration = '17.055'
        , error_description = ''
        , memory_used = '50895848'
        WHERE id = '189171458';
[09/30/2024 01:15:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '111'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.953'
        , request_start_time = '0.117'
        , parsing_start_time = '16.416'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.450'
        , search_end_time = '0.198'
        , total_duration = '17.243'
        , error_description = ''
        , memory_used = '77185128'
        WHERE id = '189171457';
[09/30/2024 01:15:11], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_14_54_17277020944.json', 'rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020944.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_14_54_17277020944.json', 'ratehawk', '2024-09-30 01:15:11', '', '12843020240913145251676845182', '16618253', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_14_54_17277020944.json');
[09/30/2024 01:15:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '139'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.962'
        , request_start_time = '0.158'
        , parsing_start_time = '16.527'
        , mapping_complete_time = '0.167'
        , mongo_start_time = '0.553'
        , search_end_time = '0.281'
        , total_duration = '17.595'
        , error_description = ''
        , memory_used = '139450984'
        WHERE id = '189171460';
[09/30/2024 01:15:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '131'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913145251676845182&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:14:53.963'
        , request_start_time = '0.198'
        , parsing_start_time = '17.203'
        , mapping_complete_time = '0.141'
        , mongo_start_time = '0.503'
        , search_end_time = '0.307'
        , total_duration = '18.282'
        , error_description = ''
        , memory_used = '128788688'
        WHERE id = '189171464';
[09/30/2024 01:15:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1039',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913145251676845182',
        duration = '19.983',
        merge_duration = '0.066',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.39',
        system_load_5_min = '7.03',
        system_load_15_min = '6.74',
        system_memory_usage = '29.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16618253') + '6042528',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16618253';
[09/30/2024 01:19:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/04' , departure_date = '2024/11/11' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:19:37' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:19:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913193781263728441', session_id='12843020240913193781263728441', Collection_create_time='2024-09-30 13:19:38';
[09/30/2024 01:19:42], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_172770237912.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237912.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_172770237912.json', 'ratehawk', '2024-09-30 01:19:42', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237912.json');
[09/30/2024 01:19:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.854'
        , request_start_time = '0.589'
        , parsing_start_time = '3.081'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.019'
        , search_end_time = '0.001'
        , total_duration = '3.717'
        , error_description = ''
        , memory_used = '2655768'
        WHERE id = '189173168';
[09/30/2024 01:19:46], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023794.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023794.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023794.json', 'ratehawk', '2024-09-30 01:19:46', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023794.json');
[09/30/2024 01:19:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '131'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.835'
        , request_start_time = '0.138'
        , parsing_start_time = '7.421'
        , mapping_complete_time = '0.150'
        , mongo_start_time = '0.513'
        , search_end_time = '0.390'
        , total_duration = '8.528'
        , error_description = ''
        , memory_used = '126443288'
        WHERE id = '189173169';
[09/30/2024 01:19:50], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_172770237911.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237911.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_172770237911.json', 'ratehawk', '2024-09-30 01:19:50', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237911.json');
[09/30/2024 01:19:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '49'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.853'
        , request_start_time = '0.580'
        , parsing_start_time = '10.993'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.102'
        , search_end_time = '0.066'
        , total_duration = '11.774'
        , error_description = ''
        , memory_used = '26756920'
        WHERE id = '189173170';
[09/30/2024 01:19:54], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023797.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023797.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023797.json', 'ratehawk', '2024-09-30 01:19:54', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023797.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_38_17277023780.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023780.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_38_17277023780.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023780.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_172770237910.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237910.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_172770237910.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_172770237910.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023799.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023799.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023799.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023799.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023795.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023795.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023795.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023795.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023798.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023798.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023798.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023798.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_38_17277023781.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023781.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_38_17277023781.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023781.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_38_17277023783.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023783.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_38_17277023783.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_38_17277023783.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023792.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023792.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023792.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023792.json');
[09/30/2024 01:19:55], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_19_39_17277023796.json', 'rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023796.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_19_39_17277023796.json', 'ratehawk', '2024-09-30 01:19:55', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_19_39_17277023796.json');
[09/30/2024 01:19:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '57'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.829'
        , request_start_time = '0.094'
        , parsing_start_time = '16.105'
        , mapping_complete_time = '0.178'
        , mongo_start_time = '0.824'
        , search_end_time = '0.294'
        , total_duration = '17.372'
        , error_description = ''
        , memory_used = '51652008'
        WHERE id = '189173251';
[09/30/2024 01:19:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.845'
        , request_start_time = '0.275'
        , parsing_start_time = '15.799'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.524'
        , search_end_time = '1.202'
        , total_duration = '17.879'
        , error_description = ''
        , memory_used = '54210976'
        WHERE id = '189173239';
[09/30/2024 01:19:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '54'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.852'
        , request_start_time = '0.473'
        , parsing_start_time = '15.676'
        , mapping_complete_time = '0.204'
        , mongo_start_time = '0.746'
        , search_end_time = '1.073'
        , total_duration = '18.056'
        , error_description = ''
        , memory_used = '34959840'
        WHERE id = '189173264';
[09/30/2024 01:19:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.845'
        , request_start_time = '0.328'
        , parsing_start_time = '15.940'
        , mapping_complete_time = '0.144'
        , mongo_start_time = '0.909'
        , search_end_time = '1.003'
        , total_duration = '18.248'
        , error_description = ''
        , memory_used = '50234408'
        WHERE id = '189173270';
[09/30/2024 01:19:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '60'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.853'
        , request_start_time = '0.324'
        , parsing_start_time = '16.008'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.448'
        , search_end_time = '1.617'
        , total_duration = '18.452'
        , error_description = ''
        , memory_used = '35091544'
        WHERE id = '189173292';
[09/30/2024 01:19:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '92'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.828'
        , request_start_time = '0.141'
        , parsing_start_time = '16.331'
        , mapping_complete_time = '0.335'
        , mongo_start_time = '0.781'
        , search_end_time = '1.758'
        , total_duration = '19.069'
        , error_description = ''
        , memory_used = '66482000'
        WHERE id = '189173307';
[09/30/2024 01:19:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '117'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.832'
        , request_start_time = '0.136'
        , parsing_start_time = '16.380'
        , mapping_complete_time = '0.350'
        , mongo_start_time = '1.491'
        , search_end_time = '1.425'
        , total_duration = '19.526'
        , error_description = ''
        , memory_used = '107907632'
        WHERE id = '189173311';
[09/30/2024 01:19:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '111'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.830'
        , request_start_time = '0.143'
        , parsing_start_time = '16.513'
        , mapping_complete_time = '0.307'
        , mongo_start_time = '0.960'
        , search_end_time = '2.101'
        , total_duration = '19.781'
        , error_description = ''
        , memory_used = '76373736'
        WHERE id = '189173315';
[09/30/2024 01:19:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.837'
        , request_start_time = '0.194'
        , parsing_start_time = '16.609'
        , mapping_complete_time = '0.490'
        , mongo_start_time = '1.106'
        , search_end_time = '1.917'
        , total_duration = '19.893'
        , error_description = ''
        , memory_used = '86099400'
        WHERE id = '189173322';
[09/30/2024 01:19:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '139'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913193781263728441&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:19:38.838'
        , request_start_time = '0.132'
        , parsing_start_time = '16.222'
        , mapping_complete_time = '0.324'
        , mongo_start_time = '1.073'
        , search_end_time = '2.648'
        , total_duration = '20.159'
        , error_description = ''
        , memory_used = '138447752'
        WHERE id = '189173284';
[09/30/2024 01:20:00], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1039',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913193781263728441',
        duration = '22.638',
        merge_duration = '0.109',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.62',
        system_load_5_min = '4.02',
        system_load_15_min = '5.61',
        system_memory_usage = '30.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16618472') + '5950640',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16618472';
[09/30/2024 01:23:56], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_23_52_1727702632.json', 'rh/30_09_2024/response_availability_qtech_agent_13_23_52_1727702632.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_23_52_1727702632.json', 'ratehawk', '2024-09-30 01:23:56', '', '12843020240913193781263728441', '16618472', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_23_52_1727702632.json');
[09/30/2024 01:24:08], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727702648','43.239.53.130');
[09/30/2024 01:25:44], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/04' , departure_date = '2024/11/11' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:25:44' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:25:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913254448510492458', session_id='12843020240913254448510492458', Collection_create_time='2024-09-30 13:25:44';
[09/30/2024 01:25:52], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_172770274512.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274512.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_172770274512.json', 'ratehawk', '2024-09-30 01:25:52', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274512.json');
[09/30/2024 01:25:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.366'
        , request_start_time = '0.564'
        , parsing_start_time = '6.495'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.022'
        , search_end_time = '0.001'
        , total_duration = '7.146'
        , error_description = ''
        , memory_used = '2655768'
        WHERE id = '189175286';
[09/30/2024 01:25:53], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027450.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027450.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027450.json', 'ratehawk', '2024-09-30 01:25:53', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027450.json');
[09/30/2024 01:25:53], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027457.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027457.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027457.json', 'ratehawk', '2024-09-30 01:25:53', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027457.json');
[09/30/2024 01:25:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '58'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.329'
        , request_start_time = '0.092'
        , parsing_start_time = '8.218'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.182'
        , search_end_time = '0.122'
        , total_duration = '8.653'
        , error_description = ''
        , memory_used = '51369176'
        WHERE id = '189175294';
[09/30/2024 01:25:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.353'
        , request_start_time = '0.252'
        , parsing_start_time = '8.058'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.206'
        , search_end_time = '0.121'
        , total_duration = '8.680'
        , error_description = ''
        , memory_used = '55522752'
        WHERE id = '189175295';
[09/30/2024 01:25:54], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027452.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027452.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027452.json', 'ratehawk', '2024-09-30 01:25:54', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027452.json');
[09/30/2024 01:25:54], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027451.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027451.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027451.json', 'ratehawk', '2024-09-30 01:25:54', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027451.json');
[09/30/2024 01:25:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '92'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.331'
        , request_start_time = '0.105'
        , parsing_start_time = '8.769'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.279'
        , search_end_time = '0.157'
        , total_duration = '9.355'
        , error_description = ''
        , memory_used = '69668952'
        WHERE id = '189175297';
[09/30/2024 01:25:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.334'
        , request_start_time = '0.105'
        , parsing_start_time = '8.733'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.314'
        , search_end_time = '0.178'
        , total_duration = '9.383'
        , error_description = ''
        , memory_used = '78660776'
        WHERE id = '189175296';
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_172770274510.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274510.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_172770274510.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274510.json');
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_172770274511.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274511.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_172770274511.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_172770274511.json');
[09/30/2024 01:25:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.363'
        , request_start_time = '0.580'
        , parsing_start_time = '11.448'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.107'
        , search_end_time = '0.067'
        , total_duration = '12.233'
        , error_description = ''
        , memory_used = '26076976'
        WHERE id = '189175300';
[09/30/2024 01:25:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '54'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.361'
        , request_start_time = '0.473'
        , parsing_start_time = '11.475'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.130'
        , search_end_time = '0.166'
        , total_duration = '12.277'
        , error_description = ''
        , memory_used = '34447576'
        WHERE id = '189175299';
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027458.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027458.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027458.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027458.json');
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027459.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027459.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027459.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027459.json');
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027456.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027456.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027456.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027456.json');
[09/30/2024 01:25:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '61'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.356'
        , request_start_time = '0.318'
        , parsing_start_time = '12.027'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.141'
        , search_end_time = '0.086'
        , total_duration = '12.609'
        , error_description = ''
        , memory_used = '35134048'
        WHERE id = '189175301';
[09/30/2024 01:25:57], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027454.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027454.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027454.json', 'ratehawk', '2024-09-30 01:25:57', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027454.json');
[09/30/2024 01:25:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '67'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.359'
        , request_start_time = '0.387'
        , parsing_start_time = '12.052'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.251'
        , search_end_time = '0.108'
        , total_duration = '12.842'
        , error_description = ''
        , memory_used = '52750720'
        WHERE id = '189175302';
[09/30/2024 01:25:58], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027453.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027453.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027453.json', 'ratehawk', '2024-09-30 01:25:58', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027453.json');
[09/30/2024 01:25:58], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_25_45_17277027455.json', 'rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027455.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_25_45_17277027455.json', 'ratehawk', '2024-09-30 01:25:58', '', '12843020240913254448510492458', '16618620', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_25_45_17277027455.json');
[09/30/2024 01:25:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.347'
        , request_start_time = '0.198'
        , parsing_start_time = '12.357'
        , mapping_complete_time = '0.170'
        , mongo_start_time = '0.407'
        , search_end_time = '0.176'
        , total_duration = '13.204'
        , error_description = ''
        , memory_used = '88142888'
        WHERE id = '189175303';
[09/30/2024 01:25:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '132'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.340'
        , request_start_time = '0.119'
        , parsing_start_time = '12.493'
        , mapping_complete_time = '0.163'
        , mongo_start_time = '0.548'
        , search_end_time = '0.302'
        , total_duration = '13.528'
        , error_description = ''
        , memory_used = '133295888'
        WHERE id = '189175304';
[09/30/2024 01:25:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '119'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.339'
        , request_start_time = '0.123'
        , parsing_start_time = '12.805'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.435'
        , search_end_time = '0.373'
        , total_duration = '13.799'
        , error_description = ''
        , memory_used = '108806824'
        WHERE id = '189175305';
[09/30/2024 01:25:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '141'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913254448510492458&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:25:45.345'
        , request_start_time = '0.143'
        , parsing_start_time = '12.876'
        , mapping_complete_time = '0.172'
        , mongo_start_time = '0.564'
        , search_end_time = '0.329'
        , total_duration = '13.977'
        , error_description = ''
        , memory_used = '139214840'
        WHERE id = '189175306';
[09/30/2024 01:26:00], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1049',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913254448510492458',
        duration = '16.174',
        merge_duration = '0.078',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.22',
        system_load_5_min = '4.00',
        system_load_15_min = '4.95',
        system_memory_usage = '31.04',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16618620') + '5565544',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16618620';
[09/30/2024 01:26:20], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/12/18' , departure_date = '2024/12/25' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:26:20' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:26:21], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913262062353442380', session_id='12843020240913262062353442380', Collection_create_time='2024-09-30 13:26:21';
[09/30/2024 01:26:31], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_172770278212.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278212.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_172770278212.json', 'ratehawk', '2024-09-30 01:26:31', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278212.json');
[09/30/2024 01:26:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.120'
        , request_start_time = '0.592'
        , parsing_start_time = '8.651'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.024'
        , search_end_time = '0.033'
        , total_duration = '9.325'
        , error_description = ''
        , memory_used = '2720528'
        WHERE id = '189175582';
[09/30/2024 01:26:32], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_172770278211.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278211.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_172770278211.json', 'ratehawk', '2024-09-30 01:26:32', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278211.json');
[09/30/2024 01:26:32], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.118'
        , request_start_time = '0.580'
        , parsing_start_time = '9.505'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.132'
        , search_end_time = '0.079'
        , total_duration = '10.332'
        , error_description = ''
        , memory_used = '35525640'
        WHERE id = '189175587';
[09/30/2024 01:26:33], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027820.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027820.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027820.json', 'ratehawk', '2024-09-30 01:26:33', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027820.json');
[09/30/2024 01:26:33], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027821.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027821.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027821.json', 'ratehawk', '2024-09-30 01:26:33', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027821.json');
[09/30/2024 01:26:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '64'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.92'
        , request_start_time = '0.094'
        , parsing_start_time = '11.047'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.232'
        , search_end_time = '0.152'
        , total_duration = '11.573'
        , error_description = ''
        , memory_used = '67453808'
        WHERE id = '189175590';
[09/30/2024 01:26:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '96'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.95'
        , request_start_time = '0.098'
        , parsing_start_time = '11.072'
        , mapping_complete_time = '0.094'
        , mongo_start_time = '0.311'
        , search_end_time = '0.165'
        , total_duration = '11.698'
        , error_description = ''
        , memory_used = '78782616'
        WHERE id = '189175591';
[09/30/2024 01:26:34], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027828.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027828.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027828.json', 'ratehawk', '2024-09-30 01:26:34', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027828.json');
[09/30/2024 01:26:34], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027829.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027829.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027829.json', 'ratehawk', '2024-09-30 01:26:34', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027829.json');
[09/30/2024 01:26:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.112'
        , request_start_time = '0.293'
        , parsing_start_time = '12.377'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.176'
        , search_end_time = '0.101'
        , total_duration = '12.990'
        , error_description = ''
        , memory_used = '46210200'
        WHERE id = '189175593';
[09/30/2024 01:26:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '71'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.114'
        , request_start_time = '0.326'
        , parsing_start_time = '12.367'
        , mapping_complete_time = '0.076'
        , mongo_start_time = '0.221'
        , search_end_time = '0.131'
        , total_duration = '13.088'
        , error_description = ''
        , memory_used = '61557360'
        WHERE id = '189175594';
[09/30/2024 01:26:35], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027825.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027825.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027825.json', 'ratehawk', '2024-09-30 01:26:35', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027825.json');
[09/30/2024 01:26:35], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027822.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027822.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027822.json', 'ratehawk', '2024-09-30 01:26:35', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027822.json');
[09/30/2024 01:26:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '117'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.96'
        , request_start_time = '0.147'
        , parsing_start_time = '13.317'
        , mapping_complete_time = '0.122'
        , mongo_start_time = '0.388'
        , search_end_time = '0.252'
        , total_duration = '14.170'
        , error_description = ''
        , memory_used = '101177216'
        WHERE id = '189175596';
[09/30/2024 01:26:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '153'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.108'
        , request_start_time = '0.194'
        , parsing_start_time = '13.051'
        , mapping_complete_time = '0.203'
        , mongo_start_time = '0.633'
        , search_end_time = '0.344'
        , total_duration = '14.297'
        , error_description = ''
        , memory_used = '169071992'
        WHERE id = '189175595';
[09/30/2024 01:26:38], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_172770278210.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278210.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_172770278210.json', 'ratehawk', '2024-09-30 01:26:38', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_172770278210.json');
[09/30/2024 01:26:38], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027827.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027827.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027827.json', 'ratehawk', '2024-09-30 01:26:38', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027827.json');
[09/30/2024 01:26:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '59'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.117'
        , request_start_time = '0.465'
        , parsing_start_time = '15.886'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.152'
        , search_end_time = '0.092'
        , total_duration = '16.632'
        , error_description = ''
        , memory_used = '41093624'
        WHERE id = '189175599';
[09/30/2024 01:26:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.113'
        , request_start_time = '0.254'
        , parsing_start_time = '16.256'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.265'
        , search_end_time = '0.221'
        , total_duration = '17.044'
        , error_description = ''
        , memory_used = '69023208'
        WHERE id = '189175600';
[09/30/2024 01:26:39], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027826.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027826.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027826.json', 'ratehawk', '2024-09-30 01:26:39', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027826.json');
[09/30/2024 01:26:39], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027824.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027824.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027824.json', 'ratehawk', '2024-09-30 01:26:39', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027824.json');
[09/30/2024 01:26:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '123'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.108'
        , request_start_time = '0.198'
        , parsing_start_time = '16.823'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.408'
        , search_end_time = '0.245'
        , total_duration = '17.735'
        , error_description = ''
        , memory_used = '108194672'
        WHERE id = '189175601';
[09/30/2024 01:26:39], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_22_17277027823.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027823.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_22_17277027823.json', 'ratehawk', '2024-09-30 01:26:39', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_22_17277027823.json');
[09/30/2024 01:26:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '145'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.101'
        , request_start_time = '0.143'
        , parsing_start_time = '17.383'
        , mapping_complete_time = '0.191'
        , mongo_start_time = '0.605'
        , search_end_time = '0.331'
        , total_duration = '18.537'
        , error_description = ''
        , memory_used = '161582384'
        WHERE id = '189175602';
[09/30/2024 01:26:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '131'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913262062353442380&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:26:22.99'
        , request_start_time = '0.152'
        , parsing_start_time = '17.559'
        , mapping_complete_time = '0.165'
        , mongo_start_time = '0.587'
        , search_end_time = '0.312'
        , total_duration = '18.681'
        , error_description = ''
        , memory_used = '133052968'
        WHERE id = '189175603';
[09/30/2024 01:26:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1133',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913262062353442380',
        duration = '21.093',
        merge_duration = '0.073',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.27',
        system_load_5_min = '3.64',
        system_load_15_min = '4.79',
        system_memory_usage = '30.96',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16618635') + '6132032',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16618635';
[09/30/2024 01:26:56], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_26_53_1727702813.json', 'rh/30_09_2024/response_availability_qtech_agent_13_26_53_1727702813.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_26_53_1727702813.json', 'ratehawk', '2024-09-30 01:26:56', '', '12843020240913262062353442380', '16618635', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_26_53_1727702813.json');
[09/30/2024 01:28:19], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727702899','43.239.53.130');
[09/30/2024 01:28:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727702914','43.239.53.130');
[09/30/2024 01:30:30], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727703030','43.239.53.130');
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'ratehawk', reservation_id = '2050765', create_date = '2024-09-30 13:30:33', agent_id = '1284', parent_agent_id = '1284', agent_ref_no = '', nationality = 'Saudi', city_id = 'paris', country_id = '58', current_status = 'inprocess-booking', booking_branch_id = '26', is_xml = '0', display_room_rate = '35118.72', display_currency_code = 'INR', native_room_rate = '420', native_currency_code = 'USD', supplier_profile_id = '47', service_type = 'hotel', service_date = '2024/12/18', check_out_date = '2024/12/25', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'shiv', leader_last_name = 'chauhan', status_date = '2024-09-30 13:30:33';
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('142504','KYRIAD PARIS EST - BOIS DE VINCENNES','KYRIAD PARIS EST - Bois de Vincennes','kyriad_paris_est_bois_de_vincennes','OT000104999','paris','ratehawk',NOW());
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '26'
		WHERE
		id='142504'
		;
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('142504','2050765','','1','1','0','-','','','kyriad_paris_est_bois_de_vincennes','KYRIAD PARIS EST - Bois de Vincennes','12 rue du Mar&eacute;chal Leclerc 94410 Saint Maurice','+33143759494','3.0','7','2024/12/18','2024/12/25','','https://betalive.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9jZG4ud29ybGRvdGEubmV0L3QvMTAyNHg3NjgvY29udGVudC9hMS9jNS9hMWM1ZTNiNDg1NWIyYzQxZTY1NmNkNmIxY2UyNDM4NTBmNWQ0MTQ4LmpwZWc=');
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '142504', booking_detail_id = '1', room_type_code = 'm-be4aeafd-cc36-58e7-a553-0f6d409fc60b', room_name = 'single', room_type_description = 'Superior Double room (full double bed) (Room Only)', display_nightly_rates = 'a:7:{i:0;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:1;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:2;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:3;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:4;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:5;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:6;a:2:{s:18:"displayNightlyRate";d:5016.96;s:25:"displayNightlyRateDisplay";s:158:"Rate - 60, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}}', native_nightly_rates = 'a:7:{i:0;a:1:{s:17:"nativeNightlyRate";i:60;}i:1;a:1:{s:17:"nativeNightlyRate";i:60;}i:2;a:1:{s:17:"nativeNightlyRate";i:60;}i:3;a:1:{s:17:"nativeNightlyRate";i:60;}i:4;a:1:{s:17:"nativeNightlyRate";i:60;}i:5;a:1:{s:17:"nativeNightlyRate";i:60;}i:6;a:1:{s:17:"nativeNightlyRate";i:60;}}', native_room_rate_total = '420', display_room_rate_total = '35118.72', number_of_rooms = '1', room_category = 'Superior Double room (full double bed)', meal_basis = 'Room Only';
[09/30/2024 01:30:33], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '142504', booking_detail_id = '1', rid = '156598', room = '0', salutations = 'Mr', first_name = 'shiv', last_name = 'chauhan', passenger_type = 'adult', age = '';
[09/30/2024 01:36:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/01' , departure_date = '2024/11/08' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:36:25' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:36:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913362554392873546', session_id='12843020240913362554392873546', Collection_create_time='2024-09-30 13:36:26';
[09/30/2024 01:36:33], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_172770338712.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338712.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_172770338712.json', 'ratehawk', '2024-09-30 01:36:33', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338712.json');
[09/30/2024 01:36:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.999'
        , request_start_time = '0.589'
        , parsing_start_time = '6.078'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.022'
        , search_end_time = '0.001'
        , total_duration = '6.719'
        , error_description = ''
        , memory_used = '2655768'
        WHERE id = '189178897';
[09/30/2024 01:36:34], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033870.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033870.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033870.json', 'ratehawk', '2024-09-30 01:36:34', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033870.json');
[09/30/2024 01:36:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '57'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.971'
        , request_start_time = '0.097'
        , parsing_start_time = '7.175'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.185'
        , search_end_time = '0.132'
        , total_duration = '7.648'
        , error_description = ''
        , memory_used = '50592160'
        WHERE id = '189178902';
[09/30/2024 01:36:34], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033871.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033871.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033871.json', 'ratehawk', '2024-09-30 01:36:34', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033871.json');
[09/30/2024 01:36:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.970'
        , request_start_time = '0.112'
        , parsing_start_time = '7.640'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.274'
        , search_end_time = '0.153'
        , total_duration = '8.244'
        , error_description = ''
        , memory_used = '67338312'
        WHERE id = '189178909';
[09/30/2024 01:36:40], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033875.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033875.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033875.json', 'ratehawk', '2024-09-30 01:36:40', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033875.json');
[09/30/2024 01:36:41], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033879.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033879.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033879.json', 'ratehawk', '2024-09-30 01:36:41', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033879.json');
[09/30/2024 01:36:43], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_172770338711.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338711.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_172770338711.json', 'ratehawk', '2024-09-30 01:36:43', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338711.json');
[09/30/2024 01:36:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '139'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.980'
        , request_start_time = '0.162'
        , parsing_start_time = '13.100'
        , mapping_complete_time = '0.361'
        , mongo_start_time = '1.611'
        , search_end_time = '1.332'
        , total_duration = '16.293'
        , error_description = ''
        , memory_used = '136892592'
        WHERE id = '189178949';
[09/30/2024 01:36:43], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033877.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033877.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033877.json', 'ratehawk', '2024-09-30 01:36:43', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033877.json');
[09/30/2024 01:36:43], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_172770338710.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338710.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_172770338710.json', 'ratehawk', '2024-09-30 01:36:43', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_172770338710.json');
[09/30/2024 01:36:43], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033878.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033878.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033878.json', 'ratehawk', '2024-09-30 01:36:43', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033878.json');
[09/30/2024 01:36:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.996'
        , request_start_time = '0.398'
        , parsing_start_time = '14.334'
        , mapping_complete_time = '0.190'
        , mongo_start_time = '0.499'
        , search_end_time = '1.488'
        , total_duration = '16.779'
        , error_description = ''
        , memory_used = '53335824'
        WHERE id = '189178965';
[09/30/2024 01:36:43], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033872.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033872.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033872.json', 'ratehawk', '2024-09-30 01:36:43', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033872.json');
[09/30/2024 01:36:44], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033873.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033873.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033873.json', 'ratehawk', '2024-09-30 01:36:44', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033873.json');
[09/30/2024 01:36:44], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033876.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033876.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033876.json', 'ratehawk', '2024-09-30 01:36:44', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033876.json');
[09/30/2024 01:36:44], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_36_27_17277033874.json', 'rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033874.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_36_27_17277033874.json', 'ratehawk', '2024-09-30 01:36:44', '', '12843020240913362554392873546', '16618913', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_36_27_17277033874.json');
[09/30/2024 01:36:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.999'
        , request_start_time = '0.467'
        , parsing_start_time = '15.905'
        , mapping_complete_time = '0.196'
        , mongo_start_time = '0.460'
        , search_end_time = '0.780'
        , total_duration = '17.663'
        , error_description = ''
        , memory_used = '31526216'
        WHERE id = '189178998';
[09/30/2024 01:36:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.989'
        , request_start_time = '0.320'
        , parsing_start_time = '16.349'
        , mapping_complete_time = '0.197'
        , mongo_start_time = '0.555'
        , search_end_time = '0.421'
        , total_duration = '17.695'
        , error_description = ''
        , memory_used = '30716232'
        WHERE id = '189179001';
[09/30/2024 01:36:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.998'
        , request_start_time = '0.562'
        , parsing_start_time = '15.476'
        , mapping_complete_time = '0.173'
        , mongo_start_time = '0.532'
        , search_end_time = '1.175'
        , total_duration = '17.796'
        , error_description = ''
        , memory_used = '27592312'
        WHERE id = '189178992';
[09/30/2024 01:36:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '73'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.985'
        , request_start_time = '0.278'
        , parsing_start_time = '16.055'
        , mapping_complete_time = '0.279'
        , mongo_start_time = '0.647'
        , search_end_time = '1.288'
        , total_duration = '18.339'
        , error_description = ''
        , memory_used = '53564888'
        WHERE id = '189178997';
[09/30/2024 01:36:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '113'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.975'
        , request_start_time = '0.153'
        , parsing_start_time = '16.943'
        , mapping_complete_time = '0.545'
        , mongo_start_time = '1.163'
        , search_end_time = '1.262'
        , total_duration = '19.614'
        , error_description = ''
        , memory_used = '111759816'
        WHERE id = '189179008';
[09/30/2024 01:36:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '108'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.972'
        , request_start_time = '0.134'
        , parsing_start_time = '16.833'
        , mapping_complete_time = '0.367'
        , mongo_start_time = '0.781'
        , search_end_time = '1.870'
        , total_duration = '19.700'
        , error_description = ''
        , memory_used = '82649080'
        WHERE id = '189179006';
[09/30/2024 01:36:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '110'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.985'
        , request_start_time = '0.230'
        , parsing_start_time = '16.919'
        , mapping_complete_time = '0.313'
        , mongo_start_time = '0.835'
        , search_end_time = '1.957'
        , total_duration = '20.035'
        , error_description = ''
        , memory_used = '84691096'
        WHERE id = '189179009';
[09/30/2024 01:36:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '133'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913362554392873546&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:36:26.980'
        , request_start_time = '0.193'
        , parsing_start_time = '17.288'
        , mapping_complete_time = '0.658'
        , mongo_start_time = '1.276'
        , search_end_time = '2.951'
        , total_duration = '21.859'
        , error_description = ''
        , memory_used = '131526816'
        WHERE id = '189179012';
[09/30/2024 01:36:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1034',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913362554392873546',
        duration = '23.801',
        merge_duration = '0.065',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.70',
        system_load_5_min = '4.07',
        system_load_15_min = '4.62',
        system_memory_usage = '32.98',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16618913') + '6042432',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16618913';
[09/30/2024 01:45:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/11/01' , departure_date = '2024/11/08' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 13:45:09' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 01:45:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240913450910450754463', session_id='12843020240913450910450754463', Collection_create_time='2024-09-30 13:45:10';
[09/30/2024 01:45:15], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_172770391112.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391112.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_172770391112.json', 'ratehawk', '2024-09-30 01:45:15', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391112.json');
[09/30/2024 01:45:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.200'
        , request_start_time = '0.557'
        , parsing_start_time = '3.769'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.024'
        , search_end_time = '0.001'
        , total_duration = '4.434'
        , error_description = ''
        , memory_used = '2655768'
        WHERE id = '189181814';
[09/30/2024 01:45:20], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039114.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039114.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039114.json', 'ratehawk', '2024-09-30 01:45:20', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039114.json');
[09/30/2024 01:45:21], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_172770391110.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391110.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_172770391110.json', 'ratehawk', '2024-09-30 01:45:21', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391110.json');
[09/30/2024 01:45:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '134'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.173'
        , request_start_time = '0.127'
        , parsing_start_time = '9.078'
        , mapping_complete_time = '0.156'
        , mongo_start_time = '0.518'
        , search_end_time = '0.295'
        , total_duration = '10.087'
        , error_description = ''
        , memory_used = '127402552'
        WHERE id = '189181815';
[09/30/2024 01:45:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.193'
        , request_start_time = '0.425'
        , parsing_start_time = '9.402'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.124'
        , search_end_time = '0.073'
        , total_duration = '10.118'
        , error_description = ''
        , memory_used = '31670048'
        WHERE id = '189181816';
[09/30/2024 01:45:21], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039117.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039117.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039117.json', 'ratehawk', '2024-09-30 01:45:21', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039117.json');
[09/30/2024 01:45:21], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039119.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039119.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039119.json', 'ratehawk', '2024-09-30 01:45:21', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039119.json');
[09/30/2024 01:45:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '74'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.183'
        , request_start_time = '0.231'
        , parsing_start_time = '9.894'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.206'
        , search_end_time = '0.121'
        , total_duration = '10.497'
        , error_description = ''
        , memory_used = '53358136'
        WHERE id = '189181817';
[09/30/2024 01:45:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.192'
        , request_start_time = '0.373'
        , parsing_start_time = '9.864'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.194'
        , search_end_time = '0.113'
        , total_duration = '10.614'
        , error_description = ''
        , memory_used = '51780168'
        WHERE id = '189181818';
[09/30/2024 01:45:21], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039110.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039110.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039110.json', 'ratehawk', '2024-09-30 01:45:21', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039110.json');
[09/30/2024 01:45:21], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039115.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039115.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039115.json', 'ratehawk', '2024-09-30 01:45:21', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039115.json');
[09/30/2024 01:45:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '57'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.164'
        , request_start_time = '0.075'
        , parsing_start_time = '10.609'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.187'
        , search_end_time = '0.107'
        , total_duration = '11.023'
        , error_description = ''
        , memory_used = '51450256'
        WHERE id = '189181819';
[09/30/2024 01:45:22], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_172770391111.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391111.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_172770391111.json', 'ratehawk', '2024-09-30 01:45:22', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_172770391111.json');
[09/30/2024 01:45:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.194'
        , request_start_time = '0.557'
        , parsing_start_time = '10.532'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.108'
        , search_end_time = '0.167'
        , total_duration = '11.457'
        , error_description = ''
        , memory_used = '27941640'
        WHERE id = '189181821';
[09/30/2024 01:45:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '140'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.177'
        , request_start_time = '0.173'
        , parsing_start_time = '10.584'
        , mapping_complete_time = '0.167'
        , mongo_start_time = '0.541'
        , search_end_time = '0.358'
        , total_duration = '11.722'
        , error_description = ''
        , memory_used = '135137936'
        WHERE id = '189181820';
[09/30/2024 01:45:23], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039111.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039111.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039111.json', 'ratehawk', '2024-09-30 01:45:23', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039111.json');
[09/30/2024 01:45:23], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039112.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039112.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039112.json', 'ratehawk', '2024-09-30 01:45:23', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039112.json');
[09/30/2024 01:45:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.165'
        , request_start_time = '0.120'
        , parsing_start_time = '11.786'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.274'
        , search_end_time = '0.141'
        , total_duration = '12.369'
        , error_description = ''
        , memory_used = '66777320'
        WHERE id = '189181822';
[09/30/2024 01:45:23], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039118.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039118.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039118.json', 'ratehawk', '2024-09-30 01:45:23', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039118.json');
[09/30/2024 01:45:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '110'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.168'
        , request_start_time = '0.154'
        , parsing_start_time = '12.002'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.322'
        , search_end_time = '0.165'
        , total_duration = '12.693'
        , error_description = ''
        , memory_used = '82609480'
        WHERE id = '189181823';
[09/30/2024 01:45:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.189'
        , request_start_time = '0.258'
        , parsing_start_time = '12.306'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.132'
        , search_end_time = '0.086'
        , total_duration = '12.817'
        , error_description = ''
        , memory_used = '31061248'
        WHERE id = '189181824';
[09/30/2024 01:45:24], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039113.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039113.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039113.json', 'ratehawk', '2024-09-30 01:45:24', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039113.json');
[09/30/2024 01:45:24], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_45_11_17277039116.json', 'rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039116.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_45_11_17277039116.json', 'ratehawk', '2024-09-30 01:45:24', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_45_11_17277039116.json');
[09/30/2024 01:45:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '111'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.181'
        , request_start_time = '0.161'
        , parsing_start_time = '12.971'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.332'
        , search_end_time = '0.170'
        , total_duration = '13.685'
        , error_description = ''
        , memory_used = '85541768'
        WHERE id = '189181826';
[09/30/2024 01:45:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '113'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240913450910450754463&destination_code=2734&city_name=Paris&country_code=FR&country_name=France&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 13:45:11.171'
        , request_start_time = '0.136'
        , parsing_start_time = '12.867'
        , mapping_complete_time = '0.142'
        , mongo_start_time = '0.426'
        , search_end_time = '0.261'
        , total_duration = '13.747'
        , error_description = ''
        , memory_used = '112995168'
        WHERE id = '189181825';
[09/30/2024 01:45:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1041',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240913450910450754463',
        duration = '16.054',
        merge_duration = '0.060',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.93',
        system_load_5_min = '2.12',
        system_load_15_min = '3.30',
        system_memory_usage = '33.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16619223') + '5648288',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16619223';
[09/30/2024 01:49:17], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_13_49_13_1727704153.json', 'rh/30_09_2024/response_availability_qtech_agent_13_49_13_1727704153.json', 'rh/30_09_2024/response_header_availability_qtech_agent_13_49_13_1727704153.json', 'ratehawk', '2024-09-30 01:49:17', '', '12843020240913450910450754463', '16619223', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_13_49_13_1727704153.json');
[09/30/2024 01:49:48], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727704188','43.239.53.130');
