[12/23/2024 11:37:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-23 11:37:58',login_attempt=0 where id = '1089';
[12/23/2024 11:37:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-12-23 11:37:58', ip = '43.239.53.130', action = 'Login' ;
[12/23/2024 11:38:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , 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 = '138' , service_type = 'hotel' , arrival_date = '2024/12/24' , departure_date = '2024/12/25' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-23 11:38:10' , 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' ;
[12/23/2024 11:38:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892320241211380988261075505', session_id='10892320241211380988261075505', Collection_create_time='2024-12-23 11:38:10';
[12/23/2024 11:38:11], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_36_6.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_36_6.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_36_6.json', 'hotelbeds', '2024-12-23 11:38:11', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_36_6.json');
[12/23/2024 11:38:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.824'
        , request_start_time = '0.065'
        , parsing_start_time = '1.068'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.087'
        , search_end_time = '0.164'
        , total_duration = '1.416'
        , error_description = ''
        , memory_used = '15241376'
        WHERE id = '208955729';
[12/23/2024 11:38:12], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_70_2.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_70_2.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_70_2.json', 'hotelbeds', '2024-12-23 11:38:12', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_70_2.json');
[12/23/2024 11:38:12], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_65_1.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_65_1.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_65_1.json', 'hotelbeds', '2024-12-23 11:38:12', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_65_1.json');
[12/23/2024 11:38:13], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_8_3.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_8_3.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_8_3.json', 'hotelbeds', '2024-12-23 11:38:13', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_8_3.json');
[12/23/2024 11:38:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.812'
        , request_start_time = '0.080'
        , parsing_start_time = '1.618'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.165'
        , search_end_time = '0.325'
        , total_duration = '2.235'
        , error_description = ''
        , memory_used = '29797032'
        WHERE id = '208955758';
[12/23/2024 11:38:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.809'
        , request_start_time = '0.074'
        , parsing_start_time = '1.823'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.155'
        , search_end_time = '0.300'
        , total_duration = '2.393'
        , error_description = ''
        , memory_used = '27440968'
        WHERE id = '208955764';
[12/23/2024 11:38:13], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_91_0.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_91_0.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_91_0.json', 'hotelbeds', '2024-12-23 11:38:13', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_91_0.json');
[12/23/2024 11:38:13], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_33_4.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_33_4.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_33_4.json', 'hotelbeds', '2024-12-23 11:38:13', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_33_4.json');
[12/23/2024 11:38:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.815'
        , request_start_time = '0.074'
        , parsing_start_time = '2.069'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.148'
        , search_end_time = '0.315'
        , total_duration = '2.654'
        , error_description = ''
        , memory_used = '28438040'
        WHERE id = '208955770';
[12/23/2024 11:38:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.807'
        , request_start_time = '0.075'
        , parsing_start_time = '2.281'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.152'
        , search_end_time = '0.320'
        , total_duration = '2.871'
        , error_description = ''
        , memory_used = '27393528'
        WHERE id = '208955776';
[12/23/2024 11:38:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.818'
        , request_start_time = '0.147'
        , parsing_start_time = '2.254'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.198'
        , search_end_time = '0.405'
        , total_duration = '3.050'
        , error_description = ''
        , memory_used = '35519888'
        WHERE id = '208955777';
[12/23/2024 11:38:13], [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/23_12_2024/request_availability_Test_DoNotUse_11_38_10_1734953890_34_5.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_34_5.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_38_10_1734953890_34_5.json', 'hotelbeds', '2024-12-23 11:38:13', '\n', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_38_10_1734953890_34_5.json');
[12/23/2024 11:38:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211380988261075505&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:38:10.822'
        , request_start_time = '0.068'
        , parsing_start_time = '2.944'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.194'
        , search_end_time = '0.450'
        , total_duration = '3.701'
        , error_description = ''
        , memory_used = '39945352'
        WHERE id = '208955800';
[12/23/2024 11:38: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,file_path) VALUE ('', 'AVAILABILITY', 'r2/23_12_2024/request_availability__11_38_10_Test_DoNotUse_1734953890_.xml', 'r2/23_12_2024/response_availability__11_38_10_Test_DoNotUse_1734953890_.xml', 'r2/23_12_2024/response_header_availability__11_38_10_Test_DoNotUse_1734953890_.xml', 'roomsxml', '2024-12-23 11:38:22', '', '10892320241211380988261075505', '18630574', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/23_12_2024/response_availability__11_38_10_Test_DoNotUse_1734953890_.xml');
[12/23/2024 11:38:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '474'
        , request_url = '/call.php?s=roomsxml&sessionid=10892320241211380988261075505&xml_user_id=1089&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 = '2024-12-23 11:38:10.808'
        , request_start_time = '0.077'
        , parsing_start_time = '11.694'
        , mapping_complete_time = '0.733'
        , mongo_start_time = '1.266'
        , search_end_time = '1.063'
        , total_duration = '14.187'
        , error_description = ''
        , memory_used = '124336160'
        WHERE id = '208955885';
[12/23/2024 11:38:41], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1159',
        request_path = '/xml_all.php?userid=1089&sessionid=10892320241211380988261075505',
        duration = '31.250',
        merge_duration = '4.947',
        assigned_supplier_count = '20',
        searched_supplier_count = '3',
        system_load_1_min = '0.46',
        system_load_5_min = '0.45',
        system_load_15_min = '0.76',
        system_memory_usage = '49.75',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18630574') + '43188440',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18630574';
[12/23/2024 11:41:46], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-23 11:41:46',login_attempt=0 where id = '1089';
[12/23/2024 11:41:46], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-12-23 11:41:46', ip = '43.239.53.130', action = 'Login' ;
[12/23/2024 11:42:02], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , 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 = '138' , service_type = 'hotel' , arrival_date = '2025/01/01' , departure_date = '2025/01/02' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-23 11:42:02' , 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' ;
[12/23/2024 11:42:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892320241211420223476574856', session_id='10892320241211420223476574856', Collection_create_time='2024-12-23 11:42:03';
[12/23/2024 11:42: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_98_6.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_98_6.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_98_6.json', 'hotelbeds', '2024-12-23 11:42:04', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_98_6.json');
[12/23/2024 11:42: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_31_1.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_31_1.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_31_1.json', 'hotelbeds', '2024-12-23 11:42:04', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_31_1.json');
[12/23/2024 11:42:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.181'
        , request_start_time = '0.017'
        , parsing_start_time = '1.035'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.100'
        , search_end_time = '0.031'
        , total_duration = '1.213'
        , error_description = ''
        , memory_used = '19224064'
        WHERE id = '208957387';
[12/23/2024 11:42:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '70'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.168'
        , request_start_time = '0.021'
        , parsing_start_time = '1.096'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.160'
        , search_end_time = '0.044'
        , total_duration = '1.356'
        , error_description = ''
        , memory_used = '28643960'
        WHERE id = '208957388';
[12/23/2024 11:42: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_59_4.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_59_4.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_59_4.json', 'hotelbeds', '2024-12-23 11:42:04', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_59_4.json');
[12/23/2024 11:42: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_92_2.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_92_2.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_92_2.json', 'hotelbeds', '2024-12-23 11:42:04', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_92_2.json');
[12/23/2024 11:42:04], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '72'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.174'
        , request_start_time = '0.017'
        , parsing_start_time = '1.548'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.149'
        , search_end_time = '0.039'
        , total_duration = '1.789'
        , error_description = ''
        , memory_used = '28711288'
        WHERE id = '208957399';
[12/23/2024 11:42:05], [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/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_51_0.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_51_0.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_51_0.json', 'hotelbeds', '2024-12-23 11:42:05', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_51_0.json');
[12/23/2024 11:42:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.170'
        , request_start_time = '0.018'
        , parsing_start_time = '1.664'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.232'
        , search_end_time = '0.048'
        , total_duration = '2.002'
        , error_description = ''
        , memory_used = '33806880'
        WHERE id = '208957417';
[12/23/2024 11:42:05], [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/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_36_5.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_36_5.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_36_5.json', 'hotelbeds', '2024-12-23 11:42:05', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_36_5.json');
[12/23/2024 11:42:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.166'
        , request_start_time = '0.022'
        , parsing_start_time = '1.922'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.165'
        , search_end_time = '0.042'
        , total_duration = '2.189'
        , error_description = ''
        , memory_used = '32797456'
        WHERE id = '208957485';
[12/23/2024 11:42:05], [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/23_12_2024/request_availability_Test_DoNotUse_11_42_03_1734954123_13_3.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_13_3.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_11_42_03_1734954123_13_3.json', 'hotelbeds', '2024-12-23 11:42:05', '\n', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_11_42_03_1734954123_13_3.json');
[12/23/2024 11:42:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '71'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.177'
        , request_start_time = '0.018'
        , parsing_start_time = '2.024'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.171'
        , search_end_time = '0.044'
        , total_duration = '2.293'
        , error_description = ''
        , memory_used = '31383392'
        WHERE id = '208957500';
[12/23/2024 11:42:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241211420223476574856&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 11:42:03.172'
        , request_start_time = '0.015'
        , parsing_start_time = '2.214'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.253'
        , search_end_time = '0.048'
        , total_duration = '2.572'
        , error_description = ''
        , memory_used = '33498056'
        WHERE id = '208957508';
[12/23/2024 11:42:17], [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/23_12_2024/request_availability__11_42_03_Test_DoNotUse_1734954123_.xml', 'r2/23_12_2024/response_availability__11_42_03_Test_DoNotUse_1734954123_.xml', 'r2/23_12_2024/response_header_availability__11_42_03_Test_DoNotUse_1734954123_.xml', 'roomsxml', '2024-12-23 11:42:17', '', '10892320241211420223476574856', '18630861', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/23_12_2024/response_availability__11_42_03_Test_DoNotUse_1734954123_.xml');
[12/23/2024 11:42:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '199'
        , request_url = '/call.php?s=roomsxml&sessionid=10892320241211420223476574856&xml_user_id=1089&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 = '2024-12-23 11:42:03.163'
        , request_start_time = '0.025'
        , parsing_start_time = '14.467'
        , mapping_complete_time = '0.202'
        , mongo_start_time = '0.401'
        , search_end_time = '0.067'
        , total_duration = '15.003'
        , error_description = ''
        , memory_used = '43363216'
        WHERE id = '208957691';
[12/23/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1045',
        request_path = '/xml_all.php?userid=1089&sessionid=10892320241211420223476574856',
        duration = '34.591',
        merge_duration = '4.308',
        assigned_supplier_count = '20',
        searched_supplier_count = '3',
        system_load_1_min = '0.47',
        system_load_5_min = '0.40',
        system_load_15_min = '0.66',
        system_memory_usage = '49.59',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18630861') + '34068392',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18630861';
