[05/13/2024 07:02:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:02:57' WHERE id= '884';
[05/13/2024 07:03:10], [file name :-/efsdata/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:03:10' WHERE id= '883';
[05/13/2024 07:03:13], [file name :-/efsdata/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:03:13' WHERE id= '883';
[05/13/2024 07:07:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:07:43' WHERE id= '884';
[05/13/2024 07:07:48], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:07:48' WHERE id= '883';
[05/13/2024 07:07:48], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-13 07:07:48' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/13/2024 07:07:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:07:49' WHERE id= '883';
[05/13/2024 07:07:49], [file name :-/efsdata/otrams/public_html/beta/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', '2024-05-13 07:07:49', '', '1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396', '1723');
[05/13/2024 07:07:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-13 07:07:49.574'
        , request_start_time = '0.028'
        , parsing_start_time = '0.020'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.096'
        , search_end_time = '0.010'
        , total_duration = '0.190'
        , error_description = ''
        , memory_used = '4991136'
        WHERE id = '546553';
[05/13/2024 07:07:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396',
        duration = '0.329',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.48',
        system_load_5_min = '1.59',
        system_load_15_min = '0.91',
        system_memory_usage = '7.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1723') + '3808152',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1723';
[05/13/2024 07:07:50], [file name :-/efsdata/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:07:50' WHERE id= '883';
[05/13/2024 07:07:52], [file name :-/efsdata/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:07:52' WHERE id= '883';
[05/13/2024 07:08:04], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:08:04' WHERE id= '884';
[05/13/2024 07:08:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:08:22' WHERE id= '884';
[05/13/2024 07:08:25], [file name :-/efsdata/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:08:25' WHERE id= '883';
[05/13/2024 07:08:27], [file name :-/efsdata/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:08:27' WHERE id= '883';
[05/13/2024 07:08:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:08:49' WHERE id= '884';
[05/13/2024 07:09:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:09:14' WHERE id= '884';
[05/13/2024 07:09:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:09:42' WHERE id= '884';
[05/13/2024 07:10:17], [file name :-/efsdata/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:17' WHERE id= '883';
[05/13/2024 07:10:19], [file name :-/efsdata/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:19' WHERE id= '883';
[05/13/2024 07:10:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:22' WHERE id= '884';
[05/13/2024 07:10:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:23' WHERE id= '883';
[05/13/2024 07:10:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-13 07:10:23' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:24' WHERE id= '883';
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:24' WHERE id= '884';
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/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', '2024-05-13 07:10:24', '', '1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396', '1724');
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-13 07:10:24.86'
        , request_start_time = '0.012'
        , parsing_start_time = '0.013'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.033'
        , search_end_time = '0.008'
        , total_duration = '0.101'
        , error_description = ''
        , memory_used = '1396328'
        WHERE id = '546554';
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=1da1c99f96cdde0c72cc9b3f2645f2647d8bfefa3fb6245a5aff4e5ec7845396',
        duration = '0.157',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.21',
        system_load_5_min = '1.04',
        system_load_15_min = '0.81',
        system_memory_usage = '7.49',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1724') + '1741624',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1724';
[05/13/2024 07:10:24], [file name :-/efsdata/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:24' WHERE id= '883';
[05/13/2024 07:10:26], [file name :-/efsdata/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:26' WHERE id= '883';
[05/13/2024 07:10:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:10:50' WHERE id= '884';
[05/13/2024 07:11:34], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:11:34' WHERE id= '884';
[05/13/2024 07:12:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:12:03' WHERE id= '884';
[05/13/2024 07:12:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:12:56' WHERE id= '884';
[05/13/2024 07:15:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-13 07:15:25' WHERE id= '884';
