[04/18/2024 06:01:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:01:50' WHERE id= '792';
[04/18/2024 06:01:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:01:56' WHERE id= '792';
[04/18/2024 06:01:56], [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/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:01:56' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:01:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:01:56' WHERE id= '792';
[04/18/2024 06:01:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1121_1713420116_91.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420116_91.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420116_91.json', 'expediapackage', '2024-04-18 06:01:57', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:01:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:01:56.772'
        , 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.374'
        , error_description = ''
        , memory_used = '1560048'
        WHERE id = '113792';
[04/18/2024 06:01:58], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1121_1713420116_78.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420116_78.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420116_78.json', 'expediapackage', '2024-04-18 06:01:58', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:01:59], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1121_1713420116_69.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420116_69.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420116_69.json', 'expediapackage', '2024-04-18 06:01:59', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:01:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:01:56.772'
        , 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.155'
        , error_description = ''
        , memory_used = '182087248'
        WHERE id = '113793';
[04/18/2024 06:02:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:01:56.773'
        , 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.685'
        , error_description = ''
        , memory_used = '183685592'
        WHERE id = '113794';
[04/18/2024 06:02:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '3.774',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '8.37',
        system_load_5_min = '14.56',
        system_load_15_min = '9.56',
        system_memory_usage = '54.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1121') + '1948832',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1121';
[04/18/2024 06:02:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:00' WHERE id= '792';
[04/18/2024 06:02:01], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:01' WHERE id= '791';
[04/18/2024 06:02:03], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:03' WHERE id= '792';
[04/18/2024 06:02:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:06' WHERE id= '791';
[04/18/2024 06:02:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:02:06' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:02:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:06' WHERE id= '791';
[04/18/2024 06:02: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/18_04_2024/request_availability_hotel_yards_1122_1713420126_49.json', 'e1p/18_04_2024/response_availability_hotel_yards_1122_1713420126_49.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1122_1713420126_49.json', 'expediapackage', '2024-04-18 06:02:08', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1122');
[04/18/2024 06:02:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:08' WHERE id= '792';
[04/18/2024 06:02:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1122_1713420126_44.json', 'e1p/18_04_2024/response_availability_hotel_yards_1122_1713420126_44.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1122_1713420126_44.json', 'expediapackage', '2024-04-18 06:02:09', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1122');
[04/18/2024 06:02:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:02:06.748'
        , 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.002'
        , error_description = ''
        , memory_used = '125521712'
        WHERE id = '113795';
[04/18/2024 06:02:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:02:06.747'
        , 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.158'
        , error_description = ''
        , memory_used = '225571096'
        WHERE id = '113796';
[04/18/2024 06:02:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '4.233',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '7.23',
        system_load_5_min = '14.12',
        system_load_15_min = '9.47',
        system_memory_usage = '54.39',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1122') + '2039520',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1122';
[04/18/2024 06:02:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:10' WHERE id= '791';
[04/18/2024 06:02:11], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:11' WHERE id= '791';
[04/18/2024 06:02:11], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:11' WHERE id= '791';
[04/18/2024 06:02:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:18' WHERE id= '791';
[04/18/2024 06:02:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:02:18' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:02:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:19' WHERE id= '791';
[04/18/2024 06:02: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', 'e1p/18_04_2024/request_availability_hotel_yards_1123_1713420139_26.json', 'e1p/18_04_2024/response_availability_hotel_yards_1123_1713420139_26.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1123_1713420139_26.json', 'expediapackage', '2024-04-18 06:02:21', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1123');
[04/18/2024 06:02: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', 'e1p/18_04_2024/request_availability_hotel_yards_1123_1713420139_51.json', 'e1p/18_04_2024/response_availability_hotel_yards_1123_1713420139_51.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1123_1713420139_51.json', 'expediapackage', '2024-04-18 06:02:21', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1123');
[04/18/2024 06:02:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:02:19.680'
        , 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.451'
        , error_description = ''
        , memory_used = '125481616'
        WHERE id = '113797';
[04/18/2024 06:02:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:02:19.679'
        , 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.790'
        , error_description = ''
        , memory_used = '225800904'
        WHERE id = '113798';
[04/18/2024 06:02:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c',
        duration = '3.861',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.42',
        system_load_5_min = '13.72',
        system_load_15_min = '9.39',
        system_memory_usage = '54.56',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1123') + '2039520',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1123';
[04/18/2024 06:02:23], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:23' WHERE id= '791';
[04/18/2024 06:02:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:38' WHERE id= '791';
[04/18/2024 06:02:40], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:02:40' WHERE id= '791';
[04/18/2024 06:03:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:03:02' WHERE id= '791';
[04/18/2024 06:03:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:03:12' WHERE id= '792';
[04/18/2024 06:03:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1121_1713420192_39.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420192_39.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420192_39.json', 'expediapackage', '2024-04-18 06:03:14', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:03:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106&debug=1'
        , http_hit_time = '2024-04-18 06:03:12.807'
        , 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.207'
        , error_description = ''
        , memory_used = '182199960'
        WHERE id = '113799';
[04/18/2024 06:03:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:03:37' WHERE id= '791';
[04/18/2024 06:03:39], [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/18_04_2024/request_availability_hotel_yards_1123_1713420217_45.json', 'e1p/18_04_2024/response_availability_hotel_yards_1123_1713420217_45.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1123_1713420217_45.json', 'expediapackage', '2024-04-18 06:03:39', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1123');
[04/18/2024 06:03:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106&debug=1'
        , http_hit_time = '2024-04-18 06:03:37.797'
        , 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.822'
        , error_description = ''
        , memory_used = '209102824'
        WHERE id = '113800';
[04/18/2024 06:04:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:04:24' WHERE id= '791';
[04/18/2024 06:04:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1123_1713420264_77.json', 'e1p/18_04_2024/response_availability_hotel_yards_1123_1713420264_77.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1123_1713420264_77.json', 'expediapackage', '2024-04-18 06:04:26', '', '67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c', '1123');
[04/18/2024 06:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=67bccc5e044fa3189d2fa5a701015eb1150c800f52d0b40b80a0a9920d9bbb5c&xml_user_id=7867&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=21&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106&debug=1'
        , http_hit_time = '2024-04-18 06:04:24.180'
        , 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 = '116383776'
        WHERE id = '113801';
[04/18/2024 06:04:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:04:44' WHERE id= '792';
[04/18/2024 06:04:45], [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/18_04_2024/request_availability_hotel_yards_1121_1713420284_67.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420284_67.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420284_67.json', 'expediapackage', '2024-04-18 06:04:45', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:04:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:04:44.867'
        , 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.527'
        , error_description = ''
        , memory_used = '1736816'
        WHERE id = '113802';
[04/18/2024 06:04: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/18_04_2024/request_availability_hotel_yards_1121_1713420284_68.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420284_68.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420284_68.json', 'expediapackage', '2024-04-18 06:04:48', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:04: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/18_04_2024/request_availability_hotel_yards_1121_1713420284_98.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420284_98.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420284_98.json', 'expediapackage', '2024-04-18 06:04:48', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:04:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:04:44.866'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.156'
        , error_description = ''
        , memory_used = '182152496'
        WHERE id = '113803';
[04/18/2024 06:04:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-04-18 06:04:44.866'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.288'
        , error_description = ''
        , memory_used = '183986520'
        WHERE id = '113804';
[04/18/2024 06:04:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7867&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703',
        duration = '5.375',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.99',
        system_load_5_min = '8.67',
        system_load_15_min = '8.12',
        system_memory_usage = '54.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1121') + '2015224',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1121';
[04/18/2024 06:05:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:05:01' WHERE id= '792';
[04/18/2024 06:05:10], [file name :-/home/otrams/public_html/beta/call.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:05:10' WHERE id= '792';
[04/18/2024 06:05:12], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/18_04_2024/request_availability_hotel_yards_1121_1713420310_52.json', 'e1p/18_04_2024/response_availability_hotel_yards_1121_1713420310_52.json', 'e1p/18_04_2024/response_header_availability_hotel_yards_1121_1713420310_52.json', 'expediapackage', '2024-04-18 06:05:12', '', '8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703', '1121');
[04/18/2024 06:05:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=8e61d9246e6bab30cf4d65107d77bdf428d0cdca723d411f6a279c0e61a01703&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F123.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106&debug=1'
        , http_hit_time = '2024-04-18 06:05:10.509'
        , 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.200'
        , error_description = ''
        , memory_used = '183771672'
        WHERE id = '113805';
[04/18/2024 06:16:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:16:57' WHERE id= '791';
[04/18/2024 06:17:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:17:00' WHERE id= '792';
[04/18/2024 06:18:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:18:13' WHERE id= '792';
[04/18/2024 06:18:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:18:26' WHERE id= '792';
[04/18/2024 06:18:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:18:30' WHERE id= '791';
[04/18/2024 06:19:54], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:19:54' WHERE id= '792';
[04/18/2024 06:20:00], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:20:00' WHERE id= '791';
[04/18/2024 06:20:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:20:56' WHERE id= '791';
[04/18/2024 06:21:04], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:21:04' WHERE id= '792';
[04/18/2024 06:21:05], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:21:05' WHERE id= '791';
[04/18/2024 06:26:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:26:23' WHERE id= '792';
[04/18/2024 06:26:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:26:25' WHERE id= '791';
[04/18/2024 06:27:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:27:10' WHERE id= '792';
[04/18/2024 06:27:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:27:12' WHERE id= '791';
[04/18/2024 06:27:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:27:16' WHERE id= '792';
[04/18/2024 06:28:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:28:06' WHERE id= '791';
[04/18/2024 06:28:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:28:09' WHERE id= '791';
[04/18/2024 06:28:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:28:12' WHERE id= '792';
[04/18/2024 06:29:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:29:12' WHERE id= '792';
[04/18/2024 06:29:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:29:13' WHERE id= '791';
[04/18/2024 06:30:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:30:22' WHERE id= '792';
[04/18/2024 06:30:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:30:24' WHERE id= '791';
[04/18/2024 06:35:31], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:31' WHERE id= '792';
[04/18/2024 06:35:33], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:33' WHERE id= '792';
[04/18/2024 06:35:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:36' WHERE id= '792';
[04/18/2024 06:35:36], [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/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:35:36' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:35:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:37' WHERE id= '792';
[04/18/2024 06:35:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:37' WHERE id= '792';
[04/18/2024 06:35:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:39' WHERE id= '792';
[04/18/2024 06:35:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:35:42' WHERE id= '792';
[04/18/2024 06:36:29], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:29' WHERE id= '792';
[04/18/2024 06:36:29], [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/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:36:29' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:36:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:30' WHERE id= '792';
[04/18/2024 06:36:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:30' WHERE id= '792';
[04/18/2024 06:36:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:32' WHERE id= '792';
[04/18/2024 06:36:52], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:52' WHERE id= '792';
[04/18/2024 06:36:52], [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/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:36:52' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:36:52], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:52' WHERE id= '792';
[04/18/2024 06:36:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:36:53' WHERE id= '792';
[04/18/2024 06:37:05], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:37:05' WHERE id= '791';
[04/18/2024 06:37:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-04-18 06:37:06' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[04/18/2024 06:37:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:37:06' WHERE id= '791';
[04/18/2024 06:37:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:37:07' WHERE id= '791';
[04/18/2024 06:51:59], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-18 06:51:59',login_attempt=0 where id = '7851';
[04/18/2024 06:51:59], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-04-18 06:51:59', ip = '43.239.53.130', action = 'Login' ;
[04/18/2024 06:51:59], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7851', session_id='c04932c66a424fbab6ed3d90d5c6cf7e28dac4fa3777ce5d9eff3040799072bd',create_date='2024-04-18 06:51:59', update_date='2024-04-18 06:51:59',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[04/18/2024 06:52:07], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:52:07' WHERE id= '793';
[04/18/2024 06:52:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:52:12' WHERE id= '793';
[04/18/2024 06:52:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:52:19' WHERE id= '793';
[04/18/2024 06:52:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :06:52:19',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:19], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:19', '', '', '1128');
[04/18/2024 06:52:20], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_19_1713423139.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_19_1713423139.json', 'viator', '2024-04-18 06:52:20', '', '', '1128');
[04/18/2024 06:52:20], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_20_1713423140.json', 'viator', '2024-04-18 06:52:20', '', '', '1128');
[04/18/2024 06:52:20], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_20_1713423140.json', 'viator', '2024-04-18 06:52:20', '', '', '1128');
[04/18/2024 06:52:20], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_52_20_1713423140.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_52_20_1713423140.json', 'viator', '2024-04-18 06:52:20', '', '', '1128');
[04/18/2024 06:56:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-18 06:56:31' WHERE id= '793';
[04/18/2024 06:56:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-04-18 :06:56:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/18/2024 06:56:31], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:31', '', '', '1129');
[04/18/2024 06:56:31], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:31', '', '', '1129');
[04/18/2024 06:56:31], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:31', '', '', '1129');
[04/18/2024 06:56:31], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:31', '', '', '1129');
[04/18/2024 06:56:31], [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 ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:31', '', '', '1129');
[04/18/2024 06:56:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_31_1713423391.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_31_1713423391.json', 'viator', '2024-04-18 06:56:32', '', '', '1129');
[04/18/2024 06:56:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_32_1713423392.json', 'viator', '2024-04-18 06:56:32', '', '', '1129');
[04/18/2024 06:56:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_32_1713423392.json', 'viator', '2024-04-18 06:56:32', '', '', '1129');
[04/18/2024 06:56:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_32_1713423392.json', 'viator', '2024-04-18 06:56:32', '', '', '1129');
[04/18/2024 06:56:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_04_2024/request_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_sight_details_Viator_test_06_56_32_1713423392.json', 'v1/18_04_2024/response_header_sight_details_Viator_test_06_56_32_1713423392.json', 'viator', '2024-04-18 06:56:32', '', '', '1129');
