[09/23/2024 07:01:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727074884','43.239.53.130');
[09/23/2024 07:06:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727075198','43.239.53.130');
[09/23/2024 07:08:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727075337','43.239.53.130');
[09/23/2024 07:14:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-23 07:14:30',login_attempt=0 where id = '2406';
[09/23/2024 07:14:30], [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 07:14:30', ip = '43.239.53.130', action = 'Login' ;
[09/23/2024 07:14:47], [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/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 07:14:47' , 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 07:14:48], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907144774884462172', session_id='24062320240907144774884462172', Collection_create_time='2024-09-23 07:14:48';
[09/23/2024 07:14: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/23_09_2024/request_availability_Qtech_pranali_07_14_49_17270756897.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756897.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756897.json', 'ratehawk', '2024-09-23 07:14:55', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756897.json');
[09/23/2024 07:14:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.227'
        , request_start_time = '0.544'
        , parsing_start_time = '5.953'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.208'
        , search_end_time = '0.003'
        , total_duration = '6.819'
        , error_description = ''
        , memory_used = '2665744'
        WHERE id = '187089873';
[09/23/2024 07:14:56], [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_07_14_49_17270756896.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756896.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756896.json', 'ratehawk', '2024-09-23 07:14:56', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756896.json');
[09/23/2024 07:14:56], [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_07_14_49_17270756895.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756895.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756895.json', 'ratehawk', '2024-09-23 07:14:56', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756895.json');
[09/23/2024 07:14:56], [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_07_14_49_17270756892.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756892.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756892.json', 'ratehawk', '2024-09-23 07:14:56', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756892.json');
[09/23/2024 07:14:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.190'
        , request_start_time = '0.420'
        , parsing_start_time = '6.538'
        , mapping_complete_time = '0.231'
        , mongo_start_time = '0.551'
        , search_end_time = '0.876'
        , total_duration = '8.472'
        , error_description = ''
        , memory_used = '12201624'
        WHERE id = '187089886';
[09/23/2024 07: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/23_09_2024/request_availability_Qtech_pranali_07_14_49_17270756891.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756891.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756891.json', 'ratehawk', '2024-09-23 07:14:57', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756891.json');
[09/23/2024 07:14:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.211'
        , request_start_time = '0.587'
        , parsing_start_time = '6.324'
        , mapping_complete_time = '0.193'
        , mongo_start_time = '0.527'
        , search_end_time = '1.415'
        , total_duration = '8.970'
        , error_description = ''
        , memory_used = '26926096'
        WHERE id = '187089884';
[09/23/2024 07:14:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.133'
        , request_start_time = '0.150'
        , parsing_start_time = '7.086'
        , mapping_complete_time = '0.256'
        , mongo_start_time = '0.587'
        , search_end_time = '1.339'
        , total_duration = '9.261'
        , error_description = ''
        , memory_used = '42504288'
        WHERE id = '187089890';
[09/23/2024 07:14: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/23_09_2024/request_availability_Qtech_pranali_07_14_49_17270756890.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756890.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756890.json', 'ratehawk', '2024-09-23 07:14:58', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756890.json');
[09/23/2024 07:15:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.87'
        , request_start_time = '0.274'
        , parsing_start_time = '8.993'
        , mapping_complete_time = '0.577'
        , mongo_start_time = '0.833'
        , search_end_time = '0.786'
        , total_duration = '11.006'
        , error_description = ''
        , memory_used = '36664472'
        WHERE id = '187089943';
[09/23/2024 07:15:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '155'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.109'
        , request_start_time = '0.196'
        , parsing_start_time = '8.378'
        , mapping_complete_time = '1.554'
        , mongo_start_time = '2.447'
        , search_end_time = '3.204'
        , total_duration = '14.367'
        , error_description = ''
        , memory_used = '171308312'
        WHERE id = '187089925';
[09/23/2024 07:15:05], [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_07_14_49_17270756893.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756893.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756893.json', 'ratehawk', '2024-09-23 07:15:05', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756893.json');
[09/23/2024 07:15:06], [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_07_14_49_17270756894.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756894.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_14_49_17270756894.json', 'ratehawk', '2024-09-23 07:15:06', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_14_49_17270756894.json');
[09/23/2024 07:15:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.153'
        , request_start_time = '0.314'
        , parsing_start_time = '16.250'
        , mapping_complete_time = '0.130'
        , mongo_start_time = '0.588'
        , search_end_time = '0.563'
        , total_duration = '17.814'
        , error_description = ''
        , memory_used = '23004288'
        WHERE id = '187090218';
[09/23/2024 07:15:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:14:49.171'
        , request_start_time = '0.406'
        , parsing_start_time = '16.570'
        , mapping_complete_time = '0.306'
        , mongo_start_time = '0.684'
        , search_end_time = '0.526'
        , total_duration = '18.318'
        , error_description = ''
        , memory_used = '33215344'
        WHERE id = '187090234';
[09/23/2024 07:15:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '390',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240907144774884462172',
        duration = '20.331',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.68',
        system_load_5_min = '3.45',
        system_load_15_min = '3.67',
        system_memory_usage = '48.36',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16464682') + '4174240',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16464682';
[09/23/2024 07:15:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907144774884462172', session_id='24062320240907144774884462172', Collection_create_time='2024-09-23 07:15:09';
[09/23/2024 07:15:29], [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_07_15_28_17270757287.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_15_28_17270757287.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_15_28_17270757287.json', 'ratehawk', '2024-09-23 07:15:29', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_15_28_17270757287.json');
[09/23/2024 07:15:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:15:27.955'
        , request_start_time = '0.508'
        , parsing_start_time = '0.609'
        , mapping_complete_time = '0.012'
        , mongo_start_time = '0.046'
        , search_end_time = '0.001'
        , total_duration = '1.190'
        , error_description = ''
        , memory_used = '2754232'
        WHERE id = '187090727';
[09/23/2024 07:15: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/23_09_2024/request_availability_Qtech_pranali_07_15_33_17270757337.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_15_33_17270757337.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_15_33_17270757337.json', 'ratehawk', '2024-09-23 07:15:34', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_15_33_17270757337.json');
[09/23/2024 07:15:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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&debug=1'
        , http_hit_time = '2024-09-23 07:15:33.107'
        , request_start_time = '0.506'
        , parsing_start_time = '0.485'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.127'
        , error_description = ''
        , memory_used = '2763224'
        WHERE id = '187090773';
[09/23/2024 07:16: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/23_09_2024/request_availability_Qtech_pranali_07_15_57_17270757576.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_15_57_17270757576.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_15_57_17270757576.json', 'ratehawk', '2024-09-23 07:16:01', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_15_57_17270757576.json');
[09/23/2024 07:16:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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 07:15:56.454'
        , request_start_time = '0.656'
        , parsing_start_time = '3.899'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '0.773'
        , search_end_time = '0.106'
        , total_duration = '6.055'
        , error_description = ''
        , memory_used = '26999400'
        WHERE id = '187092017';
[09/23/2024 07:16:08], [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_07_16_06_17270757666.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_16_06_17270757666.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_16_06_17270757666.json', 'ratehawk', '2024-09-23 07:16:08', '', '24062320240907144774884462172', '16464682', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_16_06_17270757666.json');
[09/23/2024 07:16:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907144774884462172&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&debug=1'
        , http_hit_time = '2024-09-23 07:16:01.572'
        , request_start_time = '2.505'
        , parsing_start_time = '1.885'
        , mapping_complete_time = '0.342'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.968'
        , error_description = ''
        , memory_used = '27015104'
        WHERE id = '187092192';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '58' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '98' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '101' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/23/2024 07:47:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-23 07:47:52',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;120\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2406 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[09/23/2024 07:48:00], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-23 07:48:00',login_attempt=0 where id = '2406';
[09/23/2024 07:48:00], [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 07:48:00', ip = '43.239.53.130', action = 'Login' ;
[09/23/2024 07:48:19], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/30' , departure_date = '2024/10/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 07:48:19' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/23/2024 07:48:20], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 07:48:20';
[09/23/2024 07:48:30], [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_07_48_21_172707770110.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770110.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_172707770110.json', 'ratehawk', '2024-09-23 07:48:30', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770110.json');
[09/23/2024 07:48:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.202'
        , request_start_time = '0.593'
        , parsing_start_time = '8.820'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.057'
        , search_end_time = '0.059'
        , total_duration = '9.559'
        , error_description = ''
        , memory_used = '17276224'
        WHERE id = '187104883';
[09/23/2024 07:48:36], [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_07_48_21_17270777018.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777018.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777018.json', 'ratehawk', '2024-09-23 07:48:36', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777018.json');
[09/23/2024 07:48:36], [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_07_48_21_17270777016.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777016.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777016.json', 'ratehawk', '2024-09-23 07:48:36', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777016.json');
[09/23/2024 07:48:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.197'
        , request_start_time = '0.470'
        , parsing_start_time = '14.444'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.141'
        , search_end_time = '0.098'
        , total_duration = '15.184'
        , error_description = ''
        , memory_used = '58490720'
        WHERE id = '187104894';
[09/23/2024 07:48:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.192'
        , request_start_time = '0.472'
        , parsing_start_time = '14.490'
        , mapping_complete_time = '0.089'
        , mongo_start_time = '0.152'
        , search_end_time = '0.111'
        , total_duration = '15.261'
        , error_description = ''
        , memory_used = '61683808'
        WHERE id = '187104895';
[09/23/2024 07:48:37], [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_07_48_21_172707770111.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770111.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_172707770111.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770111.json');
[09/23/2024 07:48:37], [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_07_48_21_17270777019.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777019.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777019.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777019.json');
[09/23/2024 07:48:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.205'
        , request_start_time = '0.552'
        , parsing_start_time = '15.665'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.109'
        , search_end_time = '0.053'
        , total_duration = '16.415'
        , error_description = ''
        , memory_used = '26190024'
        WHERE id = '187104919';
[09/23/2024 07:48:37], [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_07_48_21_172707770112.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770112.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_172707770112.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_172707770112.json');
[09/23/2024 07:48:37], [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_07_48_21_17270777015.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777015.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777015.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777015.json');
[09/23/2024 07:48:37], [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_07_48_21_17270777010.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777010.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777010.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777010.json');
[09/23/2024 07:48:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.190'
        , request_start_time = '0.459'
        , parsing_start_time = '15.998'
        , mapping_complete_time = '0.065'
        , mongo_start_time = '0.103'
        , search_end_time = '0.061'
        , total_duration = '16.653'
        , error_description = ''
        , memory_used = '43475824'
        WHERE id = '187104928';
[09/23/2024 07:48:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.200'
        , request_start_time = '0.671'
        , parsing_start_time = '15.710'
        , mapping_complete_time = '0.085'
        , mongo_start_time = '0.144'
        , search_end_time = '0.094'
        , total_duration = '16.656'
        , error_description = ''
        , memory_used = '57299936'
        WHERE id = '187104924';
[09/23/2024 07:48:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.207'
        , request_start_time = '0.657'
        , parsing_start_time = '15.701'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.163'
        , search_end_time = '0.074'
        , total_duration = '16.662'
        , error_description = ''
        , memory_used = '39723800'
        WHERE id = '187104926';
[09/23/2024 07:48:37], [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_07_48_21_17270777014.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777014.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777014.json', 'ratehawk', '2024-09-23 07:48:37', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777014.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_21_17270777017.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777017.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777017.json', 'ratehawk', '2024-09-23 07:48:38', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777017.json');
[09/23/2024 07:48:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.178'
        , request_start_time = '0.171'
        , parsing_start_time = '16.408'
        , mapping_complete_time = '0.146'
        , mongo_start_time = '0.287'
        , search_end_time = '0.171'
        , total_duration = '17.084'
        , error_description = ''
        , memory_used = '105302816'
        WHERE id = '187104929';
[09/23/2024 07:48:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '41'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.185'
        , request_start_time = '0.347'
        , parsing_start_time = '16.417'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.196'
        , search_end_time = '0.115'
        , total_duration = '17.112'
        , error_description = ''
        , memory_used = '84822480'
        WHERE id = '187104937';
[09/23/2024 07:48:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.194'
        , request_start_time = '0.455'
        , parsing_start_time = '16.451'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.152'
        , search_end_time = '0.105'
        , total_duration = '17.197'
        , error_description = ''
        , memory_used = '62298360'
        WHERE id = '187104946';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_21_17270777013.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777013.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777013.json', 'ratehawk', '2024-09-23 07:48:38', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777013.json');
[09/23/2024 07:48:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.184'
        , request_start_time = '0.485'
        , parsing_start_time = '16.725'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.174'
        , search_end_time = '0.108'
        , total_duration = '17.529'
        , error_description = ''
        , memory_used = '73084240'
        WHERE id = '187104963';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_21_17270777011.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777011.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777011.json', 'ratehawk', '2024-09-23 07:48:38', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777011.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_21_17270777012.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777012.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_21_17270777012.json', 'ratehawk', '2024-09-23 07:48:38', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_21_17270777012.json');
[09/23/2024 07:48:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '102'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.181'
        , request_start_time = '0.261'
        , parsing_start_time = '17.486'
        , mapping_complete_time = '0.238'
        , mongo_start_time = '0.501'
        , search_end_time = '0.288'
        , total_duration = '18.592'
        , error_description = ''
        , memory_used = '173525984'
        WHERE id = '187105022';
[09/23/2024 07:48:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '136'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:21.178'
        , request_start_time = '0.118'
        , parsing_start_time = '17.622'
        , mapping_complete_time = '0.315'
        , mongo_start_time = '0.681'
        , search_end_time = '0.349'
        , total_duration = '18.837'
        , error_description = ''
        , memory_used = '219677784'
        WHERE id = '187105020';
[09/23/2024 07:48:41], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '604',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240907481962723868949',
        duration = '21.159',
        merge_duration = '0.062',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.56',
        system_load_5_min = '4.75',
        system_load_15_min = '3.92',
        system_memory_usage = '32.65',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16466383') + '5331888',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16466383';
[09/23/2024 07:48:41], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 07:48:41';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_17270777239.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777239.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_17270777239.json', 'ratehawk', '2024-09-23 07:48:46', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777239.json');
[09/23/2024 07:48:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.518'
        , request_start_time = '0.691'
        , parsing_start_time = '3.452'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.146'
        , search_end_time = '0.108'
        , total_duration = '4.435'
        , error_description = ''
        , memory_used = '57081952'
        WHERE id = '187105130';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_172707772310.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772310.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_172707772310.json', 'ratehawk', '2024-09-23 07:48:50', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772310.json');
[09/23/2024 07:48:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.521'
        , request_start_time = '0.627'
        , parsing_start_time = '7.644'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.062'
        , search_end_time = '0.035'
        , total_duration = '8.395'
        , error_description = ''
        , memory_used = '16768176'
        WHERE id = '187105152';
[09/23/2024 07:48:51], [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_07_48_42_17270777220.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777220.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777220.json', 'ratehawk', '2024-09-23 07:48:51', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777220.json');
[09/23/2024 07:48:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.496'
        , request_start_time = '0.097'
        , parsing_start_time = '9.362'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.296'
        , search_end_time = '0.149'
        , total_duration = '9.956'
        , error_description = ''
        , memory_used = '105692888'
        WHERE id = '187105156';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777222.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777222.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777222.json', 'ratehawk', '2024-09-23 07:48:53', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777222.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777223.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777223.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777223.json', 'ratehawk', '2024-09-23 07:48:53', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777223.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777226.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777226.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777226.json', 'ratehawk', '2024-09-23 07:48:53', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777226.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777224.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777224.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777224.json', 'ratehawk', '2024-09-23 07:48:53', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777224.json');
[09/23/2024 07:48:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.503'
        , request_start_time = '0.307'
        , parsing_start_time = '10.811'
        , mapping_complete_time = '0.118'
        , mongo_start_time = '0.198'
        , search_end_time = '0.107'
        , total_duration = '11.463'
        , error_description = ''
        , memory_used = '74481472'
        WHERE id = '187105159';
[09/23/2024 07:48:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.510'
        , request_start_time = '0.418'
        , parsing_start_time = '10.752'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.160'
        , search_end_time = '0.110'
        , total_duration = '11.477'
        , error_description = ''
        , memory_used = '63880008'
        WHERE id = '187105160';
[09/23/2024 07:48:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '41'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.506'
        , request_start_time = '0.455'
        , parsing_start_time = '10.951'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.201'
        , search_end_time = '0.099'
        , total_duration = '11.747'
        , error_description = ''
        , memory_used = '83932840'
        WHERE id = '187105161';
[09/23/2024 07:48:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '102'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.500'
        , request_start_time = '0.237'
        , parsing_start_time = '10.874'
        , mapping_complete_time = '0.251'
        , mongo_start_time = '0.515'
        , search_end_time = '0.291'
        , total_duration = '11.976'
        , error_description = ''
        , memory_used = '174944032'
        WHERE id = '187105158';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777221.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777221.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777221.json', 'ratehawk', '2024-09-23 07:48:54', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777221.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_17270777235.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777235.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_17270777235.json', 'ratehawk', '2024-09-23 07:48:55', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777235.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_172707772312.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772312.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_172707772312.json', 'ratehawk', '2024-09-23 07:48:55', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772312.json');
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_172707772311.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772311.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_172707772311.json', 'ratehawk', '2024-09-23 07:48:55', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_172707772311.json');
[09/23/2024 07:48:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.522'
        , request_start_time = '0.535'
        , parsing_start_time = '11.986'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.079'
        , search_end_time = '0.046'
        , total_duration = '12.676'
        , error_description = ''
        , memory_used = '26281184'
        WHERE id = '187105165';
[09/23/2024 07:48:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.509'
        , request_start_time = '0.565'
        , parsing_start_time = '11.952'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.094'
        , search_end_time = '0.057'
        , total_duration = '12.701'
        , error_description = ''
        , memory_used = '43738112'
        WHERE id = '187105163';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_43_17270777238.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777238.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_43_17270777238.json', 'ratehawk', '2024-09-23 07:48:55', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_43_17270777238.json');
[09/23/2024 07:48:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.524'
        , request_start_time = '0.559'
        , parsing_start_time = '11.945'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.111'
        , search_end_time = '0.087'
        , total_duration = '12.742'
        , error_description = ''
        , memory_used = '39812576'
        WHERE id = '187105164';
[09/23/2024 07:48:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '32'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.515'
        , request_start_time = '0.564'
        , parsing_start_time = '12.109'
        , mapping_complete_time = '0.093'
        , mongo_start_time = '0.146'
        , search_end_time = '0.093'
        , total_duration = '12.949'
        , error_description = ''
        , memory_used = '56757720'
        WHERE id = '187105166';
[09/23/2024 07:48: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/23_09_2024/request_availability_Qtech_pranali_07_48_42_17270777227.json', 'rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777227.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_07_48_42_17270777227.json', 'ratehawk', '2024-09-23 07:48:55', '', '24062320240907481962723868949', '16466383', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_07_48_42_17270777227.json');
[09/23/2024 07:48:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '136'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.498'
        , request_start_time = '0.105'
        , parsing_start_time = '12.117'
        , mapping_complete_time = '0.314'
        , mongo_start_time = '0.677'
        , search_end_time = '0.391'
        , total_duration = '13.357'
        , error_description = ''
        , memory_used = '220498960'
        WHERE id = '187105162';
[09/23/2024 07:48:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240907481962723868949&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&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-23 07:48:42.513'
        , request_start_time = '0.410'
        , parsing_start_time = '12.802'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.156'
        , search_end_time = '0.102'
        , total_duration = '13.507'
        , error_description = ''
        , memory_used = '61453168'
        WHERE id = '187105167';
[09/23/2024 07:48:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '602',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240907481962723868949',
        duration = '15.998',
        merge_duration = '0.059',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.55',
        system_load_5_min = '4.44',
        system_load_15_min = '3.83',
        system_memory_usage = '32.63',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16466383') + '5453616',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16466383';
[09/23/2024 07:49:19], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 07:49:19';
[09/23/2024 07:52:18], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 07:52:18';
[09/23/2024 07:53:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 07:53:59';
