[02/08/2024 01:00:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 01:00:32',login_attempt=0 where id = '7870';
[02/08/2024 01:00:32], [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-08 13:00:32', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 01:00:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:00:33' WHERE id= '517';
[02/08/2024 01:00:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:00:37' WHERE id= '517';
[02/08/2024 01:00:48], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:00:48' WHERE id= '517';
[02/08/2024 01:00: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/02/28' , departure_date = '2024/02/29' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-08 13:00:48' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:00:49' WHERE id= '517';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696472';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696440';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696440';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696520';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696520';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696472';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696472';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696472';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696440';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.737'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696472';
[02/08/2024 01:00:49], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:00:49.738'
                , total_duration = '0.040'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:00:49'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696608';
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_22.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_22.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_22.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&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-08 13:00:49.737'
            , 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.354'
            , error_description = ''
            , memory_used = '1434024'
            WHERE id = '31880';
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_6.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_6.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_6.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&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-08 13:00:49.737'
            , 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.386'
            , error_description = ''
            , memory_used = '1434024'
            WHERE id = '31881';
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_53.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_53.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_53.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&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-08 13:00:49.737'
            , 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.578'
            , error_description = ''
            , memory_used = '1775160'
            WHERE id = '31882';
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_27.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_27.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_27.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_86.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_86.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_86.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_44.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_44.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_44.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_43.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_43.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_43.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_48.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_48.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_48.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_97.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_97.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_97.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00: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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_7.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_7.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_7.json', 'expedia', '2024-02-08 01:00:50', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&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-08 13:00:49.737'
            , 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.279'
            , error_description = ''
            , memory_used = '27874264'
            WHERE id = '31883';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&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-08 13:00:49.737'
            , 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.339'
            , error_description = ''
            , memory_used = '24329808'
            WHERE id = '31885';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&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-08 13:00:49.737'
            , 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.355'
            , error_description = ''
            , memory_used = '28856608'
            WHERE id = '31888';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&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-08 13:00:49.737'
            , 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.369'
            , error_description = ''
            , memory_used = '39680696'
            WHERE id = '31884';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&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-08 13:00:49.737'
            , 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.438'
            , error_description = ''
            , memory_used = '28180128'
            WHERE id = '31889';
[02/08/2024 01:00:51], [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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_82.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_82.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_82.json', 'expedia', '2024-02-08 01:00:51', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:51], [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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_48.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_48.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_48.json', 'expedia', '2024-02-08 01:00:51', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&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-08 13:00:49.737'
            , 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.452'
            , error_description = ''
            , memory_used = '33870408'
            WHERE id = '31886';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&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-08 13:00:49.737'
            , 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.540'
            , error_description = ''
            , memory_used = '40718680'
            WHERE id = '31887';
[02/08/2024 01:00:51], [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/08_02_2024/request_availability_hotel_yards_13_00_49_1707397249_77.json', 'e1/08_02_2024/response_availability_hotel_yards_13_00_49_1707397249_77.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_00_49_1707397249_77.json', 'expedia', '2024-02-08 01:00:51', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&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-08 13:00:49.737'
            , 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.910'
            , error_description = ''
            , memory_used = '40060104'
            WHERE id = '31891';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&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-08 13:00:49.737'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.916'
            , error_description = ''
            , memory_used = '47193464'
            WHERE id = '31890';
[02/08/2024 01:00:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&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-08 13:00:49.737'
            , 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.999'
            , error_description = ''
            , memory_used = '42209320'
            WHERE id = '31892';
[02/08/2024 01:00:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:00:52' WHERE id= '517';
[02/08/2024 01:01:12], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:01:12' WHERE id= '517';
[02/08/2024 01:01:12], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:01:12' WHERE id= '517';
[02/08/2024 01:02:13], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:02:13' WHERE id= '517';
[02/08/2024 01:02:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:02:15' WHERE id= '517';
[02/08/2024 01:02:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:02:36' WHERE id= '517';
[02/08/2024 01:02:36], [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/26' , departure_date = '2024/03/30' , nights = '4' , nationality = '106' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-02-08 13:02:36' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:02:37' WHERE id= '517';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697872';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697984';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697984';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697872';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1698032';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697872';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697984';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697984';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.920'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697872';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697824';
[02/08/2024 01:02:37], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:02:37.921'
                , total_duration = '0.042'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:02:37'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697984';
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_50.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_50.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_50.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&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-08 13:02:37.922'
            , 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.408'
            , error_description = ''
            , memory_used = '1436992'
            WHERE id = '31909';
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_18.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&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-08 13:02:37.920'
            , 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.763'
            , error_description = ''
            , memory_used = '1436088'
            WHERE id = '31910';
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_37_1707397357_49.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_37_1707397357_49.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_37_1707397357_49.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_6.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_6.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_6.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_18.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&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-08 13:02:37.922'
            , 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.890'
            , error_description = ''
            , memory_used = '1436088'
            WHERE id = '31913';
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_64.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_64.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_64.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&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-08 13:02:37.921'
            , 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.020'
            , error_description = ''
            , memory_used = '14575128'
            WHERE id = '31911';
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_39.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_39.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_39.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:38], [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/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_25.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_25.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_25.json', 'expedia', '2024-02-08 01:02:38', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&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-08 13:02:37.921'
            , 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.138'
            , error_description = ''
            , memory_used = '22268056'
            WHERE id = '31912';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_11.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_11.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_11.json', 'expedia', '2024-02-08 01:02:39', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&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-08 13:02:37.922'
            , 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.220'
            , error_description = ''
            , memory_used = '12951384'
            WHERE id = '31915';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_02_37_1707397357_74.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_37_1707397357_74.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_37_1707397357_74.json', 'expedia', '2024-02-08 01:02:39', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_18.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_18.json', 'expedia', '2024-02-08 01:02:39', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&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-08 13:02:37.921'
            , 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.238'
            , error_description = ''
            , memory_used = '22380560'
            WHERE id = '31914';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_02_38_1707397358_21.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_38_1707397358_21.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_38_1707397358_21.json', 'expedia', '2024-02-08 01:02:39', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&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-08 13:02:37.921'
            , 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.383'
            , error_description = ''
            , memory_used = '13732552'
            WHERE id = '31918';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_02_37_1707397357_39.json', 'e1/08_02_2024/response_availability_hotel_yards_13_02_37_1707397357_39.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_02_37_1707397357_39.json', 'expedia', '2024-02-08 01:02:39', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&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-08 13:02:37.922'
            , 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.404'
            , error_description = ''
            , memory_used = '21433192'
            WHERE id = '31917';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&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-08 13:02:37.922'
            , 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.412'
            , error_description = ''
            , memory_used = '32392968'
            WHERE id = '31916';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&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-08 13:02:37.921'
            , 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.435'
            , error_description = ''
            , memory_used = '18032096'
            WHERE id = '31919';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&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-08 13:02:37.921'
            , 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.555'
            , error_description = ''
            , memory_used = '14754944'
            WHERE id = '31921';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&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-08 13:02:37.922'
            , 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.614'
            , error_description = ''
            , memory_used = '27429288'
            WHERE id = '31920';
[02/08/2024 01:02:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:02:39' WHERE id= '517';
[02/08/2024 01:03:16], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:03:16' WHERE id= '517';
[02/08/2024 01:03:16], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:03:16' WHERE id= '517';
[02/08/2024 01:03:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:03:32' WHERE id= '517';
[02/08/2024 01:03:32], [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/26' , departure_date = '2024/03/30' , nights = '4' , nationality = '106' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-02-08 13:03:32' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:03:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:03:33' WHERE id= '517';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.787'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.787'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.787'
                , total_duration = '0.037'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697640';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.041'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.059'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.064'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:34], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:03:34.788'
                , total_duration = '0.080'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:03:34'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_35_1707397415_23.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_35_1707397415_23.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_35_1707397415_23.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&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-08 13:03:34.790'
            , 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.381'
            , error_description = ''
            , memory_used = '1436264'
            WHERE id = '31938';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_35_1707397415_20.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_35_1707397415_20.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_35_1707397415_20.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&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-08 13:03:34.789'
            , 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.427'
            , error_description = ''
            , memory_used = '1437200'
            WHERE id = '31939';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_31.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_31.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_31.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_97.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_97.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_97.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_14.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_14.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_14.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_43.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_43.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_43.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_51.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_51.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_51.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&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-08 13:03:34.788'
            , 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.788'
            , error_description = ''
            , memory_used = '14752368'
            WHERE id = '31940';
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&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-08 13:03:34.788'
            , 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.794'
            , error_description = ''
            , memory_used = '13734008'
            WHERE id = '31941';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_35_1707397415_28.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_35_1707397415_28.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_35_1707397415_28.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&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-08 13:03:34.788'
            , 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.846'
            , error_description = ''
            , memory_used = '14576776'
            WHERE id = '31943';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_58.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_58.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_58.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_98.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_98.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_98.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&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-08 13:03:34.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.858'
            , error_description = ''
            , memory_used = '1436264'
            WHERE id = '31946';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_25.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_25.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_25.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&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-08 13:03:34.788'
            , 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.886'
            , error_description = ''
            , memory_used = '18032024'
            WHERE id = '31942';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_95.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_95.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_95.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&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-08 13:03:34.789'
            , 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.965'
            , error_description = ''
            , memory_used = '12979840'
            WHERE id = '31945';
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&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-08 13:03:34.789'
            , 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.003'
            , error_description = ''
            , memory_used = '22383608'
            WHERE id = '31944';
[02/08/2024 01:03:35], [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/08_02_2024/request_availability_hotel_yards_13_03_34_1707397414_9.json', 'e1/08_02_2024/response_availability_hotel_yards_13_03_34_1707397414_9.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_03_34_1707397414_9.json', 'expedia', '2024-02-08 01:03:35', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&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-08 13:03:34.790'
            , 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.079'
            , error_description = ''
            , memory_used = '21435864'
            WHERE id = '31947';
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&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-08 13:03:34.788'
            , 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.127'
            , error_description = ''
            , memory_used = '22266696'
            WHERE id = '31949';
[02/08/2024 01:03:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&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-08 13:03:34.788'
            , 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.129'
            , error_description = ''
            , memory_used = '27428792'
            WHERE id = '31948';
[02/08/2024 01:03:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&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-08 13:03:34.789'
            , 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.330'
            , error_description = ''
            , memory_used = '32386080'
            WHERE id = '31950';
[02/08/2024 01:03:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:03:36' WHERE id= '517';
[02/08/2024 01:04:51], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:04:51' WHERE id= '517';
[02/08/2024 01:04:51], [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/26' , departure_date = '2024/03/30' , nights = '4' , nationality = '106' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-02-08 13:04:51' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:04:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:04:51' WHERE id= '517';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.267'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697640';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.267'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697640';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.267'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697640';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697752';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.267'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.267'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697592';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.268'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697560';
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:04:52.269'
                , total_duration = '0.041'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:04:52'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:04:52], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_9.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_9.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_9.json', 'expedia', '2024-02-08 01:04:52', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&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-08 13:04:52.267'
            , 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.387'
            , error_description = ''
            , memory_used = '1436256'
            WHERE id = '31967';
[02/08/2024 01:04:52], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_30.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_30.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_30.json', 'expedia', '2024-02-08 01:04:52', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_5.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_5.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_5.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&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-08 13:04:52.268'
            , 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.854'
            , error_description = ''
            , memory_used = '18031792'
            WHERE id = '31968';
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&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-08 13:04:52.267'
            , 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.970'
            , error_description = ''
            , memory_used = '22267376'
            WHERE id = '31969';
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_93.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_93.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_93.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_62.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_62.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_62.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&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-08 13:04:52.267'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.206'
            , error_description = ''
            , memory_used = '1436256'
            WHERE id = '31970';
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_4.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_4.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_4.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_41.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_41.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_41.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_25.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_25.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_25.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_32.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_32.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_32.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&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-08 13:04:52.267'
            , 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.358'
            , error_description = ''
            , memory_used = '12952552'
            WHERE id = '31971';
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_59.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_59.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_59.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&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-08 13:04:52.268'
            , 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.421'
            , error_description = ''
            , memory_used = '14576848'
            WHERE id = '31973';
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_40.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_40.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_40.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&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-08 13:04:52.268'
            , 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.460'
            , error_description = ''
            , memory_used = '14754600'
            WHERE id = '31974';
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&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-08 13:04:52.268'
            , 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.470'
            , error_description = ''
            , memory_used = '13732232'
            WHERE id = '31975';
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&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-08 13:04:52.267'
            , 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.543'
            , error_description = ''
            , memory_used = '21437096'
            WHERE id = '31972';
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&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-08 13:04:52.268'
            , 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.669'
            , error_description = ''
            , memory_used = '27428824'
            WHERE id = '31976';
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&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-08 13:04:52.268'
            , 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.680'
            , error_description = ''
            , memory_used = '22383984'
            WHERE id = '31977';
[02/08/2024 01:04:53], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_40.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_40.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_40.json', 'expedia', '2024-02-08 01:04:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&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-08 13:04:52.267'
            , 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.725'
            , error_description = ''
            , memory_used = '1437192'
            WHERE id = '31978';
[02/08/2024 01:04:54], [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/08_02_2024/request_availability_hotel_yards_13_04_52_1707397492_51.json', 'e1/08_02_2024/response_availability_hotel_yards_13_04_52_1707397492_51.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_04_52_1707397492_51.json', 'expedia', '2024-02-08 01:04:54', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:04:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&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-08 13:04:52.268'
            , 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.323'
            , error_description = ''
            , memory_used = '32114968'
            WHERE id = '31979';
[02/08/2024 01:04:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:04:55' WHERE id= '517';
[02/08/2024 01:05:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:05:06' WHERE id= '517';
[02/08/2024 01:05:06], [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/26' , departure_date = '2024/03/28' , nights = '2' , nationality = '106' , room_types = '2.1, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-02-08 13:05:06' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:05:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:05:06' WHERE id= '517';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697632';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697584';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:05:07.306'
                , total_duration = '0.041'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:05:07'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1697704';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_88.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_88.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_88.json', 'expedia', '2024-02-08 01:05:07', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=12&total_request=13&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-08 13:05:07.307'
            , 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.327'
            , error_description = ''
            , memory_used = '1436112'
            WHERE id = '31996';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_76.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_76.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_76.json', 'expedia', '2024-02-08 01:05:07', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=11&total_request=13&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-08 13:05:07.307'
            , 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.424'
            , error_description = ''
            , memory_used = '1436168'
            WHERE id = '31997';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_49.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_49.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_49.json', 'expedia', '2024-02-08 01:05:07', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=10&total_request=13&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-08 13:05:07.307'
            , 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.511'
            , error_description = ''
            , memory_used = '1492528'
            WHERE id = '31998';
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_78.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_78.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_78.json', 'expedia', '2024-02-08 01:05:07', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:07], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_49.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_49.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_49.json', 'expedia', '2024-02-08 01:05:07', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=1&total_request=13&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-08 13:05:07.306'
            , 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.799'
            , error_description = ''
            , memory_used = '12804400'
            WHERE id = '31999';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=2&total_request=13&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-08 13:05:07.307'
            , 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.848'
            , error_description = ''
            , memory_used = '15020176'
            WHERE id = '32000';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_20.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_20.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_20.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_72.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_72.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_72.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_96.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_96.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_96.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_41.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_41.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_41.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_81.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_81.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_81.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_66.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_66.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_66.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_30.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_30.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_30.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=5&total_request=13&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-08 13:05:07.307'
            , 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.140'
            , error_description = ''
            , memory_used = '26902040'
            WHERE id = '32001';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=3&total_request=13&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-08 13:05:07.306'
            , 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.142'
            , error_description = ''
            , memory_used = '17214856'
            WHERE id = '32004';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=8&total_request=13&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-08 13:05:07.307'
            , 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.152'
            , error_description = ''
            , memory_used = '23437280'
            WHERE id = '32002';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=4&total_request=13&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-08 13:05:07.307'
            , 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.161'
            , error_description = ''
            , memory_used = '20573296'
            WHERE id = '32003';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=7&total_request=13&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-08 13:05:07.307'
            , 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.180'
            , error_description = ''
            , memory_used = '21584840'
            WHERE id = '32005';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=9&total_request=13&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-08 13:05:07.307'
            , 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.186'
            , error_description = ''
            , memory_used = '12138680'
            WHERE id = '32007';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/08_02_2024/request_availability_hotel_yards_13_05_07_1707397507_19.json', 'e1/08_02_2024/response_availability_hotel_yards_13_05_07_1707397507_19.json', 'e1/08_02_2024/response_header_availability_hotel_yards_13_05_07_1707397507_19.json', 'expedia', '2024-02-08 01:05:08', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=6&total_request=13&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-08 13:05:07.307'
            , 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.274'
            , error_description = ''
            , memory_used = '30887216'
            WHERE id = '32006';
[02/08/2024 01:05:08], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22&xml_user_id=7867&db_caching=1&erequest=0&total_request=13&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-08 13:05:07.307'
            , 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.484'
            , error_description = ''
            , memory_used = '14263464'
            WHERE id = '32008';
[02/08/2024 01:05:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:05:09' WHERE id= '517';
[02/08/2024 01:05:39], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:05:39' WHERE id= '517';
[02/08/2024 01:05:40], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:05:40' WHERE id= '517';
[02/08/2024 01:05:40], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707397540','43.239.53.130');
[02/08/2024 01:05:40], [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/08_02_2024/request_valuation_hotel_yards_13_05_40_1707397540_87.json', 'e1/08_02_2024/response_valuation_hotel_yards_13_05_40_1707397540_87.json', 'e1/08_02_2024/response_header_valuation_hotel_yards_13_05_40_1707397540_87.json', 'expedia', '2024-02-08 01:05:40', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:06:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:06:24' WHERE id= '517';
[02/08/2024 01:06:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:06:26' WHERE id= '517';
[02/08/2024 01:07:36], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:07:36' WHERE id= '517';
[02/08/2024 01:07:51], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:07:51' WHERE id= '517';
[02/08/2024 01:07:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:07:52' WHERE id= '517';
[02/08/2024 01:07:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707397672','43.239.53.130');
[02/08/2024 01:07:53], [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/08_02_2024/request_valuation_hotel_yards_13_07_52_1707397672_94.json', 'e1/08_02_2024/response_valuation_hotel_yards_13_07_52_1707397672_94.json', 'e1/08_02_2024/response_header_valuation_hotel_yards_13_07_52_1707397672_94.json', 'expedia', '2024-02-08 01:07:53', '', 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22', '0');
[02/08/2024 01:08:05], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:05' WHERE id= '517';
[02/08/2024 01:08:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:19' WHERE id= '517';
[02/08/2024 01:08:25], [file name :-/home/otrams/public_html/beta/groups.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:25' WHERE id= '517';
[02/08/2024 01:08:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:30' WHERE id= '517';
[02/08/2024 01:08:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:44' WHERE id= '517';
[02/08/2024 01:08:46], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:08:46' WHERE id= '517';
[02/08/2024 01:09:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:09:00' WHERE id= '517';
[02/08/2024 01:09:06], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:09:06' WHERE id= '517';
[02/08/2024 01:09:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:09:09' WHERE id= '517';
[02/08/2024 01:09:12], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:09:12' WHERE id= '517';
[02/08/2024 01:09:17], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:09:17' WHERE id= '517';
[02/08/2024 01:10:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 01:10:05',login_attempt=0 where id = '7849';
[02/08/2024 01:10:05], [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-08 13:10:05', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 01:10:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:05' WHERE id= '510';
[02/08/2024 01:10:11], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:11' WHERE id= '510';
[02/08/2024 01:10:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:14' WHERE id= '510';
[02/08/2024 01:10:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:19' WHERE id= '510';
[02/08/2024 01:10:19], [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/18',  departure_date='2024/02/18',  nights='1',  create_date='2024-02-08 :13:10:19',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/08/2024 01:10:27], [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/08_02_2024/request_availability_shiv_qtech_13_10_19_1707397819.json', 'v1/08_02_2024/response_availability_shiv_qtech_13_10_19_1707397819.json', 'v1/08_02_2024/response_header_availability_shiv_qtech_13_10_19_1707397819.json', 'viator', '2024-02-08 01:10:27', '', '', '1370');
[02/08/2024 01:10:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:29' WHERE id= '510';
[02/08/2024 01:10:29], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:29' WHERE id= '510';
[02/08/2024 01:10:30], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:30' WHERE id= '517';
[02/08/2024 01:10:30], [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 = '443' , service_type = 'hotel' , arrival_date = '2024/03/26' , departure_date = '2024/03/28' , nights = '2' , nationality = '416' , room_types = '9.3, 4.3, 1.3, 1.3, 1.3' , room_type='[{"numberOfAdults":9,"numberOfChild":3,"ChildAge":"1,1,1"},{"numberOfAdults":4,"numberOfChild":3,"ChildAge":"1,1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,10"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-08 13:10:30' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:10:31], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:31' WHERE id= '517';
[02/08/2024 01:10:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:31' WHERE id= '510';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.102'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703856';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703880';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.102'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703880';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703880';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.104'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703960';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.104'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352256';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.102'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.102'
                , total_duration = '0.028'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703808';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:10:32.103'
                , total_duration = '0.034'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:10:32'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1352216';
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_10_31_1707397831.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_10_31_1707397831.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_10_31_1707397831.json', 'viator', '2024-02-08 01:10:32', '', '', '1370');
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_10_32_1707397832.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_10_32_1707397832.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_10_32_1707397832.json', 'viator', '2024-02-08 01:10:32', '', '', '1370');
[02/08/2024 01:10:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:32' WHERE id= '517';
[02/08/2024 01:10:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:36' WHERE id= '510';
[02/08/2024 01:10:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/08_02_2024/request_check_availability_shiv_qtech_13_10_36_1707397836.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_13_10_36_1707397836.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_13_10_36_1707397836.json', 'viator', '2024-02-08 01:10:37', '', '', '1370');
[02/08/2024 01:10:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:37' WHERE id= '517';
[02/08/2024 01:10:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:40' WHERE id= '510';
[02/08/2024 01:10:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707397840','43.239.53.130');
[02/08/2024 01:10:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:10:48' WHERE id= '517';
[02/08/2024 01:11:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:11:42' WHERE id= '517';
[02/08/2024 01:11:42], [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 = '153' , service_type = 'hotel' , arrival_date = '2024/03/26' , departure_date = '2024/03/28' , nights = '2' , nationality = '416' , room_types = '9.3' , room_type='[{"numberOfAdults":9,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2024-02-08 13:11:42' , site_id = '21' , country_code = '107' , city_code = '107_17239-DPS_1523' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:11:43' WHERE id= '517';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699536';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699704';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.732'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.732'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345976';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.730'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699488';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.732'
                , total_duration = '0.022'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345944';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345592';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1699656';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345552';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.732'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345936';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.731'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345648';
[02/08/2024 01:11:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 13:11:43.732'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'expedia'
                , create_date = '2024-02-08 01:11:43'
                , session_id = 'eb1e282b1fa050573ddb1b051048a63cccf2f456836ea00595a4a3f2d6371c22'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1345552';
[02/08/2024 01:11:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:11:44' WHERE id= '517';
[02/08/2024 01:28:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 01:28:10',login_attempt=0 where id = '7849';
[02/08/2024 01:28:10], [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-08 13:28:10', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 01:28:10], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:10' WHERE id= '520';
[02/08/2024 01:28:15], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:15' WHERE id= '520';
[02/08/2024 01:28:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:20' WHERE id= '520';
[02/08/2024 01:28:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:23' WHERE id= '520';
[02/08/2024 01:28:23], [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-08 :13:28:23',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/08/2024 01:28:28], [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/08_02_2024/request_availability_shiv_qtech_13_28_23_1707398903.json', 'v1/08_02_2024/response_availability_shiv_qtech_13_28_23_1707398903.json', 'v1/08_02_2024/response_header_availability_shiv_qtech_13_28_23_1707398903.json', 'viator', '2024-02-08 01:28:28', '', '', '1371');
[02/08/2024 01:28:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:31' WHERE id= '520';
[02/08/2024 01:28:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:31' WHERE id= '520';
[02/08/2024 01:28:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:38' WHERE id= '520';
[02/08/2024 01:28:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_28_38_1707398918.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_28_38_1707398918.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_28_38_1707398918.json', 'viator', '2024-02-08 01:28:38', '', '', '1371');
[02/08/2024 01:28:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_28_38_1707398918.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_28_38_1707398918.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_28_38_1707398918.json', 'viator', '2024-02-08 01:28:38', '', '', '1371');
[02/08/2024 01:28:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:41' WHERE id= '520';
[02/08/2024 01:28:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_28_41_1707398921.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_28_41_1707398921.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_28_41_1707398921.json', 'viator', '2024-02-08 01:28:42', '', '', '1371');
[02/08/2024 01:28:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_13_28_42_1707398922.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_13_28_42_1707398922.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_13_28_42_1707398922.json', 'viator', '2024-02-08 01:28:42', '', '', '1371');
[02/08/2024 01:28:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:45' WHERE id= '520';
[02/08/2024 01:28:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/08_02_2024/request_check_availability_shiv_qtech_13_28_45_1707398925.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_13_28_45_1707398925.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_13_28_45_1707398925.json', 'viator', '2024-02-08 01:28:46', '', '', '1371');
[02/08/2024 01:28:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 01:28:48' WHERE id= '520';
[02/08/2024 01:28:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707398928','43.239.53.130');
