[02/09/2024 05:17:34], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 05:17:34',login_attempt=0 where id = '7870';
[02/09/2024 05:17:34], [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 05:17:34', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 05:17:34], [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='c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63',create_date='2024-02-09 05:17:34', update_date='2024-02-09 05:17:34',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 05:17:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:17:39' WHERE id= '523';
[02/09/2024 05:18:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:18:21' WHERE id= '523';
[02/09/2024 05:18:34], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:18:34' WHERE id= '523';
[02/09/2024 05:18:34], [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/03/19' , departure_date = '2024/03/20' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 05:18:34' , site_id = '21' , 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 = '' ;
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:18:35' WHERE id= '523';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696432';
[02/09/2024 05:18:35], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:18:35.886'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:18:35'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696464';
[02/09/2024 05:18:36], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_18_35_1707455915_43.json', 'e1/09_02_2024/response_availability_hotel_yards_05_18_35_1707455915_43.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_18_35_1707455915_43.json', 'expedia', '2024-02-09 05:18:36', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:18:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:18:35.886'
            , 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.391'
            , error_description = ''
            , memory_used = '1425344'
            WHERE id = '32120';
[02/09/2024 05:18:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_18_35_1707455915_4.json', 'e1/09_02_2024/response_availability_hotel_yards_05_18_35_1707455915_4.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_18_35_1707455915_4.json', 'expedia', '2024-02-09 05:18:37', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:18:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_18_35_1707455915_93.json', 'e1/09_02_2024/response_availability_hotel_yards_05_18_35_1707455915_93.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_18_35_1707455915_93.json', 'expedia', '2024-02-09 05:18:37', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:18:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:18:35.886'
            , 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.206'
            , error_description = ''
            , memory_used = '185734392'
            WHERE id = '32121';
[02/09/2024 05:18:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:18:35.886'
            , 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.243'
            , error_description = ''
            , memory_used = '186554288'
            WHERE id = '32122';
[02/09/2024 05:18:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:18:39' WHERE id= '523';
[02/09/2024 05:19:06], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:19:06' WHERE id= '523';
[02/09/2024 05:19:06], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:19:06' WHERE id= '523';
[02/09/2024 05:19:06], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707455946','43.239.53.130');
[02/09/2024 05:19:07], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/09_02_2024/request_valuation_hotel_yards_05_19_06_1707455946_73.json', 'e1/09_02_2024/response_valuation_hotel_yards_05_19_06_1707455946_73.json', 'e1/09_02_2024/response_header_valuation_hotel_yards_05_19_06_1707455946_73.json', 'expedia', '2024-02-09 05:19:07', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:19:10], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:19:10' WHERE id= '523';
[02/09/2024 05:19:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:19:50' WHERE id= '523';
[02/09/2024 05:20:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:00' WHERE id= '523';
[02/09/2024 05:20:00], [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/04/16' , departure_date = '2024/04/17' , nights = '1' , nationality = '95' , room_types = '4.2, 1' , room_type='[{"numberOfAdults":4,"numberOfChild":2,"ChildAge":"7,4"},{"numberOfAdults":1}]' , available='0' , create_date = '2024-02-09 05:20:00' , 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 = '' ;
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:01' WHERE id= '523';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.371'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698392';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.371'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698392';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.370'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698424';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.370'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698424';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.371'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698392';
[02/09/2024 05:20:01], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:20:01.370'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:20:01'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698424';
[02/09/2024 05:20: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_05_20_01_1707456001_32.json', 'e1/09_02_2024/response_availability_hotel_yards_05_20_01_1707456001_32.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_20_01_1707456001_32.json', 'expedia', '2024-02-09 05:20:02', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:20:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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=95'
            , http_hit_time = '2024-02-09 05:20:01.371'
            , 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.292'
            , error_description = ''
            , memory_used = '7983600'
            WHERE id = '32130';
[02/09/2024 05:20: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_05_20_01_1707456001_67.json', 'e1/09_02_2024/response_availability_hotel_yards_05_20_01_1707456001_67.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_20_01_1707456001_67.json', 'expedia', '2024-02-09 05:20:02', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:20:02], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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=95'
            , http_hit_time = '2024-02-09 05:20:01.371'
            , 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.581'
            , error_description = ''
            , memory_used = '25481856'
            WHERE id = '32131';
[02/09/2024 05:20:03], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:03' WHERE id= '523';
[02/09/2024 05:20:12], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:12' WHERE id= '523';
[02/09/2024 05:20:13], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:13' WHERE id= '523';
[02/09/2024 05:20:13], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707456013','43.239.53.130');
[02/09/2024 05:20:13], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/09_02_2024/request_valuation_hotel_yards_05_20_13_1707456013_89.json', 'e1/09_02_2024/response_valuation_hotel_yards_05_20_13_1707456013_89.json', 'e1/09_02_2024/response_header_valuation_hotel_yards_05_20_13_1707456013_89.json', 'expedia', '2024-02-09 05:20:13', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:20:39], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:39' WHERE id= '523';
[02/09/2024 05:20:43], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:20:43' WHERE id= '523';
[02/09/2024 05:21:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:21:30' WHERE id= '523';
[02/09/2024 05:21:37], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:21:37' WHERE id= '523';
[02/09/2024 05:21:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:21:37' WHERE id= '523';
[02/09/2024 05:21:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707456097','43.239.53.130');
[02/09/2024 05:21:38], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/09_02_2024/request_valuation_hotel_yards_05_21_37_1707456097_34.json', 'e1/09_02_2024/response_valuation_hotel_yards_05_21_37_1707456097_34.json', 'e1/09_02_2024/response_header_valuation_hotel_yards_05_21_37_1707456097_34.json', 'expedia', '2024-02-09 05:21:38', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:22:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:22:16' WHERE id= '523';
[02/09/2024 05:22:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:22:32' WHERE id= '523';
[02/09/2024 05:22:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:22:34' WHERE id= '523';
[02/09/2024 05:22:34], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:22:34' WHERE id= '523';
[02/09/2024 05:22:47], [file name :-/home/otrams/public_html/beta/ajax/ajax_send_quotation_email.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:22:47' WHERE id= '523';
[02/09/2024 05:25:16], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:25:16' WHERE id= '523';
[02/09/2024 05:25:16], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 05:25:16',login_attempt=0 where id = '7870';
[02/09/2024 05:25:16], [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 05:25:16', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 05:25:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:25:17' WHERE id= '523';
[02/09/2024 05:26:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 05:26:45',login_attempt=0 where id = '7866';
[02/09/2024 05:26:45], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-02-09 05:26:45', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 05:26:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='b35b8c7fd16cfee7edabcd932b9ba20addb09f22541499bdb9ab352a9cd8cf04',create_date='2024-02-09 05:26:45', update_date='2024-02-09 05:26:45',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 05:28:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:28:43' WHERE id= '523';
[02/09/2024 05:28:48], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:28:48' WHERE id= '523';
[02/09/2024 05:28:48], [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/13' , departure_date = '2024/03/14' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 05:28:48' , 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 05:28:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:28:49' WHERE id= '523';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696456';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696456';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696456';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696456';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696552';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696456';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696272';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/09/2024 05:28:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 05:28:49.786'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 05:28:49'
                , session_id = 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696304';
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_26.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_26.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_26.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.335'
            , error_description = ''
            , memory_used = '1433704'
            WHERE id = '32150';
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_98.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_98.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_98.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.360'
            , error_description = ''
            , memory_used = '1434344'
            WHERE id = '32151';
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_67.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_67.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_67.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.534'
            , error_description = ''
            , memory_used = '3641960'
            WHERE id = '32152';
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_80.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_80.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_80.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_79.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_79.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_79.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_96.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_96.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_96.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_48.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_48.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_48.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_78.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_78.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_78.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_31.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_31.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_31.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_85.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_85.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_85.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_05_28_49_1707456529_16.json', 'e1/09_02_2024/response_availability_hotel_yards_05_28_49_1707456529_16.json', 'e1/09_02_2024/response_header_availability_hotel_yards_05_28_49_1707456529_16.json', 'expedia', '2024-02-09 05:28:50', '', 'c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63', '0');
[02/09/2024 05:28:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.786'
            , 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.200'
            , error_description = ''
            , memory_used = '36960048'
            WHERE id = '32153';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.288'
            , error_description = ''
            , memory_used = '38310576'
            WHERE id = '32154';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.786'
            , 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.314'
            , error_description = ''
            , memory_used = '39261000'
            WHERE id = '32155';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.395'
            , error_description = ''
            , memory_used = '44987128'
            WHERE id = '32157';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.415'
            , error_description = ''
            , memory_used = '42814032'
            WHERE id = '32156';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.786'
            , 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.505'
            , error_description = ''
            , memory_used = '49674344'
            WHERE id = '32158';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.589'
            , error_description = ''
            , memory_used = '52398552'
            WHERE id = '32160';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c7d9e6fb5e5d9d940bca4c0db9255cc29100753d959cfea3ef777207eea13a63&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 05:28:49.787'
            , 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.636'
            , error_description = ''
            , memory_used = '58023440'
            WHERE id = '32159';
[02/09/2024 05:28:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:28:51' WHERE id= '523';
[02/09/2024 05:29:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:29:09' WHERE id= '523';
[02/09/2024 05:29:10], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:29:10' WHERE id= '523';
[02/09/2024 05:29:11], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:29:11' WHERE id= '523';
[02/09/2024 05:31:13], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:31:13' WHERE id= '523';
[02/09/2024 05:42:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 05:42:32',login_attempt=0 where id = '7849';
[02/09/2024 05:42:32], [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 05:42:32', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 05:42:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:42:33' WHERE id= '520';
[02/09/2024 05:43:14], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:43:14' WHERE id= '520';
[02/09/2024 05:43:17], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:43:17' WHERE id= '520';
[02/09/2024 05:43:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:43:21' WHERE id= '520';
[02/09/2024 05:43:21], [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/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-09 :05:43:21',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/09/2024 05:43:29], [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_05_43_21_1707457401.json', 'v1/09_02_2024/response_availability_shiv_qtech_05_43_21_1707457401.json', 'v1/09_02_2024/response_header_availability_shiv_qtech_05_43_21_1707457401.json', 'viator', '2024-02-09 05:43:29', '', '', '1373');
[02/09/2024 05:43:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:43:31' WHERE id= '520';
[02/09/2024 05:43:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:43:31' WHERE id= '520';
[02/09/2024 05:53:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 05:53:03',login_attempt=0 where id = '7866';
[02/09/2024 05:53:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-02-09 05:53:03', ip = '43.239.53.130', action = 'Login' ;
[02/09/2024 05:53:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:03' WHERE id= '521';
[02/09/2024 05:53:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:16' WHERE id= '521';
[02/09/2024 05:53:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:18' WHERE id= '521';
[02/09/2024 05:53:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/02/23' , departure_date = '2024/02/24' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 05:53:18' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 05:53:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:19' WHERE id= '521';
[02/09/2024 05:53:19], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_Baysan_Tourism_wh_05_53_19_1707457999_6.json', 'e1/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_6.json', 'e1/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_6.json', 'expedia', '2024-02-09 05:53:19', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '0.234'
            , error_description = ''
            , memory_used = '1435184'
            WHERE id = '32162';
[02/09/2024 05:53:20], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/09_02_2024/request_availability_Baysan_Tourism_wh_05_53_19_1707457999_78.json', 'e1p/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_78.json', 'e1p/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_78.json', 'expediapackage', '2024-02-09 05:53:20', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '0.336'
            , error_description = ''
            , memory_used = '1436088'
            WHERE id = '32163';
[02/09/2024 05:53: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_Baysan_Tourism_wh_05_53_19_1707457999_50.json', 'e1/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_50.json', 'e1/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_50.json', 'expedia', '2024-02-09 05:53:21', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53: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/09_02_2024/request_availability_Baysan_Tourism_wh_05_53_19_1707457999_30.json', 'e1p/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_30.json', 'e1p/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_30.json', 'expediapackage', '2024-02-09 05:53:21', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53: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_Baysan_Tourism_wh_05_53_19_1707457999_75.json', 'e1/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_75.json', 'e1/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_75.json', 'expedia', '2024-02-09 05:53:21', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53: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/09_02_2024/request_availability_Baysan_Tourism_wh_05_53_19_1707457999_73.json', 'e1p/09_02_2024/response_availability_Baysan_Tourism_wh_05_53_19_1707457999_73.json', 'e1p/09_02_2024/response_header_availability_Baysan_Tourism_wh_05_53_19_1707457999_73.json', 'expediapackage', '2024-02-09 05:53:21', '', 'a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84', '0');
[02/09/2024 05:53:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '2.677'
            , error_description = ''
            , memory_used = '140193968'
            WHERE id = '32164';
[02/09/2024 05:53:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '3.236'
            , error_description = ''
            , memory_used = '147425496'
            WHERE id = '32167';
[02/09/2024 05:53:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '3.346'
            , error_description = ''
            , memory_used = '165987088'
            WHERE id = '32166';
[02/09/2024 05:53:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=a84c0f5894a7d733b8e85085b5f743c9f556e9ef40a04cf0802efa0870a41c84&xml_user_id=7863&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=138'
            , http_hit_time = '2024-02-09 05:53:19.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 = '3.356'
            , error_description = ''
            , memory_used = '175405496'
            WHERE id = '32165';
[02/09/2024 05:53:24], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:24' WHERE id= '521';
[02/09/2024 05:53:24], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 05:53:24' WHERE id= '521';
