[03/21/2024 01:01:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:01:35' WHERE id= '688';
[03/21/2024 01:03:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:03:31' WHERE id= '688';
[03/21/2024 01:03:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:03:33' WHERE id= '688';
[03/21/2024 01:03:42], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:03:42' WHERE id= '688';
[03/21/2024 01:03:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:03:43' WHERE id= '688';
[03/21/2024 01:04:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:04:01' WHERE id= '681';
[03/21/2024 01:04:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711026241','43.239.53.130');
[03/21/2024 01:04:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:04:50' WHERE id= '688';
[03/21/2024 01:04:53], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:04:53' WHERE id= '688';
[03/21/2024 01:06:42], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:06:42' WHERE id= '688';
[03/21/2024 01:19:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:19:24' WHERE id= '681';
[03/21/2024 01:19:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027164','43.239.53.130');
[03/21/2024 01:20:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:20:14' WHERE id= '681';
[03/21/2024 01:20:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027214','43.239.53.130');
[03/21/2024 01:20:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:20:30' WHERE id= '681';
[03/21/2024 01:20:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027230','43.239.53.130');
[03/21/2024 01:21:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:21:37' WHERE id= '681';
[03/21/2024 01:21:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027297','43.239.53.130');
[03/21/2024 01:23:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:23:06' WHERE id= '681';
[03/21/2024 01:23:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027387','43.239.53.130');
[03/21/2024 01:23:26], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:23:26' WHERE id= '681';
[03/21/2024 01:23:26], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027406','43.239.53.130');
[03/21/2024 01:24:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:01' WHERE id= '681';
[03/21/2024 01:24:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027441','43.239.53.130');
[03/21/2024 01:24:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:23' WHERE id= '681';
[03/21/2024 01:24:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:25' WHERE id= '681';
[03/21/2024 01:24:25], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:25' WHERE id= '681';
[03/21/2024 01:24:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:28' WHERE id= '681';
[03/21/2024 01:24: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/21_03_2024/request_sight_details_Viator_test_13_24_29_1711027469.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_24_29_1711027469.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_24_29_1711027469.json', 'viator', '2024-03-21 01:24:29', '', '', '452');
[03/21/2024 01:24: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/21_03_2024/request_sight_details_Viator_test_13_24_29_1711027469.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_24_29_1711027469.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_24_29_1711027469.json', 'viator', '2024-03-21 01:24:30', '', '', '452');
[03/21/2024 01:24:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:32' WHERE id= '681';
[03/21/2024 01:24:33], [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/21_03_2024/request_check_availability_Viator_test_13_24_32_1711027472.json', 'v1/21_03_2024/response_check_availability_Viator_test_13_24_32_1711027472.json', 'v1/21_03_2024/response_header_check_availability_Viator_test_13_24_32_1711027472.json', 'viator', '2024-03-21 01:24:33', '', '', '452');
[03/21/2024 01:24:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:47' WHERE id= '681';
[03/21/2024 01:24:48], [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/21_03_2024/request_sight_details_Viator_test_13_24_47_1711027487.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_24_47_1711027487.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_24_47_1711027487.json', 'viator', '2024-03-21 01:24:48', '', '', '452');
[03/21/2024 01:24:49], [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/21_03_2024/request_sight_details_Viator_test_13_24_48_1711027488.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_24_48_1711027488.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_24_48_1711027488.json', 'viator', '2024-03-21 01:24:49', '', '', '452');
[03/21/2024 01:24:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:51' WHERE id= '681';
[03/21/2024 01:24:51], [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/21_03_2024/request_check_availability_Viator_test_13_24_51_1711027491.json', 'v1/21_03_2024/response_check_availability_Viator_test_13_24_51_1711027491.json', 'v1/21_03_2024/response_header_check_availability_Viator_test_13_24_51_1711027491.json', 'viator', '2024-03-21 01:24:51', '', '', '452');
[03/21/2024 01:24:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:24:59' WHERE id= '681';
[03/21/2024 01:25: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/21_03_2024/request_sight_details_Viator_test_13_25_00_1711027500.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_25_00_1711027500.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_25_00_1711027500.json', 'viator', '2024-03-21 01:25:00', '', '', '452');
[03/21/2024 01:25: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/21_03_2024/request_sight_details_Viator_test_13_25_00_1711027500.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_25_00_1711027500.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_25_00_1711027500.json', 'viator', '2024-03-21 01:25:01', '', '', '452');
[03/21/2024 01:25:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:25:04' WHERE id= '681';
[03/21/2024 01:25:05], [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/21_03_2024/request_check_availability_Viator_test_13_25_04_1711027504.json', 'v1/21_03_2024/response_check_availability_Viator_test_13_25_04_1711027504.json', 'v1/21_03_2024/response_header_check_availability_Viator_test_13_25_04_1711027504.json', 'viator', '2024-03-21 01:25:05', '', '', '452');
[03/21/2024 01:25:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:25:15' WHERE id= '681';
[03/21/2024 01:25:16], [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/21_03_2024/request_sight_details_Viator_test_13_25_15_1711027515.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_25_15_1711027515.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_25_15_1711027515.json', 'viator', '2024-03-21 01:25:16', '', '', '452');
[03/21/2024 01:25:16], [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/21_03_2024/request_sight_details_Viator_test_13_25_16_1711027516.json', 'v1/21_03_2024/response_sight_details_Viator_test_13_25_16_1711027516.json', 'v1/21_03_2024/response_header_sight_details_Viator_test_13_25_16_1711027516.json', 'viator', '2024-03-21 01:25:16', '', '', '452');
[03/21/2024 01:25:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:25:19' WHERE id= '681';
[03/21/2024 01:25:20], [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/21_03_2024/request_check_availability_Viator_test_13_25_19_1711027519.json', 'v1/21_03_2024/response_check_availability_Viator_test_13_25_19_1711027519.json', 'v1/21_03_2024/response_header_check_availability_Viator_test_13_25_19_1711027519.json', 'viator', '2024-03-21 01:25:20', '', '', '452');
[03/21/2024 01:25:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:25:46' WHERE id= '681';
[03/21/2024 01:25:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027546','43.239.53.130');
[03/21/2024 01:26:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:26:45' WHERE id= '681';
[03/21/2024 01:26:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027605','43.239.53.130');
[03/21/2024 01:27:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:27:01' WHERE id= '681';
[03/21/2024 01:27:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027621','43.239.53.130');
[03/21/2024 01:28:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:28:07' WHERE id= '681';
[03/21/2024 01:28:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027687','43.239.53.130');
[03/21/2024 01:28:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:28:54' WHERE id= '681';
[03/21/2024 01:28:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027734','43.239.53.130');
[03/21/2024 01:29:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:29:46' WHERE id= '681';
[03/21/2024 01:29:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027786','43.239.53.130');
[03/21/2024 01:31:17], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:31:17' WHERE id= '681';
[03/21/2024 01:31:17], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027877','43.239.53.130');
[03/21/2024 01:32:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:32:03' WHERE id= '681';
[03/21/2024 01:32:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027923','43.239.53.130');
[03/21/2024 01:32:22], [file name :-/home/otrams/public_html/beta/supplier_registration.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-03-21 13:32:22', ip = '66.249.66.166', action = 'Login' ;
[03/21/2024 01:33:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:33:19' WHERE id= '681';
[03/21/2024 01:33:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711027999','43.239.53.130');
[03/21/2024 01:33:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:33:49' WHERE id= '681';
[03/21/2024 01:33:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028029','43.239.53.130');
[03/21/2024 01:43:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:43:13' WHERE id= '681';
[03/21/2024 01:43:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028593','43.239.53.130');
[03/21/2024 01:44:29], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:44:29' WHERE id= '681';
[03/21/2024 01:44:29], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028669','43.239.53.130');
[03/21/2024 01:44:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:44:34' WHERE id= '681';
[03/21/2024 01:44:34], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028674','43.239.53.130');
[03/21/2024 01:45:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:45:05' WHERE id= '681';
[03/21/2024 01:45:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028705','43.239.53.130');
[03/21/2024 01:45:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-21 01:45:51',login_attempt=0 where id = '7873';
[03/21/2024 01:45:51], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-03-21 13:45:51', ip = '43.239.53.130', action = 'Login' ;
[03/21/2024 01:45:52], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:45:52' WHERE id= '688';
[03/21/2024 01:46:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:46:18' WHERE id= '681';
[03/21/2024 01:46:18], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028778','43.239.53.130');
[03/21/2024 01:48:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:00' WHERE id= '688';
[03/21/2024 01:48:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:00' WHERE id= '688';
[03/21/2024 01:48:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:01' WHERE id= '681';
[03/21/2024 01:48:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028881','43.239.53.130');
[03/21/2024 01:48:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:03' WHERE id= '681';
[03/21/2024 01:48:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028883','43.239.53.130');
[03/21/2024 01:48:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:17' WHERE id= '688';
[03/21/2024 01:48:18], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-21 13:48:18' , 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/21/2024 01:48:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:19' WHERE id= '688';
[03/21/2024 01:48:20], [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/21_03_2024/request_availability_Gajendra_461_1711028899_95.json', 'e1p/21_03_2024/response_availability_Gajendra_461_1711028899_95.json', 'e1p/21_03_2024/response_header_availability_Gajendra_461_1711028899_95.json', 'expediapackage', '2024-03-21 01:48:20', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '461');
[03/21/2024 01:48:20], [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/21_03_2024/request_availability_Gajendra_461_1711028899_36.json', 'e1/21_03_2024/response_availability_Gajendra_461_1711028899_36.json', 'e1/21_03_2024/response_header_availability_Gajendra_461_1711028899_36.json', 'expedia', '2024-03-21 01:48:20', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '461');
[03/21/2024 01:48:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:48:19.640'
        , 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.334'
        , error_description = ''
        , memory_used = '3013784'
        WHERE id = '76971';
[03/21/2024 01:48:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:48:19.638'
        , 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.340'
        , error_description = ''
        , memory_used = '3025024'
        WHERE id = '76970';
[03/21/2024 01:48:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '4',
        request_path = '/xml_all.php?userid=7873&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '1.934',
        merge_duration = '0.027',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '18.23',
        system_load_5_min = '11.15',
        system_load_15_min = '12.22',
        system_memory_usage = '92.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '461') + '2213040',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '461';
[03/21/2024 01:48:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:21' WHERE id= '688';
[03/21/2024 01:48:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:48:58' WHERE id= '688';
[03/21/2024 01:49:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:01' WHERE id= '681';
[03/21/2024 01:49:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028941','43.239.53.130');
[03/21/2024 01:49:01], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:01' WHERE id= '688';
[03/21/2024 01:49:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:34' WHERE id= '688';
[03/21/2024 01:49:34], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-21 13:49:34' , 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/21/2024 01:49:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:35' WHERE id= '688';
[03/21/2024 01:49:35], [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/21_03_2024/request_availability_Gajendra_462_1711028975_25.json', 'e1/21_03_2024/response_availability_Gajendra_462_1711028975_25.json', 'e1/21_03_2024/response_header_availability_Gajendra_462_1711028975_25.json', 'expedia', '2024-03-21 01:49:35', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '462');
[03/21/2024 01:49:35], [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/21_03_2024/request_availability_Gajendra_462_1711028975_17.json', 'e1p/21_03_2024/response_availability_Gajendra_462_1711028975_17.json', 'e1p/21_03_2024/response_header_availability_Gajendra_462_1711028975_17.json', 'expediapackage', '2024-03-21 01:49:35', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '462');
[03/21/2024 01:49:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:49:35.517'
        , 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.394'
        , error_description = ''
        , memory_used = '2495120'
        WHERE id = '76972';
[03/21/2024 01:49:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:49:35.515'
        , 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.443'
        , error_description = ''
        , memory_used = '2495728'
        WHERE id = '76973';
[03/21/2024 01:49:35], [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=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '0.511',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '18.78',
        system_load_5_min = '13.58',
        system_load_15_min = '13.04',
        system_memory_usage = '90.83',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '462') + '2214192',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '462';
[03/21/2024 01:49:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:36' WHERE id= '688';
[03/21/2024 01:49:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:39' WHERE id= '688';
[03/21/2024 01:49:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:49:54' WHERE id= '681';
[03/21/2024 01:49:55], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711028995','43.239.53.130');
[03/21/2024 01:50:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:44' WHERE id= '688';
[03/21/2024 01:50:44], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-21 13:50:44' , 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/21/2024 01:50:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:44' WHERE id= '688';
[03/21/2024 01:50: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', 'e1/21_03_2024/request_availability_Gajendra_463_1711029044_49.json', 'e1/21_03_2024/response_availability_Gajendra_463_1711029044_49.json', 'e1/21_03_2024/response_header_availability_Gajendra_463_1711029044_49.json', 'expedia', '2024-03-21 01:50:45', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '463');
[03/21/2024 01:50: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/21_03_2024/request_availability_Gajendra_463_1711029044_82.json', 'e1p/21_03_2024/response_availability_Gajendra_463_1711029044_82.json', 'e1p/21_03_2024/response_header_availability_Gajendra_463_1711029044_82.json', 'expediapackage', '2024-03-21 01:50:45', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '463');
[03/21/2024 01:50:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:50:44.907'
        , 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.344'
        , error_description = ''
        , memory_used = '2495008'
        WHERE id = '76974';
[03/21/2024 01:50:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:50:44.909'
        , 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.419'
        , error_description = ''
        , memory_used = '2495312'
        WHERE id = '76975';
[03/21/2024 01:50:45], [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=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '0.482',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '20.97',
        system_load_5_min = '15.63',
        system_load_15_min = '13.81',
        system_memory_usage = '91.29',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '463') + '2214272',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '463';
[03/21/2024 01:50:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:45' WHERE id= '688';
[03/21/2024 01:50:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:50' WHERE id= '688';
[03/21/2024 01:50:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:54' WHERE id= '688';
[03/21/2024 01:50:54], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:50:54' WHERE id= '688';
[03/21/2024 01:51:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:17' WHERE id= '688';
[03/21/2024 01:51:17], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-21 13:51:17' , 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/21/2024 01:51:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:19' WHERE id= '688';
[03/21/2024 01:51: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', 'e1/21_03_2024/request_availability_Gajendra_464_1711029079_67.json', 'e1/21_03_2024/response_availability_Gajendra_464_1711029079_67.json', 'e1/21_03_2024/response_header_availability_Gajendra_464_1711029079_67.json', 'expedia', '2024-03-21 01:51:19', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '464');
[03/21/2024 01:51:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:51:19.238'
        , 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.325'
        , error_description = ''
        , memory_used = '2495112'
        WHERE id = '76976';
[03/21/2024 01:51: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/21_03_2024/request_availability_Gajendra_464_1711029079_51.json', 'e1p/21_03_2024/response_availability_Gajendra_464_1711029079_51.json', 'e1p/21_03_2024/response_header_availability_Gajendra_464_1711029079_51.json', 'expediapackage', '2024-03-21 01:51:19', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '464');
[03/21/2024 01:51:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:51:19.237'
        , 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.462'
        , error_description = ''
        , memory_used = '2495536'
        WHERE id = '76977';
[03/21/2024 01:51:19], [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=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '0.525',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '15.11',
        system_load_5_min = '14.83',
        system_load_15_min = '13.62',
        system_memory_usage = '91.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '464') + '2214760',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '464';
[03/21/2024 01:51:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:20' WHERE id= '688';
[03/21/2024 01:51:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:21' WHERE id= '681';
[03/21/2024 01:51:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711029081','43.239.53.130');
[03/21/2024 01:51:24], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:24' WHERE id= '688';
[03/21/2024 01:51:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:51:46' WHERE id= '681';
[03/21/2024 01:51:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711029106','43.239.53.130');
[03/21/2024 01:53:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:43' WHERE id= '688';
[03/21/2024 01:53:43], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-21 13:53:43' , 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/21/2024 01:53:45], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:45' WHERE id= '688';
[03/21/2024 01:53: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', 'e1/21_03_2024/request_availability_Gajendra_465_1711029225_15.json', 'e1/21_03_2024/response_availability_Gajendra_465_1711029225_15.json', 'e1/21_03_2024/response_header_availability_Gajendra_465_1711029225_15.json', 'expedia', '2024-03-21 01:53:45', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '465');
[03/21/2024 01:53:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:53:45.567'
        , 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.338'
        , error_description = ''
        , memory_used = '2495088'
        WHERE id = '76978';
[03/21/2024 01:53: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/21_03_2024/request_availability_Gajendra_465_1711029225_16.json', 'e1p/21_03_2024/response_availability_Gajendra_465_1711029225_16.json', 'e1p/21_03_2024/response_header_availability_Gajendra_465_1711029225_16.json', 'expediapackage', '2024-03-21 01:53:45', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '465');
[03/21/2024 01:53:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:53:45.569'
        , 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.526'
        , error_description = ''
        , memory_used = '2495288'
        WHERE id = '76979';
[03/21/2024 01:53:46], [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=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '0.606',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '11.94',
        system_load_5_min = '13.03',
        system_load_15_min = '13.07',
        system_memory_usage = '91.12',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '465') + '2214272',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '465';
[03/21/2024 01:53:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:46' WHERE id= '688';
[03/21/2024 01:53:50], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:50' WHERE id= '688';
[03/21/2024 01:53:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:55' WHERE id= '688';
[03/21/2024 01:53:58], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:53:58' WHERE id= '688';
[03/21/2024 01:55:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:55:07' WHERE id= '688';
[03/21/2024 01:55:07], [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/09' , departure_date = '2024/05/10' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-21 13:55:07' , 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/21/2024 01:55:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:55:08' WHERE id= '688';
[03/21/2024 01:55:09], [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/21_03_2024/request_availability_Gajendra_466_1711029309_82.json', 'e1/21_03_2024/response_availability_Gajendra_466_1711029309_82.json', 'e1/21_03_2024/response_header_availability_Gajendra_466_1711029309_82.json', 'expedia', '2024-03-21 01:55:09', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '466');
[03/21/2024 01:55:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:55:09.7'
        , 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.347'
        , error_description = ''
        , memory_used = '2495008'
        WHERE id = '76980';
[03/21/2024 01:55:09], [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/21_03_2024/request_availability_Gajendra_466_1711029309_92.json', 'e1p/21_03_2024/response_availability_Gajendra_466_1711029309_92.json', 'e1p/21_03_2024/response_header_availability_Gajendra_466_1711029309_92.json', 'expediapackage', '2024-03-21 01:55:09', '', 'c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212', '466');
[03/21/2024 01:55:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212&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-21 13:55:09.8'
        , 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.469'
        , error_description = ''
        , memory_used = '2495320'
        WHERE id = '76981';
[03/21/2024 01:55:09], [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=c6e222b8981839694a6ffede2457fcc3b3f9ec70f003b35c2f1a306194696212',
        duration = '0.532',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '11.64',
        system_load_5_min = '12.78',
        system_load_15_min = '12.98',
        system_memory_usage = '91.34',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '466') + '2214272',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '466';
[03/21/2024 01:55:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:55:09' WHERE id= '688';
[03/21/2024 01:55:13], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:55:13' WHERE id= '688';
[03/21/2024 01:57:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:57:53' WHERE id= '681';
[03/21/2024 01:57:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711029473','43.239.53.130');
[03/21/2024 01:57:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:57:57' WHERE id= '681';
[03/21/2024 01:57:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711029477','43.239.53.130');
[03/21/2024 01:58:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-21 01:58:52' WHERE id= '681';
[03/21/2024 01:58:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711029532','43.239.53.130');
