[07/26/2021 02:00:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'colombo' , service_name = 'Test Hotel' , service_type = 'hotel' , arrival_date = '2021/07/28' , departure_date = '2021/07/29' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2021-07-26 14:00:16' , site_id = '' , country_code = '132' , web_service = '' ;
[07/26/2021 02:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 02:00:19', '', 'fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e', '11');
[07/26/2021 02:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e&xml_user_id=21&request_no=0&local_hotel_code=53733&web_service=no&site_id='
, http_hit_time = '2021-07-26 14:00:18.762'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '0.707'
, error_description = ''
, memory_used = '11609784'
WHERE id = '3416';
[07/26/2021 02:00:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e',
  duration = '1.123',
  merge_duration = '0.115',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '9.02',
  system_load_5_min = '2.57',
  system_load_15_min = '1.66',
  system_memory_usage = '95.62',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '11') + '6605656',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '11';
