[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-23',to_date='2021-01-23',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-24',to_date='2021-01-24',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-25',to_date='2021-01-25',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-26',to_date='2021-01-26',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-27',to_date='2021-01-27',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-28',to_date='2021-01-28',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-29',to_date='2021-01-29',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-30',to_date='2021-01-30',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-31',to_date='2021-01-31',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-01',to_date='2021-02-01',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-02',to_date='2021-02-02',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-03',to_date='2021-02-03',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-04',to_date='2021-02-04',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-05',to_date='2021-02-05',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-06',to_date='2021-02-06',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-07',to_date='2021-02-07',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-08',to_date='2021-02-08',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-09',to_date='2021-02-09',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-10',to_date='2021-02-10',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-11',to_date='2021-02-11',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-12',to_date='2021-02-12',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-13',to_date='2021-02-13',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-14',to_date='2021-02-14',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-15',to_date='2021-02-15',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-16',to_date='2021-02-16',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-17',to_date='2021-02-17',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-18',to_date='2021-02-18',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-19',to_date='2021-02-19',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-20',to_date='2021-02-20',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-21',to_date='2021-02-21',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-02-22',to_date='2021-02-22',supplier_id='S000000236',hotel_id='53767',room_basis_id='1',room_class_id='1074',child_no='',adult_wb_rate='20',adult_wb_weekend_rate='20',adult_display= 'yes';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2021-01-23 11:09:42',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For Malang added successfully for Room Category :- Superior Room - Double, Extrabed - 1(Bed & Breakfast) From :- 23-01-2021 To :- 22-02-2021',`ip`= '60.254.11.54',`username`= 'tfg',`user_id`= 'S000000236';
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4088', `entity`='Hotels', `value`='53767' ;
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4088', `entity`='Suppliers', `value`='S000000236' ;
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4088', `entity`='Inventory', `value`='20' ;
[01/23/2021 11:09:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4088', `entity`='Room', `value`='1074' ;
[01/23/2021 11:09: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 = '60.254.11.54' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/01/24' , departure_date = '2021/01/25' , nationality = '106' , nights = '1' , room_types = '3' , create_date = '2021-01-23 11:09:53' , site_id = '' , country_code = '106' , web_service = '' ;
[01/23/2021 11:09: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', '2021-01-23 11:09:56', '', 'b5336e211c7f4c834d1901b77cd286f1701e8df4eacdf2cb11176b95b083c345', '530');
[01/23/2021 11:09: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', '2021-01-23 11:09:56', '', 'b5336e211c7f4c834d1901b77cd286f1701e8df4eacdf2cb11176b95b083c345', '530');
[01/23/2021 11:09:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b5336e211c7f4c834d1901b77cd286f1701e8df4eacdf2cb11176b95b083c345&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;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&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2021-01-23 11:09:55.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.095'
, error_description = ''
, memory_used = '7910072'
WHERE id = '3398';
[01/23/2021 11:09:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b5336e211c7f4c834d1901b77cd286f1701e8df4eacdf2cb11176b95b083c345&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&#039;,&#039;53780&#039;,&#039;53781&#039;,&#039;53782&web_service=no&site_id='
, http_hit_time = '2021-01-23 11:09:55.674'
, 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.248'
, error_description = ''
, memory_used = '7908728'
WHERE id = '3397';
[01/23/2021 11:09: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=b5336e211c7f4c834d1901b77cd286f1701e8df4eacdf2cb11176b95b083c345',
  duration = '1.746',
  merge_duration = '0.074',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.33',
  system_load_5_min = '0.74',
  system_load_15_min = '0.96',
  system_memory_usage = '92.54',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '530') + '8043224',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '530';
