[11/29/2024 08:07:38], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-11-29 08:07:38',login_attempt=0 where id = '5';
[11/29/2024 08:07:38], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Bawadi', user_type = 'A', branch_id = '1', login_datetime = '2024-11-29 08:07:38', ip = '43.239.53.130', action = 'Login' ;
[11/29/2024 08:08:41], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '5' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'abu dhabi' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/12/17' , departure_date = '2024/12/18' , nights = '1' , nationality = '95' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-11-29 08:08:41' , site_id = '' , country_code = '138' , city_code = '71650' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[11/29/2024 08:08:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_5_52920241108084188085999247', session_id='52920241108084188085999247', Collection_create_time='2024-11-29 08:08:42';
[11/29/2024 08:08: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', 'j2/29_11_2024/request_availability_Bawadi_08_08_43_17328677230.xml', 'j2/29_11_2024/response_availability_Bawadi_08_08_43_17328677230.xml', 'j2/29_11_2024/response_header_availability_Bawadi_08_08_43_17328677230.xml', 'jumbotours', '2024-11-29 08:08:43', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/29_11_2024/response_availability_Bawadi_08_08_43_17328677230.xml');
[11/29/2024 08:08:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.57'
        , request_start_time = '0.020'
        , parsing_start_time = '0.385'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.036'
        , search_end_time = '0.000'
        , total_duration = '0.473'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2043096'
        WHERE id = '204480657';
[11/29/2024 08:08: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', 'd3/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_56_0.xml', 'd3/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_56_0.xml', 'd3/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_56_0.xml', 'darina', '2024-11-29 08:08:43', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/d3/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_56_0.xml');
[11/29/2024 08:08: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', 'h1/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_12_1.json', 'h1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_12_1.json', 'h1/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_12_1.json', 'hotelbeds', '2024-11-29 08:08:43', '\n', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_12_1.json');
[11/29/2024 08:08: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', 't1/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_6980.xml', 't1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_6980.xml', 't1/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_6980.xml', 'travco', '2024-11-29 08:08:43', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_6980.xml');
[11/29/2024 08:08:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '12'
        , request_url = '/call.php?s=travco&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotels_ids=&city_code=AUH&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.90'
        , request_start_time = '0.126'
        , parsing_start_time = '0.619'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.048'
        , search_end_time = '0.014'
        , total_duration = '0.848'
        , error_description = ''
        , memory_used = '2416304'
        WHERE id = '204480660';
[11/29/2024 08:08:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelbeds&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=1&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.85'
        , request_start_time = '0.015'
        , parsing_start_time = '0.627'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.082'
        , search_end_time = '0.101'
        , total_duration = '0.862'
        , error_description = ''
        , memory_used = '7706632'
        WHERE id = '204480659';
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'res/29_11_2024/request_AVAILABILITY_Bawadi_08_08_43_17328677230_865.xml', 'res/29_11_2024/response_AVAILABILITY_Bawadi_08_08_43_17328677230_865.xml', 'res/29_11_2024/response_header_AVAILABILITY_Bawadi_08_08_43_17328677230_865.xml', 'restel', '2024-11-29 08:08:44', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/res/29_11_2024/response_AVAILABILITY_Bawadi_08_08_43_17328677230_865.xml');
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=restel&sessionid=52920241108084188085999247&city_name=SIR+BANI+YAS&province_code=AESIR&city_code=102139-AESIR&country_code=AE&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.47'
        , request_start_time = '0.137'
        , parsing_start_time = '0.901'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.016'
        , search_end_time = '0.007'
        , total_duration = '1.093'
        , error_description = ''
        , memory_used = '2369728'
        WHERE id = '204480661';
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=darina&sessionid=52920241108084188085999247&darina_country=UAE&darina_city=AUH&darina_country_id=12&darina_city_id=56&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.69'
        , request_start_time = '0.141'
        , parsing_start_time = '0.429'
        , mapping_complete_time = '0.114'
        , mongo_start_time = '0.384'
        , search_end_time = '0.128'
        , total_duration = '1.122'
        , error_description = ''
        , memory_used = '20224544'
        WHERE id = '204480658';
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/29_11_2024/request_availability_Bawadi_08_08_43_17328677231.json', 'rh/29_11_2024/response_availability_Bawadi_08_08_43_17328677231.json', 'rh/29_11_2024/response_header_availability_Bawadi_08_08_43_17328677231.json', 'ratehawk', '2024-11-29 08:08:44', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_08_08_43_17328677231.json');
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=52920241108084188085999247&destination_code=453&city_name=Abu+Dhabi&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=1&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.52'
        , request_start_time = '0.012'
        , parsing_start_time = '1.383'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.050'
        , search_end_time = '0.009'
        , total_duration = '1.485'
        , error_description = ''
        , memory_used = '3396648'
        WHERE id = '204480663';
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'tr/29_11_2024/request_availability_Bawadi__0_08_08_43_1732867723.json', 'tr/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json', 'tr/29_11_2024/response_header_availability_Bawadi__0_08_08_43_1732867723.json', 'tripathonxml', '2024-11-29 08:08:44', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/tr/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json');
[11/29/2024 08:08:44], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'be/29_11_2024/request_availability_Bawadi__1_08_08_43_1732867723.json', 'be/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json', 'be/29_11_2024/response_header_availability_Bawadi__1_08_08_43_1732867723.json', 'bedzinn', '2024-11-29 08:08:44', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/be/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json');
[11/29/2024 08:08:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=tripathonxml&sessionid=52920241108084188085999247&xml_user_id=5&city_code=2799&country_code=AE&db_caching=1&web_service=no&&multicityreq=0&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.42'
        , request_start_time = '0.022'
        , parsing_start_time = '1.603'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.175'
        , search_end_time = '0.310'
        , total_duration = '2.151'
        , error_description = ''
        , memory_used = '30703736'
        WHERE id = '204480664';
[11/29/2024 08:08:45], [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', 'tr/29_11_2024/request_availability_Bawadi__1_08_08_43_1732867723.json', 'tr/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json', 'tr/29_11_2024/response_header_availability_Bawadi__1_08_08_43_1732867723.json', 'tripathonxml', '2024-11-29 08:08:45', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/tr/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json');
[11/29/2024 08:08:45], [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/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_52_0.json', 'h1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_52_0.json', 'h1/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_52_0.json', 'hotelbeds', '2024-11-29 08:08:45', '\n', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_52_0.json');
[11/29/2024 08:08:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=bedzinn&sessionid=52920241108084188085999247&xml_user_id=5&city_code=71650&country_code=138&db_caching=1&web_service=no&&multicityreq=1&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.39'
        , request_start_time = '0.023'
        , parsing_start_time = '1.754'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.270'
        , search_end_time = '0.323'
        , total_duration = '2.414'
        , error_description = ''
        , memory_used = '40887808'
        WHERE id = '204480665';
[11/29/2024 08:08:45], [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', 'm1/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_0.json', 'm1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_0.json', 'm1/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_0.json', 'miki', '2024-11-29 08:08:45', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/m1/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_0.json');
[11/29/2024 08:08:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '84'
        , request_url = '/call.php?s=hotelbeds&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.84'
        , request_start_time = '0.018'
        , parsing_start_time = '2.184'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.246'
        , search_end_time = '0.508'
        , total_duration = '3.010'
        , error_description = ''
        , memory_used = '42172760'
        WHERE id = '204480668';
[11/29/2024 08:08:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=tripathonxml&sessionid=52920241108084188085999247&xml_user_id=5&city_code=2799&country_code=AE&db_caching=1&web_service=no&&multicityreq=1&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.44'
        , request_start_time = '0.022'
        , parsing_start_time = '2.239'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.450'
        , search_end_time = '0.559'
        , total_duration = '3.324'
        , error_description = ''
        , memory_used = '68520440'
        WHERE id = '204480667';
[11/29/2024 08:08:46], [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', 'be/29_11_2024/request_availability_Bawadi__0_08_08_43_1732867723.json', 'be/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json', 'be/29_11_2024/response_header_availability_Bawadi__0_08_08_43_1732867723.json', 'bedzinn', '2024-11-29 08:08:46', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/be/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json');
[11/29/2024 08:08:46], [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', 'ebookingcenter/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_46_1.json', 'ebookingcenter/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_46_1.json', 'ebookingcenter/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_46_1.json', 'ebookingcenter', '2024-11-29 08:08:46', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_46_1.json');
[11/29/2024 08:08:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '72'
        , request_url = '/call.php?s=miki&sessionid=52920241108084188085999247&city_code=2799&city_name=Abu+Dhabi&country_code=AE&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.90'
        , request_start_time = '0.129'
        , parsing_start_time = '2.306'
        , mapping_complete_time = '0.105'
        , mongo_start_time = '0.748'
        , search_end_time = '0.368'
        , total_duration = '3.602'
        , error_description = ''
        , memory_used = '51950720'
        WHERE id = '204480669';
[11/29/2024 08:08:46], [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', 'res/29_11_2024/request_AVAILABILITY_Bawadi_08_08_43_17328677230_201.xml', 'res/29_11_2024/response_AVAILABILITY_Bawadi_08_08_43_17328677230_201.xml', 'res/29_11_2024/response_header_AVAILABILITY_Bawadi_08_08_43_17328677230_201.xml', 'restel', '2024-11-29 08:08:46', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/res/29_11_2024/response_AVAILABILITY_Bawadi_08_08_43_17328677230_201.xml');
[11/29/2024 08:08:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=restel&sessionid=52920241108084188085999247&city_name=ABU+DHABI&province_code=AEAUH&city_code=15723-AEAUH&country_code=AE&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.49'
        , request_start_time = '0.133'
        , parsing_start_time = '3.639'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.133'
        , search_end_time = '0.181'
        , total_duration = '4.126'
        , error_description = ''
        , memory_used = '16153680'
        WHERE id = '204480673';
[11/29/2024 08:08:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ebookingcenter&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=1&total_request=2&city_code=2554&city_name=ABU+DHABI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.83'
        , request_start_time = '0.140'
        , parsing_start_time = '3.404'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.233'
        , search_end_time = '0.266'
        , total_duration = '4.106'
        , error_description = ''
        , memory_used = '64136808'
        WHERE id = '204480672';
[11/29/2024 08:08:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '70'
        , request_url = '/call.php?s=bedzinn&sessionid=52920241108084188085999247&xml_user_id=5&city_code=71650&country_code=138&db_caching=1&web_service=no&&multicityreq=0&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.40'
        , request_start_time = '0.022'
        , parsing_start_time = '3.413'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.661'
        , search_end_time = '0.793'
        , total_duration = '4.953'
        , error_description = ''
        , memory_used = '95590224'
        WHERE id = '204480671';
[11/29/2024 08:08: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', 'ao/29_11_2024/request_availability_Bawadi__0_08_08_43_1732867723.json', 'ao/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json', 'ao/29_11_2024/response_header_availability_Bawadi__0_08_08_43_1732867723.json', 'aosc', '2024-11-29 08:08:48', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ao/29_11_2024/response_availability_Bawadi__0_08_08_43_1732867723.json');
[11/29/2024 08:08: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', 'j2/29_11_2024/request_availability_Bawadi_08_08_43_17328677231.xml', 'j2/29_11_2024/response_availability_Bawadi_08_08_43_17328677231.xml', 'j2/29_11_2024/response_header_availability_Bawadi_08_08_43_17328677231.xml', 'jumbotours', '2024-11-29 08:08:48', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/29_11_2024/response_availability_Bawadi_08_08_43_17328677231.xml');
[11/29/2024 08:08:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=1&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.59'
        , request_start_time = '0.013'
        , parsing_start_time = '5.220'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.026'
        , search_end_time = '0.000'
        , total_duration = '5.298'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2030568'
        WHERE id = '204480678';
[11/29/2024 08:08:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=aosc&sessionid=52920241108084188085999247&xml_user_id=5&city_code=71650&country_code=138&db_caching=1&web_service=no&&multicityreq=0&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.78'
        , request_start_time = '0.010'
        , parsing_start_time = '5.103'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.430'
        , search_end_time = '0.332'
        , total_duration = '5.927'
        , error_description = ''
        , memory_used = '68182064'
        WHERE id = '204480677';
[11/29/2024 08:08:49], [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', 'ao/29_11_2024/request_availability_Bawadi__1_08_08_43_1732867723.json', 'ao/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json', 'ao/29_11_2024/response_header_availability_Bawadi__1_08_08_43_1732867723.json', 'aosc', '2024-11-29 08:08:49', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ao/29_11_2024/response_availability_Bawadi__1_08_08_43_1732867723.json');
[11/29/2024 08:08:49], [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', 'ebookingcenter/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_55_0.json', 'ebookingcenter/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_55_0.json', 'ebookingcenter/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_55_0.json', 'ebookingcenter', '2024-11-29 08:08:49', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_55_0.json');
[11/29/2024 08:08:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '61'
        , request_url = '/call.php?s=aosc&sessionid=52920241108084188085999247&xml_user_id=5&city_code=71650&country_code=138&db_caching=1&web_service=no&&multicityreq=1&ws=1&original_source=&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.79'
        , request_start_time = '0.010'
        , parsing_start_time = '5.926'
        , mapping_complete_time = '0.148'
        , mongo_start_time = '0.532'
        , search_end_time = '0.344'
        , total_duration = '6.873'
        , error_description = ''
        , memory_used = '76169080'
        WHERE id = '204480682';
[11/29/2024 08:08:50], [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', 'd5/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_56.json', 'd5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_56.json', 'd5/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_56.json', 'dida', '2024-11-29 08:08:50', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_56.json');
[11/29/2024 08:08:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ebookingcenter&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=2&city_code=2554&city_name=ABU+DHABI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.77'
        , request_start_time = '0.143'
        , parsing_start_time = '6.451'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.374'
        , search_end_time = '0.585'
        , total_duration = '7.637'
        , error_description = ''
        , memory_used = '110151304'
        WHERE id = '204480683';
[11/29/2024 08:08:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=dida&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=2&total_request=3&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.66'
        , request_start_time = '0.156'
        , parsing_start_time = '7.068'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.331'
        , search_end_time = '0.063'
        , total_duration = '7.655'
        , error_description = ''
        , memory_used = '13790288'
        WHERE id = '204480684';
[11/29/2024 08:08:51], [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', 'd5/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_59.json', 'd5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_59.json', 'd5/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_59.json', 'dida', '2024-11-29 08:08:51', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_59.json');
[11/29/2024 08:08:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '46'
        , request_url = '/call.php?s=dida&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=1&total_request=3&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.64'
        , request_start_time = '0.071'
        , parsing_start_time = '8.058'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.359'
        , search_end_time = '0.101'
        , total_duration = '8.631'
        , error_description = ''
        , memory_used = '22803048'
        WHERE id = '204480685';
[11/29/2024 08:08:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'd5/29_11_2024/request_availability_Bawadi_08_08_43_1732867723_43.json', 'd5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_43.json', 'd5/29_11_2024/response_header_availability_Bawadi_08_08_43_1732867723_43.json', 'dida', '2024-11-29 08:08:53', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_08_08_43_1732867723_43.json');
[11/29/2024 08:08:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=52920241108084188085999247&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.62'
        , request_start_time = '0.020'
        , parsing_start_time = '10.460'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.402'
        , search_end_time = '0.140'
        , total_duration = '11.072'
        , error_description = ''
        , memory_used = '36120240'
        WHERE id = '204480686';
[11/29/2024 08:08:58], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/29_11_2024/request_availability_Bawadi_08_08_43_17328677230.json', 'rh/29_11_2024/response_availability_Bawadi_08_08_43_17328677230.json', 'rh/29_11_2024/response_header_availability_Bawadi_08_08_43_17328677230.json', 'ratehawk', '2024-11-29 08:08:58', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_08_08_43_17328677230.json');
[11/29/2024 08:08:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '114'
        , request_url = '/call.php?s=ratehawk&sessionid=52920241108084188085999247&destination_code=453&city_name=Abu+Dhabi&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=5&db_caching=1&wh_agent_id=&erequest=0&total_request=2&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-11-29 08:08:43.50'
        , request_start_time = '0.015'
        , parsing_start_time = '15.556'
        , mapping_complete_time = '0.292'
        , mongo_start_time = '0.728'
        , search_end_time = '0.338'
        , total_duration = '16.701'
        , error_description = ''
        , memory_used = '199171192'
        WHERE id = '204480689';
[11/29/2024 08:09:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '147',
        request_path = '/xml_all.php?userid=5&sessionid=52920241108084188085999247',
        duration = '22.566',
        merge_duration = '3.770',
        assigned_supplier_count = '19',
        searched_supplier_count = '13',
        system_load_1_min = '0.57',
        system_load_5_min = '1.20',
        system_load_15_min = '1.98',
        system_memory_usage = '64.95',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '17837045') + '54021264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '17837045';
[11/29/2024 08:09:41], [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/29_11_2024/request_availability_Bawadi_08_09_32_1732867772.json', 'rh/29_11_2024/response_availability_Bawadi_08_09_32_1732867772.json', 'rh/29_11_2024/response_header_availability_Bawadi_08_09_32_1732867772.json', 'ratehawk', '2024-11-29 08:09:41', '', '52920241108084188085999247', '17837045', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_08_09_32_1732867772.json');
