[09/23/2024 06:02:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727071358','43.239.53.130');
[09/23/2024 06:08:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727071680','43.239.53.130');
[09/23/2024 06:09:44], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727071784','43.239.53.130');
[09/23/2024 06:15:32], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727072132','43.239.53.130');
[09/23/2024 06:18:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727072339','43.239.53.130');
[09/23/2024 06:21:01], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727072461','43.239.53.130');
[09/23/2024 06:30:45], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727073045','43.239.53.130');
[09/23/2024 06:35:48], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727073348','43.239.53.130');
[09/23/2024 06:43:42], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727073822','43.239.53.130');
[09/23/2024 06:43:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-23 06:43:50',login_attempt=0 where id = '2406';
[09/23/2024 06:43:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-09-23 06:43:50', ip = '43.239.53.130', action = 'Login' ;
[09/23/2024 06:44:13], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'madrid' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/11/27' , departure_date = '2024/11/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 06:44:13' , site_id = '' , country_code = '90' , city_code = '60279' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/23/2024 06:44:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240906441383762534243', session_id='24062320240906441383762534243', Collection_create_time='2024-09-23 06:44:13';
[09/23/2024 06:44: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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738546.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738546.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738546.json', 'ratehawk', '2024-09-23 06:44:23', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738546.json');
[09/23/2024 06:44:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '45'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.383'
        , request_start_time = '0.521'
        , parsing_start_time = '8.090'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.123'
        , search_end_time = '0.083'
        , total_duration = '8.847'
        , error_description = ''
        , memory_used = '30124040'
        WHERE id = '187080109';
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738547.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738547.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738547.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738547.json');
[09/23/2024 06:44:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.386'
        , request_start_time = '0.524'
        , parsing_start_time = '10.604'
        , mapping_complete_time = '0.009'
        , mongo_start_time = '0.045'
        , search_end_time = '0.001'
        , total_duration = '11.198'
        , error_description = ''
        , memory_used = '1570848'
        WHERE id = '187080110';
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738545.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738545.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738545.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738545.json');
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738542.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738542.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738542.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738542.json');
[09/23/2024 06:44:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.379'
        , request_start_time = '0.383'
        , parsing_start_time = '10.804'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.070'
        , search_end_time = '0.052'
        , total_duration = '11.334'
        , error_description = ''
        , memory_used = '12124968'
        WHERE id = '187080111';
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738540.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738540.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738540.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738540.json');
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738544.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738544.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738544.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738544.json');
[09/23/2024 06:44:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '58'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.373'
        , request_start_time = '0.152'
        , parsing_start_time = '11.060'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.163'
        , search_end_time = '0.102'
        , total_duration = '11.512'
        , error_description = ''
        , memory_used = '48463776'
        WHERE id = '187080112';
[09/23/2024 06:44:25], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738543.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738543.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738543.json', 'ratehawk', '2024-09-23 06:44:25', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738543.json');
[09/23/2024 06:44:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.371'
        , request_start_time = '0.102'
        , parsing_start_time = '11.219'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.135'
        , search_end_time = '0.069'
        , total_duration = '11.560'
        , error_description = ''
        , memory_used = '34155584'
        WHERE id = '187080113';
[09/23/2024 06:44:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '46'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.377'
        , request_start_time = '0.321'
        , parsing_start_time = '11.099'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.130'
        , search_end_time = '0.058'
        , total_duration = '11.638'
        , error_description = ''
        , memory_used = '34581056'
        WHERE id = '187080114';
[09/23/2024 06:44:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.375'
        , request_start_time = '0.215'
        , parsing_start_time = '11.307'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.114'
        , search_end_time = '0.053'
        , total_duration = '11.718'
        , error_description = ''
        , memory_used = '27729064'
        WHERE id = '187080115';
[09/23/2024 06:44:26], [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/23_09_2024/request_availability_Qtech_pranali_06_44_14_17270738541.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738541.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_14_17270738541.json', 'ratehawk', '2024-09-23 06:44:26', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_14_17270738541.json');
[09/23/2024 06:44:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '158'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240906441383762534243&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 06:44:14.371'
        , request_start_time = '0.111'
        , parsing_start_time = '11.834'
        , mapping_complete_time = '0.240'
        , mongo_start_time = '0.581'
        , search_end_time = '0.317'
        , total_duration = '12.904'
        , error_description = ''
        , memory_used = '167447168'
        WHERE id = '187080116';
[09/23/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '424',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240906441383762534243',
        duration = '14.813',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.28',
        system_load_5_min = '1.51',
        system_load_15_min = '1.63',
        system_memory_usage = '44.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16463574') + '3729016',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16463574';
[09/23/2024 06:44:34], [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/23_09_2024/request_availability_Qtech_pranali_06_44_32_1727073872.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_44_32_1727073872.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_44_32_1727073872.json', 'ratehawk', '2024-09-23 06:44:34', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_44_32_1727073872.json');
[09/23/2024 06:44:40], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727073880','43.239.53.130');
[09/23/2024 06:48:34], [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/23_09_2024/request_availability_Qtech_pranali_06_48_33_1727074113.json', 'rh/23_09_2024/response_availability_Qtech_pranali_06_48_33_1727074113.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_06_48_33_1727074113.json', 'ratehawk', '2024-09-23 06:48:34', '', '24062320240906441383762534243', '16463574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_06_48_33_1727074113.json');
[09/23/2024 06:48:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727074117','43.239.53.130');
[09/23/2024 06:48:56], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727074136','43.239.53.130');
