[05/16/2024 11:00:02], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 10:59:59.290'
            , total_duration = '2.760'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:00:02'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9554174'
            , error_description = ''
            , memory_used = '3506184';
[05/16/2024 11:00:30], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_00_27_1715857227.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_00_27_1715857227.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_00_27_1715857227.json', 'tripathonxml', '2024-05-16 11:00:30', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 11:00:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:00:27.144'
        , request_start_time = '0.012'
        , parsing_start_time = '3.655'
        , mapping_complete_time = '0.527'
        , mongo_start_time = '3.579'
        , search_end_time = '23.210'
        , total_duration = '30.864'
        , error_description = ''
        , memory_used = '601281656'
        WHERE id = '139557821';
[05/16/2024 11:01:53], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_01_50_1715857310.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_01_50_1715857310.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_01_50_1715857310.json', 'tripathonxml', '2024-05-16 11:01:53', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9554174');
[05/16/2024 11:01:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source=&rdebug=3'
        , http_hit_time = '2024-05-16 11:01:50.282'
        , request_start_time = '0.016'
        , parsing_start_time = '3.284'
        , mapping_complete_time = '0.548'
        , mongo_start_time = '3.654'
        , search_end_time = '0.000'
        , total_duration = '9.525'
        , error_description = ''
        , memory_used = '604227720'
        WHERE id = '139558314';
[05/16/2024 11:12:01], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:12:01' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 11:12:03], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:03.234'
            , total_duration = '0.060'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:03'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9555922'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:03], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:03.234'
            , total_duration = '0.084'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:03'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9555922'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:03], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:03.234'
            , total_duration = '0.084'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:03'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9555922'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:03], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__3_11_12_03_1715857923.json', 'tr/16_05_2024/response_availability_qtech_agent__3_11_12_03_1715857923.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_11_12_03_1715857923.json', 'tripathonxml', '2024-05-16 11:12:03', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9555922');
[05/16/2024 11:12:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:12:03.234'
        , request_start_time = '0.012'
        , parsing_start_time = '0.628'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.028'
        , search_end_time = '0.034'
        , total_duration = '0.746'
        , error_description = ''
        , memory_used = '4229176'
        WHERE id = '139564853';
[05/16/2024 11:12:07], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_12_03_1715857923.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_12_03_1715857923.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_12_03_1715857923.json', 'tripathonxml', '2024-05-16 11:12:07', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9555922');
[05/16/2024 11:12:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:12:03.233'
        , request_start_time = '0.011'
        , parsing_start_time = '4.049'
        , mapping_complete_time = '0.541'
        , mongo_start_time = '3.624'
        , search_end_time = '15.179'
        , total_duration = '23.232'
        , error_description = ''
        , memory_used = '603810344'
        WHERE id = '139564861';
[05/16/2024 11:12:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '703',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '24.090',
        merge_duration = '0.258',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.37',
        system_load_5_min = '1.99',
        system_load_15_min = '1.67',
        system_memory_usage = '94.85',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9555922') + '37049552',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9555922';
[05/16/2024 11:12:39], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:12:39' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 11:12:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:40.503'
            , total_duration = '0.057'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:40'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556003'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:40.502'
            , total_duration = '0.078'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:40'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556003'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:12:40.502'
            , total_duration = '0.081'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:12:40'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556003'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:12:41], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__3_11_12_40_1715857960.json', 'tr/16_05_2024/response_availability_qtech_agent__3_11_12_40_1715857960.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_11_12_40_1715857960.json', 'tripathonxml', '2024-05-16 11:12:41', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556003');
[05/16/2024 11:12:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:12:40.503'
        , request_start_time = '0.012'
        , parsing_start_time = '0.516'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.028'
        , search_end_time = '0.030'
        , total_duration = '0.629'
        , error_description = ''
        , memory_used = '4229176'
        WHERE id = '139565154';
[05/16/2024 11:12:44], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_12_40_1715857960.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_12_40_1715857960.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_12_40_1715857960.json', 'tripathonxml', '2024-05-16 11:12:44', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556003');
[05/16/2024 11:13:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '704'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:12:40.503'
        , request_start_time = '0.012'
        , parsing_start_time = '4.170'
        , mapping_complete_time = '0.713'
        , mongo_start_time = '3.653'
        , search_end_time = '15.641'
        , total_duration = '23.831'
        , error_description = ''
        , memory_used = '603409704'
        WHERE id = '139565172';
[05/16/2024 11:13:04], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '703',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '24.342',
        merge_duration = '0.256',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.54',
        system_load_5_min = '1.94',
        system_load_15_min = '1.67',
        system_memory_usage = '96.14',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9556003') + '37046576',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9556003';
[05/16/2024 11:14:24], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:14:24' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 11:14:25], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:14:25.551'
            , total_duration = '0.068'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:14:25'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556124'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:14:25], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:14:25.552'
            , total_duration = '0.080'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:14:25'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556124'
            , error_description = ''
            , memory_used = '2663008';
[05/16/2024 11:14:25], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-16 11:14:25.551'
            , total_duration = '0.091'
            , hotel_count = 0
            , source_type = 'tripathonxml'
            , create_date = '2024-05-16 11:14:25'
            , session_id = '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02'
            , agent_logs_id = '9556124'
            , error_description = ''
            , memory_used = '2662944';
[05/16/2024 11:14:26], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__3_11_14_25_1715858065.json', 'tr/16_05_2024/response_availability_qtech_agent__3_11_14_25_1715858065.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_11_14_25_1715858065.json', 'tripathonxml', '2024-05-16 11:14:26', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556124');
[05/16/2024 11:14:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=AE_135012_&city_name=Hatta+%28Dubai%29&country_code=AE&country_name=United+Arab+Emirates&multicityreq=3&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:14:25.552'
        , request_start_time = '0.012'
        , parsing_start_time = '1.020'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.029'
        , search_end_time = '0.031'
        , total_duration = '1.147'
        , error_description = ''
        , memory_used = '4229176'
        WHERE id = '139565830';
[05/16/2024 11:14:29], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_14_25_1715858065.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_14_25_1715858065.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_14_25_1715858065.json', 'tripathonxml', '2024-05-16 11:14:29', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556124');
[05/16/2024 11:14:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '703'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=97001&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&multicityreq=0&ws=1&original_source='
        , http_hit_time = '2024-05-16 11:14:25.552'
        , request_start_time = '0.012'
        , parsing_start_time = '4.138'
        , mapping_complete_time = '0.535'
        , mongo_start_time = '3.543'
        , search_end_time = '22.865'
        , total_duration = '30.929'
        , error_description = ''
        , memory_used = '604193224'
        WHERE id = '139565846';
[05/16/2024 11:14:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '702',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '31.496',
        merge_duration = '0.260',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.17',
        system_load_5_min = '1.68',
        system_load_15_min = '1.61',
        system_memory_usage = '94.69',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9556124') + '36913896',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9556124';
[05/16/2024 11:18:19], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/05/23' , departure_date = '2024/05/24' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:18:19' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=0&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.678'
        , request_start_time = '0.015'
        , parsing_start_time = '0.404'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.023'
        , search_end_time = '0.000'
        , total_duration = '0.515'
        , error_description = ''
        , memory_used = '3218256'
        WHERE id = '139567750';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__7_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__7_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__7_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__0_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__0_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__0_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__2_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__2_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__2_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=AE_135012_&country_code=AE&db_caching=1&web_service=no&&multicityreq=0&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.021'
        , parsing_start_time = '0.536'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.032'
        , search_end_time = '0.036'
        , total_duration = '0.703'
        , error_description = ''
        , memory_used = '4560072'
        WHERE id = '139567752';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__1_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__1_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__1_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=2&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.020'
        , parsing_start_time = '0.586'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.026'
        , search_end_time = '0.000'
        , total_duration = '0.713'
        , error_description = ''
        , memory_used = '3219312'
        WHERE id = '139567753';
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=1&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.677'
        , request_start_time = '0.014'
        , parsing_start_time = '0.597'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.022'
        , search_end_time = '0.020'
        , total_duration = '0.743'
        , error_description = ''
        , memory_used = '3515424'
        WHERE id = '139567754';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__4_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__4_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__4_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__3_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__3_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__3_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=3&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.678'
        , request_start_time = '0.016'
        , parsing_start_time = '0.691'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.025'
        , search_end_time = '0.000'
        , total_duration = '0.821'
        , error_description = ''
        , memory_used = '3219024'
        WHERE id = '139567756';
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '7'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=4&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.020'
        , parsing_start_time = '0.720'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.029'
        , search_end_time = '0.045'
        , total_duration = '0.866'
        , error_description = ''
        , memory_used = '5960944'
        WHERE id = '139567755';
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=7&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.678'
        , request_start_time = '0.018'
        , parsing_start_time = '0.519'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.076'
        , search_end_time = '0.271'
        , total_duration = '0.953'
        , error_description = ''
        , memory_used = '23945032'
        WHERE id = '139567751';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__5_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__5_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__5_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__9_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__9_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__9_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=5&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.677'
        , request_start_time = '0.016'
        , parsing_start_time = '0.847'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.029'
        , search_end_time = '0.046'
        , total_duration = '1.030'
        , error_description = ''
        , memory_used = '6155760'
        WHERE id = '139567757';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__23_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__23_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__23_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__8_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__8_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__8_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '6'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=9&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.022'
        , parsing_start_time = '0.874'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.041'
        , search_end_time = '0.076'
        , total_duration = '1.084'
        , error_description = ''
        , memory_used = '8276264'
        WHERE id = '139567758';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__6_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__6_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__6_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__10_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__10_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__10_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=8&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.677'
        , request_start_time = '0.020'
        , parsing_start_time = '0.947'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.038'
        , search_end_time = '0.068'
        , total_duration = '1.169'
        , error_description = ''
        , memory_used = '6002520'
        WHERE id = '139567760';
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=23&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.678'
        , request_start_time = '0.040'
        , parsing_start_time = '0.943'
        , mapping_complete_time = '0.019'
        , mongo_start_time = '0.043'
        , search_end_time = '0.087'
        , total_duration = '1.188'
        , error_description = ''
        , memory_used = '9969368'
        WHERE id = '139567759';
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=10&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.036'
        , parsing_start_time = '1.009'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.034'
        , search_end_time = '0.061'
        , total_duration = '1.216'
        , error_description = ''
        , memory_used = '6724616'
        WHERE id = '139567762';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__18_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__18_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__18_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__17_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__17_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__17_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '8'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=6&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.025'
        , parsing_start_time = '0.994'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.047'
        , search_end_time = '0.105'
        , total_duration = '1.248'
        , error_description = ''
        , memory_used = '11913968'
        WHERE id = '139567761';
[05/16/2024 11:18:21], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__11_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__11_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__11_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:21', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__16_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__16_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__16_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__14_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__14_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__14_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__12_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__12_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__12_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__15_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__15_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__15_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__21_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__21_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__21_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '15'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=17&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.679'
        , request_start_time = '0.021'
        , parsing_start_time = '1.130'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.083'
        , search_end_time = '0.279'
        , total_duration = '1.601'
        , error_description = ''
        , memory_used = '27857104'
        WHERE id = '139567764';
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__19_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__19_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__19_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__22_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__22_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__22_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__13_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__13_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__13_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=11&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.019'
        , parsing_start_time = '1.143'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.119'
        , search_end_time = '0.584'
        , total_duration = '1.958'
        , error_description = ''
        , memory_used = '50953968'
        WHERE id = '139567765';
[05/16/2024 11:18:22], [file name :-/efsdata/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', 'tr/16_05_2024/request_availability_qtech_agent__20_11_18_20_1715858300.json', 'tr/16_05_2024/response_availability_qtech_agent__20_11_18_20_1715858300.json', 'tr/16_05_2024/response_header_availability_qtech_agent__20_11_18_20_1715858300.json', 'tripathonxml', '2024-05-16 11:18:22', '', '33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02', '9556446');
[05/16/2024 11:18:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=18&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.025'
        , parsing_start_time = '1.138'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.148'
        , search_end_time = '0.753'
        , total_duration = '2.144'
        , error_description = ''
        , memory_used = '67123576'
        WHERE id = '139567763';
[05/16/2024 11:18:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=12&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.018'
        , parsing_start_time = '1.378'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.254'
        , search_end_time = '1.191'
        , total_duration = '2.949'
        , error_description = ''
        , memory_used = '95648560'
        WHERE id = '139567768';
[05/16/2024 11:18:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=13&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.020'
        , parsing_start_time = '1.766'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.236'
        , search_end_time = '1.064'
        , total_duration = '3.192'
        , error_description = ''
        , memory_used = '84183056'
        WHERE id = '139567773';
[05/16/2024 11:18:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=16&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.023'
        , parsing_start_time = '1.337'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.248'
        , search_end_time = '1.556'
        , total_duration = '3.254'
        , error_description = ''
        , memory_used = '106072552'
        WHERE id = '139567766';
[05/16/2024 11:18:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=14&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.678'
        , request_start_time = '0.022'
        , parsing_start_time = '1.376'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.385'
        , search_end_time = '2.091'
        , total_duration = '3.984'
        , error_description = ''
        , memory_used = '143766312'
        WHERE id = '139567767';
[05/16/2024 11:18:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '63'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=21&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.674'
        , request_start_time = '0.023'
        , parsing_start_time = '1.447'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.481'
        , search_end_time = '2.185'
        , total_duration = '4.249'
        , error_description = ''
        , memory_used = '178565360'
        WHERE id = '139567770';
[05/16/2024 11:18:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=15&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.677'
        , request_start_time = '0.023'
        , parsing_start_time = '1.419'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.473'
        , search_end_time = '2.288'
        , total_duration = '4.301'
        , error_description = ''
        , memory_used = '163945056'
        WHERE id = '139567769';
[05/16/2024 11:18:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '60'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=22&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.674'
        , request_start_time = '0.032'
        , parsing_start_time = '1.655'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.375'
        , search_end_time = '2.151'
        , total_duration = '4.313'
        , error_description = ''
        , memory_used = '152530336'
        WHERE id = '139567772';
[05/16/2024 11:18:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '67'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=19&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.674'
        , request_start_time = '0.028'
        , parsing_start_time = '1.578'
        , mapping_complete_time = '0.072'
        , mongo_start_time = '0.427'
        , search_end_time = '2.328'
        , total_duration = '4.456'
        , error_description = ''
        , memory_used = '164148984'
        WHERE id = '139567771';
[05/16/2024 11:18:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '88'
        , request_url = '/call.php?s=tripathonxml&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02&xml_user_id=1284&city_code=97001&country_code=AE&db_caching=1&web_service=no&&multicityreq=20&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-16 11:18:20.675'
        , request_start_time = '0.026'
        , parsing_start_time = '1.983'
        , mapping_complete_time = '0.158'
        , mongo_start_time = '1.010'
        , search_end_time = '4.147'
        , total_duration = '7.289'
        , error_description = ''
        , memory_used = '328629032'
        WHERE id = '139567774';
[05/16/2024 11:18:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '642',
        request_path = '/xml_all.php?userid=1284&sessionid=33dead5378109e43140af09bfa1f6437af14a8754c268344d41932efccdbcb02',
        duration = '7.812',
        merge_duration = '0.252',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.76',
        system_load_5_min = '2.58',
        system_load_15_min = '1.94',
        system_memory_usage = '95.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9556446') + '32382368',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '9556446';
[05/16/2024 11:19:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:19:50',login_attempt=0 where id = '7851';
[05/16/2024 11:19:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-05-16 11:19:50', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:20:07], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/05/30',  departure_date='2024/05/30',  nights='1',  create_date='2024-05-16 :11:20:07',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/16/2024 11:20:07], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_20_07_1715858407.json', 'v1/16_05_2024/response_availability_Viator_test_11_20_07_1715858407.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_20_07_1715858407.json', 'viator', '2024-05-16 11:20:07', '', '', '1766');
[05/16/2024 11:21:03], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/05/30',  departure_date='2024/05/30',  nights='1',  create_date='2024-05-16 :11:21:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/16/2024 11:21:23], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_03_1715858463.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_03_1715858463.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_03_1715858463.json', 'viator', '2024-05-16 11:21:23', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:43], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:43', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:44], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_availability_Viator_test_11_21_23_1715858483_45.json', 'v1/16_05_2024/response_header_availability_Viator_test_11_21_23_1715858483_45.json', 'viator', '2024-05-16 11:21:44', '', '', '1767');
[05/16/2024 11:21:50], [file name :-/efsdata/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/16_05_2024/request_sight_details_Viator_test_11_21_49_1715858509.json', 'v1/16_05_2024/response_sight_details_Viator_test_11_21_49_1715858509.json', 'v1/16_05_2024/response_header_sight_details_Viator_test_11_21_49_1715858509.json', 'viator', '2024-05-16 11:21:50', '', '', '1767');
[05/16/2024 11:21:53], [file name :-/efsdata/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/16_05_2024/request_check_availability_Viator_test_11_21_52_1715858512.json', 'v1/16_05_2024/response_check_availability_Viator_test_11_21_52_1715858512.json', 'v1/16_05_2024/response_header_check_availability_Viator_test_11_21_52_1715858512.json', 'viator', '2024-05-16 11:21:53', '', '', '1767');
[05/16/2024 11:22:23], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1715858543','43.239.53.130');
[05/16/2024 11:22:33], [file name :-/efsdata/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/16_05_2024/request_sight_details_Viator_test_11_22_32_1715858552.json', 'v1/16_05_2024/response_sight_details_Viator_test_11_22_32_1715858552.json', 'v1/16_05_2024/response_header_sight_details_Viator_test_11_22_32_1715858552.json', 'viator', '2024-05-16 11:22:33', '', '', '1767');
[05/16/2024 11:22:34], [file name :-/efsdata/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/16_05_2024/request_sight_details_Viator_test_11_22_33_1715858553.json', 'v1/16_05_2024/response_sight_details_Viator_test_11_22_33_1715858553.json', 'v1/16_05_2024/response_header_sight_details_Viator_test_11_22_33_1715858553.json', 'viator', '2024-05-16 11:22:34', '', '', '1767');
[05/16/2024 11:22:37], [file name :-/efsdata/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/16_05_2024/request_check_availability_Viator_test_11_22_36_1715858556.json', 'v1/16_05_2024/response_check_availability_Viator_test_11_22_36_1715858556.json', 'v1/16_05_2024/response_header_check_availability_Viator_test_11_22_36_1715858556.json', 'viator', '2024-05-16 11:22:37', '', '', '1767');
[05/16/2024 11:28:57], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:28:57',login_attempt=0 where id = '7869';
[05/16/2024 11:28:57], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:28:57', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:29:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/05/17' , departure_date = '2024/05/18' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:29:07' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/16/2024 11:29:09], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1768_1715858948_39.json', 'e1/16_05_2024/response_availability_Viator_1768_1715858948_39.json', 'e1/16_05_2024/response_header_availability_Viator_1768_1715858948_39.json', 'expedia', '2024-05-16 11:29:09', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1768');
[05/16/2024 11:29:10], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1768_1715858948_61.json', 'e1/16_05_2024/response_availability_Viator_1768_1715858948_61.json', 'e1/16_05_2024/response_header_availability_Viator_1768_1715858948_61.json', 'expedia', '2024-05-16 11:29:10', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1768');
[05/16/2024 11:29:10], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1768_1715858948_79.json', 'e1p/16_05_2024/response_availability_Viator_1768_1715858948_79.json', 'e1p/16_05_2024/response_header_availability_Viator_1768_1715858948_79.json', 'expediapackage', '2024-05-16 11:29:10', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1768');
[05/16/2024 11:29:10], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1768_1715858948_68.json', 'e1p/16_05_2024/response_availability_Viator_1768_1715858948_68.json', 'e1p/16_05_2024/response_header_availability_Viator_1768_1715858948_68.json', 'expediapackage', '2024-05-16 11:29:10', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1768');
[05/16/2024 11:29:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:29:08.444'
        , 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.537'
        , error_description = ''
        , memory_used = '125923208'
        WHERE id = '549872';
[05/16/2024 11:29:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:29:08.444'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.027'
        , error_description = ''
        , memory_used = '117136384'
        WHERE id = '549873';
[05/16/2024 11:29:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:29:08.444'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.415'
        , error_description = ''
        , memory_used = '141040248'
        WHERE id = '549875';
[05/16/2024 11:29:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:29:08.444'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.714'
        , error_description = ''
        , memory_used = '130773304'
        WHERE id = '549876';
[05/16/2024 11:30:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '337',
        request_path = '/xml_all.php?userid=7869&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c',
        duration = '107.966',
        merge_duration = '0.690',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '1.38',
        system_load_5_min = '1.79',
        system_load_15_min = '1.83',
        system_memory_usage = '94.36',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1768') + '33630984',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1768';
[05/16/2024 11:33:42], [file name :-/efsdata/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/16_05_2024/request_check_availability_Viator_test_11_33_41_1715859221.json', 'v1/16_05_2024/response_check_availability_Viator_test_11_33_41_1715859221.json', 'v1/16_05_2024/response_header_check_availability_Viator_test_11_33_41_1715859221.json', 'viator', '2024-05-16 11:33:42', '', '', '1767');
[05/16/2024 11:35:43], [file name :-/efsdata/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/16_05_2024/request_sight_details_Viator_test_11_35_42_1715859342.json', 'v1/16_05_2024/response_sight_details_Viator_test_11_35_42_1715859342.json', 'v1/16_05_2024/response_header_sight_details_Viator_test_11_35_42_1715859342.json', 'viator', '2024-05-16 11:35:43', '', '', '1767');
[05/16/2024 11:35:43], [file name :-/efsdata/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/16_05_2024/request_sight_details_Viator_test_11_35_43_1715859343.json', 'v1/16_05_2024/response_sight_details_Viator_test_11_35_43_1715859343.json', 'v1/16_05_2024/response_header_sight_details_Viator_test_11_35_43_1715859343.json', 'viator', '2024-05-16 11:35:43', '', '', '1767');
[05/16/2024 11:36:10], [file name :-/efsdata/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/16_05_2024/request_check_availability_Viator_test_11_36_10_1715859370.json', 'v1/16_05_2024/response_check_availability_Viator_test_11_36_10_1715859370.json', 'v1/16_05_2024/response_header_check_availability_Viator_test_11_36_10_1715859370.json', 'viator', '2024-05-16 11:36:10', '', '', '1767');
[05/16/2024 11:43:34], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:43:34',login_attempt=0 where id = '7869';
[05/16/2024 11:43:34], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:43:34', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:43:55], [file name :-/efsdata/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/16_05_2024/request_check_availability_Viator_test_11_43_55_1715859835.json', 'v1/16_05_2024/response_check_availability_Viator_test_11_43_55_1715859835.json', 'v1/16_05_2024/response_header_check_availability_Viator_test_11_43_55_1715859835.json', 'viator', '2024-05-16 11:43:55', '', '', '1767');
[05/16/2024 11:43:55], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/05/17' , departure_date = '2024/05/18' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:43:55' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/16/2024 11:43:57], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1769_1715859836_30.json', 'e1/16_05_2024/response_availability_Viator_1769_1715859836_30.json', 'e1/16_05_2024/response_header_availability_Viator_1769_1715859836_30.json', 'expedia', '2024-05-16 11:43:57', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1769');
[05/16/2024 11:43:57], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1769_1715859836_94.json', 'e1/16_05_2024/response_availability_Viator_1769_1715859836_94.json', 'e1/16_05_2024/response_header_availability_Viator_1769_1715859836_94.json', 'expedia', '2024-05-16 11:43:57', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1769');
[05/16/2024 11:43:58], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1769_1715859836_92.json', 'e1p/16_05_2024/response_availability_Viator_1769_1715859836_92.json', 'e1p/16_05_2024/response_header_availability_Viator_1769_1715859836_92.json', 'expediapackage', '2024-05-16 11:43:58', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1769');
[05/16/2024 11:43:58], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1769_1715859836_66.json', 'e1p/16_05_2024/response_availability_Viator_1769_1715859836_66.json', 'e1p/16_05_2024/response_header_availability_Viator_1769_1715859836_66.json', 'expediapackage', '2024-05-16 11:43:58', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1769');
[05/16/2024 11:43:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:43:56.670'
        , 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.203'
        , error_description = ''
        , memory_used = '117211968'
        WHERE id = '549884';
[05/16/2024 11:43:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:43:56.671'
        , 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.220'
        , error_description = ''
        , memory_used = '125896616'
        WHERE id = '549883';
[05/16/2024 11:43:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:43:56.670'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.050'
        , error_description = ''
        , memory_used = '141039784'
        WHERE id = '549886';
[05/16/2024 11:43:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:43:56.671'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.241'
        , error_description = ''
        , memory_used = '130801808'
        WHERE id = '549887';
[05/16/2024 11:45:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '337',
        request_path = '/xml_all.php?userid=7869&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c',
        duration = '107.230',
        merge_duration = '0.609',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.59',
        system_load_5_min = '1.17',
        system_load_15_min = '1.58',
        system_memory_usage = '93.22',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1769') + '27423608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1769';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '80' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:20], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:21], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:21], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:21], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/16/2024 11:47:21], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-16 11:47:21',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 80 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7869 ## supplier_id- 80 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7869 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7869 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/16/2024 11:47:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:47:24',login_attempt=0 where id = '7869';
[05/16/2024 11:47:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:47:24', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:47:38], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/05/17' , departure_date = '2024/05/18' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:47:38' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/16/2024 11:47:40], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1770_1715860059_28.json', 'e1/16_05_2024/response_availability_Viator_1770_1715860059_28.json', 'e1/16_05_2024/response_header_availability_Viator_1770_1715860059_28.json', 'expedia', '2024-05-16 11:47:40', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1770');
[05/16/2024 11:47:40], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1770_1715860059_32.json', 'e1/16_05_2024/response_availability_Viator_1770_1715860059_32.json', 'e1/16_05_2024/response_header_availability_Viator_1770_1715860059_32.json', 'expedia', '2024-05-16 11:47:40', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1770');
[05/16/2024 11:47:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1770_1715860059_60.json', 'e1p/16_05_2024/response_availability_Viator_1770_1715860059_60.json', 'e1p/16_05_2024/response_header_availability_Viator_1770_1715860059_60.json', 'expediapackage', '2024-05-16 11:47:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1770');
[05/16/2024 11:47:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1770_1715860059_77.json', 'e1p/16_05_2024/response_availability_Viator_1770_1715860059_77.json', 'e1p/16_05_2024/response_header_availability_Viator_1770_1715860059_77.json', 'expediapackage', '2024-05-16 11:47:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1770');
[05/16/2024 11:47:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:47:39.533'
        , 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.293'
        , error_description = ''
        , memory_used = '126016296'
        WHERE id = '549890';
[05/16/2024 11:47:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:47:39.533'
        , 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.543'
        , error_description = ''
        , memory_used = '117160360'
        WHERE id = '549891';
[05/16/2024 11:47:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:47:39.532'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.004'
        , error_description = ''
        , memory_used = '130875624'
        WHERE id = '549892';
[05/16/2024 11:47:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:47:39.533'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.317'
        , error_description = ''
        , memory_used = '141034056'
        WHERE id = '549893';
[05/16/2024 11:49:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '337',
        request_path = '/xml_all.php?userid=7869&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c',
        duration = '106.858',
        merge_duration = '0.608',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '0.86',
        system_load_5_min = '0.98',
        system_load_15_min = '1.41',
        system_memory_usage = '93.82',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1770') + '30322264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1770';
[05/16/2024 11:49:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:49:26',login_attempt=0 where id = '7869';
[05/16/2024 11:49:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:49:26', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:49:27], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:49:27',login_attempt=0 where id = '7869';
[05/16/2024 11:49:27], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:49:27', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:49:39], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/05/17' , departure_date = '2024/05/18' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-16 11:49:39' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/16/2024 11:49:41], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1771_1715860180_2.json', 'e1/16_05_2024/response_availability_Viator_1771_1715860180_2.json', 'e1/16_05_2024/response_header_availability_Viator_1771_1715860180_2.json', 'expedia', '2024-05-16 11:49:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1771');
[05/16/2024 11:49:41], [file name :-/efsdata/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/16_05_2024/request_availability_Viator_1771_1715860180_89.json', 'e1/16_05_2024/response_availability_Viator_1771_1715860180_89.json', 'e1/16_05_2024/response_header_availability_Viator_1771_1715860180_89.json', 'expedia', '2024-05-16 11:49:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1771');
[05/16/2024 11:49:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1771_1715860180_2.json', 'e1p/16_05_2024/response_availability_Viator_1771_1715860180_2.json', 'e1p/16_05_2024/response_header_availability_Viator_1771_1715860180_2.json', 'expediapackage', '2024-05-16 11:49:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1771');
[05/16/2024 11:49:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/16_05_2024/request_availability_Viator_1771_1715860180_33.json', 'e1p/16_05_2024/response_availability_Viator_1771_1715860180_33.json', 'e1p/16_05_2024/response_header_availability_Viator_1771_1715860180_33.json', 'expediapackage', '2024-05-16 11:49:41', '', 'ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c', '1771');
[05/16/2024 11:49:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:49:39.999'
        , 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.355'
        , error_description = ''
        , memory_used = '117202016'
        WHERE id = '549896';
[05/16/2024 11:49:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expedia&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:49:39.999'
        , 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.721'
        , error_description = ''
        , memory_used = '125793032'
        WHERE id = '549897';
[05/16/2024 11:49:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '190'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=0&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:49:39.999'
        , 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.875'
        , error_description = ''
        , memory_used = '141028952'
        WHERE id = '549898';
[05/16/2024 11:49:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '147'
        , request_url = '/call.php?s=expediapackage&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c&xml_user_id=7869&db_caching=1&erequest=1&total_request=2&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F124.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
        , http_hit_time = '2024-05-16 11:49:39.999'
        , request_start_time = '0.000'
        , parsing_start_time = '0.000'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '3.114'
        , error_description = ''
        , memory_used = '131251352'
        WHERE id = '549899';
[05/16/2024 11:51:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '337',
        request_path = '/xml_all.php?userid=7869&sessionid=ff60c11f4ecae8a6d5604b9f5e7dd3d16e2eea09468c44c2f83800433cd7ae0c',
        duration = '106.969',
        merge_duration = '0.651',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '1.42',
        system_load_5_min = '1.10',
        system_load_15_min = '1.40',
        system_memory_usage = '93.94',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1771') + '28335304',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1771';
[05/16/2024 11:53:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:53:40',login_attempt=0 where id = '7869';
[05/16/2024 11:53:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:53:40', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:54:23], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:54:23',login_attempt=0 where id = '7869';
[05/16/2024 11:54:23], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:54:23', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:55:21], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:55:21',login_attempt=0 where id = '7869';
[05/16/2024 11:55:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:55:22', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:55:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:55:51',login_attempt=0 where id = '7869';
[05/16/2024 11:55:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:55:51', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:56:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:56:24',login_attempt=0 where id = '7869';
[05/16/2024 11:56:24], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:56:24', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:57:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:57:01',login_attempt=0 where id = '7869';
[05/16/2024 11:57:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:57:01', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:58:15], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:58:15',login_attempt=0 where id = '7869';
[05/16/2024 11:58:15], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:58:15', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:58:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:58:30',login_attempt=0 where id = '7869';
[05/16/2024 11:58:30], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:58:30', ip = '43.239.53.130', action = 'Login' ;
[05/16/2024 11:59:02], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-16 11:59:02',login_attempt=0 where id = '7869';
[05/16/2024 11:59:02], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-05-16 11:59:02', ip = '43.239.53.130', action = 'Login' ;
