[04/18/2024 07:08:04], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:08:04' WHERE id= '792';
[04/18/2024 07:08:04], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:08:04' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:08:05], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:08:05' WHERE id= '792';
[04/18/2024 07:08:05], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:08:05' WHERE id= '792';
[04/18/2024 07:08:07], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:08:07' WHERE id= '792';
[04/18/2024 07:09:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:09:01' WHERE id= '792';
[04/18/2024 07:09:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:09:01' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:09:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:09:01' WHERE id= '792';
[04/18/2024 07:09:01], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:09:01' WHERE id= '792';
[04/18/2024 07:09:03], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:09:03' WHERE id= '792';
[04/18/2024 07:10:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:10:04' WHERE id= '793';
[04/18/2024 07:10:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:10:04',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:10:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_04_1713424204.json', 'viator', '2024-04-18 07:10:04', '', '', '1132');
[04/18/2024 07:10:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_04_1713424204.json', 'viator', '2024-04-18 07:10:04', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_04_1713424204.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_04_1713424204.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_10_05_1713424205.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_10_05_1713424205.json', 'viator', '2024-04-18 07:10:05', '', '', '1132');
[04/18/2024 07:10:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:10:34' WHERE id= '792';
[04/18/2024 07:10:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:10:34' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:10:34], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:10:34' WHERE id= '792';
[04/18/2024 07:10:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:10:35' WHERE id= '792';
[04/18/2024 07:10:36], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:10:36' WHERE id= '792';
[04/18/2024 07:11:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:11:57' WHERE id= '792';
[04/18/2024 07:12:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:12:12' WHERE id= '791';
[04/18/2024 07:12:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:12:12' WHERE id= '791';
[04/18/2024 07:12:13], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:12:13' WHERE id= '791';
[04/18/2024 07:12:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:12:13' WHERE id= '791';
[04/18/2024 07:12:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:12:28' WHERE id= '791';
[04/18/2024 07:14:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:14:27' WHERE id= '793';
[04/18/2024 07:14:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:14:27',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:14:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_27_1713424467.json', 'viator', '2024-04-18 07:14:27', '', '', '1134');
[04/18/2024 07:14:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_27_1713424467.json', 'viator', '2024-04-18 07:14:27', '', '', '1134');
[04/18/2024 07:14:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_27_1713424467.json', 'viator', '2024-04-18 07:14:27', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_27_1713424467.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_27_1713424467.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:28', '', '', '1134');
[04/18/2024 07:14:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_14_28_1713424468.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_14_28_1713424468.json', 'viator', '2024-04-18 07:14:29', '', '', '1134');
[04/18/2024 07:17:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:17:08], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:17:08',login_attempt=0 where id = '7851';
[04/18/2024 07:17:08], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:17:08', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:17:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:17:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '791';
[04/18/2024 07:17:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '791';
[04/18/2024 07:17:22], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:17:22',login_attempt=0 where id = '7851';
[04/18/2024 07:17:22], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:17:22', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:17:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:18:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:18:12',login_attempt=0 where id = '7851';
[04/18/2024 07:18:12], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:18:12', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:18:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:19:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:19:03',login_attempt=0 where id = '7851';
[04/18/2024 07:19:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:19:03', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:19:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:20:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:20:31',login_attempt=0 where id = '7851';
[04/18/2024 07:20:31], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:20:31', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:20:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:20:55], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-04-18 07:20:55' , ip = '103.104.226.130' , action = 'Logout'  ;
[04/18/2024 07:21:30], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:21:30',login_attempt=0 where id = '7851';
[04/18/2024 07:21:30], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:21:30', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:21:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:21:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:21:48',login_attempt=0 where id = '7851';
[04/18/2024 07:21:48], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:21:48', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:21:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:22:42], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:22:42',login_attempt=0 where id = '7851';
[04/18/2024 07:22:42], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:22:42', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:22:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='103.104.226.130', agent_id='7851', session_id='2eee995333e6294bc0e603c8dc2120e56e16f4d69b2751935d8b1197d651991a',create_date='2024-04-18 07:22:42', update_date='2024-04-18 07:22:42',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 07:22:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:22:47' WHERE id= '794';
[04/18/2024 07:23:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:23:05',login_attempt=0 where id = '7851';
[04/18/2024 07:23:05], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 07:23:05', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:23:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '793';
[04/18/2024 07:23:39], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-04-18 07:23:39' , ip = '103.104.226.130' , action = 'Logout'  ;
[04/18/2024 07:23:45], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:23:45' WHERE id= '794';
[04/18/2024 07:23:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:23:51' WHERE id= '794';
[04/18/2024 07:23:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:23:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:23:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_51_1713425031.json', 'viator', '2024-04-18 07:23:51', '', '', '1135');
[04/18/2024 07:23:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_51_1713425031.json', 'viator', '2024-04-18 07:23:51', '', '', '1135');
[04/18/2024 07:23:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_51_1713425031.json', 'viator', '2024-04-18 07:23:51', '', '', '1135');
[04/18/2024 07:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_51_1713425031.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_51_1713425031.json', 'viator', '2024-04-18 07:23:52', '', '', '1135');
[04/18/2024 07:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_52_1713425032.json', 'viator', '2024-04-18 07:23:52', '', '', '1135');
[04/18/2024 07:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_52_1713425032.json', 'viator', '2024-04-18 07:23:52', '', '', '1135');
[04/18/2024 07:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_52_1713425032.json', 'viator', '2024-04-18 07:23:52', '', '', '1135');
[04/18/2024 07:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_52_1713425032.json', 'viator', '2024-04-18 07:23:52', '', '', '1135');
[04/18/2024 07:23:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_52_1713425032.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_52_1713425032.json', 'viator', '2024-04-18 07:23:53', '', '', '1135');
[04/18/2024 07:23:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_23_53_1713425033.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_23_53_1713425033.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_23_53_1713425033.json', 'viator', '2024-04-18 07:23:53', '', '', '1135');
[04/18/2024 07:24:03], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '792';
[04/18/2024 07:24:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:24:03',login_attempt=0 where id = '7867';
[04/18/2024 07:24:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 07:24:03', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:24:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:24:46',login_attempt=0 where id = '7867';
[04/18/2024 07:24:46], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 07:24:46', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:24:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '792';
[04/18/2024 07:25:02], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:25:02',login_attempt=0 where id = '7867';
[04/18/2024 07:25:02], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 07:25:02', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:25:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '792';
[04/18/2024 07:25:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:25:11' WHERE id= '794';
[04/18/2024 07:25:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:25:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:25:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_11_1713425111.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_11_1713425111.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_11_1713425111.json', 'viator', '2024-04-18 07:25:11', '', '', '1136');
[04/18/2024 07:25:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_11_1713425111.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_11_1713425111.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_11_1713425111.json', 'viator', '2024-04-18 07:25:12', '', '', '1136');
[04/18/2024 07:25:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_12_1713425112.json', 'viator', '2024-04-18 07:25:12', '', '', '1136');
[04/18/2024 07:25:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_12_1713425112.json', 'viator', '2024-04-18 07:25:12', '', '', '1136');
[04/18/2024 07:25:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_12_1713425112.json', 'viator', '2024-04-18 07:25:12', '', '', '1136');
[04/18/2024 07:25:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_12_1713425112.json', 'viator', '2024-04-18 07:25:12', '', '', '1136');
[04/18/2024 07:25:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_12_1713425112.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_12_1713425112.json', 'viator', '2024-04-18 07:25:13', '', '', '1136');
[04/18/2024 07:25:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_13_1713425113.json', 'viator', '2024-04-18 07:25:13', '', '', '1136');
[04/18/2024 07:25:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_13_1713425113.json', 'viator', '2024-04-18 07:25:13', '', '', '1136');
[04/18/2024 07:25:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_25_13_1713425113.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_25_13_1713425113.json', 'viator', '2024-04-18 07:25:13', '', '', '1136');
[04/18/2024 07:26:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:26:57',login_attempt=0 where id = '7867';
[04/18/2024 07:26:57], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 07:26:57', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:26:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='103.104.226.130', agent_id='7867', session_id='2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',create_date='2024-04-18 07:26:58', update_date='2024-04-18 07:26:58',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 07:27:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:27:43' WHERE id= '794';
[04/18/2024 07:27:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:27:43',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:27:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_43_1713425263.json', 'viator', '2024-04-18 07:27:43', '', '', '1137');
[04/18/2024 07:27:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_43_1713425263.json', 'viator', '2024-04-18 07:27:43', '', '', '1137');
[04/18/2024 07:27:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_43_1713425263.json', 'viator', '2024-04-18 07:27:43', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_43_1713425263.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_43_1713425263.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:27:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_27_44_1713425264.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_27_44_1713425264.json', 'viator', '2024-04-18 07:27:44', '', '', '1137');
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:28:01' WHERE id= '794';
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:28:01',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:01', '', '', '1138');
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:01', '', '', '1138');
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:01', '', '', '1138');
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:01', '', '', '1138');
[04/18/2024 07:28:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:01', '', '', '1138');
[04/18/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_01_1713425281.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_01_1713425281.json', 'viator', '2024-04-18 07:28:02', '', '', '1138');
[04/18/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_02_1713425282.json', 'viator', '2024-04-18 07:28:02', '', '', '1138');
[04/18/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_02_1713425282.json', 'viator', '2024-04-18 07:28:02', '', '', '1138');
[04/18/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_02_1713425282.json', 'viator', '2024-04-18 07:28:02', '', '', '1138');
[04/18/2024 07:28:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_02_1713425282.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_02_1713425282.json', 'viator', '2024-04-18 07:28:02', '', '', '1138');
[04/18/2024 07:28:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:28:13' WHERE id= '794';
[04/18/2024 07:28:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:28:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:28:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_13_1713425293.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_13_1713425293.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_13_1713425293.json', 'viator', '2024-04-18 07:28:13', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_13_1713425293.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_13_1713425293.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_13_1713425293.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:14', '', '', '1139');
[04/18/2024 07:28:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_28_14_1713425294.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_28_14_1713425294.json', 'viator', '2024-04-18 07:28:15', '', '', '1139');
[04/18/2024 07:29:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:07' WHERE id= '795';
[04/18/2024 07:29:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:07' WHERE id= '795';
[04/18/2024 07:29:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:09' WHERE id= '795';
[04/18/2024 07:29:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:19' WHERE id= '795';
[04/18/2024 07:29:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.104.226.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:29:19' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:29:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:20' WHERE id= '795';
[04/18/2024 07:29:21], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1140_1713425360_50.json', 'e1p/18_04_2024/response_availability_hotel_yards_1140_1713425360_50.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1140_1713425360_50.json', 'expediapackage', '2024-04-18 07:29:21', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1140');
[04/18/2024 07:29:21], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1140_1713425360_52.json', 'e1p/18_04_2024/response_availability_hotel_yards_1140_1713425360_52.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1140_1713425360_52.json', 'expediapackage', '2024-04-18 07:29:21', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1140');
[04/18/2024 07:29:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:29:20.613'
        , 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.274'
        , error_description = ''
        , memory_used = '16614392'
        WHERE id = '113897';
[04/18/2024 07:29:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:29:20.614'
        , 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.308'
        , error_description = ''
        , memory_used = '35343688'
        WHERE id = '113896';
[04/18/2024 07:29:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '1.424',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.44',
        system_load_5_min = '7.12',
        system_load_15_min = '7.86',
        system_memory_usage = '75.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1140') + '2475208',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1140';
[04/18/2024 07:29:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:22' WHERE id= '795';
[04/18/2024 07:29:27], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:27' WHERE id= '795';
[04/18/2024 07:29:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:35' WHERE id= '795';
[04/18/2024 07:29:36], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1140_1713425375_71.json', 'e1p/18_04_2024/response_availability_hotel_yards_1140_1713425375_71.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1140_1713425375_71.json', 'expediapackage', '2024-04-18 07:29:36', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1140');
[04/18/2024 07:29:36], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1140_1713425375_97.json', 'e1p/18_04_2024/response_availability_hotel_yards_1140_1713425375_97.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1140_1713425375_97.json', 'expediapackage', '2024-04-18 07:29:36', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1140');
[04/18/2024 07:29:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:29:35.246'
        , 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.955'
        , error_description = ''
        , memory_used = '16637104'
        WHERE id = '113898';
[04/18/2024 07:29:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:29:35.247'
        , 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.242'
        , error_description = ''
        , memory_used = '35345944'
        WHERE id = '113899';
[04/18/2024 07:29:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '1.325',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.52',
        system_load_5_min = '6.79',
        system_load_15_min = '7.74',
        system_memory_usage = '75.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1140') + '2536472',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1140';
[04/18/2024 07:29:58], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:58' WHERE id= '795';
[04/18/2024 07:29:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:29:58' WHERE id= '795';
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:06' WHERE id= '794';
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:30:06',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:06', '', '', '1141');
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:06', '', '', '1141');
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:06', '', '', '1141');
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:06', '', '', '1141');
[04/18/2024 07:30:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:06', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_06_1713425406.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_06_1713425406.json', 'viator', '2024-04-18 07:30:07', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_07_1713425407.json', 'viator', '2024-04-18 07:30:07', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_07_1713425407.json', 'viator', '2024-04-18 07:30:07', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_07_1713425407.json', 'viator', '2024-04-18 07:30:07', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_30_07_1713425407.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_30_07_1713425407.json', 'viator', '2024-04-18 07:30:07', '', '', '1141');
[04/18/2024 07:30:07], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:07' WHERE id= '795';
[04/18/2024 07:30:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:15' WHERE id= '795';
[04/18/2024 07:30:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.104.226.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:30:15' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:30:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:16' WHERE id= '795';
[04/18/2024 07:30:17], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1142_1713425416_90.json', 'e1p/18_04_2024/response_availability_hotel_yards_1142_1713425416_90.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1142_1713425416_90.json', 'expediapackage', '2024-04-18 07:30:17', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1142');
[04/18/2024 07:30:17], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1142_1713425416_1.json', 'e1p/18_04_2024/response_availability_hotel_yards_1142_1713425416_1.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1142_1713425416_1.json', 'expediapackage', '2024-04-18 07:30:17', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1142');
[04/18/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:16.487'
        , 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.906'
        , error_description = ''
        , memory_used = '16601800'
        WHERE id = '113910';
[04/18/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:16.487'
        , 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.237'
        , error_description = ''
        , memory_used = '35315168'
        WHERE id = '113911';
[04/18/2024 07:30:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '1.309',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.90',
        system_load_5_min = '5.91',
        system_load_15_min = '7.40',
        system_memory_usage = '75.24',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1142') + '2475656',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1142';
[04/18/2024 07:30:18], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:18' WHERE id= '795';
[04/18/2024 07:30:24], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:24' WHERE id= '795';
[04/18/2024 07:30:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:31' WHERE id= '795';
[04/18/2024 07:30:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.104.226.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:30:31' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:30:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:32' WHERE id= '795';
[04/18/2024 07:30:33], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1143_1713425432_55.json', 'e1p/18_04_2024/response_availability_hotel_yards_1143_1713425432_55.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1143_1713425432_55.json', 'expediapackage', '2024-04-18 07:30:33', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1143');
[04/18/2024 07:30:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:32.565'
        , 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.901'
        , error_description = ''
        , memory_used = '16614168'
        WHERE id = '113912';
[04/18/2024 07:30:33], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1143_1713425432_39.json', 'e1p/18_04_2024/response_availability_hotel_yards_1143_1713425432_39.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1143_1713425432_39.json', 'expediapackage', '2024-04-18 07:30:33', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1143');
[04/18/2024 07:30:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:32.564'
        , 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.319'
        , error_description = ''
        , memory_used = '35343992'
        WHERE id = '113913';
[04/18/2024 07:30:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '1.396',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.48',
        system_load_5_min = '5.62',
        system_load_15_min = '7.28',
        system_memory_usage = '75.16',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1143') + '2475304',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1143';
[04/18/2024 07:30:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:34' WHERE id= '795';
[04/18/2024 07:30:39], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:39' WHERE id= '795';
[04/18/2024 07:30:40], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1143_1713425439_23.json', 'e1p/18_04_2024/response_availability_hotel_yards_1143_1713425439_23.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1143_1713425439_23.json', 'expediapackage', '2024-04-18 07:30:40', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1143');
[04/18/2024 07:30:40], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1143_1713425439_84.json', 'e1p/18_04_2024/response_availability_hotel_yards_1143_1713425439_84.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1143_1713425439_84.json', 'expediapackage', '2024-04-18 07:30:40', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1143');
[04/18/2024 07:30:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:39.286'
        , 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.922'
        , error_description = ''
        , memory_used = '16649024'
        WHERE id = '113914';
[04/18/2024 07:30:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:30:39.286'
        , 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.251'
        , error_description = ''
        , memory_used = '35352136'
        WHERE id = '113915';
[04/18/2024 07:30:40], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '1.340',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.36',
        system_load_5_min = '5.53',
        system_load_15_min = '7.24',
        system_memory_usage = '75.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1143') + '2535224',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1143';
[04/18/2024 07:30:40], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:40' WHERE id= '795';
[04/18/2024 07:30:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:30:46' WHERE id= '795';
[04/18/2024 07:31:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:31:40' WHERE id= '795';
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:32:58' WHERE id= '794';
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:32:58',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:58', '', '', '1144');
[04/18/2024 07:32:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_58_1713425578.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_58_1713425578.json', 'viator', '2024-04-18 07:32:59', '', '', '1144');
[04/18/2024 07:32:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_32_59_1713425579.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_32_59_1713425579.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_32_59_1713425579.json', 'viator', '2024-04-18 07:32:59', '', '', '1144');
[04/18/2024 07:33:47], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:33:47' WHERE id= '795';
[04/18/2024 07:33:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:33:54' WHERE id= '795';
[04/18/2024 07:34:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:34:14' WHERE id= '794';
[04/18/2024 07:34:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:34:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:34:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_14_1713425654.json', 'viator', '2024-04-18 07:34:14', '', '', '1145');
[04/18/2024 07:34:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_14_1713425654.json', 'viator', '2024-04-18 07:34:14', '', '', '1145');
[04/18/2024 07:34:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_14_1713425654.json', 'viator', '2024-04-18 07:34:14', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_14_1713425654.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_14_1713425654.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_34_15_1713425655.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_34_15_1713425655.json', 'viator', '2024-04-18 07:34:15', '', '', '1145');
[04/18/2024 07:34:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:34:16' WHERE id= '795';
[04/18/2024 07:34:18], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:34:18' WHERE id= '795';
[04/18/2024 07:35:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:35:31' WHERE id= '795';
[04/18/2024 07:35:42], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:35:42' WHERE id= '795';
[04/18/2024 07:35:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:35:45' WHERE id= '795';
[04/18/2024 07:36:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:36:51' WHERE id= '795';
[04/18/2024 07:36:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:36:55' WHERE id= '795';
[04/18/2024 07:37:18], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:37:18' WHERE id= '795';
[04/18/2024 07:37:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:37:21' WHERE id= '795';
[04/18/2024 07:45:43], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18' , login_datetime = '2024-04-18 07:45:43' , ip = '103.104.226.130' , action = 'Logout'  ;
[04/18/2024 07:46:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 07:46:19',login_attempt=0 where id = '7868';
[04/18/2024 07:46:19], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '32', login_datetime = '2024-04-18 07:46:19', ip = '103.104.226.130', action = 'Login' ;
[04/18/2024 07:46:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='103.104.226.130', agent_id='7867', session_id='00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f',create_date='2024-04-18 07:46:20', update_date='2024-04-18 07:46:20',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 07:46:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:46:31' WHERE id= '794';
[04/18/2024 07:46:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '103.104.226.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :07:46:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 07:46:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_31_1713426391.json', 'viator', '2024-04-18 07:46:31', '', '', '1146');
[04/18/2024 07:46:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_31_1713426391.json', 'viator', '2024-04-18 07:46:31', '', '', '1146');
[04/18/2024 07:46:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_31_1713426391.json', 'viator', '2024-04-18 07:46:31', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_31_1713426391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_31_1713426391.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:46:32' WHERE id= '796';
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_sight_details_Viator_test_07_46_32_1713426392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_07_46_32_1713426392.json', 'viator', '2024-04-18 07:46:32', '', '', '1146');
[04/18/2024 07:46:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:46:41' WHERE id= '796';
[04/18/2024 07:46:41], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:46:41' WHERE id= '796';
[04/18/2024 07:46:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:46:42' WHERE id= '796';
[04/18/2024 07:47:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:09' WHERE id= '796';
[04/18/2024 07:47:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:09' WHERE id= '796';
[04/18/2024 07:47:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:17' WHERE id= '796';
[04/18/2024 07:47:17], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:17' WHERE id= '796';
[04/18/2024 07:47:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:17' WHERE id= '796';
[04/18/2024 07:47:30], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:30' WHERE id= '796';
[04/18/2024 07:47:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:44' WHERE id= '796';
[04/18/2024 07:47:45], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:45' WHERE id= '796';
[04/18/2024 07:47:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:47:45' WHERE id= '796';
[04/18/2024 07:48:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:10' WHERE id= '796';
[04/18/2024 07:48:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:18' WHERE id= '796';
[04/18/2024 07:48:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:48:18' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:48:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:30' WHERE id= '796';
[04/18/2024 07:48:31], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426511_36.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426511_36.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426511_36.json', 'expediapackage', '2024-04-18 07:48:31', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:31.254'
        , 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.669'
        , error_description = ''
        , memory_used = '2163048'
        WHERE id = '113946';
[04/18/2024 07:48:33], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426511_47.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426511_47.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426511_47.json', 'expediapackage', '2024-04-18 07:48:33', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:33], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426511_46.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426511_46.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426511_46.json', 'expediapackage', '2024-04-18 07:48:33', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:31.263'
        , 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 = '9.080'
        , error_description = ''
        , memory_used = '178988968'
        WHERE id = '113948';
[04/18/2024 07:48:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:31.254'
        , 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 = '10.573'
        , error_description = ''
        , memory_used = '211404976'
        WHERE id = '113947';
[04/18/2024 07:48:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f',
        duration = '11.121',
        merge_duration = '0.019',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '13.29',
        system_load_5_min = '10.16',
        system_load_15_min = '9.33',
        system_memory_usage = '80.03',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1147') + '2551840',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1147';
[04/18/2024 07:48:42], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:42' WHERE id= '796';
[04/18/2024 07:48:42], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:42' WHERE id= '796';
[04/18/2024 07:48:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:42' WHERE id= '796';
[04/18/2024 07:48:43], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426523_55.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426523_55.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426523_55.json', 'expediapackage', '2024-04-18 07:48:43', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:43.327'
        , 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.622'
        , error_description = ''
        , memory_used = '2163048'
        WHERE id = '113949';
[04/18/2024 07:48:45], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426523_85.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426523_85.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426523_85.json', 'expediapackage', '2024-04-18 07:48:45', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:45], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1147_1713426523_92.json', 'e1p/18_04_2024/response_availability_hotel_yards_1147_1713426523_92.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1147_1713426523_92.json', 'expediapackage', '2024-04-18 07:48:45', '', '00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f', '1147');
[04/18/2024 07:48:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:43.368'
        , 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 = '7.485'
        , error_description = ''
        , memory_used = '179020016'
        WHERE id = '113951';
[04/18/2024 07:48:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:48:43.314'
        , 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 = '7.562'
        , error_description = ''
        , memory_used = '211343232'
        WHERE id = '113950';
[04/18/2024 07:48:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=00002cb2224a507e70db8e01a787e7625a2e41a7abe1663b4193ad85eb8f9b9f',
        duration = '8.218',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '27.20',
        system_load_5_min = '13.37',
        system_load_15_min = '10.39',
        system_memory_usage = '81.71',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1147') + '2552512',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1147';
[04/18/2024 07:48:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:50' WHERE id= '796';
[04/18/2024 07:48:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:51' WHERE id= '796';
[04/18/2024 07:48:51], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:51' WHERE id= '796';
[04/18/2024 07:48:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:51' WHERE id= '796';
[04/18/2024 07:48:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:48:52' WHERE id= '796';
[04/18/2024 07:49:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:08' WHERE id= '796';
[04/18/2024 07:49:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:12' WHERE id= '795';
[04/18/2024 07:49:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:17' WHERE id= '795';
[04/18/2024 07:49:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 07:49:17' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 07:49:18], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:18' WHERE id= '795';
[04/18/2024 07:49:18], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426558_62.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426558_62.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426558_62.json', 'expediapackage', '2024-04-18 07:49:18', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:18.202'
        , 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.371'
        , error_description = ''
        , memory_used = '2086680'
        WHERE id = '113952';
[04/18/2024 07:49:19], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426558_5.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426558_5.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426558_5.json', 'expediapackage', '2024-04-18 07:49:19', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:19], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426558_89.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426558_89.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426558_89.json', 'expediapackage', '2024-04-18 07:49:19', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:18.201'
        , 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.966'
        , error_description = ''
        , memory_used = '166307536'
        WHERE id = '113953';
[04/18/2024 07:49:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:18.202'
        , 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 = '3.177'
        , error_description = ''
        , memory_used = '195746784'
        WHERE id = '113954';
[04/18/2024 07:49:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '3.273',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '26.99',
        system_load_5_min = '15.14',
        system_load_15_min = '11.11',
        system_memory_usage = '76.63',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1148') + '2475304',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1148';
[04/18/2024 07:49:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:21' WHERE id= '795';
[04/18/2024 07:49:21], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426561_28.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426561_28.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426561_28.json', 'expediapackage', '2024-04-18 07:49:21', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:21.516'
        , 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.250'
        , error_description = ''
        , memory_used = '2086680'
        WHERE id = '113955';
[04/18/2024 07:49:22], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426561_16.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426561_16.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426561_16.json', 'expediapackage', '2024-04-18 07:49:22', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:23], [file name :-/home/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', 'e1p/18_04_2024/request_availability_hotel_yards_1148_1713426561_22.json', 'e1p/18_04_2024/response_availability_hotel_yards_1148_1713426561_22.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1148_1713426561_22.json', 'expediapackage', '2024-04-18 07:49:23', '', '2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8', '1148');
[04/18/2024 07:49:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:21.516'
        , 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.944'
        , error_description = ''
        , memory_used = '165868336'
        WHERE id = '113957';
[04/18/2024 07:49:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=103.104.226.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 07:49:21.516'
        , 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 = '3.005'
        , error_description = ''
        , memory_used = '195937656'
        WHERE id = '113956';
[04/18/2024 07:49:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=2b911e47bbb6a9330a4bebaec2c1883173db8f62c205dfc244521015653721b8',
        duration = '3.112',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '26.99',
        system_load_5_min = '15.14',
        system_load_15_min = '11.11',
        system_memory_usage = '76.77',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1148') + '2476504',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1148';
[04/18/2024 07:49:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:24' WHERE id= '795';
[04/18/2024 07:49:25], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:25' WHERE id= '795';
[04/18/2024 07:49:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:25' WHERE id= '795';
[04/18/2024 07:49:28], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 07:49:28' WHERE id= '795';
