[01/11/2024 05:10:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-11 05:10:12',login_attempt=0 where id = '7865';
[01/11/2024 05:10:12], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-11 05:10:12', ip = '43.239.53.130', action = 'Login' ;
[01/11/2024 05:10:12], [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='6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2',create_date='2024-01-11 05:10:12', update_date='2024-01-11 05:10:12',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/11/2024 05:10:26], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:26' WHERE id= '271';
[01/11/2024 05:10:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:27' WHERE id= '271';
[01/11/2024 05:10:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:32' WHERE id= '271';
[01/11/2024 05:10:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:34' WHERE id= '271';
[01/11/2024 05:10:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:39' WHERE id= '271';
[01/11/2024 05:10:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:48' WHERE id= '271';
[01/11/2024 05:10:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:49' WHERE id= '271';
[01/11/2024 05:10:57], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:57' WHERE id= '271';
[01/11/2024 05:10:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:10:59' WHERE id= '271';
[01/11/2024 05:11:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:11:08' WHERE id= '271';
[01/11/2024 05:11:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:11:11' WHERE id= '271';
[01/11/2024 05:11:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/11' , departure_date = '2024/01/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-11 05:11:11' , 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/11/2024 05:11:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:11:13' WHERE id= '271';
[01/11/2024 05:11:14], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_8.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_8.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_8.json', 'expediapackage', '2024-01-11 05:11:14', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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.476'
            , error_description = ''
            , memory_used = '1387432'
            WHERE id = '27320';
[01/11/2024 05:11:15], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_63.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_63.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_63.json', 'expedia', '2024-01-11 05:11:15', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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.367'
            , error_description = ''
            , memory_used = '1387272'
            WHERE id = '27321';
[01/11/2024 05:11: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'expediapackage', '2024-01-11 05:11:16', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_18.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_18.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_18.json', 'expediapackage', '2024-01-11 05:11:16', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_6.json', 'expedia', '2024-01-11 05:11:17', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_11_14_1704949874_48.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_11_14_1704949874_48.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_11_14_1704949874_48.json', 'expedia', '2024-01-11 05:11:17', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:11:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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.694'
            , error_description = ''
            , memory_used = '112169880'
            WHERE id = '27323';
[01/11/2024 05:11:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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.720'
            , error_description = ''
            , memory_used = '103326088'
            WHERE id = '27322';
[01/11/2024 05:11:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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.870'
            , error_description = ''
            , memory_used = '101927512'
            WHERE id = '27324';
[01/11/2024 05:11:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:11:13.989'
            , 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 = '4.371'
            , error_description = ''
            , memory_used = '93808288'
            WHERE id = '27325';
[01/11/2024 05:11:18], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:11:18' WHERE id= '271';
[01/11/2024 05:11:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:11:19' WHERE id= '271';
[01/11/2024 05:21:53], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-11 05:21:53',login_attempt=0 where id = '7865';
[01/11/2024 05:21:53], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-11 05:21:53', ip = '43.239.53.130', action = 'Login' ;
[01/11/2024 05:21:53], [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='bd614cd63d0c60dae8c7f8d8a8820ee42eddb60d96edc46b10f519ed55eeb530',create_date='2024-01-11 05:21:53', update_date='2024-01-11 05:21:53',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/11/2024 05:21:57], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:21:57' WHERE id= '272';
[01/11/2024 05:22:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:01' WHERE id= '272';
[01/11/2024 05:22:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:03' WHERE id= '272';
[01/11/2024 05:22:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-11 :05:22:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/11/2024 05:22:03], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_22_03_1704950523.json', 'v1/11_01_2024/response_availability_Baysan_Tourism_wh_05_22_03_1704950523.json', 'v1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_22_03_1704950523.json', 'viator', '2024-01-11 05:22:03', '', '', '720');
[01/11/2024 05:22:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:05' WHERE id= '272';
[01/11/2024 05:22:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:05' WHERE id= '272';
[01/11/2024 05:22:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:08' WHERE id= '271';
[01/11/2024 05:22:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:12' WHERE id= '271';
[01/11/2024 05:22:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:13' WHERE id= '271';
[01/11/2024 05:22:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:14' WHERE id= '271';
[01/11/2024 05:22:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:14' WHERE id= '271';
[01/11/2024 05:22:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:16' WHERE id= '271';
[01/11/2024 05:22:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:16' WHERE id= '272';
[01/11/2024 05:22:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_22_16_1704950536.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_22_16_1704950536.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_22_16_1704950536.json', 'viator', '2024-01-11 05:22:16', '', '', '720');
[01/11/2024 05:22:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:30' WHERE id= '271';
[01/11/2024 05:22:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:30' WHERE id= '272';
[01/11/2024 05:22:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:36' WHERE id= '271';
[01/11/2024 05:22:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:43' WHERE id= '271';
[01/11/2024 05:22:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:51' WHERE id= '271';
[01/11/2024 05:22:53], [file name :-/home/otrams/public_html/beta/sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:53' WHERE id= '272';
[01/11/2024 05:22:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:22:53' WHERE id= '271';
[01/11/2024 05:23:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:03' WHERE id= '271';
[01/11/2024 05:23:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:08' WHERE id= '271';
[01/11/2024 05:23:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:31' WHERE id= '271';
[01/11/2024 05:23:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:41' WHERE id= '271';
[01/11/2024 05:23:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:47' WHERE id= '271';
[01/11/2024 05:23:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:58' WHERE id= '271';
[01/11/2024 05:23:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:23:59' WHERE id= '271';
[01/11/2024 05:26:02], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:26:02' WHERE id= '271';
[01/11/2024 05:26:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:26:03' WHERE id= '271';
[01/11/2024 05:26:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:26:10' WHERE id= '271';
[01/11/2024 05:27:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:02' WHERE id= '272';
[01/11/2024 05:27:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-11 :05:27:02',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/11/2024 05:27:02], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_27_02_1704950822.json', 'v1/11_01_2024/response_availability_Baysan_Tourism_wh_05_27_02_1704950822.json', 'v1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_27_02_1704950822.json', 'viator', '2024-01-11 05:27:02', '', '', '721');
[01/11/2024 05:27:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:04' WHERE id= '272';
[01/11/2024 05:27:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:05' WHERE id= '272';
[01/11/2024 05:27:08], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:08' WHERE id= '271';
[01/11/2024 05:27:09], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:09' WHERE id= '271';
[01/11/2024 05:27:26], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:26' WHERE id= '271';
[01/11/2024 05:27:26], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:26' WHERE id= '271';
[01/11/2024 05:27:33], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:33' WHERE id= '271';
[01/11/2024 05:27:33], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:33' WHERE id= '271';
[01/11/2024 05:27:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:27:55' WHERE id= '272';
[01/11/2024 05:27:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_27_55_1704950875.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_27_55_1704950875.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_27_55_1704950875.json', 'viator', '2024-01-11 05:27:55', '', '', '721');
[01/11/2024 05:28:00], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:00' WHERE id= '271';
[01/11/2024 05:28:00], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:00' WHERE id= '271';
[01/11/2024 05:28:00], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950880','43.239.53.130');
[01/11/2024 05:28:01], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_28_00_1704950880_88.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_28_00_1704950880_88.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_28_00_1704950880_88.json', 'expediapackage', '2024-01-11 05:28:01', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:28:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:08' WHERE id= '272';
[01/11/2024 05:28:22], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:22' WHERE id= '271';
[01/11/2024 05:28:27], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:27' WHERE id= '271';
[01/11/2024 05:28:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:31' WHERE id= '271';
[01/11/2024 05:28:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/03/28' , departure_date = '2024/03/29' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:28:31' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:28:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:33' WHERE id= '271';
[01/11/2024 05:28:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_28_33_1704950913_67.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_28_33_1704950913_67.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_28_33_1704950913_67.json', 'expedia', '2024-01-11 05:28:35', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:28:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_28_33_1704950913_74.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_28_33_1704950913_74.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_28_33_1704950913_74.json', 'expedia', '2024-01-11 05:28:35', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:28:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:28:33.740'
            , 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.107'
            , error_description = ''
            , memory_used = '101503528'
            WHERE id = '27331';
[01/11/2024 05:28:36], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_28_33_1704950913_55.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_28_33_1704950913_55.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_28_33_1704950913_55.json', 'expediapackage', '2024-01-11 05:28:36', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:28:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:28:33.740'
            , 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.494'
            , error_description = ''
            , memory_used = '103711504'
            WHERE id = '27333';
[01/11/2024 05:28:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:28:33.740'
            , 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.680'
            , error_description = ''
            , memory_used = '225978928'
            WHERE id = '27332';
[01/11/2024 05:28:38], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_28_33_1704950913_95.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_28_33_1704950913_95.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_28_33_1704950913_95.json', 'expediapackage', '2024-01-11 05:28:38', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:28:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:28:33.740'
            , 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 = '6.559'
            , error_description = ''
            , memory_used = '238825384'
            WHERE id = '27334';
[01/11/2024 05:28:41], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:41' WHERE id= '271';
[01/11/2024 05:28:41], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:41' WHERE id= '271';
[01/11/2024 05:28:54], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:54' WHERE id= '271';
[01/11/2024 05:28:54], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:54' WHERE id= '271';
[01/11/2024 05:28:58], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:58' WHERE id= '271';
[01/11/2024 05:28:58], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:28:58' WHERE id= '271';
[01/11/2024 05:28:58], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950938','43.239.53.130');
[01/11/2024 05:28:59], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/11_01_2024/request_valuation_Baysan_Tourism_wh_05_28_58_1704950938_74.json', 'e1/11_01_2024/response_valuation_Baysan_Tourism_wh_05_28_58_1704950938_74.json', 'e1/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_28_58_1704950938_74.json', 'expedia', '2024-01-11 05:28:59', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:25' WHERE id= '271';
[01/11/2024 05:29:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:29:25' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:29:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:25' WHERE id= '271';
[01/11/2024 05:29:27], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_29_25_1704950965_11.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_29_25_1704950965_11.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_29_25_1704950965_11.json', 'expedia', '2024-01-11 05:29:27', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:29:25.953'
            , 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.292'
            , error_description = ''
            , memory_used = '97986048'
            WHERE id = '27336';
[01/11/2024 05:29: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_29_25_1704950965_55.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_29_25_1704950965_55.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_29_25_1704950965_55.json', 'expediapackage', '2024-01-11 05:29:28', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_29_25_1704950965_36.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_29_25_1704950965_36.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_29_25_1704950965_36.json', 'expedia', '2024-01-11 05:29:28', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:29:25.953'
            , 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.171'
            , error_description = ''
            , memory_used = '104041688'
            WHERE id = '27337';
[01/11/2024 05:29:29], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_29_25_1704950965_76.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_29_25_1704950965_76.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_29_25_1704950965_76.json', 'expediapackage', '2024-01-11 05:29:29', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:29:25.953'
            , 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 = '4.730'
            , error_description = ''
            , memory_used = '223169888'
            WHERE id = '27338';
[01/11/2024 05:29:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:29:25.953'
            , 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.585'
            , error_description = ''
            , memory_used = '240011192'
            WHERE id = '27339';
[01/11/2024 05:29:32], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:32' WHERE id= '271';
[01/11/2024 05:29:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:32' WHERE id= '271';
[01/11/2024 05:29:41], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:41' WHERE id= '271';
[01/11/2024 05:29:41], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:41' WHERE id= '271';
[01/11/2024 05:29:41], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950981','43.239.53.130');
[01/11/2024 05:29:42], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_41_1704950981_73.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_41_1704950981_73.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_41_1704950981_73.json', 'expediapackage', '2024-01-11 05:29:42', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:44], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:44' WHERE id= '271';
[01/11/2024 05:29:44], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:44' WHERE id= '271';
[01/11/2024 05:29:44], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950984','43.239.53.130');
[01/11/2024 05:29:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_44_1704950984_63.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_44_1704950984_63.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_44_1704950984_63.json', 'expediapackage', '2024-01-11 05:29:45', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:47], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:47' WHERE id= '271';
[01/11/2024 05:29:47], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:47' WHERE id= '271';
[01/11/2024 05:29:47], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950987','43.239.53.130');
[01/11/2024 05:29:48], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_47_1704950987_89.json', 'e1/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_47_1704950987_89.json', 'e1/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_47_1704950987_89.json', 'expedia', '2024-01-11 05:29:48', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:49], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:49' WHERE id= '271';
[01/11/2024 05:29:50], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:50' WHERE id= '271';
[01/11/2024 05:29:50], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950990','43.239.53.130');
[01/11/2024 05:29:50], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_50_1704950990_74.json', 'e1/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_50_1704950990_74.json', 'e1/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_50_1704950990_74.json', 'expedia', '2024-01-11 05:29:50', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:53], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:53' WHERE id= '271';
[01/11/2024 05:29:53], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:53' WHERE id= '271';
[01/11/2024 05:29:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950993','43.239.53.130');
[01/11/2024 05:29:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_53_1704950993_37.json', 'e1/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_53_1704950993_37.json', 'e1/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_53_1704950993_37.json', 'expedia', '2024-01-11 05:29:53', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:29:55], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:55' WHERE id= '271';
[01/11/2024 05:29:55], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:29:55' WHERE id= '271';
[01/11/2024 05:29:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704950995','43.239.53.130');
[01/11/2024 05:29:56], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/11_01_2024/request_valuation_Baysan_Tourism_wh_05_29_55_1704950995_98.json', 'e1/11_01_2024/response_valuation_Baysan_Tourism_wh_05_29_55_1704950995_98.json', 'e1/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_29_55_1704950995_98.json', 'expedia', '2024-01-11 05:29:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:30:01], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:01' WHERE id= '271';
[01/11/2024 05:30:02], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:02' WHERE id= '271';
[01/11/2024 05:30:02], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704951002','43.239.53.130');
[01/11/2024 05:30:02], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_30_02_1704951002_82.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_30_02_1704951002_82.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_30_02_1704951002_82.json', 'expediapackage', '2024-01-11 05:30:02', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:30:10], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:10' WHERE id= '271';
[01/11/2024 05:30:10], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:10' WHERE id= '271';
[01/11/2024 05:30:10], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704951010','43.239.53.130');
[01/11/2024 05:30:13], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_30_11_1704951011_42.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_30_11_1704951011_42.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_30_11_1704951011_42.json', 'expediapackage', '2024-01-11 05:30:13', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:30:18], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:18' WHERE id= '271';
[01/11/2024 05:30:18], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:18' WHERE id= '271';
[01/11/2024 05:30:18], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704951018','43.239.53.130');
[01/11/2024 05:30:19], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/11_01_2024/request_valuation_Baysan_Tourism_wh_05_30_18_1704951018_61.json', 'e1p/11_01_2024/response_valuation_Baysan_Tourism_wh_05_30_18_1704951018_61.json', 'e1p/11_01_2024/response_header_valuation_Baysan_Tourism_wh_05_30_18_1704951018_61.json', 'expediapackage', '2024-01-11 05:30:19', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:30:29], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:30:29' WHERE id= '271';
[01/11/2024 05:31:02], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:31:02' WHERE id= '271';
[01/11/2024 05:31:02], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1704951062','43.239.53.130');
[01/11/2024 05:31:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:31:04' WHERE id= '271';
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1459', create_date = '2024-01-11 05:31:05', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '52.83', display_currency_code = 'USD', native_room_rate = '48.03', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/06/19', check_out_date = '2024/06/20', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'deepak', leader_last_name = 'trivedi', status_date = '2024-01-11 05:31:05';
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('161','IBIS DUBAI MALL OF THE EMIRATES','ibis Dubai Mall of the Emirates Hotel','2301578','OT000144444','dubai','expediapackage',NOW());
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='161'
		;
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('161','1459','','1','1','0','-','','','2301578','ibis Dubai Mall of the Emirates Hotel','2 A Street Al Barsha, Mall of the Emirates','+97143823000','3.0','1','2024/06/19','2024/06/20','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzMwMDAwMDAvMjMxMDAwMC8yMzAxNjAwLzIzMDE1NzgvYTUzNDBiZWJfYi5qcGc=');
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '161', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Double Room, 1 Double Bed(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Special deal)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:52.829999999999998;s:25:"displayNightlyRateDisplay";s:197:"Rate - 48.03, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 10.00%, Markup Amount - 0, Markup Amount in SAR- 0.00, Supplier Commission - 2.71 USD, Marketing Fee - 2.71  USD #expediapackage";s:13:"whNightlyRate";d:53.090000000000003;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:48.030000000000001;}}', native_room_rate_total = '48.03', wh_room_rate_total = '53.09', display_room_rate_total = '52.83', number_of_rooms = '1';
[01/11/2024 05:31:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '161', booking_detail_id = '1', rid = '158', room = '0', salutations = 'Mr', first_name = 'deepak', last_name = 'trivedi', passenger_type = 'adult', age = '';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/11_01_2024/request_reservation_Baysan_Tourism_wh_05_31_05_1704951065_14.json', 'e1p/11_01_2024/response_reservation_Baysan_Tourism_wh_05_31_05_1704951065_14.json', 'e1p/11_01_2024/response_header_reservation_Baysan_Tourism_wh_05_31_05_1704951065_14.json', 'expediapackage', '2024-01-11 05:31:06', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7825212542854', confirmation_number = '7825212542854', display_discount = '0', cancellation_policy = 'Free cancellation up to  01:59:59 on  2024-06-18<br>If you cancel between 2024-06-18 02:00:00 and 2024-06-19 00:00:00 , you will be charged 48.76 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 02:00 on 18th of June 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-06-18 14:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Special deal,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 9.99 AED (2.72 USD)</b><br/><span style=\'color: red;\'><strong>Note:</strong> *This conversion is an approximate price based on the current exchange rate and may change before your stay.</span><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'deepak.trivedi@qtechsoftware.com', leader_phone = '12345677654', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Special deal,<br><br/><br/><br/><b style=\'color:#2748a3;\'>Property fee due at property 9.99 AED (2.72 USD)</b><br/><span style=\'color: red;\'><strong>Note:</strong> *This conversion is an approximate price based on the current exchange rate and may change before your stay.</span><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='53.09',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='9.99',  agent_markup='9.99',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='52.83',  applicable_service_tax='0',  supplier_rate='48.03',  uid='3ae12638de5af55b4e06aa37c785b3c9'  where id='161';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='161';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('161','25.116302857621','55.195640982803');
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2024-01-11 05:31:06',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;161\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -161 And Booking Status - confirmed',`ip`= '43.239.53.130';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='598', `entity`='BookingId', `value`='161' ;
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1459','161','confirmed','2024-01-11 05:31:06','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('161','2024-06-18 02:00:00','2024-06-18 02:00:00','2024-06-19 00:00:00','2024-06-19 00:00:00','44.11','48.76','0','2024-01-11 05:31:06','48.76');
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='161',status='1' where reservation_id='1459' and booking_id ='0';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='161' where agent_logs_id='0' and source_type='expediapackage';
[01/11/2024 05:31:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='2.71',  commission_tax='',  booking_id ='161',  supplier_tax='8.82',  supplier_base_fare='39.21',  supplier_commissionable_fare='2.71'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-01-11 05:31:06';
[01/11/2024 05:31:43], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:31:43' WHERE id= '271';
[01/11/2024 05:33:56], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:33:56' WHERE id= '271';
[01/11/2024 05:34:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:10' WHERE id= '272';
[01/11/2024 05:34:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-11 :05:34:10',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/11/2024 05:34: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_34_10_1704951250.json', 'v1/11_01_2024/response_availability_Baysan_Tourism_wh_05_34_10_1704951250.json', 'v1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_34_10_1704951250.json', 'viator', '2024-01-11 05:34:11', '', '', '722');
[01/11/2024 05:34:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:13' WHERE id= '272';
[01/11/2024 05:34:13], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:13' WHERE id= '272';
[01/11/2024 05:34:15], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-11 05:34:15',login_attempt=0 where id = '7851';
[01/11/2024 05:34:15], [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-01-11 05:34:15', ip = '43.239.53.130', action = 'Login' ;
[01/11/2024 05:34:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7851', session_id='ae5e6393edfcd5608049c0b30f60716cc8d09b0f13e38132d200722f7eadb332',create_date='2024-01-11 05:34:15', update_date='2024-01-11 05:34:15',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/11/2024 05:34:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:17' WHERE id= '272';
[01/11/2024 05:34:18], [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/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_34_17_1704951257.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_34_17_1704951257.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_34_17_1704951257.json', 'viator', '2024-01-11 05:34:18', '', '', '722');
[01/11/2024 05:34:23], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:23' WHERE id= '271';
[01/11/2024 05:34:45], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:45' WHERE id= '273';
[01/11/2024 05:34:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:50' WHERE id= '273';
[01/11/2024 05:34:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:57' WHERE id= '273';
[01/11/2024 05:34:57], [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-11 :05:34:57',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/11/2024 05:34:57], [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/11_01_2024/request_availability_Viator_test_05_34_57_1704951297.json', 'v1/11_01_2024/response_availability_Viator_test_05_34_57_1704951297.json', 'v1/11_01_2024/response_header_availability_Viator_test_05_34_57_1704951297.json', 'viator', '2024-01-11 05:34:57', '', '', '723');
[01/11/2024 05:34:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:58' WHERE id= '273';
[01/11/2024 05:34:59], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:34:59' WHERE id= '273';
[01/11/2024 05:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:35:02' WHERE id= '273';
[01/11/2024 05:35:03], [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/11_01_2024/request_sight_details_Viator_test_05_35_02_1704951302.json', 'v1/11_01_2024/response_sight_details_Viator_test_05_35_02_1704951302.json', 'v1/11_01_2024/response_header_sight_details_Viator_test_05_35_02_1704951302.json', 'viator', '2024-01-11 05:35:03', '', '', '723');
[01/11/2024 05:35:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:35:06' WHERE id= '273';
[01/11/2024 05:35:07], [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/11_01_2024/request_check_availability_Viator_test_05_35_06_1704951306.json', 'v1/11_01_2024/response_check_availability_Viator_test_05_35_06_1704951306.json', 'v1/11_01_2024/response_header_check_availability_Viator_test_05_35_06_1704951306.json', 'viator', '2024-01-11 05:35:07', '', '', '723');
[01/11/2024 05:35:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:35:54' WHERE id= '272';
[01/11/2024 05:35: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 ('', 'sight_details', 'v1/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_35_54_1704951354.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_35_54_1704951354.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_35_54_1704951354.json', 'viator', '2024-01-11 05:35:54', '', '', '722');
[01/11/2024 05:36:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:04' WHERE id= '272';
[01/11/2024 05:36:04], [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/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_36_04_1704951364.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_36_04_1704951364.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_36_04_1704951364.json', 'viator', '2024-01-11 05:36:04', '', '', '722');
[01/11/2024 05:36:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:07' WHERE id= '272';
[01/11/2024 05:36:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-11 :05:36:07',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/11/2024 05:36:08], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_36_07_1704951367.json', 'v1/11_01_2024/response_availability_Baysan_Tourism_wh_05_36_07_1704951367.json', 'v1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_36_07_1704951367.json', 'viator', '2024-01-11 05:36:08', '', '', '724');
[01/11/2024 05:36:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:10' WHERE id= '272';
[01/11/2024 05:36:11], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:11' WHERE id= '272';
[01/11/2024 05:36:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:17' WHERE id= '272';
[01/11/2024 05:36: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/11_01_2024/request_sight_details_Baysan_Tourism_wh_05_36_17_1704951377.json', 'v1/11_01_2024/response_sight_details_Baysan_Tourism_wh_05_36_17_1704951377.json', 'v1/11_01_2024/response_header_sight_details_Baysan_Tourism_wh_05_36_17_1704951377.json', 'viator', '2024-01-11 05:36:17', '', '', '724');
[01/11/2024 05:36:38], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:36:38' WHERE id= '271';
[01/11/2024 05:37:07], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-11 05:37:07',login_attempt=0 where id = '7866';
[01/11/2024 05:37:07], [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-11 05:37:07', ip = '43.239.53.130', action = 'Login' ;
[01/11/2024 05:37:08], [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='dee55a1f3c190d783f1ab5a931b502610549d996e6435db1612e0dd177518ee9',create_date='2024-01-11 05:37:08', update_date='2024-01-11 05:37:08',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/11/2024 05:37:10], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:10' WHERE id= '274';
[01/11/2024 05:37:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:31' WHERE id= '272';
[01/11/2024 05:37:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:36' WHERE id= '272';
[01/11/2024 05:37:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/11',  departure_date='2024/01/11',  nights='1',  create_date='2024-01-11 :05:37:36',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/11/2024 05:37:36], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_36_1704951456.json', 'v1/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_36_1704951456.json', 'v1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_36_1704951456.json', 'viator', '2024-01-11 05:37:36', '', '', '725');
[01/11/2024 05:37:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:43' WHERE id= '272';
[01/11/2024 05:37:45], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:45' WHERE id= '274';
[01/11/2024 05:37:45], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:45' WHERE id= '272';
[01/11/2024 05:37:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:48' WHERE id= '271';
[01/11/2024 05:37:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:53' WHERE id= '271';
[01/11/2024 05:37:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:37:53' , 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/11/2024 05:37:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:54' WHERE id= '271';
[01/11/2024 05:37:54], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_33.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_33.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_33.json', 'expedia', '2024-01-11 05:37:54', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.200'
            , error_description = ''
            , memory_used = '1376616'
            WHERE id = '27360';
[01/11/2024 05:37:54], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_22.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_22.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_22.json', 'expediapackage', '2024-01-11 05:37:54', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.279'
            , error_description = ''
            , memory_used = '1377256'
            WHERE id = '27361';
[01/11/2024 05:37: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_72.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_72.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_72.json', 'expedia', '2024-01-11 05:37:55', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_10.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_10.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_10.json', 'expedia', '2024-01-11 05:37:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_99.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_99.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_99.json', 'expediapackage', '2024-01-11 05:37:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_37_54_1704951474_24.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_37_54_1704951474_24.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_37_54_1704951474_24.json', 'expediapackage', '2024-01-11 05:37:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:37:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.797'
            , error_description = ''
            , memory_used = '168432352'
            WHERE id = '27362';
[01/11/2024 05:37:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.320'
            , error_description = ''
            , memory_used = '196466592'
            WHERE id = '27363';
[01/11/2024 05:37:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.591'
            , error_description = ''
            , memory_used = '179777144'
            WHERE id = '27365';
[01/11/2024 05:37:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:37:54.417'
            , 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.893'
            , error_description = ''
            , memory_used = '209645456'
            WHERE id = '27364';
[01/11/2024 05:37:59], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:59' WHERE id= '271';
[01/11/2024 05:37:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:37:59' WHERE id= '271';
[01/11/2024 05:38:11], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:38:11' WHERE id= '271';
[01/11/2024 05:38:30], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:38:30' WHERE id= '274';
[01/11/2024 05:39:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:39:05' WHERE id= '271';
[01/11/2024 05:39:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:39:09' WHERE id= '271';
[01/11/2024 05:39:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:39:09' , 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/11/2024 05:39:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:39:09' WHERE id= '271';
[01/11/2024 05:39:10], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_77.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_77.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_77.json', 'expediapackage', '2024-01-11 05:39:10', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.96'
            , 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.270'
            , error_description = ''
            , memory_used = '1377256'
            WHERE id = '27366';
[01/11/2024 05:39:10], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_15.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_15.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_15.json', 'expedia', '2024-01-11 05:39:10', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.96'
            , 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.316'
            , error_description = ''
            , memory_used = '1376616'
            WHERE id = '27367';
[01/11/2024 05:39:11], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_59.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_59.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_59.json', 'expedia', '2024-01-11 05:39:11', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:12], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_10.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_10.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_10.json', 'expedia', '2024-01-11 05:39:12', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:12], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_5.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_5.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_5.json', 'expediapackage', '2024-01-11 05:39:12', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:12], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_39_10_1704951550_23.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_39_10_1704951550_23.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_39_10_1704951550_23.json', 'expediapackage', '2024-01-11 05:39:12', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:39:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.95'
            , 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.843'
            , error_description = ''
            , memory_used = '168433432'
            WHERE id = '27368';
[01/11/2024 05:39:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.95'
            , 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.535'
            , error_description = ''
            , memory_used = '196280096'
            WHERE id = '27369';
[01/11/2024 05:39:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.95'
            , 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.596'
            , error_description = ''
            , memory_used = '179484168'
            WHERE id = '27371';
[01/11/2024 05:39:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:39:10.95'
            , 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.784'
            , error_description = ''
            , memory_used = '209516496'
            WHERE id = '27370';
[01/11/2024 05:39:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:39:14' WHERE id= '271';
[01/11/2024 05:39:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:39:15' WHERE id= '271';
[01/11/2024 05:41:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:41:57' WHERE id= '271';
[01/11/2024 05:41:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:41:57' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:41:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:41:57' WHERE id= '271';
[01/11/2024 05:41: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', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'expedia', '2024-01-11 05:41:59', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:41: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', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_41_57_1704951717_67.json', 'expedia', '2024-01-11 05:41:59', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:42:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:41:57.881'
            , 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.422'
            , error_description = ''
            , memory_used = '119012112'
            WHERE id = '27372';
[01/11/2024 05:42:00], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_41_57_1704951717_78.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_41_57_1704951717_78.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_41_57_1704951717_78.json', 'expediapackage', '2024-01-11 05:42:00', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:42:01], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_41_57_1704951717_68.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_41_57_1704951717_68.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_41_57_1704951717_68.json', 'expediapackage', '2024-01-11 05:42:01', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:42:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:41:57.881'
            , 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.709'
            , error_description = ''
            , memory_used = '206139080'
            WHERE id = '27373';
[01/11/2024 05:42:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:41:57.881'
            , 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 = '4.202'
            , error_description = ''
            , memory_used = '222449560'
            WHERE id = '27374';
[01/11/2024 05:42:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:41:57.881'
            , 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 = '4.233'
            , error_description = ''
            , memory_used = '125964800'
            WHERE id = '27375';
[01/11/2024 05:42:02], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:42:02' WHERE id= '271';
[01/11/2024 05:42:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:42:03' WHERE id= '271';
[01/11/2024 05:44:21], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:44:21' WHERE id= '274';
[01/11/2024 05:45:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:07' WHERE id= '271';
[01/11/2024 05:45:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:45:07' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:45:09], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:09' WHERE id= '274';
[01/11/2024 05:45:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:09' WHERE id= '271';
[01/11/2024 05:45:10], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_09_1704951909_54.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_09_1704951909_54.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_09_1704951909_54.json', 'expedia', '2024-01-11 05:45:10', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:11], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_09_1704951909_41.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_09_1704951909_41.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_09_1704951909_41.json', 'expediapackage', '2024-01-11 05:45:11', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:09.582'
            , 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.188'
            , error_description = ''
            , memory_used = '118929656'
            WHERE id = '27376';
[01/11/2024 05:45:12], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_09_1704951909_22.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_09_1704951909_22.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_09_1704951909_22.json', 'expedia', '2024-01-11 05:45:12', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:12], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_09_1704951909_49.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_09_1704951909_49.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_09_1704951909_49.json', 'expediapackage', '2024-01-11 05:45:12', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:09.582'
            , 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.854'
            , error_description = ''
            , memory_used = '222131576'
            WHERE id = '27377';
[01/11/2024 05:45:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:09.582'
            , 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.868'
            , error_description = ''
            , memory_used = '125903904'
            WHERE id = '27379';
[01/11/2024 05:45:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:09.582'
            , 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 = '4.217'
            , error_description = ''
            , memory_used = '206321912'
            WHERE id = '27378';
[01/11/2024 05:45:14], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:14' WHERE id= '271';
[01/11/2024 05:45:14], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:14' WHERE id= '271';
[01/11/2024 05:45:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:24' WHERE id= '271';
[01/11/2024 05:45:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:45:24' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:45:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:25' WHERE id= '271';
[01/11/2024 05:45:26], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_25_1704951925_12.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_25_1704951925_12.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_25_1704951925_12.json', 'expedia', '2024-01-11 05:45:26', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:26], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_25_1704951925_7.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_25_1704951925_7.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_25_1704951925_7.json', 'expedia', '2024-01-11 05:45:26', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:25.366'
            , 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.112'
            , error_description = ''
            , memory_used = '118999440'
            WHERE id = '27380';
[01/11/2024 05:45:27], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_25_1704951925_18.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_25_1704951925_18.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_25_1704951925_18.json', 'expediapackage', '2024-01-11 05:45:27', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_25_1704951925_52.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_25_1704951925_52.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_25_1704951925_52.json', 'expediapackage', '2024-01-11 05:45:28', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:25.365'
            , 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.170'
            , error_description = ''
            , memory_used = '206096840'
            WHERE id = '27381';
[01/11/2024 05:45:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:25.366'
            , 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 = '4.011'
            , error_description = ''
            , memory_used = '125660832'
            WHERE id = '27383';
[01/11/2024 05:45:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:25.365'
            , 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 = '4.090'
            , error_description = ''
            , memory_used = '222194008'
            WHERE id = '27382';
[01/11/2024 05:45:30], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:30' WHERE id= '271';
[01/11/2024 05:45:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:30' WHERE id= '271';
[01/11/2024 05:45:38], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:38' WHERE id= '274';
[01/11/2024 05:45:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:40' WHERE id= '271';
[01/11/2024 05:45:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:45:40' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:45:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:41' WHERE id= '271';
[01/11/2024 05:45:43], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_41_1704951941_45.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_41_1704951941_45.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_41_1704951941_45.json', 'expedia', '2024-01-11 05:45:43', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:43], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_41_1704951941_49.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_41_1704951941_49.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_41_1704951941_49.json', 'expediapackage', '2024-01-11 05:45:43', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:43], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_41_1704951941_25.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_41_1704951941_25.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_41_1704951941_25.json', 'expedia', '2024-01-11 05:45:43', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:43], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_45_41_1704951941_18.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_45_41_1704951941_18.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_45_41_1704951941_18.json', 'expediapackage', '2024-01-11 05:45:43', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:45:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:41.755'
            , 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.174'
            , error_description = ''
            , memory_used = '119015096'
            WHERE id = '27384';
[01/11/2024 05:45:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:41.755'
            , 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.882'
            , error_description = ''
            , memory_used = '125311576'
            WHERE id = '27385';
[01/11/2024 05:45:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:41.755'
            , 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.718'
            , error_description = ''
            , memory_used = '205830672'
            WHERE id = '27386';
[01/11/2024 05:45:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:45:41.755'
            , 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.842'
            , error_description = ''
            , memory_used = '222367136'
            WHERE id = '27387';
[01/11/2024 05:45:46], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:46' WHERE id= '271';
[01/11/2024 05:45:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:45:46' WHERE id= '271';
[01/11/2024 05:46:06], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:46:06' WHERE id= '271';
[01/11/2024 05:46:12], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:46:12' WHERE id= '271';
[01/11/2024 05:46:27], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:46:27' WHERE id= '271';
[01/11/2024 05:47:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:06' WHERE id= '271';
[01/11/2024 05:47:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:35' WHERE id= '271';
[01/11/2024 05:47:38], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:38' WHERE id= '271';
[01/11/2024 05:47:47], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:47' WHERE id= '271';
[01/11/2024 05:47:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:50' WHERE id= '271';
[01/11/2024 05:47:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:47:50' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:47:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:51' WHERE id= '271';
[01/11/2024 05:47: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_6.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_6.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_6.json', 'expediapackage', '2024-01-11 05:47:51', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_97.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_97.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_97.json', 'expedia', '2024-01-11 05:47:51', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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.196'
            , error_description = ''
            , memory_used = '1377528'
            WHERE id = '27388';
[01/11/2024 05:47:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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.198'
            , error_description = ''
            , memory_used = '1377000'
            WHERE id = '27389';
[01/11/2024 05:47:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_19.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_19.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_19.json', 'expedia', '2024-01-11 05:47:53', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_51.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_51.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_51.json', 'expedia', '2024-01-11 05:47:53', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_16.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_16.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_16.json', 'expediapackage', '2024-01-11 05:47:53', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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.040'
            , error_description = ''
            , memory_used = '182104584'
            WHERE id = '27390';
[01/11/2024 05:47:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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.100'
            , error_description = ''
            , memory_used = '186305928'
            WHERE id = '27391';
[01/11/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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_47_51_1704952071_93.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_47_51_1704952071_93.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_47_51_1704952071_93.json', 'expediapackage', '2024-01-11 05:47:55', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:47:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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.498'
            , error_description = ''
            , memory_used = '197939312'
            WHERE id = '27392';
[01/11/2024 05:47:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:47:51.791'
            , 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 = '4.857'
            , error_description = ''
            , memory_used = '194486216'
            WHERE id = '27393';
[01/11/2024 05:47:57], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:57' WHERE id= '271';
[01/11/2024 05:47:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:47:58' WHERE id= '271';
[01/11/2024 05:48:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:18' WHERE id= '271';
[01/11/2024 05:48:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:22' WHERE id= '271';
[01/11/2024 05:48:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:23' WHERE id= '271';
[01/11/2024 05:48:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:23' WHERE id= '271';
[01/11/2024 05:48:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:25' WHERE id= '271';
[01/11/2024 05:48:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:33' WHERE id= '271';
[01/11/2024 05:48:34], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:48:34' WHERE id= '274';
[01/11/2024 05:50:01], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:50:01' WHERE id= '274';
[01/11/2024 05:50:07], [file name :-/home/otrams/public_html/beta/manage_sub_agents.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:50:07' WHERE id= '274';
[01/11/2024 05:50:33], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:50:33' WHERE id= '274';
[01/11/2024 05:52:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:21' WHERE id= '271';
[01/11/2024 05:52:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:52:21' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:52:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:22' WHERE id= '271';
[01/11/2024 05:52: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_52_22_1704952342_52.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_52_22_1704952342_52.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_52_22_1704952342_52.json', 'expedia', '2024-01-11 05:52:24', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:52: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_52_22_1704952342_51.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_52_22_1704952342_51.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_52_22_1704952342_51.json', 'expediapackage', '2024-01-11 05:52:24', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:52: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_52_22_1704952342_2.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_52_22_1704952342_2.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_52_22_1704952342_2.json', 'expedia', '2024-01-11 05:52:24', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:52:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:52:22.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.545'
            , error_description = ''
            , memory_used = '119059088'
            WHERE id = '27394';
[01/11/2024 05:52: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_52_22_1704952342_28.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_52_22_1704952342_28.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_52_22_1704952342_28.json', 'expediapackage', '2024-01-11 05:52:25', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:52:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:52:22.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 = '3.788'
            , error_description = ''
            , memory_used = '222330080'
            WHERE id = '27395';
[01/11/2024 05:52:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:52:22.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 = '3.803'
            , error_description = ''
            , memory_used = '125860504'
            WHERE id = '27397';
[01/11/2024 05:52:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:52:22.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 = '3.920'
            , error_description = ''
            , memory_used = '206303904'
            WHERE id = '27396';
[01/11/2024 05:52:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:27' WHERE id= '271';
[01/11/2024 05:52:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:27' WHERE id= '271';
[01/11/2024 05:52:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:33' WHERE id= '271';
[01/11/2024 05:52:40], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:52:40' WHERE id= '271';
[01/11/2024 05:53:59], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:53:59' WHERE id= '271';
[01/11/2024 05:54:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:02' WHERE id= '271';
[01/11/2024 05:54:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:06' WHERE id= '271';
[01/11/2024 05:54:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:54:06' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:54:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:06' WHERE id= '271';
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_19.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_19.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_19.json', 'expediapackage', '2024-01-11 05:54:07', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.915'
            , 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.198'
            , error_description = ''
            , memory_used = '1377528'
            WHERE id = '27398';
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_36.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_36.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_36.json', 'expedia', '2024-01-11 05:54:07', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.915'
            , 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.261'
            , error_description = ''
            , memory_used = '1376976'
            WHERE id = '27399';
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_18.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_18.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_18.json', 'expedia', '2024-01-11 05:54:08', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_13.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_13.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_13.json', 'expedia', '2024-01-11 05:54:09', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_59.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_59.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_59.json', 'expediapackage', '2024-01-11 05:54:09', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_06_1704952446_12.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_06_1704952446_12.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_06_1704952446_12.json', 'expediapackage', '2024-01-11 05:54:09', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.915'
            , 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.896'
            , error_description = ''
            , memory_used = '186256432'
            WHERE id = '27400';
[01/11/2024 05:54:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.914'
            , 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.525'
            , error_description = ''
            , memory_used = '182287272'
            WHERE id = '27401';
[01/11/2024 05:54:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.914'
            , 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.691'
            , error_description = ''
            , memory_used = '194635096'
            WHERE id = '27402';
[01/11/2024 05:54:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&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=106'
            , http_hit_time = '2024-01-11 05:54:06.915'
            , 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 = '4.213'
            , error_description = ''
            , memory_used = '198214632'
            WHERE id = '27403';
[01/11/2024 05:54:12], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:12' WHERE id= '271';
[01/11/2024 05:54:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:12' WHERE id= '271';
[01/11/2024 05:54:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:53' WHERE id= '271';
[01/11/2024 05:54:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:54:53' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:54:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:54:54' WHERE id= '271';
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_54_1704952494_49.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_54_1704952494_49.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_54_1704952494_49.json', 'expedia', '2024-01-11 05:54:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:54:54.591'
            , 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.395'
            , error_description = ''
            , memory_used = '119019568'
            WHERE id = '27404';
[01/11/2024 05:54: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_54_1704952494_24.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_54_1704952494_24.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_54_1704952494_24.json', 'expediapackage', '2024-01-11 05:54:56', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_54_1704952494_67.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_54_1704952494_67.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_54_1704952494_67.json', 'expedia', '2024-01-11 05:54:57', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_54_54_1704952494_99.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_54_54_1704952494_99.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_54_54_1704952494_99.json', 'expediapackage', '2024-01-11 05:54:58', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:54:54.591'
            , 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 = '4.072'
            , error_description = ''
            , memory_used = '222108080'
            WHERE id = '27405';
[01/11/2024 05:54:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:54:54.591'
            , 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 = '4.375'
            , error_description = ''
            , memory_used = '206226840'
            WHERE id = '27406';
[01/11/2024 05:54:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:54:54.591'
            , 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 = '4.595'
            , error_description = ''
            , memory_used = '125895240'
            WHERE id = '27407';
[01/11/2024 05:55:00], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:00' WHERE id= '271';
[01/11/2024 05:55:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:00' WHERE id= '271';
[01/11/2024 05:55:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:16' WHERE id= '271';
[01/11/2024 05:55:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:55:16' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:55:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:17' WHERE id= '271';
[01/11/2024 05:55: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_55_17_1704952517_55.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_55_17_1704952517_55.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_55_17_1704952517_55.json', 'expedia', '2024-01-11 05:55:18', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:55:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/11_01_2024/request_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'expedia', '2024-01-11 05:55:19', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:55:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:55:17.579'
            , 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.135'
            , error_description = ''
            , memory_used = '119058176'
            WHERE id = '27408';
[01/11/2024 05:55:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_55_17_1704952517_47.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_55_17_1704952517_47.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_55_17_1704952517_47.json', 'expediapackage', '2024-01-11 05:55:20', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:55:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_55_17_1704952517_96.json', 'expediapackage', '2024-01-11 05:55:20', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:55:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:55:17.578'
            , 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.165'
            , error_description = ''
            , memory_used = '206249344'
            WHERE id = '27409';
[01/11/2024 05:55:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:55:17.579'
            , 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.994'
            , error_description = ''
            , memory_used = '125457368'
            WHERE id = '27411';
[01/11/2024 05:55:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:55:17.578'
            , 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 = '4.115'
            , error_description = ''
            , memory_used = '222105296'
            WHERE id = '27410';
[01/11/2024 05:55:22], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:22' WHERE id= '271';
[01/11/2024 05:55:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:55:22' WHERE id= '271';
[01/11/2024 05:56:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:56:01' WHERE id= '271';
[01/11/2024 05:56:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:56:01' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:56:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:56:02' WHERE id= '271';
[01/11/2024 05:56:04], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_56_02_1704952562_50.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_56_02_1704952562_50.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_56_02_1704952562_50.json', 'expedia', '2024-01-11 05:56:04', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:56:04], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'expedia', '2024-01-11 05:56:04', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:56:04], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_56_02_1704952562_66.json', 'expediapackage', '2024-01-11 05:56:04', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:56:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:56:02.623'
            , 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.259'
            , error_description = ''
            , memory_used = '118923992'
            WHERE id = '27412';
[01/11/2024 05:56:05], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_56_02_1704952562_86.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_56_02_1704952562_86.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_56_02_1704952562_86.json', 'expediapackage', '2024-01-11 05:56:05', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:56:02.623'
            , 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.156'
            , error_description = ''
            , memory_used = '125837168'
            WHERE id = '27414';
[01/11/2024 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:56:02.623'
            , 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.324'
            , error_description = ''
            , memory_used = '206060048'
            WHERE id = '27413';
[01/11/2024 05:56:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:56:02.623'
            , 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 = '4.510'
            , error_description = ''
            , memory_used = '221915416'
            WHERE id = '27415';
[01/11/2024 05:56:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:56:07' WHERE id= '271';
[01/11/2024 05:56:08], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:56:08' WHERE id= '271';
[01/11/2024 05:57:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:57:13' WHERE id= '271';
[01/11/2024 05:57:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '414' , service_type = 'hotel' , arrival_date = '2024/06/19' , departure_date = '2024/06/20' , nights = '1' , nationality = '414' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-11 05:57:13' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/11/2024 05:57:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:57:14' WHERE id= '271';
[01/11/2024 05:57:15], [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/11_01_2024/request_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'expedia', '2024-01-11 05:57:15', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:57: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_57_14_1704952634_6.json', 'e1/11_01_2024/response_availability_Baysan_Tourism_wh_05_57_14_1704952634_6.json', 'e1/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_57_14_1704952634_6.json', 'expedia', '2024-01-11 05:57:16', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:57: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', 'e1p/11_01_2024/request_availability_Baysan_Tourism_wh_05_57_14_1704952634_8.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_57_14_1704952634_8.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_57_14_1704952634_8.json', 'expediapackage', '2024-01-11 05:57:16', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:57:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:57:14.444'
            , 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.384'
            , error_description = ''
            , memory_used = '118925000'
            WHERE id = '27416';
[01/11/2024 05:57: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/11_01_2024/request_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'e1p/11_01_2024/response_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'e1p/11_01_2024/response_header_availability_Baysan_Tourism_wh_05_57_14_1704952634_67.json', 'expediapackage', '2024-01-11 05:57:17', '', '6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2', '0');
[01/11/2024 05:57:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:57:14.444'
            , 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.769'
            , error_description = ''
            , memory_used = '206002864'
            WHERE id = '27417';
[01/11/2024 05:57:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:57:14.444'
            , 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.953'
            , error_description = ''
            , memory_used = '125463688'
            WHERE id = '27419';
[01/11/2024 05:57:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=6f1c368ad0fe1ae74dbb9b0eb316445fd5798b25dd42e1c4540310ab8e67e2e2&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-11 05:57:14.444'
            , 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.958'
            , error_description = ''
            , memory_used = '222006408'
            WHERE id = '27418';
[01/11/2024 05:57:19], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:57:19' WHERE id= '271';
[01/11/2024 05:57:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-11 05:57:19' WHERE id= '271';
