[03/26/2025 10:54:46], [file name :-/efsdata/otrams/public_html/beta/google_auth_ontms.php],UPDATE psa_users SET auth_check='1' where id='supriya';
[03/26/2025 10:55:08], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-03-26 10:55:08',login_attempt=0 where id = '2633';
[03/26/2025 10:55:08], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_test_2025', user_type = 'A', branch_id = '26', login_datetime = '2025-03-26 10:55:08', ip = '103.104.226.130', action = 'Login' ;
[03/26/2025 10:55:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/04/04' , departure_date = '2025/04/05' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-03-26 10:55:35' , 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' ;
[03/26/2025 10:55:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26332620250310553590879949928', session_id='26332620250310553590879949928', Collection_create_time='2025-03-26 10:55:36';
[03/26/2025 10:55:38], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_99_6.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_99_6.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_99_6.json', 'hotelbeds', '2025-03-26 10:55:38', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_99_6.json');
[03/26/2025 10:55:38], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_98_2.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_98_2.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_98_2.json', 'hotelbeds', '2025-03-26 10:55:38', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_98_2.json');
[03/26/2025 10:55:38], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_17_1.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_17_1.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_17_1.json', 'hotelbeds', '2025-03-26 10:55:38', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_17_1.json');
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.545'
        , request_start_time = '0.024'
        , parsing_start_time = '2.153'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.182'
        , search_end_time = '0.049'
        , total_duration = '2.462'
        , error_description = ''
        , memory_used = '35181368'
        WHERE id = '225977050';
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.537'
        , request_start_time = '0.029'
        , parsing_start_time = '2.164'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.264'
        , search_end_time = '0.065'
        , total_duration = '2.588'
        , error_description = ''
        , memory_used = '54443288'
        WHERE id = '225977058';
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.531'
        , request_start_time = '0.037'
        , parsing_start_time = '2.311'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.204'
        , search_end_time = '0.054'
        , total_duration = '2.665'
        , error_description = ''
        , memory_used = '42612376'
        WHERE id = '225977080';
[03/26/2025 10:55:39], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_92_4.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_92_4.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_92_4.json', 'hotelbeds', '2025-03-26 10:55:39', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_92_4.json');
[03/26/2025 10:55:39], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_53_0.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_53_0.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_53_0.json', 'hotelbeds', '2025-03-26 10:55:39', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_53_0.json');
[03/26/2025 10:55:39], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_99_5.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_99_5.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_99_5.json', 'hotelbeds', '2025-03-26 10:55:39', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_99_5.json');
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.540'
        , request_start_time = '0.023'
        , parsing_start_time = '2.574'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.230'
        , search_end_time = '0.061'
        , total_duration = '2.959'
        , error_description = ''
        , memory_used = '48820552'
        WHERE id = '225977084';
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.531'
        , request_start_time = '0.036'
        , parsing_start_time = '2.633'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.219'
        , search_end_time = '0.058'
        , total_duration = '3.007'
        , error_description = ''
        , memory_used = '46757472'
        WHERE id = '225977086';
[03/26/2025 10:55:39], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_55_36_1742986536_80_3.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_80_3.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_55_36_1742986536_80_3.json', 'hotelbeds', '2025-03-26 10:55:39', '\n', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_55_36_1742986536_80_3.json');
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.542'
        , request_start_time = '0.024'
        , parsing_start_time = '2.675'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.290'
        , search_end_time = '0.067'
        , total_duration = '3.123'
        , error_description = ''
        , memory_used = '56950200'
        WHERE id = '225977088';
[03/26/2025 10:55:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '82'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:55:36.536'
        , request_start_time = '0.030'
        , parsing_start_time = '2.941'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.260'
        , search_end_time = '0.065'
        , total_duration = '3.360'
        , error_description = ''
        , memory_used = '53082960'
        WHERE id = '225977090';
[03/26/2025 10:55:48], [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,file_path) VALUE ('', 'AVAILABILITY', 'r2/26_03_2025/request_availability__10_55_36_qtech_test_2025_1742986536_.xml', 'r2/26_03_2025/response_availability__10_55_36_qtech_test_2025_1742986536_.xml', 'r2/26_03_2025/response_header_availability__10_55_36_qtech_test_2025_1742986536_.xml', 'roomsxml', '2025-03-26 10:55:48', '', '26332620250310553590879949928', '22451948', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/26_03_2025/response_availability__10_55_36_qtech_test_2025_1742986536_.xml');
[03/26/2025 10:55:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '420'
        , request_url = '/call.php?s=roomsxml&sessionid=26332620250310553590879949928&xml_user_id=2633&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2025-03-26 10:55:36.530'
        , request_start_time = '0.048'
        , parsing_start_time = '11.942'
        , mapping_complete_time = '0.730'
        , mongo_start_time = '1.256'
        , search_end_time = '0.206'
        , total_duration = '13.537'
        , error_description = ''
        , memory_used = '120754144'
        WHERE id = '225977300';
[03/26/2025 10:56:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '961',
        request_path = '/xml_all.php?userid=2633&sessionid=26332620250310553590879949928',
        duration = '30.386',
        merge_duration = '0.001',
        assigned_supplier_count = '25',
        searched_supplier_count = '3',
        system_load_1_min = '1.08',
        system_load_5_min = '0.75',
        system_load_15_min = '0.70',
        system_memory_usage = '45.66',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '22451948') + '4221728',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '22451948';
[03/26/2025 10:58:34], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-03-26 10:58:34',login_attempt=0 where id = '2633';
[03/26/2025 10:58:34], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_test_2025', user_type = 'A', branch_id = '26', login_datetime = '2025-03-26 10:58:34', ip = '103.104.226.130', action = 'Login' ;
[03/26/2025 10:58:51], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/04/04' , departure_date = '2025/04/05' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-03-26 10:58:51' , 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' ;
[03/26/2025 10:58:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26332620250310585184921277874', session_id='26332620250310585184921277874', Collection_create_time='2025-03-26 10:58:52';
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_91_6.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_91_6.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_91_6.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_91_6.json');
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_16_2.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_16_2.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_16_2.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_16_2.json');
[03/26/2025 10:58:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.269'
        , request_start_time = '0.045'
        , parsing_start_time = '1.892'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.179'
        , search_end_time = '0.047'
        , total_duration = '2.240'
        , error_description = ''
        , memory_used = '35207968'
        WHERE id = '225978514';
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_100_1.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_100_1.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_100_1.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_100_1.json');
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_54_5.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_54_5.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_54_5.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_54_5.json');
[03/26/2025 10:58:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.257'
        , request_start_time = '0.042'
        , parsing_start_time = '1.978'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.252'
        , search_end_time = '0.064'
        , total_duration = '2.416'
        , error_description = ''
        , memory_used = '54229720'
        WHERE id = '225978519';
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_52_0.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_52_0.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_52_0.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_52_0.json');
[03/26/2025 10:58:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.256'
        , request_start_time = '0.062'
        , parsing_start_time = '2.200'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.215'
        , search_end_time = '0.054'
        , total_duration = '2.604'
        , error_description = ''
        , memory_used = '42211328'
        WHERE id = '225978530';
[03/26/2025 10:58:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.268'
        , request_start_time = '0.043'
        , parsing_start_time = '2.192'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.273'
        , search_end_time = '0.068'
        , total_duration = '2.666'
        , error_description = ''
        , memory_used = '56902528'
        WHERE id = '225978531';
[03/26/2025 10:58:54], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_86_3.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_86_3.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_86_3.json', 'hotelbeds', '2025-03-26 10:58:54', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_86_3.json');
[03/26/2025 10:58:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.253'
        , request_start_time = '0.049'
        , parsing_start_time = '2.420'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.215'
        , search_end_time = '0.061'
        , total_duration = '2.810'
        , error_description = ''
        , memory_used = '46591424'
        WHERE id = '225978540';
[03/26/2025 10:58:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.267'
        , request_start_time = '0.035'
        , parsing_start_time = '2.611'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.083'
        , search_end_time = '0.018'
        , total_duration = '2.819'
        , error_description = ''
        , memory_used = '12201520'
        WHERE id = '225978549';
[03/26/2025 10:58:55], [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,file_path) VALUE ('', 'AVAILABILITY', 'h1/26_03_2025/request_availability_qtech_test_2025_10_58_52_1742986732_66_4.json', 'h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_66_4.json', 'h1/26_03_2025/response_header_availability_qtech_test_2025_10_58_52_1742986732_66_4.json', 'hotelbeds', '2025-03-26 10:58:55', '\n', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/26_03_2025/response_availability_qtech_test_2025_10_58_52_1742986732_66_4.json');
[03/26/2025 10:58:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2025-03-26 10:58:52.267'
        , request_start_time = '0.043'
        , parsing_start_time = '2.732'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.243'
        , search_end_time = '0.059'
        , total_duration = '3.155'
        , error_description = ''
        , memory_used = '48779432'
        WHERE id = '225978555';
[03/26/2025 10:59:04], [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,file_path) VALUE ('', 'AVAILABILITY', 'r2/26_03_2025/request_availability__10_58_52_qtech_test_2025_1742986732_.xml', 'r2/26_03_2025/response_availability__10_58_52_qtech_test_2025_1742986732_.xml', 'r2/26_03_2025/response_header_availability__10_58_52_qtech_test_2025_1742986732_.xml', 'roomsxml', '2025-03-26 10:59:04', '', '26332620250310585184921277874', '22452096', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/26_03_2025/response_availability__10_58_52_qtech_test_2025_1742986732_.xml');
[03/26/2025 10:59:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '436'
        , request_url = '/call.php?s=roomsxml&sessionid=26332620250310585184921277874&xml_user_id=2633&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2025-03-26 10:58:52.252'
        , request_start_time = '0.062'
        , parsing_start_time = '12.319'
        , mapping_complete_time = '0.861'
        , mongo_start_time = '1.418'
        , search_end_time = '0.202'
        , total_duration = '14.107'
        , error_description = ''
        , memory_used = '136279032'
        WHERE id = '225978731';
[03/26/2025 10:59:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '938',
        request_path = '/xml_all.php?userid=2633&sessionid=26332620250310585184921277874',
        duration = '30.306',
        merge_duration = '0.001',
        assigned_supplier_count = '25',
        searched_supplier_count = '3',
        system_load_1_min = '0.85',
        system_load_5_min = '0.80',
        system_load_15_min = '0.73',
        system_memory_usage = '46.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '22452096') + '4221728',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '22452096';
