[10/23/2020 11:11:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-23 11:11:16',login_attempt=0 where id = '25';
[10/23/2020 11:11:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-10-23 11:11:16', ip = '203.194.101.137', action = 'Login' ;
[10/23/2020 11:14:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-23 11:14:34' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:14:39], [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', '2020-10-23 11:14:39', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '422');
[10/23/2020 11:14:39], [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', '2020-10-23 11:14:39', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '422');
[10/23/2020 11:14:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:14:38.418'
, 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.984'
, error_description = ''
, memory_used = '7908512'
WHERE id = '3105';
[10/23/2020 11:14:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:14:38.386'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.033'
, error_description = ''
, memory_used = '7910416'
WHERE id = '3104';
[10/23/2020 11:14:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.442',
  merge_duration = '0.080',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.39',
  system_load_5_min = '0.57',
  system_load_15_min = '0.83',
  system_memory_usage = '90.10',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '422') + '8043800',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '422';
[10/23/2020 11:16:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:16:18' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:16:21], [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', '2020-10-23 11:16:21', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '423');
[10/23/2020 11:16:21], [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', '2020-10-23 11:16:21', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '423');
[10/23/2020 11:16:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:16:20.333'
, 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.955'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3106';
[10/23/2020 11:16:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:16:20.334'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.434'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3107';
[10/23/2020 11:16:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.918',
  merge_duration = '0.098',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '2.26',
  system_load_5_min = '1.46',
  system_load_15_min = '1.13',
  system_memory_usage = '90.09',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '423') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '423';
[10/23/2020 11:18:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:18:00' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:18:03], [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', '2020-10-23 11:18:03', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '424');
[10/23/2020 11:18:03], [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', '2020-10-23 11:18:03', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '424');
[10/23/2020 11:18:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:02.529'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.162'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3108';
[10/23/2020 11:18:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:02.546'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.529'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3109';
[10/23/2020 11:18:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.055',
  merge_duration = '0.066',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.74',
  system_load_5_min = '1.18',
  system_load_15_min = '1.07',
  system_memory_usage = '90.13',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '424') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '424';
[10/23/2020 11:18:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:18:53' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:18:56], [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', '2020-10-23 11:18:56', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:18:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:55.393'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.043'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3110';
[10/23/2020 11:18:56], [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', '2020-10-23 11:18:56', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:18:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:55.729'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.399'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3111';
[10/23/2020 11:18:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.266',
  merge_duration = '0.070',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.43',
  system_load_5_min = '1.04',
  system_load_15_min = '1.02',
  system_memory_usage = '90.07',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '425') + '8047304',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '425';
[10/23/2020 11:18:59], [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', '2020-10-23 11:18:59', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:18:59], [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', '2020-10-23 11:18:59', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:18:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:58.350'
, 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.966'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3112';
[10/23/2020 11:18:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:18:58.308'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.681'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3113';
[10/23/2020 11:19:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.103',
  merge_duration = '0.085',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.64',
  system_load_5_min = '1.07',
  system_load_15_min = '1.03',
  system_memory_usage = '90.08',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '425') + '8047184',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '425';
[10/23/2020 11:21:07], [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', '2020-10-23 11:21:07', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:21:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:21:06.636'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.630'
, error_description = ''
, memory_used = '7955720'
WHERE id = '3114';
[10/23/2020 11:25:09], [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', '2020-10-23 11:25:09', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:25:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768%27,%2753769%27,%2753771%27,%2753773&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:25:08.382'
, 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.939'
, error_description = ''
, memory_used = '7953336'
WHERE id = '3115';
[10/23/2020 11:26:51], [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', '2020-10-23 11:26:51', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:26:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:26:50.947'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.253'
, error_description = ''
, memory_used = '7955720'
WHERE id = '3116';
[10/23/2020 11:26:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:26:54' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:26:57], [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', '2020-10-23 11:26:57', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '426');
[10/23/2020 11:26:57], [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', '2020-10-23 11:26:57', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '426');
[10/23/2020 11:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:26:56.783'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.238'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3118';
[10/23/2020 11:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:26:56.783'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.780'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3117';
[10/23/2020 11:26:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763',
  duration = '2.199',
  merge_duration = '0.063',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.67',
  system_load_5_min = '0.65',
  system_load_15_min = '0.82',
  system_memory_usage = '90.09',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '426') + '8046904',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '426';
[10/23/2020 11:34:50], [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', '2020-10-23 11:34:50', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:34:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:34:49.633'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.962'
, error_description = ''
, memory_used = '7955808'
WHERE id = '3119';
[10/23/2020 11:35:16], [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', '2020-10-23 11:35:16', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '425');
[10/23/2020 11:35:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:35:15.825'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.701'
, error_description = ''
, memory_used = '7955808'
WHERE id = '3120';
[10/23/2020 11:35:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:35:33' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:35:37], [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', '2020-10-23 11:35:37', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '427');
[10/23/2020 11:35:37], [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', '2020-10-23 11:35:37', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '427');
[10/23/2020 11:35:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:35:36.189'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.239'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3121';
[10/23/2020 11:35:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:35:36.186'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.580'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3122';
[10/23/2020 11:35:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.439',
  merge_duration = '0.138',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.52',
  system_load_5_min = '1.36',
  system_load_15_min = '1.16',
  system_memory_usage = '90.27',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '427') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '427';
[10/23/2020 11:37:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:37:46' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:37:49], [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', '2020-10-23 11:37:49', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '428');
[10/23/2020 11:37:49], [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', '2020-10-23 11:37:49', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '428');
[10/23/2020 11:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:37:48.467'
, 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.910'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3123';
[10/23/2020 11:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:37:48.421'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.323'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3124';
[10/23/2020 11:37:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.826',
  merge_duration = '0.106',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.60',
  system_load_5_min = '1.07',
  system_load_15_min = '1.07',
  system_memory_usage = '90.24',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '428') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '428';
[10/23/2020 11:40:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:40:09' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:40:12], [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', '2020-10-23 11:40:12', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '429');
[10/23/2020 11:40:12], [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', '2020-10-23 11:40:12', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '429');
[10/23/2020 11:40:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:40:11.875'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.042'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3125';
[10/23/2020 11:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:40:11.890'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.443'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3126';
[10/23/2020 11:40:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.933',
  merge_duration = '0.111',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.55',
  system_load_5_min = '0.83',
  system_load_15_min = '0.98',
  system_memory_usage = '90.39',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '429') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '429';
[10/23/2020 11:41:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:41:27' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:41:30], [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', '2020-10-23 11:41:30', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '430');
[10/23/2020 11:41:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:41:29.801'
, 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.921'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3127';
[10/23/2020 11:41:30], [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', '2020-10-23 11:41:30', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '430');
[10/23/2020 11:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:41:29.798'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.797'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3128';
[10/23/2020 11:41:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.425',
  merge_duration = '0.077',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.72',
  system_load_5_min = '0.87',
  system_load_15_min = '0.98',
  system_memory_usage = '90.31',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '430') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '430';
[10/23/2020 11:47:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:47:14' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:47:17], [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', '2020-10-23 11:47:17', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '431');
[10/23/2020 11:47:17], [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', '2020-10-23 11:47:17', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '431');
[10/23/2020 11:47:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:47:16.791'
, 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.958'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3130';
[10/23/2020 11:47:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:47:16.761'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.082'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3129';
[10/23/2020 11:47:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.495',
  merge_duration = '0.096',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.56',
  system_load_5_min = '0.77',
  system_load_15_min = '0.90',
  system_memory_usage = '90.34',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '431') + '8044216',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '431';
[10/23/2020 11:48:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:48:48' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:48:51], [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', '2020-10-23 11:48:51', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '432');
[10/23/2020 11:48:51], [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', '2020-10-23 11:48:51', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '432');
[10/23/2020 11:48:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:48:50.426'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.311'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3131';
[10/23/2020 11:48:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:48:50.440'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.711'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3132';
[10/23/2020 11:48:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.241',
  merge_duration = '0.052',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.40',
  system_load_5_min = '0.65',
  system_load_15_min = '0.85',
  system_memory_usage = '90.30',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '432') + '8047176',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '432';
[10/23/2020 11:49:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:49:49' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:49:52], [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', '2020-10-23 11:49:52', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '433');
[10/23/2020 11:49:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:49:51.802'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.304'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3133';
[10/23/2020 11:49:53], [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', '2020-10-23 11:49:53', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '433');
[10/23/2020 11:49:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:49:51.802'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.434'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3134';
[10/23/2020 11:49:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.989',
  merge_duration = '0.075',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.49',
  system_load_5_min = '0.64',
  system_load_15_min = '0.82',
  system_memory_usage = '90.31',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '433') + '8047304',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '433';
[10/23/2020 11:50:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2, 1' , create_date = '2020-10-23 11:50:06' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:50:09], [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', '2020-10-23 11:50:09', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:09], [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', '2020-10-23 11:50:09', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:08.910'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.230'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3135';
[10/23/2020 11:50:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:08.923'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.921'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3136';
[10/23/2020 11:50:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.449',
  merge_duration = '0.086',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.38',
  system_load_5_min = '0.61',
  system_load_15_min = '0.81',
  system_memory_usage = '90.44',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '434') + '8047304',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '434';
[10/23/2020 11:50:13], [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', '2020-10-23 11:50:13', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:14], [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', '2020-10-23 11:50:14', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:12.798'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.555'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3138';
[10/23/2020 11:50:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:12.798'
, 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 = '2.018'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3137';
[10/23/2020 11:50:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.692',
  merge_duration = '0.127',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.67',
  system_load_5_min = '0.66',
  system_load_15_min = '0.83',
  system_memory_usage = '90.46',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '434') + '8047184',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '434';
[10/23/2020 11:50:30], [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', '2020-10-23 11:50:30', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:29.534'
, 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.996'
, error_description = ''
, memory_used = '7911952'
WHERE id = '3139';
[10/23/2020 11:50:30], [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', '2020-10-23 11:50:30', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:50:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:50:29.530'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.509'
, error_description = ''
, memory_used = '7913856'
WHERE id = '3140';
[10/23/2020 11:50:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.600',
  merge_duration = '0.107',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.04',
  system_load_5_min = '0.75',
  system_load_15_min = '0.85',
  system_memory_usage = '90.37',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '434') + '8045512',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '434';
[10/23/2020 11:51:02], [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', '2020-10-23 11:51:02', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '434');
[10/23/2020 11:51:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:51:00.509'
, 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 = '2.232'
, error_description = ''
, memory_used = '7955720'
WHERE id = '3141';
[10/23/2020 11:54:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-23 11:54:55' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:54:58], [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', '2020-10-23 11:54:58', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '435');
[10/23/2020 11:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:54:57.749'
, 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.678'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3142';
[10/23/2020 11:54:58], [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', '2020-10-23 11:54:58', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '435');
[10/23/2020 11:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:54:57.776'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.131'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3143';
[10/23/2020 11:54:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '1.516',
  merge_duration = '0.060',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.32',
  system_load_5_min = '0.64',
  system_load_15_min = '0.79',
  system_memory_usage = '90.31',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '435') + '8044216',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '435';
[10/23/2020 11:56:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '203.194.101.137' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-23 11:56:22' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 11:56:26], [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', '2020-10-23 11:56:26', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '436');
[10/23/2020 11:56:26], [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', '2020-10-23 11:56:26', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '436');
[10/23/2020 11:56:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:56:25.568'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.206'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3144';
[10/23/2020 11:56:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:56:25.552'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.591'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3145';
[10/23/2020 11:56:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.187',
  merge_duration = '0.097',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.98',
  system_load_5_min = '0.83',
  system_load_15_min = '0.84',
  system_memory_usage = '90.33',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '436') + '8044216',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '436';
[10/23/2020 11:56:29], [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', '2020-10-23 11:56:29', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '436');
[10/23/2020 11:56:29], [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', '2020-10-23 11:56:29', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '436');
[10/23/2020 11:56:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=1&local_hotel_code=53768&#039;,&#039;53769&#039;,&#039;53771&#039;,&#039;53773&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:56:28.337'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.331'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3146';
[10/23/2020 11:56:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&#039;,&#039;53766&#039;,&#039;53767&web_service=no&site_id='
, http_hit_time = '2020-10-23 11:56:28.409'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.641'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3147';
[10/23/2020 11:56:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c',
  duration = '2.147',
  merge_duration = '0.089',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.15',
  system_load_5_min = '0.86',
  system_load_15_min = '0.85',
  system_memory_usage = '90.35',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '436') + '8044096',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '436';
[10/23/2020 11:56:48], [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', '2020-10-23 11:56:48', '', '9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c', '436');
[10/23/2020 11:56:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=9e0f7e0ac98aafae3ca6cb4e0a0b2b6ef2fb7e3d239867191faf0f2abb33d59c&xml_user_id=25&request_no=0&local_hotel_code=2%27,%2797%27,%2753716%27,%2753734%27,%2753735%27,%2753736%27,%2753737%27,%2753738%27,%2753739%27,%2753740%27,%2753741%27,%2753742%27,%2753744%27,%2753745%27,%2753746%27,%2753747%27,%2753748%27,%2753749%27,%2753750%27,%2753751%27,%2753757%27,%2753758%27,%2753759%27,%2753766%27,%2753767&web_service=no&site_id=&debug=1'
, http_hit_time = '2020-10-23 11:56:47.911'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.280'
, error_description = ''
, memory_used = '7952888'
WHERE id = '3148';
