[07/10/2020 12:00:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382434','150.129.30.138');
[07/10/2020 12:05:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382714','150.129.30.138');
[07/10/2020 12:05:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382728','150.129.30.138');
[07/10/2020 12:06:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594382786','150.129.30.138');
[07/10/2020 12:06:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:06:27','');
[07/10/2020 12:26:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594383982','150.129.30.138');
[07/10/2020 12:26:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:26:22','');
[07/10/2020 12:26:48], [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 = '150.129.30.138' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/23' , departure_date = '2020/07/24' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-10 12:26:48' , site_id = '' , country_code = '106' , web_service = '' ;
[07/10/2020 12:26:51], [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-10 12:26:51', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '338');
[07/10/2020 12:26:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&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&web_service=no&site_id='
, http_hit_time = '2020-07-10 12:26:50.429'
, 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.814'
, error_description = ''
, memory_used = '8021096'
WHERE id = '2875';
[07/10/2020 12:26:52], [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=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.377',
  merge_duration = '0.128',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.94',
  system_load_5_min = '1.33',
  system_load_15_min = '1.75',
  system_memory_usage = '91.03',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '338') + '8149272',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '338';
[07/10/2020 12:27:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384036','150.129.30.138');
[07/10/2020 12:27:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:27:16','');
[07/10/2020 12:31:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384314','150.129.30.138');
[07/10/2020 12:31:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:31:54','');
[07/10/2020 12:34:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384445','150.129.30.138');
[07/10/2020 12:34:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:34:05','');
[07/10/2020 12:35:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384521','150.129.30.138');
[07/10/2020 12:35:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hyatt Mumbai Prime', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-10 :12:35:21','');
[07/10/2020 12:35:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384546','150.129.30.138');
[07/10/2020 12:37:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384667','150.129.30.138');
[07/10/2020 12:39:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384746','150.129.30.138');
[07/10/2020 12:39:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594384795','150.129.30.138');
[07/10/2020 12:48:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594385298','150.129.30.138');
[07/10/2020 12:52:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594385579','150.129.30.138');
[07/10/2020 12:53:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594385620','150.129.30.138');
