[02/09/2024 01:00:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:01' WHERE id= '520';
[02/09/2024 01:00:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707483601','43.239.53.130');
[02/09/2024 01:00:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:14' WHERE id= '520';
[02/09/2024 01:00:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707483614','43.239.53.130');
[02/09/2024 01:00:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:18' WHERE id= '520';
[02/09/2024 01:00:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:20' WHERE id= '520';
[02/09/2024 01:00:20], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:20' WHERE id= '520';
[02/09/2024 01:00:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:00:30' WHERE id= '520';
[02/09/2024 01:00:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/21',  departure_date='2024/03/21',  nights='1',  create_date='2024-02-09 :13:00:30',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 01:01:01], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:01' WHERE id= '520';
[02/09/2024 01:01:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:07' WHERE id= '520';
[02/09/2024 01:01:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/21',  departure_date='2024/03/21',  nights='1',  create_date='2024-02-09 :13:01:07',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 01:01:38], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:38' WHERE id= '520';
[02/09/2024 01:01:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:51' WHERE id= '520';
[02/09/2024 01:01:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/04/23',  departure_date='2024/04/23',  nights='1',  create_date='2024-02-09 :13:01:51',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 01:01:52], [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/09_02_2024/request_availability_shiv_qtech_13_01_51_1707483711.json', 'v1/09_02_2024/response_availability_shiv_qtech_13_01_51_1707483711.json', 'v1/09_02_2024/response_header_availability_shiv_qtech_13_01_51_1707483711.json', 'viator', '2024-02-09 01:01:52', '', '', '1385');
[02/09/2024 01:01:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:54' WHERE id= '520';
[02/09/2024 01:01:54], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:54' WHERE id= '520';
[02/09/2024 01:01:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:01:57' WHERE id= '520';
[02/09/2024 01:01:57], [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/09_02_2024/request_sight_details_shiv_qtech_13_01_57_1707483717.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_01_57_1707483717.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_01_57_1707483717.json', 'viator', '2024-02-09 01:01:57', '', '', '1385');
[02/09/2024 01:01:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/09_02_2024/request_sight_details_shiv_qtech_13_01_58_1707483718.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_01_58_1707483718.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_01_58_1707483718.json', 'viator', '2024-02-09 01:01:58', '', '', '1385');
[02/09/2024 01:02:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:02:09' WHERE id= '520';
[02/09/2024 01:04:42], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:04:42',login_attempt=0 where id = '7870';
[02/09/2024 01:04:42], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:04:42', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:04:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38',create_date='2024-02-09 01:04:43', update_date='2024-02-09 01:04:43',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 01:04:56], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:04:56' WHERE id= '535';
[02/09/2024 01:05:02], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:02' WHERE id= '535';
[02/09/2024 01:05:05], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:05' WHERE id= '535';
[02/09/2024 01:05:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:05:46',login_attempt=0 where id = '7870';
[02/09/2024 01:05:46], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:05:46', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:05:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:46' WHERE id= '528';
[02/09/2024 01:05:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:52' WHERE id= '528';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:56' WHERE id= '528';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 13:05:56' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:05:56' WHERE id= '528';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:05:56.935'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:05:56'
                , session_id = '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705176';
[02/09/2024 01:05: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/09_02_2024/request_availability_hotel_yards_13_05_56_1707483956_20.json', 'e1/09_02_2024/response_availability_hotel_yards_13_05_56_1707483956_20.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_05_56_1707483956_20.json', 'expedia', '2024-02-09 01:05:57', '', '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39', '0');
[02/09/2024 01:05:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:05:56.935'
            , 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.475'
            , error_description = ''
            , memory_used = '1434920'
            WHERE id = '32786';
[02/09/2024 01:05:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_13_05_56_1707483956_65.json', 'e1/09_02_2024/response_availability_hotel_yards_13_05_56_1707483956_65.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_05_56_1707483956_65.json', 'expedia', '2024-02-09 01:05:58', '', '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39', '0');
[02/09/2024 01:05: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/09_02_2024/request_availability_hotel_yards_13_05_56_1707483956_81.json', 'e1/09_02_2024/response_availability_hotel_yards_13_05_56_1707483956_81.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_05_56_1707483956_81.json', 'expedia', '2024-02-09 01:05:59', '', '6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39', '0');
[02/09/2024 01:06:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:05:56.935'
            , 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.105'
            , error_description = ''
            , memory_used = '152928800'
            WHERE id = '32787';
[02/09/2024 01:06:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6ca069b6d19b22b53a4592f8b1efb39afb1e1b5fb7ac78cac9bf8c6bc1f04b39&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:05:56.935'
            , 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 = '174856864'
            WHERE id = '32788';
[02/09/2024 01:06:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:00' WHERE id= '528';
[02/09/2024 01:06:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:06:04',login_attempt=0 where id = '7870';
[02/09/2024 01:06:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:06:04', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:06:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05',create_date='2024-02-09 01:06:04', update_date='2024-02-09 01:06:04',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 01:06:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:12' WHERE id= '536';
[02/09/2024 01:06:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:18' WHERE id= '536';
[02/09/2024 01:06:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/10' , departure_date = '2024/02/11' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 13:06:18' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:19' WHERE id= '536';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:06:19.763'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:06:19'
                , session_id = '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:06: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', 'e1/09_02_2024/request_availability_hotel_yards_13_06_19_1707483979_26.json', 'e1/09_02_2024/response_availability_hotel_yards_13_06_19_1707483979_26.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_06_19_1707483979_26.json', 'expedia', '2024-02-09 01:06:20', '', '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05', '0');
[02/09/2024 01:06:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:06:19.763'
            , 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.446'
            , error_description = ''
            , memory_used = '1435032'
            WHERE id = '32795';
[02/09/2024 01:06:21], [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/09_02_2024/request_availability_hotel_yards_13_06_19_1707483979_61.json', 'e1/09_02_2024/response_availability_hotel_yards_13_06_19_1707483979_61.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_06_19_1707483979_61.json', 'expedia', '2024-02-09 01:06:21', '', '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05', '0');
[02/09/2024 01:06:21], [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/09_02_2024/request_availability_hotel_yards_13_06_19_1707483979_51.json', 'e1/09_02_2024/response_availability_hotel_yards_13_06_19_1707483979_51.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_06_19_1707483979_51.json', 'expedia', '2024-02-09 01:06:21', '', '6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05', '0');
[02/09/2024 01:06:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:06:19.763'
            , 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.473'
            , error_description = ''
            , memory_used = '83111288'
            WHERE id = '32796';
[02/09/2024 01:06:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=6568c042348cdba566b554d59242d709499a29c4d87594721cd0a869e3ebcf05&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:06:19.763'
            , 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.711'
            , error_description = ''
            , memory_used = '103344944'
            WHERE id = '32797';
[02/09/2024 01:06:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:22' WHERE id= '536';
[02/09/2024 01:06:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:50' WHERE id= '528';
[02/09/2024 01:06:55], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:55' WHERE id= '528';
[02/09/2024 01:06:59], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:59' WHERE id= '520';
[02/09/2024 01:06:59], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:06:59',login_attempt=0 where id = '7849';
[02/09/2024 01:06:59], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-09 13:06:59', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:06:59], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:06:59' WHERE id= '520';
[02/09/2024 01:07:14], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:14' WHERE id= '520';
[02/09/2024 01:07:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:18' WHERE id= '520';
[02/09/2024 01:07:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:22' WHERE id= '520';
[02/09/2024 01:07:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/20',  departure_date='2024/03/20',  nights='1',  create_date='2024-02-09 :13:07:22',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 01:07:29], [file name :-/home/otrams/public_html/beta/ajax/check_captcha.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:29' WHERE id= '535';
[02/09/2024 01:07:29], [file name :-/home/otrams/public_html/beta/ajax/check_captcha.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:29' WHERE id= '535';
[02/09/2024 01:07:29], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:29' WHERE id= '535';

[02/09/2024 01:07:30], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:30' WHERE id= '535';

[02/09/2024 01:07:31], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:31' WHERE id= '535';
[02/09/2024 01:07:41], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:41' WHERE id= '535';
[02/09/2024 01:07:41], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE sub_user SET status='D',modify_date='2024-02-09 13:07:41'  WHERE sub_user_id='2';
[02/09/2024 01:07:44], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:44' WHERE id= '535';
[02/09/2024 01:07:44], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE sub_user SET status='D',modify_date='2024-02-09 13:07:44'  WHERE sub_user_id='3';
[02/09/2024 01:07:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:49' WHERE id= '535';
[02/09/2024 01:07:53], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:53' WHERE id= '520';
[02/09/2024 01:07:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:07:56' WHERE id= '535';
[02/09/2024 01:08:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:01' WHERE id= '535';
[02/09/2024 01:08:01], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'bali' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/03/06' , departure_date = '2024/03/07' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 13:08:01' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:02' WHERE id= '535';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705352';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705208';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705216';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705160';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.591'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705216';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.591'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.591'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705168';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705216';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705352';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705352';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705400';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705352';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.593'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705160';
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:08:02.592'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:08:02'
                , session_id = 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1705448';
[02/09/2024 01:08: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/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_74.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_74.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_74.json', 'expedia', '2024-02-09 01:08:02', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=10&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.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 = '0.392'
            , error_description = ''
            , memory_used = '1443984'
            WHERE id = '32814';
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_36.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_36.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_36.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=8&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.602'
            , error_description = ''
            , memory_used = '3873008'
            WHERE id = '32815';
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_60.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_60.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_60.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_65.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_65.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_65.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_92.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_92.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_92.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=9&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.896'
            , error_description = ''
            , memory_used = '1443960'
            WHERE id = '32818';
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_23.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_23.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_23.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_84.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_84.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_84.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_41.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_41.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_41.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_86.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_86.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_86.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=1&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.592'
            , 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.206'
            , error_description = ''
            , memory_used = '36482864'
            WHERE id = '32816';
[02/09/2024 01:08:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=0&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.592'
            , 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.242'
            , error_description = ''
            , memory_used = '35271760'
            WHERE id = '32817';
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_28.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_28.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_28.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08: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', 'e1/09_02_2024/request_availability_hotel_yards_13_08_02_1707484082_11.json', 'e1/09_02_2024/response_availability_hotel_yards_13_08_02_1707484082_11.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_08_02_1707484082_11.json', 'expedia', '2024-02-09 01:08:03', '', 'c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38', '0');
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=3&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.481'
            , error_description = ''
            , memory_used = '47004928'
            WHERE id = '32819';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=6&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.494'
            , error_description = ''
            , memory_used = '43981456'
            WHERE id = '32821';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=7&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.501'
            , error_description = ''
            , memory_used = '42391016'
            WHERE id = '32820';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=2&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.592'
            , 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.681'
            , error_description = ''
            , memory_used = '38170048'
            WHERE id = '32823';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=4&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.732'
            , error_description = ''
            , memory_used = '52815560'
            WHERE id = '32822';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c511181b267be38c39a2a185bc0ec0126f66a22c5eecdf62bbcf608de035ba38&xml_user_id=7867&db_caching=1&erequest=5&total_request=11&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 13:08:02.593'
            , 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.867'
            , error_description = ''
            , memory_used = '50668632'
            WHERE id = '32824';
[02/09/2024 01:08:04], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:04' WHERE id= '535';
[02/09/2024 01:08:08], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:08' WHERE id= '535';
[02/09/2024 01:08:13], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:13' WHERE id= '535';
[02/09/2024 01:08:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:25' WHERE id= '535';
[02/09/2024 01:08:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:39' WHERE id= '520';
[02/09/2024 01:08:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/23',  departure_date='2024/03/23',  nights='1',  create_date='2024-02-09 :13:08:39',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 01:08:40], [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/09_02_2024/request_availability_shiv_qtech_13_08_39_1707484119.json', 'v1/09_02_2024/response_availability_shiv_qtech_13_08_39_1707484119.json', 'v1/09_02_2024/response_header_availability_shiv_qtech_13_08_39_1707484119.json', 'viator', '2024-02-09 01:08:40', '', '', '1387');
[02/09/2024 01:08:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:42' WHERE id= '520';
[02/09/2024 01:08:43], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:43' WHERE id= '520';
[02/09/2024 01:08:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:53' WHERE id= '520';
[02/09/2024 01:08:53], [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/09_02_2024/request_sight_details_shiv_qtech_13_08_53_1707484133.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_08_53_1707484133.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_08_53_1707484133.json', 'viator', '2024-02-09 01:08:53', '', '', '1387');
[02/09/2024 01:08: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/09_02_2024/request_sight_details_shiv_qtech_13_08_53_1707484133.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_08_53_1707484133.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_08_53_1707484133.json', 'viator', '2024-02-09 01:08:54', '', '', '1387');
[02/09/2024 01:08:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:08:57' WHERE id= '520';
[02/09/2024 01:08:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/09_02_2024/request_sight_details_shiv_qtech_13_08_57_1707484137.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_08_57_1707484137.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_08_57_1707484137.json', 'viator', '2024-02-09 01:08:58', '', '', '1387');
[02/09/2024 01:08:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/09_02_2024/request_sight_details_shiv_qtech_13_08_58_1707484138.json', 'v1/09_02_2024/response_sight_details_shiv_qtech_13_08_58_1707484138.json', 'v1/09_02_2024/response_header_sight_details_shiv_qtech_13_08_58_1707484138.json', 'viator', '2024-02-09 01:08:58', '', '', '1387');
[02/09/2024 01:09:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:09:02' WHERE id= '520';
[02/09/2024 01:09:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/09_02_2024/request_check_availability_shiv_qtech_13_09_02_1707484142.json', 'v1/09_02_2024/response_check_availability_shiv_qtech_13_09_02_1707484142.json', 'v1/09_02_2024/response_header_check_availability_shiv_qtech_13_09_02_1707484142.json', 'viator', '2024-02-09 01:09:02', '', '', '1387');
[02/09/2024 01:09:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:09:07' WHERE id= '520';
[02/09/2024 01:09:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707484147','43.239.53.130');
[02/09/2024 01:11:03], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:11:03' WHERE id= '535';
[02/09/2024 01:20:43], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:20:43' WHERE id= '520';
[02/09/2024 01:20:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:20:45' WHERE id= '520';
[02/09/2024 01:20:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:20:50' WHERE id= '520';
[02/09/2024 01:20:55], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:20:55' WHERE id= '520';
[02/09/2024 01:21:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:21:44' WHERE id= '520';
[02/09/2024 01:21:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707484904','43.239.53.130');
[02/09/2024 01:21:45], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:21:45' WHERE id= '520';
[02/09/2024 01:21:45], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2634',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauban',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 21 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 21 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-09 13:21:45',source_type='viator',expiration_date= '2024-03-21 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-23',sub_user_id='',check_out_date='2024-03-23',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/09/2024 01:21:45], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='389',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-23',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/09/2024 01:21:45], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2634','2024-02-09 13:21:45',0);
[02/09/2024 01:23:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:23:00' WHERE id= '520';
[02/09/2024 01:23:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707484980','43.239.53.130');
[02/09/2024 01:23:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:23:01' WHERE id= '520';
[02/09/2024 01:23:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2634',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauban',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 21 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 21 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-09 13:23:01',source_type='viator',expiration_date= '2024-03-21 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-23',sub_user_id='',check_out_date='2024-03-23',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/09/2024 01:23:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='390',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-23',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/09/2024 01:23:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2634','2024-02-09 13:23:01',0);
[02/09/2024 01:23:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:23:07' WHERE id= '520';
[02/09/2024 01:23:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707484987','43.239.53.130');
[02/09/2024 01:25:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:25:44',login_attempt=0 where id = '7870';
[02/09/2024 01:25:44], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:25:44', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:25:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='5c18fdfd93b98a24cdc9d30dd2704cb0a2dc56f18e239d6500717eae2471c236',create_date='2024-02-09 01:25:44', update_date='2024-02-09 01:25:44',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 01:25:48], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:25:48' WHERE id= '537';
[02/09/2024 01:28:38], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:28:38',login_attempt=0 where id = '7867';
[02/09/2024 01:28:38], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:28:38', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:28:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f',create_date='2024-02-09 01:28:39', update_date='2024-02-09 01:28:39',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 01:28:47], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:28:47' WHERE id= '538';
[02/09/2024 01:29:02], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:02' WHERE id= '538';
[02/09/2024 01:29:02], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/03/20' , departure_date = '2024/03/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 13:29:02' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 01:29:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:03' WHERE id= '538';
[02/09/2024 01:29:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:29:03.473'
                , total_duration = '0.010'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:29:03'
                , session_id = 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607800';
[02/09/2024 01:29:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:29:03.473'
                , total_duration = '0.010'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:29:03'
                , session_id = 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607800';
[02/09/2024 01:29:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:29:03.473'
                , total_duration = '0.010'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:29:03'
                , session_id = 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607800';
[02/09/2024 01:29: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', 'e1/09_02_2024/request_availability_hotel_yards_13_29_03_1707485343_8.json', 'e1/09_02_2024/response_availability_hotel_yards_13_29_03_1707485343_8.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_29_03_1707485343_8.json', 'expedia', '2024-02-09 01:29:03', '', 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f', '0');
[02/09/2024 01:29:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-09 13:29:03.473'
            , 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.262'
            , error_description = ''
            , memory_used = '1351288'
            WHERE id = '32834';
[02/09/2024 01:29: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', 'e1/09_02_2024/request_availability_hotel_yards_13_29_03_1707485343_28.json', 'e1/09_02_2024/response_availability_hotel_yards_13_29_03_1707485343_28.json', 'e1/09_02_2024/response_header_availability_hotel_yards_13_29_03_1707485343_28.json', 'expedia', '2024-02-09 01:29:05', '', 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f', '0');
[02/09/2024 01:29:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-09 13:29:03.473'
            , 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.682'
            , error_description = ''
            , memory_used = '225465352'
            WHERE id = '32835';
[02/09/2024 01:29:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:07' WHERE id= '538';
[02/09/2024 01:29:11], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:11' WHERE id= '538';
[02/09/2024 01:29:15], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:15' WHERE id= '538';
[02/09/2024 01:29:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:29:47' WHERE id= '538';
[02/09/2024 01:29:47], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:29:47.952'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:29:47'
                , session_id = 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1736424';
[02/09/2024 01:30:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:30:08' WHERE id= '538';
[02/09/2024 01:30:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 13:30:08.343'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 01:30:08'
                , session_id = 'c911a3750d3c0582e868d061af9b4a72aec90d737999160db98e399100e1b97f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1724248';
[02/09/2024 01:34:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 01:34:45',login_attempt=0 where id = '7870';
[02/09/2024 01:34:45], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-09 13:34:45', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 01:34:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='5adb86e4751017b9e3bf14c24870d5b2af620e1431ec297ff930390e266523d9',create_date='2024-02-09 01:34:46', update_date='2024-02-09 01:34:46',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 01:34:54], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:34:54' WHERE id= '539';
[02/09/2024 01:34:58], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:34:58' WHERE id= '539';
[02/09/2024 01:35:01], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 01:35:01' WHERE id= '539';
