[10/23/2020 05:03:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-23 05:03:46',login_attempt=0 where id = '25';
[10/23/2020 05:03:46], [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 05:03:46', ip = '60.254.11.53', action = 'Login' ;
[10/23/2020 05:04:05], [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/23' , departure_date = '2020/10/24' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-23 05:04:05' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 05:04: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 05:04:07', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '404');
[10/23/2020 05:04:08], [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 05:04:08', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '404');
[10/23/2020 05:04:08], [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 05:04:07.136'
, 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.116'
, error_description = ''
, memory_used = '7908512'
WHERE id = '3068';
[10/23/2020 05:04:08], [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 05:04:07.158'
, 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.440'
, error_description = ''
, memory_used = '7910416'
WHERE id = '3069';
[10/23/2020 05:04:08], [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 = '1.905',
  merge_duration = '0.096',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.65',
  system_load_5_min = '1.80',
  system_load_15_min = '1.29',
  system_memory_usage = '89.23',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '404') + '8043720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '404';
[10/23/2020 05:05:12], [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/23' , departure_date = '2020/10/26' , nationality = '106' , nights = '3' , room_types = '2' , create_date = '2020-10-23 05:05:12' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 05:05: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-23 05:05:15', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '405');
[10/23/2020 05:05: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-23 05:05:15', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '405');
[10/23/2020 05:05:16], [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 05:05:14.666'
, 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.410'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3070';
[10/23/2020 05:05:16], [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 05:05:14.671'
, 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.756'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3071';
[10/23/2020 05:05: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=25&sessionid=fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763',
  duration = '2.390',
  merge_duration = '0.087',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.75',
  system_load_5_min = '1.60',
  system_load_15_min = '1.25',
  system_memory_usage = '89.57',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '405') + '8043944',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '405';
[10/23/2020 05:05:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603429534','60.254.11.53');
[10/23/2020 05:06: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 = '60.254.11.53' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/30' , departure_date = '2020/11/02' , nationality = '106' , nights = '3' , room_types = '2' , create_date = '2020-10-23 05:06:00' , site_id = '' , country_code = '106' , web_service = '' ;
[10/23/2020 05:06: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 05:06:03', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '406');
[10/23/2020 05:06: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 05:06:03', '', 'fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763', '406');
[10/23/2020 05:06:03], [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 05:06:02.694'
, 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.240'
, error_description = ''
, memory_used = '7910792'
WHERE id = '3072';
[10/23/2020 05:06:03], [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 05:06:02.763'
, 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.225'
, error_description = ''
, memory_used = '7908888'
WHERE id = '3073';
[10/23/2020 05:06: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=fc8d69515acbce346a2a4cad95e55708ddb842934cc37d8822d907963bae1763',
  duration = '1.707',
  merge_duration = '0.065',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.96',
  system_load_5_min = '1.56',
  system_load_15_min = '1.25',
  system_memory_usage = '89.66',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '406') + '8044136',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '406';
[10/23/2020 05:06:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603429578','60.254.11.53');
