[02/09/2024 03:02:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set login_attempt ='2'  where id = '7868';
[02/09/2024 03:02:13], [file name :-/home/otrams/public_html/beta/agent_login.php],insert into invalid_login SET ip='103.156.236.105', username='hotelyards',create_date='2024-02-09 03:02:13',referrer='https://hotelyards.astrabookings.com/index.php',type='agents',password='0Wu39~EPSD3K';
[02/09/2024 03:02:40], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-09 03:02:40',login_attempt=0 where id = '7870';
[02/09/2024 03:02:40], [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 03:02:40', ip = '103.156.236.105', action = 'Login' ;
[02/09/2024 03:02:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='103.156.236.105', agent_id='7867', session_id='c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03',create_date='2024-02-09 03:02:40', update_date='2024-02-09 03:02:40',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/09/2024 03:02:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:02:47' WHERE id= '522';
[02/09/2024 03:02:53], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:02:53' WHERE id= '522';
[02/09/2024 03:04:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:13' WHERE id= '522';
[02/09/2024 03:04:24], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:24' WHERE id= '522';
[02/09/2024 03:04:24], [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 = '103.156.236.105' , city = 'bali' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/03/14' , departure_date = '2024/03/15' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-09 03:04:24' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:25' WHERE id= '522';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699232';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696520';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706880';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706880';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706880';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706952';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706880';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696520';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.616'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706800';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706728';
[02/09/2024 03:04:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-09 03:04:25.615'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-09 03:04:25'
                , session_id = 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1706880';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_40.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_40.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_40.json', 'expedia', '2024-02-09 03:04:25', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.616'
            , 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.389'
            , error_description = ''
            , memory_used = '1434632'
            WHERE id = '32099';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_71.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_71.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_71.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.672'
            , error_description = ''
            , memory_used = '1445160'
            WHERE id = '32100';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_77.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_77.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_77.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.616'
            , 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.922'
            , error_description = ''
            , memory_used = '1434632'
            WHERE id = '32101';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_43.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_43.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_43.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_18.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_18.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_18.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_83.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_83.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_83.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_27.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_27.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_27.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.190'
            , error_description = ''
            , memory_used = '17355920'
            WHERE id = '32102';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_41.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_41.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_41.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_5.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_5.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_5.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.317'
            , error_description = ''
            , memory_used = '32805496'
            WHERE id = '32103';
[02/09/2024 03: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', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_90.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_90.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_90.json', 'expedia', '2024-02-09 03:04:26', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_13.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_13.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_13.json', 'expedia', '2024-02-09 03:04:27', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.565'
            , error_description = ''
            , memory_used = '44243584'
            WHERE id = '32104';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.625'
            , error_description = ''
            , memory_used = '49025240'
            WHERE id = '32105';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_70.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_70.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_70.json', 'expedia', '2024-02-09 03:04:27', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.678'
            , error_description = ''
            , memory_used = '40647928'
            WHERE id = '32107';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/09_02_2024/request_availability_hotel_yards_03_04_25_1707447865_90.json', 'e1/09_02_2024/response_availability_hotel_yards_03_04_25_1707447865_90.json', 'e1/09_02_2024/response_header_availability_hotel_yards_03_04_25_1707447865_90.json', 'expedia', '2024-02-09 03:04:27', '', 'c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03', '0');
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.760'
            , error_description = ''
            , memory_used = '51900824'
            WHERE id = '32106';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.616'
            , 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.780'
            , error_description = ''
            , memory_used = '31584272'
            WHERE id = '32109';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.809'
            , error_description = ''
            , memory_used = '45961344'
            WHERE id = '32108';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.031'
            , error_description = ''
            , memory_used = '32133568'
            WHERE id = '32111';
[02/09/2024 03:04:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c84ab4e9f5533372fcbac20ddfa52846a739200d26bae2fa32674b6f6ef59f03&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&web_service=no&ip=103.156.236.105&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-09 03:04:25.615'
            , 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.068'
            , error_description = ''
            , memory_used = '36485472'
            WHERE id = '32110';
[02/09/2024 03:04:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:28' WHERE id= '522';
[02/09/2024 03:04:36], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:36' WHERE id= '522';
[02/09/2024 03:04:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:40' WHERE id= '522';
[02/09/2024 03:04:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '103.156.236.105' , city = 'bali' , arrival_date='2024/03/14',  departure_date='2024/03/14',  nights='1',  create_date='2024-02-09 :03:04:40',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/09/2024 03:04:51], [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_hotel_yards_03_04_40_1707447880.json', 'v1/09_02_2024/response_availability_hotel_yards_03_04_40_1707447880.json', 'v1/09_02_2024/response_header_availability_hotel_yards_03_04_40_1707447880.json', 'viator', '2024-02-09 03:04:51', '', '', '1372');
[02/09/2024 03:04:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:53' WHERE id= '522';
[02/09/2024 03:04:53], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-09 03:04:53' WHERE id= '522';
