[07/29/2020 10:29:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-29 10:29:26',login_attempt=0 where id = '25';
[07/29/2020 10:29:26], [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-07-29 10:29:26', ip = '60.254.44.39', action = 'Login' ;
[07/29/2020 10:29:57], [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.44.39' , city = 'bentota' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/29' , departure_date = '2020/07/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-29 10:29:57' , site_id = '' , country_code = '132' , web_service = '' ;
[07/29/2020 10:30: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-07-29 10:30:02', '', '60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8', '352');
[07/29/2020 10:30:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8&xml_user_id=25&request_no=0&local_hotel_code=100&#039;,&#039;53704&#039;,&#039;53707&web_service=no&site_id='
, http_hit_time = '2020-07-29 10:30:00.639'
, 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.810'
, error_description = ''
, memory_used = '7941808'
WHERE id = '2929';
[07/29/2020 10:30:03], [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=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8',
  duration = '3.326',
  merge_duration = '0.019',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.97',
  system_load_5_min = '1.34',
  system_load_15_min = '1.72',
  system_memory_usage = '92.65',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '352') + '8147976',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '352';
[07/29/2020 10:31: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.44.39' , city = 'bentota' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/29' , departure_date = '2020/07/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-29 10:31:05' , site_id = '' , country_code = '132' , web_service = '' ;
[07/29/2020 10:31: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-07-29 10:31:07', '', '60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8', '353');
[07/29/2020 10:31:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8&xml_user_id=25&request_no=0&local_hotel_code=100&#039;,&#039;53704&#039;,&#039;53707&web_service=no&site_id='
, http_hit_time = '2020-07-29 10:31:07.244'
, 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.521'
, error_description = ''
, memory_used = '7942184'
WHERE id = '2930';
[07/29/2020 10:31:07], [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=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8',
  duration = '0.869',
  merge_duration = '0.003',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '5.90',
  system_load_5_min = '3.30',
  system_load_15_min = '2.41',
  system_memory_usage = '92.84',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '353') + '8148264',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '353';
[07/29/2020 10:33:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-29 10:33:02',login_attempt=0 where id = '25';
[07/29/2020 10:33:02], [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-07-29 10:33:02', ip = '60.254.44.39', action = 'Login' ;
[07/29/2020 10:33:24], [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.44.39' , city = 'bentota' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/29' , departure_date = '2020/07/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-29 10:33:24' , site_id = '' , country_code = '132' , web_service = '' ;
[07/29/2020 10:33: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-07-29 10:33:28', '', '60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8', '354');
[07/29/2020 10:33:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8&xml_user_id=25&request_no=0&local_hotel_code=100&#039;,&#039;53704&#039;,&#039;53707&web_service=no&site_id='
, http_hit_time = '2020-07-29 10:33:27.204'
, 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.337'
, error_description = ''
, memory_used = '7941808'
WHERE id = '2931';
[07/29/2020 10:33:28], [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=60f3bddb80ba9fe952bccdfebe3403a3e1c4c8741a8309b46d5ae4646e4bfec8',
  duration = '1.632',
  merge_duration = '0.003',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.06',
  system_load_5_min = '2.26',
  system_load_15_min = '2.15',
  system_memory_usage = '92.78',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '354') + '8147976',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '354';
[07/29/2020 10:38:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-29 10:38:49',login_attempt=0 where id = '21';
[07/29/2020 10:38:49], [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-07-29 10:38:49', ip = '45.120.147.56', action = 'Login' ;
[07/29/2020 10:41:37], [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 = '45.120.147.56' , city = 'bentota' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/29' , departure_date = '2020/07/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-29 10:41:37' , site_id = '' , country_code = '132' , web_service = '' ;
[07/29/2020 10:41:45], [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-07-29 10:41:45', '', '24923b1e1519b0887f62556464faf48902e476a9807557c62351224260e52c39', '355');
[07/29/2020 10:41:46], [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=21&request_no=0&local_hotel_code=100&#039;,&#039;53704&#039;,&#039;53707&web_service=no&site_id='
, http_hit_time = '2020-07-29 10:41:44.747'
, 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.409'
, error_description = ''
, memory_used = '8019016'
WHERE id = '2932';
[07/29/2020 10:41:46], [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=24923b1e1519b0887f62556464faf48902e476a9807557c62351224260e52c39',
  duration = '1.900',
  merge_duration = '0.148',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.76',
  system_load_5_min = '2.01',
  system_load_15_min = '2.03',
  system_memory_usage = '92.84',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '355') + '8148544',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '355';
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `psa_users` set  `id`='SnehalUAT', `lname`='Valanju', `mname`='', `fname`='Snehal', `email`='snehal.valanju@qtechsoftware.com', `time_zone_offset`='5.5', `phone`='123', `connection`='', `pass`='9562ab9e0476c1cf79a1f93dd9f8ecf4', `hash`='418e8ef41dc143a08018ba949e181e5d', `user_type`='admin', `active`='Y', `can_debug`='', `allow_book_under_cancellation`='', `allow_cancellation_after_voucher`='', `all_bookings`='branch_booking', `is_booking_email_received`='1', `updated`='2020-07-29 10:48:29', `created_by`='tfg', `create_date`='2020-07-29 10:48:29', `site_id`='',`consultant_acc_id`='',`consultant_image`='',`messenger_type`='',`messenger_id`='',`user_description`='',`cal_hashcode`='8f191fc6d477192497538444e1fbd80dccf43dbc178b5696a1888ae1bcdf79d2',`designation`='';
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into psa_pass_recover set  id = '418e8ef41dc143a08018ba949e181e5d' ;
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],DELETE FROM consultant_branches WHERE consultant_id ='SnehalUAT';
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT 'SnehalUAT','1','2020-07-29 10:48:29','2020-07-29 10:48:29';
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],update psa_users set groups='8' where id='SnehalUAT';
[07/29/2020 10:48:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 10:48:29',`log_type`= 'User',`sql_query`= 'INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT \&#039;SnehalUAT\&#039;,\&#039;1\&#039;,\&#039;2020-07-29 10:48:29\&#039;,\&#039;2020-07-29 10:48:29\&#039;',`log_description`= 'User added For  -id=SnehalUAT&groups=8&lname=Valanju&fname=Snehal&mname=&email=snehal.valanju%40qtechsoftware.com&time_zone_offset=5.5&enable_dst=0&phone=123&pass=&hash=418e8ef41dc143a08018ba949e181e5d&active=Y&connection=&lockcount=0&expiration=&updated=2020-07-29+10%3A48%3A29&branch_id=0&department_id=0&messenger_type=&allow_book_under_cancellation=&allow_cancellation_after_voucher=&all_bookings=branch_booking&site_id=0&user_type=admin&created_by=tfg&create_date=2020-07-29+10%3A48%3A29&consultant_acc_id=&consultant_image=&cal_hashcode=8f191fc6d477192497538444e1fbd80dccf43dbc178b5696a1888ae1bcdf79d2&is_booking_email_received=1&messenger_id=&user_description=&can_debug=&designation=',`ip`= '60.254.44.39';
[07/29/2020 10:48:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/profile_access.php],update psa_users set groups='8' where id='SnehalUAT';
[07/29/2020 10:48:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/profile_access.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-29 10:48:44',`log_type`= 'User',`sql_query`= '',`log_description`= 'User SnehalUAT has been Updated. Previous Details -  id-8 ## name- Super Admin ',`ip`= '60.254.44.39';
