[03/26/2024 12:04:55], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-26 12:04:55',login_attempt=0 where id = '7851';
[03/26/2024 12:04:55], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-03-26 12:04:55', ip = '43.239.53.130', action = 'Login' ;
[03/26/2024 12:04:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:04:56' WHERE id= '705';
[03/26/2024 12:05:00], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:00' WHERE id= '705';
[03/26/2024 12:05:04], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:04' WHERE id= '705';
[03/26/2024 12:05:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:05' WHERE id= '705';
[03/26/2024 12:05:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:11' WHERE id= '705';
[03/26/2024 12:05:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-26 :12:05:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/26/2024 12:05:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_11_1711454711.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_11_1711454711.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_11_1711454711.json', 'viator', '2024-03-26 12:05:32', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/26_03_2024/request_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_availability_Viator_test_12_05_32_1711454732_81.json', 'v1/26_03_2024/response_header_availability_Viator_test_12_05_32_1711454732_81.json', 'viator', '2024-03-26 12:05:53', '', '', '581');
[03/26/2024 12:05:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:55' WHERE id= '705';
[03/26/2024 12:05:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:05:55' WHERE id= '705';
[03/26/2024 12:06:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:06:12' WHERE id= '705';
[03/26/2024 12:06:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:06:12' WHERE id= '705';
[03/26/2024 12:06:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:06:37' WHERE id= '705';
[03/26/2024 12:06:38], [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/26_03_2024/request_sight_details_Viator_test_12_06_37_1711454797.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_06_37_1711454797.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_06_37_1711454797.json', 'viator', '2024-03-26 12:06:38', '', '', '581');
[03/26/2024 12:06: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/26_03_2024/request_sight_details_Viator_test_12_06_38_1711454798.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_06_38_1711454798.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_06_38_1711454798.json', 'viator', '2024-03-26 12:06:39', '', '', '581');
[03/26/2024 12:06:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:06:44' WHERE id= '705';
[03/26/2024 12:06:45], [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/26_03_2024/request_check_availability_Viator_test_12_06_44_1711454804.json', 'v1/26_03_2024/response_check_availability_Viator_test_12_06_44_1711454804.json', 'v1/26_03_2024/response_header_check_availability_Viator_test_12_06_44_1711454804.json', 'viator', '2024-03-26 12:06:45', '', '', '581');
[03/26/2024 12:07:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:07:09' WHERE id= '705';
[03/26/2024 12:07:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/26_03_2024/request_sight_details_Viator_test_12_07_09_1711454829.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_07_09_1711454829.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_07_09_1711454829.json', 'viator', '2024-03-26 12:07:09', '', '', '581');
[03/26/2024 12:07:10], [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/26_03_2024/request_sight_details_Viator_test_12_07_09_1711454829.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_07_09_1711454829.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_07_09_1711454829.json', 'viator', '2024-03-26 12:07:10', '', '', '581');
[03/26/2024 12:07:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:07:13' WHERE id= '705';
[03/26/2024 12:07:13], [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/26_03_2024/request_check_availability_Viator_test_12_07_13_1711454833.json', 'v1/26_03_2024/response_check_availability_Viator_test_12_07_13_1711454833.json', 'v1/26_03_2024/response_header_check_availability_Viator_test_12_07_13_1711454833.json', 'viator', '2024-03-26 12:07:13', '', '', '581');
[03/26/2024 12:07:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:07:16' WHERE id= '705';
[03/26/2024 12:07:17], [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/26_03_2024/request_sight_details_Viator_test_12_07_16_1711454836.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_07_16_1711454836.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_07_16_1711454836.json', 'viator', '2024-03-26 12:07:16', '', '', '581');
[03/26/2024 12:07:17], [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/26_03_2024/request_sight_details_Viator_test_12_07_17_1711454837.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_07_17_1711454837.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_07_17_1711454837.json', 'viator', '2024-03-26 12:07:17', '', '', '581');
[03/26/2024 12:07:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:07:24' WHERE id= '705';
[03/26/2024 12:07:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711454844','43.239.53.130');
[03/26/2024 12:09:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:09:39' WHERE id= '705';
[03/26/2024 12:09:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:09:40' WHERE id= '705';
[03/26/2024 12:09:40], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:09:40' WHERE id= '705';
[03/26/2024 12:09:45], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:09:45' WHERE id= '705';
[03/26/2024 12:09:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:09:46' WHERE id= '705';
[03/26/2024 12:10:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:10:04' WHERE id= '705';
[03/26/2024 12:10: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 ('', 'sight_details', 'v1/26_03_2024/request_sight_details_Viator_test_12_10_04_1711455004.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_10_04_1711455004.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_10_04_1711455004.json', 'viator', '2024-03-26 12:10:05', '', '', '581');
[03/26/2024 12:10:06], [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/26_03_2024/request_sight_details_Viator_test_12_10_06_1711455006.json', 'v1/26_03_2024/response_sight_details_Viator_test_12_10_06_1711455006.json', 'v1/26_03_2024/response_header_sight_details_Viator_test_12_10_06_1711455006.json', 'viator', '2024-03-26 12:10:06', '', '', '581');
[03/26/2024 12:10:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:10:09' WHERE id= '705';
[03/26/2024 12:10:10], [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/26_03_2024/request_check_availability_Viator_test_12_10_09_1711455009.json', 'v1/26_03_2024/response_check_availability_Viator_test_12_10_09_1711455009.json', 'v1/26_03_2024/response_header_check_availability_Viator_test_12_10_09_1711455009.json', 'viator', '2024-03-26 12:10:10', '', '', '581');
[03/26/2024 12:10:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-26 12:10:44',login_attempt=0 where id = '7868';
[03/26/2024 12:10:44], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '32', login_datetime = '2024-03-26 12:10:44', ip = '43.239.53.130', action = 'Login' ;
[03/26/2024 12:10:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c',create_date='2024-03-26 12:10:44', update_date='2024-03-26 12:10:44',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[03/26/2024 12:11:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:00' WHERE id= '710';
[03/26/2024 12:11:05], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:05' WHERE id= '710';
[03/26/2024 12:11:05], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/02' , departure_date = '2024/05/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-26 12:11:05' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/26/2024 12:11:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:06' WHERE id= '710';
[03/26/2024 12:11: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', 'e1p/26_03_2024/request_availability_hotel_yards_582_1711455067_84.json', 'e1p/26_03_2024/response_availability_hotel_yards_582_1711455067_84.json', 'e1p/26_03_2024/response_header_availability_hotel_yards_582_1711455067_84.json', 'expediapackage', '2024-03-26 12:11:07', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&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-26 12:11:07.215'
        , 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.530'
        , error_description = ''
        , memory_used = '2790200'
        WHERE id = '81529';
[03/26/2024 12:11: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/26_03_2024/request_availability_hotel_yards_582_1711455067_83.json', 'e1/26_03_2024/response_availability_hotel_yards_582_1711455067_83.json', 'e1/26_03_2024/response_header_availability_hotel_yards_582_1711455067_83.json', 'expedia', '2024-03-26 12:11:07', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=21&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-26 12:11:07.223'
        , 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.653'
        , error_description = ''
        , memory_used = '2790048'
        WHERE id = '81530';
[03/26/2024 12:11:08], [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/26_03_2024/request_availability_hotel_yards_582_1711455067_78.json', 'e1/26_03_2024/response_availability_hotel_yards_582_1711455067_78.json', 'e1/26_03_2024/response_header_availability_hotel_yards_582_1711455067_78.json', 'expedia', '2024-03-26 12:11:08', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11:08], [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/26_03_2024/request_availability_hotel_yards_582_1711455067_77.json', 'e1/26_03_2024/response_availability_hotel_yards_582_1711455067_77.json', 'e1/26_03_2024/response_header_availability_hotel_yards_582_1711455067_77.json', 'expedia', '2024-03-26 12:11:08', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11:08], [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/26_03_2024/request_availability_hotel_yards_582_1711455067_82.json', 'e1p/26_03_2024/response_availability_hotel_yards_582_1711455067_82.json', 'e1p/26_03_2024/response_header_availability_hotel_yards_582_1711455067_82.json', 'expediapackage', '2024-03-26 12:11:08', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11: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/26_03_2024/request_availability_hotel_yards_582_1711455067_34.json', 'e1p/26_03_2024/response_availability_hotel_yards_582_1711455067_34.json', 'e1p/26_03_2024/response_header_availability_hotel_yards_582_1711455067_34.json', 'expediapackage', '2024-03-26 12:11:09', '', 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c', '582');
[03/26/2024 12:11:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.212'
            , total_duration = '4.915'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:12'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.208'
            , total_duration = '5.036'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:12'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.209'
            , total_duration = '5.204'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:12'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.215'
            , total_duration = '5.541'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:12'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992232';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.207'
            , total_duration = '5.857'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.212'
            , total_duration = '6.169'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.212'
            , total_duration = '6.327'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.219'
            , total_duration = '6.457'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.208'
            , total_duration = '6.617'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992384';
[03/26/2024 12:11:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.213'
            , total_duration = '6.670'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:13'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.214'
            , total_duration = '6.930'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.269'
            , total_duration = '6.952'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.266'
            , total_duration = '7.006'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.209'
            , total_duration = '7.136'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992240';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.210'
            , total_duration = '7.150'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71991744';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.257'
            , total_duration = '7.107'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.260'
            , total_duration = '7.339'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&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-26 12:11:07.217'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.458'
        , error_description = ''
        , memory_used = '173869096'
        WHERE id = '81533';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=21&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-26 12:11:07.207'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '7.602'
        , error_description = ''
        , memory_used = '166604944'
        WHERE id = '81532';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.213'
            , total_duration = '7.628'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992344';
[03/26/2024 12:11:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-03-26 12:11:07.220'
            , total_duration = '7.635'
            , hotel_count = 0
            , source_type = 'tboholidays'
            , create_date = '2024-03-26 12:11:14'
            , session_id = 'edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c'
            , agent_logs_id = '582'
            , error_description = ''
            , memory_used = '71992136';
[03/26/2024 12:11:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&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-26 12:11:07.211'
        , 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 = '8.493'
        , error_description = ''
        , memory_used = '196615056'
        WHERE id = '81531';
[03/26/2024 12:11:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=21&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-26 12:11:07.213'
        , 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 = '8.606'
        , error_description = ''
        , memory_used = '204250000'
        WHERE id = '81534';
[03/26/2024 12:11:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '370',
        request_path = '/xml_all.php?userid=7867&sessionid=edc044e28d6e972dc3d48ac5677efc8c16b187b7a31d7e68e67e5ca0bf76986c',
        duration = '13.851',
        merge_duration = '4.474',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '13.15',
        system_load_5_min = '13.70',
        system_load_15_min = '11.95',
        system_memory_usage = '96.38',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '582') + '100994752',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '582';
[03/26/2024 12:11:20], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:20' WHERE id= '710';
[03/26/2024 12:11:20], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:20' WHERE id= '710';
[03/26/2024 12:11:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:20' WHERE id= '710';
[03/26/2024 12:11:21], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:21' WHERE id= '710';
[03/26/2024 12:11:46], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:46' WHERE id= '710';
[03/26/2024 12:11:47], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-03-26 12:11:47' WHERE id= '710';
[03/26/2024 12:13:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-26 12:13:05',login_attempt=0 where id = '7866';
[03/26/2024 12:13:05], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-03-26 12:13:05', ip = '43.239.53.130', action = 'Login' ;
[03/26/2024 12:13:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='532d997a7932dfdd72707d4e9e60919cd417c3f24026c250b0190645dd6ac86a',create_date='2024-03-26 12:13:05', update_date='2024-03-26 12:13:05',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
