[10/24/2020 06:14:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs SET
type = 'ERROR'
, http_hit_time = '2020-10-24 06:14:15.172'
, total_duration = '0.847'
, hotel_count = 0
, source_type = 'localsystem'
, create_date = '2020-10-24 06:14:16'
, session_id = '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5'
, agent_logs_id = ''
, error_description = ''
, memory_used = '7903080';
[10/24/2020 06:14:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-24 06:14:35',login_attempt=0 where id = '21';
[10/24/2020 06:14:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2020-10-24 06:14:35', ip = '203.192.206.17', action = 'Login' ;
[10/24/2020 06:14:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs SET
type = 'ERROR'
, http_hit_time = '2020-10-24 06:14:56.367'
, total_duration = '0.750'
, hotel_count = 0
, source_type = 'localsystem'
, create_date = '2020-10-24 06:14:57'
, session_id = '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5'
, agent_logs_id = ''
, error_description = ''
, memory_used = '7940416';
[10/24/2020 06:15:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-24 06:15:06',login_attempt=0 where id = '21';
[10/24/2020 06:15:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2020-10-24 06:15:06', ip = '203.192.206.17', action = 'Login' ;
[10/24/2020 06:15:30], [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 = '203.192.206.17' , 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-24 06:15:30' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 06:15:33], [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-24 06:15:33', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '443');
[10/24/2020 06:15:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:15:32.122'
, 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.257'
, error_description = ''
, memory_used = '7908512'
WHERE id = '3172';
[10/24/2020 06:15:33], [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-24 06:15:33', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '443');
[10/24/2020 06:15:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:15:32.127'
, 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.918'
, error_description = ''
, memory_used = '7910416'
WHERE id = '3173';
[10/24/2020 06:15:34], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '2.609',
  merge_duration = '0.123',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '6.51',
  system_load_5_min = '2.84',
  system_load_15_min = '2.08',
  system_memory_usage = '91.58',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '443') + '8043232',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '443';
[10/24/2020 06:15:46], [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 = '203.192.206.17' , 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-24 06:15:46' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 06:15: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-24 06:15:49', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '444');
[10/24/2020 06:15:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:15:49.162'
, 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.824'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3174';
[10/24/2020 06:15: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-24 06:15:50', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '444');
[10/24/2020 06:15:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:15:49.160'
, 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.276'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3175';
[10/24/2020 06:15:50], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '1.745',
  merge_duration = '0.099',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '5.64',
  system_load_5_min = '2.83',
  system_load_15_min = '2.09',
  system_memory_usage = '91.57',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '444') + '8046736',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '444';
[10/24/2020 06:15: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-24 06:15:57', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '444');
[10/24/2020 06:15:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:15:56.918'
, 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.603'
, error_description = ''
, memory_used = '7954904'
WHERE id = '3176';
[10/24/2020 06:22:33], [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-24 06:22:33', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '444');
[10/24/2020 06:22:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:22:32.28'
, 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.768'
, error_description = ''
, memory_used = '7954776'
WHERE id = '3177';
[10/24/2020 06:22: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-24 06:22:59', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '444');
[10/24/2020 06:23:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:22:59.20'
, 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.536'
, error_description = ''
, memory_used = '7954688'
WHERE id = '3178';
[10/24/2020 06:23:12], [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 = '203.192.206.17' , 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-24 06:23:12' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 06:23:15], [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-24 06:23:15', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '445');
[10/24/2020 06:23:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:23:14.673'
, 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.890'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3179';
[10/24/2020 06:23: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-24 06:23:16', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '445');
[10/24/2020 06:23:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:23:14.620'
, 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.817'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3180';
[10/24/2020 06:23:16], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '2.253',
  merge_duration = '0.051',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.96',
  system_load_5_min = '1.89',
  system_load_15_min = '1.85',
  system_memory_usage = '94.55',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '445') + '8043648',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '445';
[10/24/2020 06:23: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-24 06:23:26', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '445');
[10/24/2020 06:23:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:23:25.200'
, 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.530'
, error_description = ''
, memory_used = '7951944'
WHERE id = '3181';
[10/24/2020 06:34: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-24 06:34:26', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '445');
[10/24/2020 06:34:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:34:25.658'
, 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.105'
, error_description = ''
, memory_used = '7951816'
WHERE id = '3182';
[10/24/2020 06:35:28], [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-24 06:35:28', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '445');
[10/24/2020 06:35:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:35:27.782'
, 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.606'
, error_description = ''
, memory_used = '7951816'
WHERE id = '3183';
[10/24/2020 06:36:46], [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 = '203.192.206.17' , 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-24 06:36:46' , site_id = '' , country_code = '106' , web_service = '' ;
[10/24/2020 06:36: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-24 06:36:49', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '446');
[10/24/2020 06:36: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-24 06:36:50', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '446');
[10/24/2020 06:36:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:36:49.43'
, 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.094'
, error_description = ''
, memory_used = '7911848'
WHERE id = '3184';
[10/24/2020 06:36:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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-24 06:36:49.43'
, 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.703'
, error_description = ''
, memory_used = '7913752'
WHERE id = '3185';
[10/24/2020 06:36:50], [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=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5',
  duration = '2.321',
  merge_duration = '0.077',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.64',
  system_load_5_min = '1.68',
  system_load_15_min = '1.95',
  system_memory_usage = '96.32',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '446') + '8046608',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '446';
[10/24/2020 06:36: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-24 06:36:58', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '446');
[10/24/2020 06:36:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:36:57.433'
, 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.560'
, error_description = ''
, memory_used = '7954904'
WHERE id = '3186';
[10/24/2020 06:40: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-24 06:40:30', '', '23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5', '446');
[10/24/2020 06:40:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=23cfe48fde2b04261dc988da5df5707e56ec09b32ed623c116169ffaaa688bf5&xml_user_id=21&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='
, http_hit_time = '2020-10-24 06:40:29.599'
, 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.733'
, error_description = ''
, memory_used = '7954776'
WHERE id = '3187';
