[09/23/2024 08:00:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 08:00:10';
[09/23/2024 08:02:11], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240907481962723868949', session_id='24062320240907481962723868949', Collection_create_time='2024-09-23 08:02:11';
[09/23/2024 08:04:53], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-23 08:04:53',login_attempt=0 where id = '2406';
[09/23/2024 08:04:53], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-09-23 08:04:53', ip = '43.239.53.130', action = 'Login' ;
[09/23/2024 08:05:03], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , 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 = '106' , service_type = 'hotel' , arrival_date = '2024/09/30' , departure_date = '2024/10/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 08:05:03' , 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' ;
[09/23/2024 08:05:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240908050390212966549', session_id='24062320240908050390212966549', Collection_create_time='2024-09-23 08:05:03';
[09/23/2024 08:05: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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_172707870510.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870510.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_172707870510.json', 'ratehawk', '2024-09-23 08:05:11', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870510.json');
[09/23/2024 08:05:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.509'
        , request_start_time = '0.693'
        , parsing_start_time = '6.405'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.053'
        , search_end_time = '0.073'
        , total_duration = '7.278'
        , error_description = ''
        , memory_used = '16273640'
        WHERE id = '187112060';
[09/23/2024 08:05:14], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787057.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787057.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787057.json', 'ratehawk', '2024-09-23 08:05:14', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787057.json');
[09/23/2024 08:05:14], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787058.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787058.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787058.json', 'ratehawk', '2024-09-23 08:05:14', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787058.json');
[09/23/2024 08:05:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.503'
        , request_start_time = '0.715'
        , parsing_start_time = '8.797'
        , mapping_complete_time = '0.097'
        , mongo_start_time = '0.158'
        , search_end_time = '0.111'
        , total_duration = '9.853'
        , error_description = ''
        , memory_used = '67994968'
        WHERE id = '187112075';
[09/23/2024 08:05:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '32'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.504'
        , request_start_time = '0.571'
        , parsing_start_time = '9.110'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.129'
        , search_end_time = '0.071'
        , total_duration = '9.943'
        , error_description = ''
        , memory_used = '55096816'
        WHERE id = '187112077';
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787059.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787059.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787059.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787059.json');
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_172707870512.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870512.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_172707870512.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870512.json');
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_172707870511.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870511.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_172707870511.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_172707870511.json');
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787055.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787055.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787055.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787055.json');
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.506'
        , request_start_time = '0.511'
        , parsing_start_time = '9.976'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.134'
        , search_end_time = '0.079'
        , total_duration = '10.760'
        , error_description = ''
        , memory_used = '53830072'
        WHERE id = '187112084';
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.512'
        , request_start_time = '0.568'
        , parsing_start_time = '10.030'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.070'
        , search_end_time = '0.047'
        , total_duration = '10.770'
        , error_description = ''
        , memory_used = '29284208'
        WHERE id = '187112086';
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.515'
        , request_start_time = '0.596'
        , parsing_start_time = '9.958'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.103'
        , search_end_time = '0.072'
        , total_duration = '10.785'
        , error_description = ''
        , memory_used = '39894520'
        WHERE id = '187112085';
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.496'
        , request_start_time = '0.537'
        , parsing_start_time = '10.115'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.089'
        , search_end_time = '0.069'
        , total_duration = '10.880'
        , error_description = ''
        , memory_used = '42448720'
        WHERE id = '187112087';
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787056.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787056.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787056.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787056.json');
[09/23/2024 08:05:15], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_05_17270787053.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787053.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_05_17270787053.json', 'ratehawk', '2024-09-23 08:05:15', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_05_17270787053.json');
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.498'
        , request_start_time = '0.549'
        , parsing_start_time = '10.340'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.147'
        , search_end_time = '0.096'
        , total_duration = '11.208'
        , error_description = ''
        , memory_used = '57921040'
        WHERE id = '187112090';
[09/23/2024 08:05:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.491'
        , request_start_time = '0.617'
        , parsing_start_time = '10.316'
        , mapping_complete_time = '0.131'
        , mongo_start_time = '0.212'
        , search_end_time = '0.120'
        , total_duration = '11.351'
        , error_description = ''
        , memory_used = '79814816'
        WHERE id = '187112091';
[09/23/2024 08:05:19], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_04_17270787044.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787044.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_04_17270787044.json', 'ratehawk', '2024-09-23 08:05:19', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787044.json');
[09/23/2024 08:05:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.494'
        , request_start_time = '0.332'
        , parsing_start_time = '14.180'
        , mapping_complete_time = '0.108'
        , mongo_start_time = '0.178'
        , search_end_time = '0.095'
        , total_duration = '14.863'
        , error_description = ''
        , memory_used = '76642696'
        WHERE id = '187112114';
[09/23/2024 08:05:19], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_04_17270787042.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787042.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_04_17270787042.json', 'ratehawk', '2024-09-23 08:05:19', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787042.json');
[09/23/2024 08:05:19], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_04_17270787040.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787040.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_04_17270787040.json', 'ratehawk', '2024-09-23 08:05:19', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787040.json');
[09/23/2024 08:05:19], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_04_17270787041.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787041.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_04_17270787041.json', 'ratehawk', '2024-09-23 08:05:19', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_04_17270787041.json');
[09/23/2024 08:05:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.487'
        , request_start_time = '0.227'
        , parsing_start_time = '14.619'
        , mapping_complete_time = '0.146'
        , mongo_start_time = '0.288'
        , search_end_time = '0.157'
        , total_duration = '15.384'
        , error_description = ''
        , memory_used = '106252200'
        WHERE id = '187112116';
[09/23/2024 08:05:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '105'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.488'
        , request_start_time = '0.323'
        , parsing_start_time = '14.489'
        , mapping_complete_time = '0.262'
        , mongo_start_time = '0.567'
        , search_end_time = '0.268'
        , total_duration = '15.749'
        , error_description = ''
        , memory_used = '193061160'
        WHERE id = '187112115';
[09/23/2024 08:05:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '140'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908050390212966549&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:05:04.487'
        , request_start_time = '0.145'
        , parsing_start_time = '14.868'
        , mapping_complete_time = '0.320'
        , mongo_start_time = '0.692'
        , search_end_time = '0.400'
        , total_duration = '16.222'
        , error_description = ''
        , memory_used = '222345752'
        WHERE id = '187112121';
[09/23/2024 08:05:21], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '619',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240908050390212966549',
        duration = '18.053',
        merge_duration = '0.060',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '12.12',
        system_load_5_min = '8.71',
        system_load_15_min = '7.07',
        system_memory_usage = '33.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16467041') + '6639736',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16467041';
[09/23/2024 08:05:37], [file name :-/efsdata/otrams/public_html/beta/method_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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_05_34_1727078734.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_05_34_1727078734.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_05_34_1727078734.json', 'ratehawk', '2024-09-23 08:05:37', '', '24062320240908050390212966549', '16467041', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_05_34_1727078734.json');
[09/23/2024 08:06:24], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , 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 = '106' , service_type = 'hotel' , arrival_date = '2024/09/30' , departure_date = '2024/10/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-23 08:06:24' , 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' ;
[09/23/2024 08:06:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240908062440171645820', session_id='24062320240908062440171645820', Collection_create_time='2024-09-23 08:06:24';
[09/23/2024 08:06:34], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_17270787869.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787869.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_17270787869.json', 'ratehawk', '2024-09-23 08:06:34', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787869.json');
[09/23/2024 08:06:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.546'
        , request_start_time = '0.510'
        , parsing_start_time = '8.159'
        , mapping_complete_time = '0.231'
        , mongo_start_time = '0.290'
        , search_end_time = '0.514'
        , total_duration = '9.526'
        , error_description = ''
        , memory_used = '54144552'
        WHERE id = '187112955';
[09/23/2024 08:06:35], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_17270787868.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787868.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_17270787868.json', 'ratehawk', '2024-09-23 08:06:35', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787868.json');
[09/23/2024 08:06:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '32'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.534'
        , request_start_time = '0.635'
        , parsing_start_time = '8.981'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.184'
        , search_end_time = '0.073'
        , total_duration = '9.928'
        , error_description = ''
        , memory_used = '55063296'
        WHERE id = '187112957';
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_17270787863.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787863.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_17270787863.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787863.json');
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_172707878610.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878610.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_172707878610.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878610.json');
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_17270787867.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787867.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_17270787867.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787867.json');
[09/23/2024 08:06:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.543'
        , request_start_time = '0.572'
        , parsing_start_time = '15.206'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.052'
        , search_end_time = '0.054'
        , total_duration = '15.930'
        , error_description = ''
        , memory_used = '16273536'
        WHERE id = '187113127';
[09/23/2024 08:06:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.520'
        , request_start_time = '0.461'
        , parsing_start_time = '15.188'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.199'
        , search_end_time = '0.136'
        , total_duration = '16.110'
        , error_description = ''
        , memory_used = '79814816'
        WHERE id = '187113125';
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_25_17270787856.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787856.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_25_17270787856.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787856.json');
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_17270787865.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787865.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_17270787865.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_17270787865.json');
[09/23/2024 08:06:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.535'
        , request_start_time = '0.489'
        , parsing_start_time = '15.359'
        , mapping_complete_time = '0.096'
        , mongo_start_time = '0.158'
        , search_end_time = '0.121'
        , total_duration = '16.184'
        , error_description = ''
        , memory_used = '68013824'
        WHERE id = '187113129';
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_172707878612.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878612.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_172707878612.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878612.json');
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_26_172707878611.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878611.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_26_172707878611.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_26_172707878611.json');
[09/23/2024 08:06:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.529'
        , request_start_time = '0.512'
        , parsing_start_time = '15.627'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.101'
        , search_end_time = '0.076'
        , total_duration = '16.366'
        , error_description = ''
        , memory_used = '42477424'
        WHERE id = '187113131';
[09/23/2024 08:06: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,file_path) VALUE ('', 'AVAILABILITY', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_25_17270787854.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787854.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_25_17270787854.json', 'ratehawk', '2024-09-23 08:06:41', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787854.json');
[09/23/2024 08:06:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.529'
        , request_start_time = '0.397'
        , parsing_start_time = '15.712'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.147'
        , search_end_time = '0.144'
        , total_duration = '16.453'
        , error_description = ''
        , memory_used = '57342912'
        WHERE id = '187113130';
[09/23/2024 08:06:42], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_25_17270787850.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787850.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_25_17270787850.json', 'ratehawk', '2024-09-23 08:06:42', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787850.json');
[09/23/2024 08:06:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.544'
        , request_start_time = '0.735'
        , parsing_start_time = '15.563'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.077'
        , search_end_time = '0.062'
        , total_duration = '16.483'
        , error_description = ''
        , memory_used = '29474944'
        WHERE id = '187113134';
[09/23/2024 08:06:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.547'
        , request_start_time = '0.649'
        , parsing_start_time = '15.580'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.112'
        , search_end_time = '0.104'
        , total_duration = '16.495'
        , error_description = ''
        , memory_used = '40250728'
        WHERE id = '187113133';
[09/23/2024 08:06:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.522'
        , request_start_time = '0.423'
        , parsing_start_time = '15.910'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '0.192'
        , search_end_time = '0.093'
        , total_duration = '16.674'
        , error_description = ''
        , memory_used = '77927504'
        WHERE id = '187113135';
[09/23/2024 08:06:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.513'
        , request_start_time = '0.116'
        , parsing_start_time = '16.346'
        , mapping_complete_time = '0.157'
        , mongo_start_time = '0.298'
        , search_end_time = '0.182'
        , total_duration = '17.002'
        , error_description = ''
        , memory_used = '106891808'
        WHERE id = '187113137';
[09/23/2024 08:06:43], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_25_17270787852.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787852.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_25_17270787852.json', 'ratehawk', '2024-09-23 08:06:43', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787852.json');
[09/23/2024 08:06:43], [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', 'rh/23_09_2024/request_availability_Qtech_pranali_08_06_25_17270787851.json', 'rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787851.json', 'rh/23_09_2024/response_header_availability_Qtech_pranali_08_06_25_17270787851.json', 'ratehawk', '2024-09-23 08:06:43', '', '24062320240908062440171645820', '16467114', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/23_09_2024/response_availability_Qtech_pranali_08_06_25_17270787851.json');
[09/23/2024 08:06:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '105'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.520'
        , request_start_time = '0.254'
        , parsing_start_time = '17.205'
        , mapping_complete_time = '0.271'
        , mongo_start_time = '0.574'
        , search_end_time = '0.265'
        , total_duration = '18.374'
        , error_description = ''
        , memory_used = '194110008'
        WHERE id = '187113140';
[09/23/2024 08:06:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '140'
        , request_url = '/call.php?s=ratehawk&sessionid=24062320240908062440171645820&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-23 08:06:25.515'
        , request_start_time = '0.127'
        , parsing_start_time = '17.983'
        , mapping_complete_time = '0.307'
        , mongo_start_time = '0.668'
        , search_end_time = '0.370'
        , total_duration = '19.233'
        , error_description = ''
        , memory_used = '221598872'
        WHERE id = '187113142';
[09/23/2024 08:06:46], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '619',
        request_path = '/xml_all.php?userid=2406&sessionid=24062320240908062440171645820',
        duration = '21.196',
        merge_duration = '0.063',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '12.06',
        system_load_5_min = '8.98',
        system_load_15_min = '7.26',
        system_memory_usage = '36.46',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16467114') + '6272336',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16467114';
[09/23/2024 08:06:46], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062320240908062440171645820', session_id='24062320240908062440171645820', Collection_create_time='2024-09-23 08:06:46';
