[03/22/2024 10:00:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:00:03' WHERE id= '681';
[03/22/2024 10:00:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101603','43.239.53.130');
[03/22/2024 10:00:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:00:25' WHERE id= '681';
[03/22/2024 10:00:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101625','43.239.53.130');
[03/22/2024 10:00:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:00:26' WHERE id= '681';
[03/22/2024 10:00:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4051','2024-03-22 10:00:26',0);
[03/22/2024 10:02:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:02:01' WHERE id= '681';
[03/22/2024 10:02:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101721','43.239.53.130');
[03/22/2024 10:02:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:02:03' WHERE id= '681';
[03/22/2024 10:02:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101723','43.239.53.130');
[03/22/2024 10:04:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:04:07' WHERE id= '681';
[03/22/2024 10:04:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101847','43.239.53.130');
[03/22/2024 10:04:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:04:31' WHERE id= '681';
[03/22/2024 10:04:33], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:04:33' WHERE id= '681';
[03/22/2024 10:04:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:04:43' WHERE id= '681';
[03/22/2024 10:04:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101883','43.239.53.130');
[03/22/2024 10:04:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:04:44' WHERE id= '681';
[03/22/2024 10:04:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4055','2024-03-22 10:04:44',0);
[03/22/2024 10:05:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:05:54' WHERE id= '681';
[03/22/2024 10:05:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101954','43.239.53.130');
[03/22/2024 10:06:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:12' WHERE id= '681';
[03/22/2024 10:06:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:19' WHERE id= '681';
[03/22/2024 10:06:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101979','43.239.53.130');
[03/22/2024 10:06:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:19' WHERE id= '681';
[03/22/2024 10:06:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4057','2024-03-22 10:06:19',0);
[03/22/2024 10:06:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:39' WHERE id= '681';
[03/22/2024 10:06:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711101999','43.239.53.130');
[03/22/2024 10:06:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:41' WHERE id= '681';
[03/22/2024 10:06:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102001','43.239.53.130');
[03/22/2024 10:06:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:06:59' WHERE id= '681';
[03/22/2024 10:06:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102019','43.239.53.130');
[03/22/2024 10:07:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:00' WHERE id= '681';
[03/22/2024 10:07:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4060','2024-03-22 10:07:00',0);
[03/22/2024 10:07:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:09' WHERE id= '681';
[03/22/2024 10:07:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102029','43.239.53.130');
[03/22/2024 10:07:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:10' WHERE id= '681';
[03/22/2024 10:07:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102030','43.239.53.130');
[03/22/2024 10:07:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:19' WHERE id= '681';
[03/22/2024 10:07:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:46' WHERE id= '681';
[03/22/2024 10:07:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102066','43.239.53.130');
[03/22/2024 10:07:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:07:47' WHERE id= '681';
[03/22/2024 10:07:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4063','2024-03-22 10:07:47',0);
[03/22/2024 10:08:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:50' WHERE id= '701';
[03/22/2024 10:08:50], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:50' WHERE id= '701';
[03/22/2024 10:08:50], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:50' WHERE id= '701';
[03/22/2024 10:08:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:56' WHERE id= '681';
[03/22/2024 10:08:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102136','43.239.53.130');
[03/22/2024 10:08:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:58' WHERE id= '681';
[03/22/2024 10:08:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102138','43.239.53.130');
[03/22/2024 10:08:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:59' WHERE id= '701';
[03/22/2024 10:08:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:08:59' WHERE id= '701';
[03/22/2024 10:09:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:09:15' WHERE id= '701';
[03/22/2024 10:09:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'agartala' , 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 = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-22 10:09:15' , site_id = '' , country_code = '106' , city_code = '64625' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/22/2024 10:09:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:09:16' WHERE id= '701';
[03/22/2024 10:09: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', 'e1/22_03_2024/request_availability_Gajendra_512_1711102157_58.json', 'e1/22_03_2024/response_availability_Gajendra_512_1711102157_58.json', 'e1/22_03_2024/response_header_availability_Gajendra_512_1711102157_58.json', 'expedia', '2024-03-22 10:09:17', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '512');
[03/22/2024 10:09:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 10:09:17.86'
        , 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.436'
        , error_description = ''
        , memory_used = '1495584'
        WHERE id = '79133';
[03/22/2024 10:09: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/22_03_2024/request_availability_Gajendra_512_1711102157_78.json', 'e1p/22_03_2024/response_availability_Gajendra_512_1711102157_78.json', 'e1p/22_03_2024/response_header_availability_Gajendra_512_1711102157_78.json', 'expediapackage', '2024-03-22 10:09:17', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '512');
[03/22/2024 10:09:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 10:09:17.89'
        , 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.650'
        , error_description = ''
        , memory_used = '1496256'
        WHERE id = '79134';
[03/22/2024 10:09:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7873&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3',
        duration = '0.741',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '31.73',
        system_load_5_min = '19.23',
        system_load_15_min = '12.28',
        system_memory_usage = '75.71',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '512') + '1738584',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '512';
[03/22/2024 10:09:18], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:09:18' WHERE id= '701';
[03/22/2024 10:09:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:09:21' WHERE id= '701';
[03/22/2024 10:13:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:13:00' WHERE id= '681';
[03/22/2024 10:13:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711102381','43.239.53.130');
[03/22/2024 10:24:48], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:24:48' WHERE id= '681';
[03/22/2024 10:24:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:24:50' WHERE id= '681';
[03/22/2024 10:24:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:24:50' WHERE id= '681';
[03/22/2024 10:24:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:24:54' WHERE id= '681';
[03/22/2024 10:24:55], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_24_54_1711103094.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_24_54_1711103094.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_24_54_1711103094.json', 'viator', '2024-03-22 10:24:55', '', '', '510');
[03/22/2024 10:24:56], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_24_56_1711103096.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_24_56_1711103096.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_24_56_1711103096.json', 'viator', '2024-03-22 10:24:56', '', '', '510');
[03/22/2024 10:24:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:24:58' WHERE id= '681';
[03/22/2024 10:24:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_24_59_1711103099.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_24_59_1711103099.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_24_59_1711103099.json', 'viator', '2024-03-22 10:24:59', '', '', '510');
[03/22/2024 10:25:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:25:07' WHERE id= '681';
[03/22/2024 10:25:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711103107','43.239.53.130');
[03/22/2024 10:27:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:27:34' WHERE id= '681';
[03/22/2024 10:27:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711103254','43.239.53.130');
[03/22/2024 10:46:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:12' WHERE id= '681';
[03/22/2024 10:46:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:14' WHERE id= '681';
[03/22/2024 10:46:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:14' WHERE id= '681';
[03/22/2024 10:46:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:22' WHERE id= '681';
[03/22/2024 10:46:22], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_22_1711104382.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_22_1711104382.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_22_1711104382.json', 'viator', '2024-03-22 10:46:22', '', '', '510');
[03/22/2024 10:46:24], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_22_1711104382.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_22_1711104382.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_22_1711104382.json', 'viator', '2024-03-22 10:46:24', '', '', '510');
[03/22/2024 10:46:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:28' WHERE id= '681';
[03/22/2024 10:46:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_46_28_1711104388.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_46_28_1711104388.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_46_28_1711104388.json', 'viator', '2024-03-22 10:46:29', '', '', '510');
[03/22/2024 10:46:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:36' WHERE id= '681';
[03/22/2024 10:46:36], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_36_1711104396.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_36_1711104396.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_36_1711104396.json', 'viator', '2024-03-22 10:46:36', '', '', '510');
[03/22/2024 10:46:37], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_36_1711104396.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_36_1711104396.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_36_1711104396.json', 'viator', '2024-03-22 10:46:37', '', '', '510');
[03/22/2024 10:46:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:40' WHERE id= '681';
[03/22/2024 10:46:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_46_40_1711104400.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_46_40_1711104400.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_46_40_1711104400.json', 'viator', '2024-03-22 10:46:40', '', '', '510');
[03/22/2024 10:46:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:46:57' WHERE id= '681';
[03/22/2024 10:46:58], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_58_1711104418.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_58_1711104418.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_58_1711104418.json', 'viator', '2024-03-22 10:46:58', '', '', '510');
[03/22/2024 10:46:58], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_46_58_1711104418.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_46_58_1711104418.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_46_58_1711104418.json', 'viator', '2024-03-22 10:46:58', '', '', '510');
[03/22/2024 10:47:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:01' WHERE id= '681';
[03/22/2024 10:47:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_47_01_1711104421.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_47_01_1711104421.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_47_01_1711104421.json', 'viator', '2024-03-22 10:47:02', '', '', '510');
[03/22/2024 10:47:26], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-22 10:47:26',login_attempt=0 where id = '7857';
[03/22/2024 10:47:26], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-03-22 10:47:26', ip = '43.239.53.130', action = 'Login' ;
[03/22/2024 10:47:26], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:26' WHERE id= '702';
[03/22/2024 10:47:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:27' WHERE id= '681';
[03/22/2024 10:47:28], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_47_28_1711104448.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_47_28_1711104448.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_47_28_1711104448.json', 'viator', '2024-03-22 10:47:28', '', '', '510');
[03/22/2024 10:47:29], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_47_28_1711104448.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_47_28_1711104448.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_47_28_1711104448.json', 'viator', '2024-03-22 10:47:29', '', '', '510');
[03/22/2024 10:47:31], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:31' WHERE id= '702';
[03/22/2024 10:47:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:33' WHERE id= '681';
[03/22/2024 10:47:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_47_33_1711104453.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_47_33_1711104453.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_47_33_1711104453.json', 'viator', '2024-03-22 10:47:33', '', '', '510');
[03/22/2024 10:47:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:35' WHERE id= '702';
[03/22/2024 10:47:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:38' WHERE id= '702';
[03/22/2024 10:47:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:39' WHERE id= '702';
[03/22/2024 10:47:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:41' WHERE id= '702';
[03/22/2024 10:47:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:44' WHERE id= '702';
[03/22/2024 10:47:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/03/27',  departure_date='2024/03/27',  nights='1',  create_date='2024-03-22 :10:47:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/22/2024 10:47:48], [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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_44_1711104464.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_44_1711104464.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_44_1711104464.json', 'viator', '2024-03-22 10:47:48', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47: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 ('', 'availability', 'v1/22_03_2024/request_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_availability_Deepak_T_10_47_48_1711104468_74.json', 'v1/22_03_2024/response_header_availability_Deepak_T_10_47_48_1711104468_74.json', 'viator', '2024-03-22 10:47:52', '', '', '513');
[03/22/2024 10:47:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:55' WHERE id= '702';
[03/22/2024 10:47:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:47:55' WHERE id= '702';
[03/22/2024 10:52:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:52:24' WHERE id= '681';
[03/22/2024 10:52:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:52:25' WHERE id= '681';
[03/22/2024 10:52:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:52:29' WHERE id= '681';
[03/22/2024 10:52:30], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_52_29_1711104749.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_52_29_1711104749.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_52_29_1711104749.json', 'viator', '2024-03-22 10:52:30', '', '', '510');
[03/22/2024 10:52:30], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_52_30_1711104750.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_52_30_1711104750.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_52_30_1711104750.json', 'viator', '2024-03-22 10:52:30', '', '', '510');
[03/22/2024 10:52:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:52:33' WHERE id= '681';
[03/22/2024 10:52:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_52_33_1711104753.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_52_33_1711104753.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_52_33_1711104753.json', 'viator', '2024-03-22 10:52:33', '', '', '510');
[03/22/2024 10:52:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:52:53' WHERE id= '681';
[03/22/2024 10:53:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:00' WHERE id= '681';
[03/22/2024 10:53:00], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_53_00_1711104780.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_53_00_1711104780.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_53_00_1711104780.json', 'viator', '2024-03-22 10:53:00', '', '', '510');
[03/22/2024 10:53:01], [file name :-/home/otrams/public_html/beta/user_sight_details.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/22_03_2024/request_sight_details_Viator_test_10_53_00_1711104780.json', 'v1/22_03_2024/response_sight_details_Viator_test_10_53_00_1711104780.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_10_53_00_1711104780.json', 'viator', '2024-03-22 10:53:01', '', '', '510');
[03/22/2024 10:53:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:08' WHERE id= '681';
[03/22/2024 10:53:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_53_08_1711104788.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_53_08_1711104788.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_53_08_1711104788.json', 'viator', '2024-03-22 10:53:09', '', '', '510');
[03/22/2024 10:53:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:22' WHERE id= '681';
[03/22/2024 10:53:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_10_53_22_1711104802.json', 'v1/22_03_2024/response_check_availability_Viator_test_10_53_22_1711104802.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_10_53_22_1711104802.json', 'viator', '2024-03-22 10:53:22', '', '', '510');
[03/22/2024 10:53:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:29' WHERE id= '701';
[03/22/2024 10:53:30], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:30' WHERE id= '701';
[03/22/2024 10:53:30], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:30' WHERE id= '701';
[03/22/2024 10:53:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:35' WHERE id= '681';
[03/22/2024 10:53:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711104815','43.239.53.130');
[03/22/2024 10:53:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:37' WHERE id= '701';
[03/22/2024 10:53:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:38' WHERE id= '701';
[03/22/2024 10:53:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:51' WHERE id= '701';
[03/22/2024 10:53:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'agartala' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/05' , departure_date = '2024/06/06' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-22 10:53:51' , site_id = '' , country_code = '106' , city_code = '64625' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/22/2024 10:53:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:52' WHERE id= '701';
[03/22/2024 10:53:53], [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/22_03_2024/request_availability_Gajendra_514_1711104832_50.json', 'e1p/22_03_2024/response_availability_Gajendra_514_1711104832_50.json', 'e1p/22_03_2024/response_header_availability_Gajendra_514_1711104832_50.json', 'expediapackage', '2024-03-22 10:53:53', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '514');
[03/22/2024 10:53:53], [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', 'e1/22_03_2024/request_availability_Gajendra_514_1711104832_26.json', 'e1/22_03_2024/response_availability_Gajendra_514_1711104832_26.json', 'e1/22_03_2024/response_header_availability_Gajendra_514_1711104832_26.json', 'expedia', '2024-03-22 10:53:53', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '514');
[03/22/2024 10:53:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 10:53:52.905'
        , 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.520'
        , error_description = ''
        , memory_used = '1496256'
        WHERE id = '79195';
[03/22/2024 10:53:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 10:53:52.904'
        , 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.569'
        , error_description = ''
        , memory_used = '1495584'
        WHERE id = '79196';
[03/22/2024 10:53:53], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7873&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3',
        duration = '0.629',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '5.22',
        system_load_5_min = '6.61',
        system_load_15_min = '9.43',
        system_memory_usage = '78.56',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '514') + '1738584',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '514';
[03/22/2024 10:53:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:53' WHERE id= '701';
[03/22/2024 10:53:57], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 10:53:57' WHERE id= '701';
