[12/01/2023 05:29:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-12-01 05:29:48',login_attempt=0 where id = '7865';
[12/01/2023 05:29:48], [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 = '2023-12-01 05:29:48', ip = '43.239.53.130', action = 'Login' ;
[12/01/2023 05:29:49], [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='81869014d0690ea0ac320b5656390e7f9dba862fd278ed019f86696187b87c42',create_date='2023-12-01 05:29:49', update_date='2023-12-01 05:29:49',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[12/01/2023 05:29:51], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:29:51' WHERE id= '185';
[12/01/2023 05:35:53], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-12-01 05:35:53',login_attempt=0 where id = '7865';
[12/01/2023 05:35: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 = '2023-12-01 05:35:53', ip = '43.239.53.130', action = 'Login' ;
[12/01/2023 05:35: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='262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc',create_date='2023-12-01 05:35:53', update_date='2023-12-01 05:35:53',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[12/01/2023 05:35:57], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:35:57' WHERE id= '186';
[12/01/2023 05:36:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:00' WHERE id= '186';
[12/01/2023 05:36:00], [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 = '2023/12/29' , departure_date = '2023/12/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:36:00' , 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 = '' ;
[12/01/2023 05:36:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:00' WHERE id= '186';
[12/01/2023 05:36: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_19.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_19.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_19.json', 'expediapackage', '2023-12-01 05:36:01', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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.383'
            , error_description = ''
            , memory_used = '1387664'
            WHERE id = '16597';
[12/01/2023 05:36: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', 'e1/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_35.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_35.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_35.json', 'expedia', '2023-12-01 05:36:01', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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.786'
            , error_description = ''
            , memory_used = '1379008'
            WHERE id = '16598';
[12/01/2023 05:36:02], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_70.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_70.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_70.json', 'expedia', '2023-12-01 05:36:02', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:02], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_8.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_8.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_8.json', 'expedia', '2023-12-01 05:36:02', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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.008'
            , error_description = ''
            , memory_used = '94427608'
            WHERE id = '16599';
[12/01/2023 05:36:03], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_10.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_10.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_10.json', 'expediapackage', '2023-12-01 05:36:03', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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.186'
            , error_description = ''
            , memory_used = '105577992'
            WHERE id = '16600';
[12/01/2023 05:36:03], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_01_1701408961_33.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_01_1701408961_33.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_01_1701408961_33.json', 'expediapackage', '2023-12-01 05:36:03', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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 = '97993536'
            WHERE id = '16601';
[12/01/2023 05:36:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:01.51'
            , 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.185'
            , error_description = ''
            , memory_used = '109220968'
            WHERE id = '16602';
[12/01/2023 05:36:04], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:04' WHERE id= '186';
[12/01/2023 05:36:16], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:16' WHERE id= '186';
[12/01/2023 05:36: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 = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2023/12/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:36:16' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/01/2023 05:36:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:17' WHERE id= '186';
[12/01/2023 05:36: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_17_1701408977_51.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_17_1701408977_51.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_17_1701408977_51.json', 'expedia', '2023-12-01 05:36:18', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_17_1701408977_10.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_17_1701408977_10.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_17_1701408977_10.json', 'expedia', '2023-12-01 05:36:18', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:17.195'
            , 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.473'
            , error_description = ''
            , memory_used = '55388464'
            WHERE id = '16603';
[12/01/2023 05:36: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', 'e1p/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_17_1701408977_56.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_17_1701408977_56.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_17_1701408977_56.json', 'expediapackage', '2023-12-01 05:36:18', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36: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', 'e1p/01_12_2023/request_availability_Baysan_Tourism_wh_05_36_17_1701408977_21.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_36_17_1701408977_21.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_36_17_1701408977_21.json', 'expediapackage', '2023-12-01 05:36:18', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:36:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:17.195'
            , 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.951'
            , error_description = ''
            , memory_used = '57363864'
            WHERE id = '16605';
[12/01/2023 05:36:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:17.195'
            , 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.371'
            , error_description = ''
            , memory_used = '120774536'
            WHERE id = '16604';
[12/01/2023 05:36:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:36:17.195'
            , 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.645'
            , error_description = ''
            , memory_used = '124633224'
            WHERE id = '16606';
[12/01/2023 05:36:20], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:36:20' WHERE id= '186';
[12/01/2023 05:41:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:41:13' WHERE id= '186';
[12/01/2023 05:41:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:41:19' WHERE id= '186';
[12/01/2023 05:43:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:32' WHERE id= '186';
[12/01/2023 05:43:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:40' WHERE id= '186';
[12/01/2023 05:43: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 = 'duba' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2024/01/02' , nights = '4' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:43:40' , site_id = '20' , country_code = '129' , city_code = '139666' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/01/2023 05:43:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:41' WHERE id= '186';
[12/01/2023 05:43:41], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:41' WHERE id= '186';
[12/01/2023 05:43:45], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:45' WHERE id= '186';
[12/01/2023 05:43:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:46' WHERE id= '186';
[12/01/2023 05:43:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:49' WHERE id= '186';
[12/01/2023 05:43:53], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:53' WHERE id= '186';
[12/01/2023 05:43: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 = '2023/12/29' , departure_date = '2024/01/06' , nights = '8' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:43:53' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/01/2023 05:43:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:54' WHERE id= '186';
[12/01/2023 05:43: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_43_54_1701409434_9.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_43_54_1701409434_9.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_43_54_1701409434_9.json', 'expedia', '2023-12-01 05:43:55', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:43:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:43:54.259'
            , 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.916'
            , error_description = ''
            , memory_used = '80146072'
            WHERE id = '16607';
[12/01/2023 05:43: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_43_54_1701409434_97.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_43_54_1701409434_97.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_43_54_1701409434_97.json', 'expedia', '2023-12-01 05:43:56', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:43: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_43_54_1701409434_20.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_43_54_1701409434_20.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_43_54_1701409434_20.json', 'expediapackage', '2023-12-01 05:43:56', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:43: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_43_54_1701409434_93.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_43_54_1701409434_93.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_43_54_1701409434_93.json', 'expediapackage', '2023-12-01 05:43:56', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:43:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:43:54.259'
            , 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.783'
            , error_description = ''
            , memory_used = '85227400'
            WHERE id = '16609';
[12/01/2023 05:43:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:43:54.259'
            , 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 = '182920192'
            WHERE id = '16608';
[12/01/2023 05:43:58], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:43:54.259'
            , 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.100'
            , error_description = ''
            , memory_used = '190433312'
            WHERE id = '16610';
[12/01/2023 05:43:59], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:59' WHERE id= '186';
[12/01/2023 05:43:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:59' WHERE id= '186';
[12/01/2023 05:43:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:43:59' WHERE id= '186';
[12/01/2023 05:44:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:06' WHERE id= '186';
[12/01/2023 05:44: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 = '106' , service_type = 'hotel' , arrival_date = '2023/12/29' , departure_date = '2024/01/06' , nights = '8' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:44:06' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/01/2023 05:44:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:06' WHERE id= '186';
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_06_1701409446_1.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_06_1701409446_1.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_06_1701409446_1.json', 'expedia', '2023-12-01 05:44:07', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_06_1701409446_29.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_06_1701409446_29.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_06_1701409446_29.json', 'expediapackage', '2023-12-01 05:44:08', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:06.606'
            , 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.815'
            , error_description = ''
            , memory_used = '80688352'
            WHERE id = '16611';
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_06_1701409446_66.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_06_1701409446_66.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_06_1701409446_66.json', 'expedia', '2023-12-01 05:44:08', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:06.606'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.299'
            , error_description = ''
            , memory_used = '85627952'
            WHERE id = '16612';
[12/01/2023 05:44:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_06_1701409446_74.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_06_1701409446_74.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_06_1701409446_74.json', 'expediapackage', '2023-12-01 05:44:08', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:06.606'
            , 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.306'
            , error_description = ''
            , memory_used = '183129520'
            WHERE id = '16613';
[12/01/2023 05:44:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:06.606'
            , 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.828'
            , error_description = ''
            , memory_used = '190012888'
            WHERE id = '16614';
[12/01/2023 05:44:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:11' WHERE id= '186';
[12/01/2023 05:44:11], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:11' WHERE id= '186';
[12/01/2023 05:44:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:25' WHERE id= '186';
[12/01/2023 05:44: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 = '2023/12/29' , departure_date = '2024/01/08' , nights = '10' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:44: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 = '' ;
[12/01/2023 05:44:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:26' WHERE id= '186';
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_26_1701409466_25.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_26_1701409466_25.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_26_1701409466_25.json', 'expedia', '2023-12-01 05:44:27', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:26.151'
            , 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.052'
            , error_description = ''
            , memory_used = '88577800'
            WHERE id = '16615';
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_26_1701409466_6.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_26_1701409466_6.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_26_1701409466_6.json', 'expediapackage', '2023-12-01 05:44:28', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_26_1701409466_60.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_26_1701409466_60.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_26_1701409466_60.json', 'expedia', '2023-12-01 05:44:28', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:26.151'
            , 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.768'
            , error_description = ''
            , memory_used = '94011008'
            WHERE id = '16616';
[12/01/2023 05:44: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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_26_1701409466_74.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_26_1701409466_74.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_26_1701409466_74.json', 'expediapackage', '2023-12-01 05:44:29', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:26.151'
            , 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.284'
            , error_description = ''
            , memory_used = '201448576'
            WHERE id = '16617';
[12/01/2023 05:44:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:26.151'
            , 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.628'
            , error_description = ''
            , memory_used = '211528576'
            WHERE id = '16618';
[12/01/2023 05:44:31], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:31' WHERE id= '186';
[12/01/2023 05:44:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:31' WHERE id= '186';
[12/01/2023 05:44:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:32' WHERE id= '186';
[12/01/2023 05:44:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:43' WHERE id= '186';
[12/01/2023 05:44:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:47' WHERE id= '186';
[12/01/2023 05:44:47], [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 = '2023/12/29' , departure_date = '2024/01/08' , nights = '10' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:44:47' , 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 = '' ;
[12/01/2023 05:44:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:47' WHERE id= '186';
[12/01/2023 05:44:48], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_13.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_13.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_13.json', 'expediapackage', '2023-12-01 05:44:48', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.282'
            , error_description = ''
            , memory_used = '1377336'
            WHERE id = '16619';
[12/01/2023 05:44:48], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_65.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_65.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_65.json', 'expedia', '2023-12-01 05:44:48', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.323'
            , error_description = ''
            , memory_used = '1376552'
            WHERE id = '16620';
[12/01/2023 05:44:50], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_54.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_54.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_54.json', 'expedia', '2023-12-01 05:44:50', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:50], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_86.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_86.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_86.json', 'expedia', '2023-12-01 05:44:50', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:50], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_3.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_3.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_3.json', 'expediapackage', '2023-12-01 05:44:50', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:50], [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/01_12_2023/request_availability_Baysan_Tourism_wh_05_44_48_1701409488_68.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_44_48_1701409488_68.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_44_48_1701409488_68.json', 'expediapackage', '2023-12-01 05:44:50', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:44:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.387'
            , error_description = ''
            , memory_used = '156395472'
            WHERE id = '16621';
[12/01/2023 05:44:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.936'
            , error_description = ''
            , memory_used = '171183272'
            WHERE id = '16622';
[12/01/2023 05:44:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.110'
            , error_description = ''
            , memory_used = '163450224'
            WHERE id = '16623';
[12/01/2023 05:44:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:44:48.2'
            , 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.275'
            , error_description = ''
            , memory_used = '180316408'
            WHERE id = '16624';
[12/01/2023 05:44:53], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:53' WHERE id= '186';
[12/01/2023 05:44:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:53' WHERE id= '186';
[12/01/2023 05:44:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:44:53' WHERE id= '186';
[12/01/2023 05:54:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:54:33' WHERE id= '186';
[12/01/2023 05:55:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:55:43' WHERE id= '186';
[12/01/2023 05:55:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:55:50' WHERE id= '186';
[12/01/2023 05:55:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:55:54' WHERE id= '186';
[12/01/2023 05:56:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:56:46' WHERE id= '186';
[12/01/2023 05:59:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:59:19' WHERE id= '186';
[12/01/2023 05:59:35], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:59:35' WHERE id= '186';
[12/01/2023 05:59:35], [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 = '2023/12/29' , departure_date = '2024/01/08' , nights = '10' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-12-01 05:59:35' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '2.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[12/01/2023 05:59:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:59:35' WHERE id= '186';
[12/01/2023 05:59: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', 'e1/01_12_2023/request_availability_Baysan_Tourism_wh_05_59_36_1701410376_44.json', 'e1/01_12_2023/response_availability_Baysan_Tourism_wh_05_59_36_1701410376_44.json', 'e1/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_59_36_1701410376_44.json', 'expedia', '2023-12-01 05:59:36', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:59:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=1&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:59:36.83'
            , 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.936'
            , error_description = ''
            , memory_used = '3400960'
            WHERE id = '16625';
[12/01/2023 05:59:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/01_12_2023/request_availability_Baysan_Tourism_wh_05_59_36_1701410376_77.json', 'e1p/01_12_2023/response_availability_Baysan_Tourism_wh_05_59_36_1701410376_77.json', 'e1p/01_12_2023/response_header_availability_Baysan_Tourism_wh_05_59_36_1701410376_77.json', 'expediapackage', '2023-12-01 05:59:37', '', '262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc', '0');
[12/01/2023 05:59:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=262943c69fba2563ca1d454ee8171eff4cab3a12c5e6645053770fa77a5385dc&xml_user_id=7863&db_caching=1&erequest=0&total_request=1&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-12-01 05:59:36.82'
            , 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.515'
            , error_description = ''
            , memory_used = '3488936'
            WHERE id = '16626';
[12/01/2023 05:59:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-12-01 05:59:37' WHERE id= '186';
