[01/12/2024 07:00:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:00:00' WHERE id= '273';
[01/12/2024 07:00:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/14',  departure_date='2024/01/14',  nights='1',  create_date='2024-01-12 :07:00:00',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/12/2024 07:00:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/12_01_2024/request_availability_Viator_test_07_00_00_1705042800.json', 'v1/12_01_2024/response_availability_Viator_test_07_00_00_1705042800.json', 'v1/12_01_2024/response_header_availability_Viator_test_07_00_00_1705042800.json', 'viator', '2024-01-12 07:00:06', '', '', '817');
[01/12/2024 07:00:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:00:08' WHERE id= '273';
[01/12/2024 07:00:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:00:09' WHERE id= '273';
[01/12/2024 07:00:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:00:11' WHERE id= '273';
[01/12/2024 07:00:11], [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/12_01_2024/request_sight_details_Viator_test_07_00_11_1705042811.json', 'v1/12_01_2024/response_sight_details_Viator_test_07_00_11_1705042811.json', 'v1/12_01_2024/response_header_sight_details_Viator_test_07_00_11_1705042811.json', 'viator', '2024-01-12 07:00:11', '', '', '817');
[01/12/2024 07:00:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:00:15' WHERE id= '273';
[01/12/2024 07:00:15], [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/12_01_2024/request_check_availability_Viator_test_07_00_15_1705042815.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_00_15_1705042815.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_00_15_1705042815.json', 'viator', '2024-01-12 07:00:15', '', '', '817');
[01/12/2024 07:02:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:02:05' WHERE id= '273';
[01/12/2024 07:02:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/14',  departure_date='2024/01/14',  nights='1',  create_date='2024-01-12 :07:02:05',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/12/2024 07:02:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/12_01_2024/request_availability_Viator_test_07_02_05_1705042925.json', 'v1/12_01_2024/response_availability_Viator_test_07_02_05_1705042925.json', 'v1/12_01_2024/response_header_availability_Viator_test_07_02_05_1705042925.json', 'viator', '2024-01-12 07:02:07', '', '', '818');
[01/12/2024 07:02:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:02:09' WHERE id= '273';
[01/12/2024 07:02:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:02:09' WHERE id= '273';
[01/12/2024 07:02:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:02:14' WHERE id= '273';
[01/12/2024 07:02:14], [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/12_01_2024/request_sight_details_Viator_test_07_02_14_1705042934.json', 'v1/12_01_2024/response_sight_details_Viator_test_07_02_14_1705042934.json', 'v1/12_01_2024/response_header_sight_details_Viator_test_07_02_14_1705042934.json', 'viator', '2024-01-12 07:02:14', '', '', '818');
[01/12/2024 07:05:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:05:27' WHERE id= '273';
[01/12/2024 07:05:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/12_01_2024/request_check_availability_Viator_test_07_05_27_1705043127.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_05_27_1705043127.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_05_27_1705043127.json', 'viator', '2024-01-12 07:05:28', '', '', '818');
[01/12/2024 07:05:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:05:49' WHERE id= '273';
[01/12/2024 07:05:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705043149','43.239.53.130');
[01/12/2024 07:06:37], [file name :-/home/otrams/public_html/beta/tms/exchange_rates.php],update currencies set mark_up = ? ;
[01/12/2024 07:06:37], [file name :-/home/otrams/public_html/beta/tms/exchange_rates.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-12 07:06:37',`log_type`= 'Exchange Currency Markup Change',`sql_query`= '',`log_description`= 'Currency Markup Changed by User v3alpha to markup=2',`ip`= '43.239.53.130';
[01/12/2024 07:08:06], [file name :-/home/otrams/public_html/beta/tms/exchange_rates.php],update currencies set mark_up = ? ;
[01/12/2024 07:08:06], [file name :-/home/otrams/public_html/beta/tms/exchange_rates.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-12 07:08:06',`log_type`= 'Exchange Currency Markup Change',`sql_query`= '',`log_description`= 'Currency Markup Changed by User v3alpha to markup=0',`ip`= '43.239.53.130';
[01/12/2024 07:16:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:15' WHERE id= '273';
[01/12/2024 07:16:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705043775','43.239.53.130');
[01/12/2024 07:16:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-12 07:16:18',login_attempt=0 where id = '7866';
[01/12/2024 07:16:18], [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-01-12 07:16:18', ip = '43.239.53.130', action = 'Login' ;
[01/12/2024 07:16:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:18' WHERE id= '292';
[01/12/2024 07:16:24], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:24' WHERE id= '292';
[01/12/2024 07:16:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:27' WHERE id= '292';
[01/12/2024 07:16:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:27' WHERE id= '292';
[01/12/2024 07:16:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:30' WHERE id= '292';
[01/12/2024 07:16:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/01/12' , departure_date = '2024/01/13' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-12 07:16:30' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/12/2024 07:16:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:32' WHERE id= '292';
[01/12/2024 07:16:32], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_39.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_39.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_39.json', 'expediapackage', '2024-01-12 07:16:32', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , 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.236'
            , error_description = ''
            , memory_used = '1376936'
            WHERE id = '27764';
[01/12/2024 07:16:32], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_63.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_63.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_63.json', 'expedia', '2024-01-12 07:16:32', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , 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.367'
            , error_description = ''
            , memory_used = '1376944'
            WHERE id = '27765';
[01/12/2024 07:16:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_24.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_24.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_24.json', 'expedia', '2024-01-12 07:16:33', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_29.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_29.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_29.json', 'expedia', '2024-01-12 07:16:33', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.988'
            , error_description = ''
            , memory_used = '94043736'
            WHERE id = '27766';
[01/12/2024 07:16:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , 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.141'
            , error_description = ''
            , memory_used = '110795488'
            WHERE id = '27767';
[01/12/2024 07:16:34], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_41.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_41.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_41.json', 'expediapackage', '2024-01-12 07:16:34', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , 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.076'
            , error_description = ''
            , memory_used = '103197032'
            WHERE id = '27768';
[01/12/2024 07:16: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', 'e1p/12_01_2024/request_availability_Baysan_Tourism_wh_07_16_32_1705043792_8.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_16_32_1705043792_8.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_16_32_1705043792_8.json', 'expediapackage', '2024-01-12 07:16:37', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:16:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:16:32.632'
            , 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 = '5.794'
            , error_description = ''
            , memory_used = '121695160'
            WHERE id = '27769';
[01/12/2024 07:16:38], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:38' WHERE id= '292';
[01/12/2024 07:16:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:16:39' WHERE id= '292';
[01/12/2024 07:18:03], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:18:03' WHERE id= '292';
[01/12/2024 07:18:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:18:52' WHERE id= '273';
[01/12/2024 07:18:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/14',  departure_date='2024/01/14',  nights='1',  create_date='2024-01-12 :07:18:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/12/2024 07:18: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/12_01_2024/request_availability_Viator_test_07_18_52_1705043932.json', 'v1/12_01_2024/response_availability_Viator_test_07_18_52_1705043932.json', 'v1/12_01_2024/response_header_availability_Viator_test_07_18_52_1705043932.json', 'viator', '2024-01-12 07:18:53', '', '', '819');
[01/12/2024 07:18:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:18:55' WHERE id= '273';
[01/12/2024 07:18:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:18:55' WHERE id= '273';
[01/12/2024 07:18:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:18:57' WHERE id= '273';
[01/12/2024 07:18:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/12_01_2024/request_sight_details_Viator_test_07_18_57_1705043937.json', 'v1/12_01_2024/response_sight_details_Viator_test_07_18_57_1705043937.json', 'v1/12_01_2024/response_header_sight_details_Viator_test_07_18_57_1705043937.json', 'viator', '2024-01-12 07:18:58', '', '', '819');
[01/12/2024 07:19:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:19:01' WHERE id= '273';
[01/12/2024 07:19:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/12_01_2024/request_check_availability_Viator_test_07_19_01_1705043941.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_19_01_1705043941.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_19_01_1705043941.json', 'viator', '2024-01-12 07:19:02', '', '', '819');
[01/12/2024 07:24:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:24:33' WHERE id= '273';
[01/12/2024 07:24:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705044273','43.239.53.130');
[01/12/2024 07:33:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:33:51' WHERE id= '292';
[01/12/2024 07:33:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:33:56' WHERE id= '292';
[01/12/2024 07:33:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/01/12' , departure_date = '2024/01/13' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-12 07:33:56' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/12/2024 07:33:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:33:57' WHERE id= '292';
[01/12/2024 07:33:57], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'expedia', '2024-01-12 07:33:57', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:33:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , 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.178'
            , error_description = ''
            , memory_used = '1376824'
            WHERE id = '27773';
[01/12/2024 07:33:57], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_9.json', 'expediapackage', '2024-01-12 07:33:57', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:33:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , 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.192'
            , error_description = ''
            , memory_used = '1376936'
            WHERE id = '27774';
[01/12/2024 07:33:58], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_63.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_63.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_63.json', 'expedia', '2024-01-12 07:33:58', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:33:58], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_19.json', 'e1/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_19.json', 'e1/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_19.json', 'expedia', '2024-01-12 07:33:58', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:33:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.921'
            , error_description = ''
            , memory_used = '93940944'
            WHERE id = '27775';
[01/12/2024 07:33:59], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_65.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_65.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_65.json', 'expediapackage', '2024-01-12 07:33:59', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:33:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , 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.392'
            , error_description = ''
            , memory_used = '109898968'
            WHERE id = '27776';
[01/12/2024 07:33:59], [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/12_01_2024/request_availability_Baysan_Tourism_wh_07_33_57_1705044837_59.json', 'e1p/12_01_2024/response_availability_Baysan_Tourism_wh_07_33_57_1705044837_59.json', 'e1p/12_01_2024/response_header_availability_Baysan_Tourism_wh_07_33_57_1705044837_59.json', 'expediapackage', '2024-01-12 07:33:59', '', '794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e', '0');
[01/12/2024 07:34:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , 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.230'
            , error_description = ''
            , memory_used = '120503512'
            WHERE id = '27777';
[01/12/2024 07:34:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=794708cb08a6439d1b0d709acb667f51b333a0ca900a7e46c5b0fa9a5078b17e&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-12 07:33:57.345'
            , 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.333'
            , error_description = ''
            , memory_used = '103388992'
            WHERE id = '27778';
[01/12/2024 07:34:01], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:34:01' WHERE id= '292';
[01/12/2024 07:47:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:47:31' WHERE id= '273';
[01/12/2024 07:47:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/14',  departure_date='2024/01/14',  nights='1',  create_date='2024-01-12 :07:47:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/12/2024 07:47:33], [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/12_01_2024/request_availability_Viator_test_07_47_31_1705045651.json', 'v1/12_01_2024/response_availability_Viator_test_07_47_31_1705045651.json', 'v1/12_01_2024/response_header_availability_Viator_test_07_47_31_1705045651.json', 'viator', '2024-01-12 07:47:33', '', '', '820');
[01/12/2024 07:47:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:47:35' WHERE id= '273';
[01/12/2024 07:47:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:47:35' WHERE id= '273';
[01/12/2024 07:47:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:47:38' WHERE id= '273';
[01/12/2024 07:47: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/12_01_2024/request_sight_details_Viator_test_07_47_38_1705045658.json', 'v1/12_01_2024/response_sight_details_Viator_test_07_47_38_1705045658.json', 'v1/12_01_2024/response_header_sight_details_Viator_test_07_47_38_1705045658.json', 'viator', '2024-01-12 07:47:38', '', '', '820');
[01/12/2024 07:47:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:47:41' WHERE id= '273';
[01/12/2024 07:47: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/12_01_2024/request_check_availability_Viator_test_07_47_41_1705045661.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_47_41_1705045661.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_47_41_1705045661.json', 'viator', '2024-01-12 07:47:42', '', '', '820');
[01/12/2024 07:57:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:57:44' WHERE id= '273';
[01/12/2024 07:57:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/14',  departure_date='2024/01/14',  nights='1',  create_date='2024-01-12 :07:57:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/12/2024 07:57:45], [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/12_01_2024/request_availability_Viator_test_07_57_44_1705046264.json', 'v1/12_01_2024/response_availability_Viator_test_07_57_44_1705046264.json', 'v1/12_01_2024/response_header_availability_Viator_test_07_57_44_1705046264.json', 'viator', '2024-01-12 07:57:45', '', '', '821');
[01/12/2024 07:57:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:57:47' WHERE id= '273';
[01/12/2024 07:57:47], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:57:47' WHERE id= '273';
[01/12/2024 07:57:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:57:50' WHERE id= '273';
[01/12/2024 07:57:50], [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/12_01_2024/request_sight_details_Viator_test_07_57_50_1705046270.json', 'v1/12_01_2024/response_sight_details_Viator_test_07_57_50_1705046270.json', 'v1/12_01_2024/response_header_sight_details_Viator_test_07_57_50_1705046270.json', 'viator', '2024-01-12 07:57:50', '', '', '821');
[01/12/2024 07:57:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:57:54' WHERE id= '273';
[01/12/2024 07:57:54], [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/12_01_2024/request_check_availability_Viator_test_07_57_54_1705046274.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_57_54_1705046274.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_57_54_1705046274.json', 'viator', '2024-01-12 07:57:54', '', '', '821');
[01/12/2024 07:58:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-12 07:58:02' WHERE id= '273';
[01/12/2024 07:58:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/12_01_2024/request_check_availability_Viator_test_07_58_02_1705046282.json', 'v1/12_01_2024/response_check_availability_Viator_test_07_58_02_1705046282.json', 'v1/12_01_2024/response_header_check_availability_Viator_test_07_58_02_1705046282.json', 'viator', '2024-01-12 07:58:02', '', '', '821');
