
[08/06/2020 10:00:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 14788 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=add',create_date= '2020-08-06 10:00:18';
[08/06/2020 10:00:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='D',modify_date='2020-08-06 10:00:29'  WHERE sub_user_id='9';
[08/06/2020 10:56:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 10:56:32',login_attempt=0 where id = '25';
[08/06/2020 10:56:32], [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-08-06 10:56:32', ip = '150.107.41.77', action = 'Login' ;
[08/06/2020 10:59:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-08-06 10:59:17',login_attempt=0 where id = '25';
[08/06/2020 10:59:17], [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-08-06 10:59:17', ip = '150.107.41.77', action = 'Login' ;
[08/06/2020 10:59:39], [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 = '150.107.41.77' , city = 'colombo' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/08/21' , departure_date = '2020/08/22' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-08-06 10:59:39' , site_id = '' , country_code = '132' , web_service = '' ;
[08/06/2020 10:59:43], [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-08-06 10:59:43', '', '24923b1e1519b0887f62556464faf48902e476a9807557c62351224260e52c39', '366');
[08/06/2020 10:59:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=24923b1e1519b0887f62556464faf48902e476a9807557c62351224260e52c39&xml_user_id=25&request_no=0&local_hotel_code=35&#039;,&#039;36&#039;,&#039;60&#039;,&#039;61&#039;,&#039;65&#039;,&#039;77&#039;,&#039;53699&#039;,&#039;53700&#039;,&#039;38&#039;,&#039;39&#039;,&#039;99&#039;,&#039;78&#039;,&#039;51821&#039;,&#039;76&#039;,&#039;51811&#039;,&#039;53701&#039;,&#039;51808&#039;,&#039;53725&#039;,&#039;53733&web_service=no&site_id='
, http_hit_time = '2020-08-06 10:59:42.992'
, 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.349'
, error_description = ''
, memory_used = '8020200'
WHERE id = '2949';
[08/06/2020 10:59:44], [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=24923b1e1519b0887f62556464faf48902e476a9807557c62351224260e52c39',
  duration = '1.898',
  merge_duration = '0.118',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.54',
  system_load_5_min = '1.07',
  system_load_15_min = '1.05',
  system_memory_usage = '93.10',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '366') + '8149456',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '366';
