[04/15/2024 05:22:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:22:36' WHERE id= '775';
[04/15/2024 05:22:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1713158556','43.239.53.130');
[04/15/2024 05:22:50], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:22:50' WHERE id= '775';
[04/15/2024 05:22:50], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 05:22:50',login_attempt=0 where id = '7869';
[04/15/2024 05:22:50], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-04-15 05:22:50', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 05:22:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:22:51' WHERE id= '775';
[04/15/2024 05:22:57], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:22:57' WHERE id= '775';
[04/15/2024 05:23:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:01' WHERE id= '775';
[04/15/2024 05:23:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:01' WHERE id= '775';
[04/15/2024 05:23:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:01' WHERE id= '775';
[04/15/2024 05:23:02], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:02' WHERE id= '775';
[04/15/2024 05:23:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:03' WHERE id= '775';
[04/15/2024 05:23:04], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:04' WHERE id= '775';
[04/15/2024 05:23:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:05' WHERE id= '775';
[04/15/2024 05:23:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:10' WHERE id= '775';
[04/15/2024 05:23:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'las vegas(nm)' , arrival_date='2024/05/26',  departure_date='2024/05/26',  nights='1',  create_date='2024-04-15 :05:23:10',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/15/2024 05:23:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/15_04_2024/request_availability_Viator_05_23_10_1713158590.json', 'v1/15_04_2024/response_availability_Viator_05_23_10_1713158590.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_10_1713158590.json', 'viator', '2024-04-15 05:23:11', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:21], [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/15_04_2024/request_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_availability_Viator_05_23_11_1713158591_63.json', 'v1/15_04_2024/response_header_availability_Viator_05_23_11_1713158591_63.json', 'viator', '2024-04-15 05:23:21', '', '', '939');
[04/15/2024 05:23:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:23' WHERE id= '775';
[04/15/2024 05:23:24], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:24' WHERE id= '775';
[04/15/2024 05:23:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:32' WHERE id= '775';
[04/15/2024 05:23:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:32' WHERE id= '775';
[04/15/2024 05:23:33], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:33' WHERE id= '775';
[04/15/2024 05:23:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:33' WHERE id= '775';
[04/15/2024 05:23:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:34' WHERE id= '775';
[04/15/2024 05:23:36], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:36' WHERE id= '775';
[04/15/2024 05:23:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:37' WHERE id= '775';
[04/15/2024 05:23:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:37' WHERE id= '775';
[04/15/2024 05:23:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:38' WHERE id= '775';
[04/15/2024 05:23:39], [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/15_04_2024/request_sight_details_Viator_05_23_38_1713158618.json', 'v1/15_04_2024/response_sight_details_Viator_05_23_38_1713158618.json', 'v1/15_04_2024/response_header_sight_details_Viator_05_23_38_1713158618.json', 'viator', '2024-04-15 05:23:39', '', '', '939');
[04/15/2024 05:23:39], [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/15_04_2024/request_sight_details_Viator_05_23_39_1713158619.json', 'v1/15_04_2024/response_sight_details_Viator_05_23_39_1713158619.json', 'v1/15_04_2024/response_header_sight_details_Viator_05_23_39_1713158619.json', 'viator', '2024-04-15 05:23:39', '', '', '939');
[04/15/2024 05:23:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:42' WHERE id= '775';
[04/15/2024 05:23:42], [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/15_04_2024/request_check_availability_Viator_05_23_42_1713158622.json', 'v1/15_04_2024/response_check_availability_Viator_05_23_42_1713158622.json', 'v1/15_04_2024/response_header_check_availability_Viator_05_23_42_1713158622.json', 'viator', '2024-04-15 05:23:42', '', '', '939');
[04/15/2024 05:23:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:23:57' WHERE id= '775';
[04/15/2024 05:23:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1713158637','43.239.53.130');
[04/15/2024 05:41:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 05:41:03',login_attempt=0 where id = '7873';
[04/15/2024 05:41:03], [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-04-15 05:41:03', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 05:41:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:03' WHERE id= '774';
[04/15/2024 05:41:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:38' WHERE id= '774';
[04/15/2024 05:41:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:43' WHERE id= '774';
[04/15/2024 05:41: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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/26' , departure_date = '2024/04/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 05:41:43' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 05:41:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:44' WHERE id= '774';
[04/15/2024 05:41:44], [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/15_04_2024/request_availability_Gajendra_940_1713159704_40.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713159704_40.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713159704_40.json', 'expedia', '2024-04-15 05:41:44', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , 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.434'
        , error_description = ''
        , memory_used = '1569872'
        WHERE id = '108450';
[04/15/2024 05:41:44], [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/15_04_2024/request_availability_Gajendra_940_1713159704_35.json', 'e1p/15_04_2024/response_availability_Gajendra_940_1713159704_35.json', 'e1p/15_04_2024/response_header_availability_Gajendra_940_1713159704_35.json', 'expediapackage', '2024-04-15 05:41:44', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , 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.451'
        , error_description = ''
        , memory_used = '1562576'
        WHERE id = '108451';
[04/15/2024 05:41: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/15_04_2024/request_availability_Gajendra_940_1713159704_84.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713159704_84.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713159704_84.json', 'expedia', '2024-04-15 05:41:45', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41: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/15_04_2024/request_availability_Gajendra_940_1713159704_75.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713159704_75.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713159704_75.json', 'expedia', '2024-04-15 05:41:45', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41:46], [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/15_04_2024/request_availability_Gajendra_940_1713159704_87.json', 'e1p/15_04_2024/response_availability_Gajendra_940_1713159704_87.json', 'e1p/15_04_2024/response_header_availability_Gajendra_940_1713159704_87.json', 'expediapackage', '2024-04-15 05:41:46', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41:46], [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/15_04_2024/request_availability_Gajendra_940_1713159704_88.json', 'e1p/15_04_2024/response_availability_Gajendra_940_1713159704_88.json', 'e1p/15_04_2024/response_header_availability_Gajendra_940_1713159704_88.json', 'expediapackage', '2024-04-15 05:41:46', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:41:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.181'
        , error_description = ''
        , memory_used = '155993280'
        WHERE id = '108453';
[04/15/2024 05:41:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.273'
        , error_description = ''
        , memory_used = '184506320'
        WHERE id = '108452';
[04/15/2024 05:41:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.964'
        , error_description = ''
        , memory_used = '164127480'
        WHERE id = '108455';
[04/15/2024 05:41:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:41:44.433'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.972'
        , error_description = ''
        , memory_used = '195434312'
        WHERE id = '108454';
[04/15/2024 05:41:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '3.163',
        merge_duration = '0.021',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '1.16',
        system_load_5_min = '1.42',
        system_load_15_min = '0.79',
        system_memory_usage = '62.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '940') + '2799416',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '940';
[04/15/2024 05:41:47], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:47' WHERE id= '774';
[04/15/2024 05:41:49], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:41:49' WHERE id= '774';
[04/15/2024 05:42:05], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:42:05' WHERE id= '774';
[04/15/2024 05:42:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:42:15' WHERE id= '774';
[04/15/2024 05:42: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/15_04_2024/request_availability_Gajendra_940_1713159736_72.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713159736_72.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713159736_72.json', 'expedia', '2024-04-15 05:42:17', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:42:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:42:15.973'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.300'
        , error_description = ''
        , memory_used = '184530424'
        WHERE id = '108456';
[04/15/2024 05:47:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:47:54' WHERE id= '774';
[04/15/2024 05:47:55], [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/15_04_2024/request_availability_Gajendra_940_1713160074_37.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160074_37.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160074_37.json', 'expedia', '2024-04-15 05:47:55', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:47:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:47:54.655'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.065'
        , error_description = ''
        , memory_used = '184467232'
        WHERE id = '108457';
[04/15/2024 05:48:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:48:23' WHERE id= '774';
[04/15/2024 05:48:24], [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/15_04_2024/request_availability_Gajendra_940_1713160103_68.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160103_68.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160103_68.json', 'expedia', '2024-04-15 05:48:24', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:48:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:48:23.583'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.320'
        , error_description = ''
        , memory_used = '184854840'
        WHERE id = '108458';
[04/15/2024 05:50:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:50:36' WHERE id= '774';
[04/15/2024 05:50:37], [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/15_04_2024/request_availability_Gajendra_940_1713160236_23.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160236_23.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160236_23.json', 'expedia', '2024-04-15 05:50:37', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:50:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:50:36.819'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.138'
        , error_description = ''
        , memory_used = '184335768'
        WHERE id = '108459';
[04/15/2024 05:51:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:51:24' WHERE id= '774';
[04/15/2024 05:51:25], [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/15_04_2024/request_availability_Gajendra_940_1713160284_94.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160284_94.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160284_94.json', 'expedia', '2024-04-15 05:51:25', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:51:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:51:24.829'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.279'
        , error_description = ''
        , memory_used = '184455232'
        WHERE id = '108460';
[04/15/2024 05:52:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:52:15' WHERE id= '774';
[04/15/2024 05:52:16], [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/15_04_2024/request_availability_Gajendra_940_1713160335_75.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160335_75.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160335_75.json', 'expedia', '2024-04-15 05:52:16', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:52:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:52:15.424'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.147'
        , error_description = ''
        , memory_used = '184452592'
        WHERE id = '108461';
[04/15/2024 05:52:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:52:27' WHERE id= '774';
[04/15/2024 05:52:28], [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/15_04_2024/request_availability_Gajendra_940_1713160347_78.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160347_78.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160347_78.json', 'expedia', '2024-04-15 05:52:28', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:52:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:52:27.696'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.241'
        , error_description = ''
        , memory_used = '184704008'
        WHERE id = '108462';
[04/15/2024 05:52:35], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-04-15 05:52:35', ip = '111.7.96.154', action = 'Login' ;
[04/15/2024 05:52:38], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-04-15 05:52:38', ip = '111.7.96.154', action = 'Login' ;
[04/15/2024 05:53:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:53:06' WHERE id= '774';
[04/15/2024 05:53:07], [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/15_04_2024/request_availability_Gajendra_940_1713160386_79.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160386_79.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160386_79.json', 'expedia', '2024-04-15 05:53:07', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:53:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:53:06.620'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.038'
        , error_description = ''
        , memory_used = '155928920'
        WHERE id = '108463';
[04/15/2024 05:54:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:54:40' WHERE id= '774';
[04/15/2024 05:54:42], [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/15_04_2024/request_availability_Gajendra_940_1713160480_41.json', 'e1/15_04_2024/response_availability_Gajendra_940_1713160480_41.json', 'e1/15_04_2024/response_header_availability_Gajendra_940_1713160480_41.json', 'expedia', '2024-04-15 05:54:42', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '940');
[04/15/2024 05:54:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:54:40.727'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.944'
        , error_description = ''
        , memory_used = '156018712'
        WHERE id = '108464';
[04/15/2024 05:56:04], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:04' WHERE id= '774';
[04/15/2024 05:56:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-15 05:56:04',login_attempt=0 where id = '7873';
[04/15/2024 05:56:04], [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-04-15 05:56:04', ip = '43.239.53.130', action = 'Login' ;
[04/15/2024 05:56:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:04' WHERE id= '774';
[04/15/2024 05:56:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:10' WHERE id= '774';
[04/15/2024 05:56:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:16' WHERE id= '774';
[04/15/2024 05:56:16], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/04/27' , departure_date = '2024/04/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-15 05:56:16' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/15/2024 05:56:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:16' WHERE id= '774';
[04/15/2024 05:56: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/15_04_2024/request_availability_Gajendra_941_1713160577_44.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160577_44.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160577_44.json', 'expedia', '2024-04-15 05:56:17', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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.249'
        , error_description = ''
        , memory_used = '1560456'
        WHERE id = '108465';
[04/15/2024 05:56: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/15_04_2024/request_availability_Gajendra_941_1713160577_8.json', 'e1p/15_04_2024/response_availability_Gajendra_941_1713160577_8.json', 'e1p/15_04_2024/response_header_availability_Gajendra_941_1713160577_8.json', 'expediapackage', '2024-04-15 05:56:17', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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.369'
        , error_description = ''
        , memory_used = '1560928'
        WHERE id = '108466';
[04/15/2024 05:56:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_941_1713160577_70.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160577_70.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160577_70.json', 'expedia', '2024-04-15 05:56:18', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/15_04_2024/request_availability_Gajendra_941_1713160577_80.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160577_80.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160577_80.json', 'expedia', '2024-04-15 05:56:18', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56: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/15_04_2024/request_availability_Gajendra_941_1713160577_98.json', 'e1p/15_04_2024/response_availability_Gajendra_941_1713160577_98.json', 'e1p/15_04_2024/response_header_availability_Gajendra_941_1713160577_98.json', 'expediapackage', '2024-04-15 05:56:19', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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 = '2.301'
        , error_description = ''
        , memory_used = '154269272'
        WHERE id = '108467';
[04/15/2024 05:56:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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 = '2.475'
        , error_description = ''
        , memory_used = '183203544'
        WHERE id = '108468';
[04/15/2024 05:56: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/15_04_2024/request_availability_Gajendra_941_1713160577_62.json', 'e1p/15_04_2024/response_availability_Gajendra_941_1713160577_62.json', 'e1p/15_04_2024/response_header_availability_Gajendra_941_1713160577_62.json', 'expediapackage', '2024-04-15 05:56:19', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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 = '3.155'
        , error_description = ''
        , memory_used = '160901120'
        WHERE id = '108469';
[04/15/2024 05:56:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56: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 = '3.929'
        , error_description = ''
        , memory_used = '193487464'
        WHERE id = '108470';
[04/15/2024 05:56:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7873&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001',
        duration = '4.117',
        merge_duration = '0.008',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '1.78',
        system_load_5_min = '1.00',
        system_load_15_min = '0.84',
        system_memory_usage = '65.18',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '941') + '2804184',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '941';
[04/15/2024 05:56:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:21' WHERE id= '774';
[04/15/2024 05:56:21], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:21' WHERE id= '774';
[04/15/2024 05:56:23], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:23' WHERE id= '774';
[04/15/2024 05:56:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:37' WHERE id= '774';
[04/15/2024 05:56:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:56:54' WHERE id= '774';
[04/15/2024 05:56:55], [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/15_04_2024/request_availability_Gajendra_941_1713160614_32.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160614_32.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160614_32.json', 'expedia', '2024-04-15 05:56:55', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:56:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:56:54.180'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.137'
        , error_description = ''
        , memory_used = '183492584'
        WHERE id = '108471';
[04/15/2024 05:57:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:57:50' WHERE id= '774';
[04/15/2024 05:57:51], [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/15_04_2024/request_availability_Gajendra_941_1713160670_18.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160670_18.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160670_18.json', 'expedia', '2024-04-15 05:57:51', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:57:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:57:50.273'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.299'
        , error_description = ''
        , memory_used = '183321104'
        WHERE id = '108472';
[04/15/2024 05:58:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-15 05:58:55' WHERE id= '774';
[04/15/2024 05:58:56], [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/15_04_2024/request_availability_Gajendra_941_1713160735_33.json', 'e1/15_04_2024/response_availability_Gajendra_941_1713160735_33.json', 'e1/15_04_2024/response_header_availability_Gajendra_941_1713160735_33.json', 'expedia', '2024-04-15 05:58:56', '', 'ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001', '941');
[04/15/2024 05:58:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ec55d89d66137d01c6706cdb8130ca598383200213926341f3f3a6f8fd904001&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-15 05:58:55.300'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.347'
        , error_description = ' Uncaught exception &#039;ClickHouseDB\Exception\QueryException&#039; with message &#039;HttpCode:400 ;  ;Code: 62. DB::Exception: Cannot parse expression of type String here: &#039;{&quot;hotelCode&quot;:&quot;2235336&quot;,&quot;hotelId&quot;:[{&quot;expedia&quot;:&quot;2235336&quot;}],&quot;name&quot;:&quot;ATLANTIS, THE PALM&quot;,&quot;local_hotel_id&quot;:&quot;&quot;,&quot;address1&quot;:&quot;Crescent Road The Palm&quot;,&quot;location&quot;:&quot;&quot;,&quot;lat: While executing ValuesBlockInputFormat. (SYNTAX_ERROR) (version 24.2.2.71 (official build))
&#039; in /home/otrams/public_html/beta/phpClickHouse/src/Statement.php:174
Stack trace:
#0 /home/otrams/public_html/beta/phpClickHouse/src/Transport/Http.php(581): ClickHouseDB\Statement-&gt;error()
#1 /home/otrams/public_html/beta/phpClickHouse/src/Client.php(538): ClickHouseDB\Transport\Http-&gt;write(&#039;INSERT INTO sup...&#039;)
#2 /home/otrams/public_html/beta/tms/classes/HotelClickhouse.php(98): ClickHouseDB\Client-&gt;insert(&#039;supplier_hotels...&#039;, Array, Array)
#3 /home/otrams/public_html/beta/tms/classes/OMongo.php(362): HotelClickhouse-&gt;clickRowDataInsert(Array)
#4 /home/otrams/public_html/beta/tms/classes/supplier/ | 1 | /home/otrams/public_html/beta/phpClickHouse/src/Statement.php:174'
        , memory_used = '183455456'
        WHERE id = '108473';
