[11/29/2024 10:26:06], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-11-29 10:26:06',login_attempt=0 where id = '5';
[11/29/2024 10:26:06], [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 10:26:06', ip = '43.239.53.130', action = 'Login' ;
[11/29/2024 10:26:45], [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 = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-11-29 10:26:45' , 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 10:26:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_5_52920241110264565794723856', session_id='52920241110264565794723856', Collection_create_time='2024-11-29 10:26:47';
[11/29/2024 10:26: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_10_26_47_17328760070.xml', 'j2/29_11_2024/response_availability_Bawadi_10_26_47_17328760070.xml', 'j2/29_11_2024/response_header_availability_Bawadi_10_26_47_17328760070.xml', 'jumbotours', '2024-11-29 10:26:48', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/29_11_2024/response_availability_Bawadi_10_26_47_17328760070.xml');
[11/29/2024 10:26:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=52920241110264565794723856&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 10:26:47.948'
        , request_start_time = '0.013'
        , parsing_start_time = '0.395'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.031'
        , search_end_time = '0.000'
        , total_duration = '0.462'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2043160'
        WHERE id = '204507943';
[11/29/2024 10:26: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_10_26_48_17328760081.xml', 'j2/29_11_2024/response_availability_Bawadi_10_26_48_17328760081.xml', 'j2/29_11_2024/response_header_availability_Bawadi_10_26_48_17328760081.xml', 'jumbotours', '2024-11-29 10:26:48', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/29_11_2024/response_availability_Bawadi_10_26_48_17328760081.xml');
[11/29/2024 10:26:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=52920241110264565794723856&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 10:26:47.992'
        , request_start_time = '0.011'
        , parsing_start_time = '0.405'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.027'
        , search_end_time = '0.000'
        , total_duration = '0.467'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2030632'
        WHERE id = '204507944';
[11/29/2024 10:26: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', 'rh/29_11_2024/request_availability_Bawadi_10_26_47_17328760071.json', 'rh/29_11_2024/response_availability_Bawadi_10_26_47_17328760071.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_26_47_17328760071.json', 'ratehawk', '2024-11-29 10:26:49', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_26_47_17328760071.json');
[11/29/2024 10:26:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=52920241110264565794723856&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 10:26:47.902'
        , request_start_time = '0.011'
        , parsing_start_time = '1.152'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.040'
        , search_end_time = '0.039'
        , total_duration = '1.268'
        , error_description = ''
        , memory_used = '3396976'
        WHERE id = '204507946';
[11/29/2024 10:26: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', 't1/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_9965.xml', 't1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_9965.xml', 't1/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_9965.xml', 'travco', '2024-11-29 10:26:49', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_9965.xml');
[11/29/2024 10:26: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', 'h1/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_23_1.json', 'h1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_23_1.json', 'h1/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_23_1.json', 'hotelbeds', '2024-11-29 10:26:49', '\n', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_23_1.json');
[11/29/2024 10:26:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=travco&sessionid=52920241110264565794723856&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 10:26:48.481'
        , request_start_time = '0.124'
        , parsing_start_time = '0.636'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.061'
        , search_end_time = '0.018'
        , total_duration = '0.863'
        , error_description = ''
        , memory_used = '2581712'
        WHERE id = '204507947';
[11/29/2024 10:26:49], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelbeds&sessionid=52920241110264565794723856&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 10:26:48.437'
        , request_start_time = '0.010'
        , parsing_start_time = '0.820'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.073'
        , search_end_time = '0.082'
        , total_duration = '1.011'
        , error_description = ''
        , memory_used = '7602800'
        WHERE id = '204507948';
[11/29/2024 10:26: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', 'h1/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_12_0.json', 'h1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_12_0.json', 'h1/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_12_0.json', 'hotelbeds', '2024-11-29 10:26:49', '\n', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_12_0.json');
[11/29/2024 10:26:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '84'
        , request_url = '/call.php?s=hotelbeds&sessionid=52920241110264565794723856&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 10:26:48.393'
        , request_start_time = '0.010'
        , parsing_start_time = '1.409'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.209'
        , search_end_time = '0.455'
        , total_duration = '2.127'
        , error_description = ''
        , memory_used = '40487800'
        WHERE id = '204507950';
[11/29/2024 10:26: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', 'ao/29_11_2024/request_availability_Bawadi__0_10_26_48_1732876008.json', 'ao/29_11_2024/response_availability_Bawadi__0_10_26_48_1732876008.json', 'ao/29_11_2024/response_header_availability_Bawadi__0_10_26_48_1732876008.json', 'aosc', '2024-11-29 10:26:53', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ao/29_11_2024/response_availability_Bawadi__0_10_26_48_1732876008.json');
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'res/29_11_2024/request_AVAILABILITY_Bawadi_10_26_47_17328760070_292.xml', 'res/29_11_2024/response_AVAILABILITY_Bawadi_10_26_47_17328760070_292.xml', 'res/29_11_2024/response_header_AVAILABILITY_Bawadi_10_26_47_17328760070_292.xml', 'restel', '2024-11-29 10:26:54', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/res/29_11_2024/response_AVAILABILITY_Bawadi_10_26_47_17328760070_292.xml');
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=restel&sessionid=52920241110264565794723856&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 10:26:47.765'
        , request_start_time = '0.127'
        , parsing_start_time = '6.435'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.012'
        , search_end_time = '0.000'
        , total_duration = '6.598'
        , error_description = ''
        , memory_used = '2258680'
        WHERE id = '204507960';
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ao/29_11_2024/request_availability_Bawadi__1_10_26_48_1732876008.json', 'ao/29_11_2024/response_availability_Bawadi__1_10_26_48_1732876008.json', 'ao/29_11_2024/response_header_availability_Bawadi__1_10_26_48_1732876008.json', 'aosc', '2024-11-29 10:26:54', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ao/29_11_2024/response_availability_Bawadi__1_10_26_48_1732876008.json');
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'res/29_11_2024/request_AVAILABILITY_Bawadi_10_26_47_17328760070_700.xml', 'res/29_11_2024/response_AVAILABILITY_Bawadi_10_26_47_17328760070_700.xml', 'res/29_11_2024/response_header_AVAILABILITY_Bawadi_10_26_47_17328760070_700.xml', 'restel', '2024-11-29 10:26:54', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/res/29_11_2024/response_AVAILABILITY_Bawadi_10_26_47_17328760070_700.xml');
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=restel&sessionid=52920241110264565794723856&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 10:26:47.812'
        , request_start_time = '0.122'
        , parsing_start_time = '6.518'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.032'
        , search_end_time = '0.017'
        , total_duration = '6.713'
        , error_description = ''
        , memory_used = '2905736'
        WHERE id = '204507962';
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'd5/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_73.json', 'd5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_73.json', 'd5/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_73.json', 'dida', '2024-11-29 10:26:54', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_73.json');
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=aosc&sessionid=52920241110264565794723856&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 10:26:48.213'
        , request_start_time = '0.009'
        , parsing_start_time = '5.664'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.434'
        , search_end_time = '0.388'
        , total_duration = '6.541'
        , error_description = ''
        , memory_used = '64360080'
        WHERE id = '204507957';
[11/29/2024 10:26:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=dida&sessionid=52920241110264565794723856&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 10:26:48.124'
        , request_start_time = '0.115'
        , parsing_start_time = '6.315'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.251'
        , search_end_time = '0.039'
        , total_duration = '6.750'
        , error_description = ''
        , memory_used = '7690552'
        WHERE id = '204507963';
[11/29/2024 10:26:55], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_36_1.json', 'ebookingcenter/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_36_1.json', 'ebookingcenter/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_36_1.json', 'ebookingcenter', '2024-11-29 10:26:55', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_36_1.json');
[11/29/2024 10:26:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '60'
        , request_url = '/call.php?s=aosc&sessionid=52920241110264565794723856&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 10:26:48.257'
        , request_start_time = '0.009'
        , parsing_start_time = '6.096'
        , mapping_complete_time = '0.082'
        , mongo_start_time = '0.479'
        , search_end_time = '0.351'
        , total_duration = '6.986'
        , error_description = ''
        , memory_used = '75499144'
        WHERE id = '204507961';
[11/29/2024 10:26:55], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ebookingcenter&sessionid=52920241110264565794723856&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 10:26:48.348'
        , request_start_time = '0.144'
        , parsing_start_time = '6.632'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.235'
        , search_end_time = '0.292'
        , total_duration = '7.356'
        , error_description = ''
        , memory_used = '64460576'
        WHERE id = '204507964';
[11/29/2024 10:26:55], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_13_0.json', 'ebookingcenter/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_13_0.json', 'ebookingcenter/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_13_0.json', 'ebookingcenter', '2024-11-29 10:26:55', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_13_0.json');
[11/29/2024 10:26:56], [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_10_26_48_1732876008_45.json', 'd5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_45.json', 'd5/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_45.json', 'dida', '2024-11-29 10:26:56', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_45.json');
[11/29/2024 10:26:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ebookingcenter&sessionid=52920241110264565794723856&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 10:26:48.302'
        , request_start_time = '0.147'
        , parsing_start_time = '7.488'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.375'
        , search_end_time = '0.577'
        , total_duration = '8.658'
        , error_description = ''
        , memory_used = '110713392'
        WHERE id = '204507965';
[11/29/2024 10:26:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=dida&sessionid=52920241110264565794723856&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 10:26:48.81'
        , request_start_time = '0.087'
        , parsing_start_time = '8.553'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.307'
        , search_end_time = '0.103'
        , total_duration = '9.086'
        , error_description = ''
        , memory_used = '26060176'
        WHERE id = '204507966';
[11/29/2024 10:26: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', 'd5/29_11_2024/request_availability_Bawadi_10_26_48_1732876008_99.json', 'd5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_99.json', 'd5/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_99.json', 'dida', '2024-11-29 10:26:58', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d5/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_99.json');
[11/29/2024 10:26:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '47'
        , request_url = '/call.php?s=dida&sessionid=52920241110264565794723856&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 10:26:48.38'
        , request_start_time = '0.024'
        , parsing_start_time = '10.899'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.328'
        , search_end_time = '0.178'
        , total_duration = '11.466'
        , error_description = ''
        , memory_used = '35476808'
        WHERE id = '204507967';
[11/29/2024 10:27: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', 'tr/29_11_2024/request_availability_Bawadi__0_10_26_47_1732876007.json', 'tr/29_11_2024/response_availability_Bawadi__0_10_26_47_1732876007.json', 'tr/29_11_2024/response_header_availability_Bawadi__0_10_26_47_1732876007.json', 'tripathonxml', '2024-11-29 10:27:05', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/tr/29_11_2024/response_availability_Bawadi__0_10_26_47_1732876007.json');
[11/29/2024 10:27: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', 'tr/29_11_2024/request_availability_Bawadi__1_10_26_47_1732876007.json', 'tr/29_11_2024/response_availability_Bawadi__1_10_26_47_1732876007.json', 'tr/29_11_2024/response_header_availability_Bawadi__1_10_26_47_1732876007.json', 'tripathonxml', '2024-11-29 10:27:05', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/tr/29_11_2024/response_availability_Bawadi__1_10_26_47_1732876007.json');
[11/29/2024 10:27: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', 'be/29_11_2024/request_availability_Bawadi__1_10_26_47_1732876007.json', 'be/29_11_2024/response_availability_Bawadi__1_10_26_47_1732876007.json', 'be/29_11_2024/response_header_availability_Bawadi__1_10_26_47_1732876007.json', 'bedzinn', '2024-11-29 10:27:05', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/be/29_11_2024/response_availability_Bawadi__1_10_26_47_1732876007.json');
[11/29/2024 10:27:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=tripathonxml&sessionid=52920241110264565794723856&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 10:26:47.676'
        , request_start_time = '0.009'
        , parsing_start_time = '17.448'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.158'
        , search_end_time = '0.189'
        , total_duration = '17.836'
        , error_description = ''
        , memory_used = '28301920'
        WHERE id = '204507969';
[11/29/2024 10:27: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', 'be/29_11_2024/request_availability_Bawadi__0_10_26_47_1732876007.json', 'be/29_11_2024/response_availability_Bawadi__0_10_26_47_1732876007.json', 'be/29_11_2024/response_header_availability_Bawadi__0_10_26_47_1732876007.json', 'bedzinn', '2024-11-29 10:27:05', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/be/29_11_2024/response_availability_Bawadi__0_10_26_47_1732876007.json');
[11/29/2024 10:27:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=bedzinn&sessionid=52920241110264565794723856&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 10:26:47.632'
        , request_start_time = '0.009'
        , parsing_start_time = '17.740'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.315'
        , search_end_time = '0.417'
        , total_duration = '18.517'
        , error_description = ''
        , memory_used = '46525368'
        WHERE id = '204507971';
[11/29/2024 10:27:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=tripathonxml&sessionid=52920241110264565794723856&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 10:26:47.721'
        , request_start_time = '0.011'
        , parsing_start_time = '17.537'
        , mapping_complete_time = '0.069'
        , mongo_start_time = '0.403'
        , search_end_time = '0.519'
        , total_duration = '18.517'
        , error_description = ''
        , memory_used = '62472072'
        WHERE id = '204507970';
[11/29/2024 10:27:06], [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_10_26_47_17328760070.json', 'rh/29_11_2024/response_availability_Bawadi_10_26_47_17328760070.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_26_47_17328760070.json', 'ratehawk', '2024-11-29 10:27:06', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_26_47_17328760070.json');
[11/29/2024 10:27:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '70'
        , request_url = '/call.php?s=bedzinn&sessionid=52920241110264565794723856&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 10:26:47.588'
        , request_start_time = '0.021'
        , parsing_start_time = '17.907'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.656'
        , search_end_time = '0.930'
        , total_duration = '19.573'
        , error_description = ''
        , memory_used = '102086888'
        WHERE id = '204507972';
[11/29/2024 10:27:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '112'
        , request_url = '/call.php?s=ratehawk&sessionid=52920241110264565794723856&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 10:26:47.857'
        , request_start_time = '0.011'
        , parsing_start_time = '18.964'
        , mapping_complete_time = '0.325'
        , mongo_start_time = '0.738'
        , search_end_time = '0.316'
        , total_duration = '20.086'
        , error_description = ''
        , memory_used = '219651272'
        WHERE id = '204507973';
[11/29/2024 10:27:08], [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_10_26_48_1732876008_56_0.xml', 'd3/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_56_0.xml', 'd3/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_56_0.xml', 'darina', '2024-11-29 10:27:08', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/d3/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_56_0.xml');
[11/29/2024 10:27:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=darina&sessionid=52920241110264565794723856&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 10:26:48.170'
        , request_start_time = '0.125'
        , parsing_start_time = '20.010'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '20.180'
        , error_description = ' Cannot use object of type XML_Parser_Error as array | 1 | /efsdata/otrams/public_html/beta/tms/classes/supplier/DARINA.php:462'
        , memory_used = '2387576'
        WHERE id = '204507974';
[11/29/2024 10:27:08], [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_10_26_48_1732876008_0.json', 'm1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_0.json', 'm1/29_11_2024/response_header_availability_Bawadi_10_26_48_1732876008_0.json', 'miki', '2024-11-29 10:27:08', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/m1/29_11_2024/response_availability_Bawadi_10_26_48_1732876008_0.json');
[11/29/2024 10:27:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=miki&sessionid=52920241110264565794723856&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 10:26:48.528'
        , request_start_time = '0.132'
        , parsing_start_time = '20.022'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.018'
        , search_end_time = '0.000'
        , total_duration = '20.197'
        , error_description = ''
        , memory_used = '4412624'
        WHERE id = '204507975';
[11/29/2024 10:27:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '142',
        request_path = '/xml_all.php?userid=5&sessionid=52920241110264565794723856',
        duration = '25.879',
        merge_duration = '3.155',
        assigned_supplier_count = '19',
        searched_supplier_count = '13',
        system_load_1_min = '1.22',
        system_load_5_min = '2.47',
        system_load_15_min = '2.27',
        system_memory_usage = '71.19',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '17840836') + '39217312',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '17840836';
[11/29/2024 10:27:29], [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_10_27_26_1732876046.json', 'rh/29_11_2024/response_availability_Bawadi_10_27_26_1732876046.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_27_26_1732876046.json', 'ratehawk', '2024-11-29 10:27:29', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_27_26_1732876046.json');
[11/29/2024 10:27:53], [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_10_27_50_1732876070.json', 'rh/29_11_2024/response_availability_Bawadi_10_27_50_1732876070.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_27_50_1732876070.json', 'ratehawk', '2024-11-29 10:27:53', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_27_50_1732876070.json');
[11/29/2024 10:28:12], [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_10_28_09_1732876089.json', 'rh/29_11_2024/response_availability_Bawadi_10_28_09_1732876089.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_28_09_1732876089.json', 'ratehawk', '2024-11-29 10:28:12', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_28_09_1732876089.json');
[11/29/2024 10:29:07], [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_10_28_59_1732876139.json', 'rh/29_11_2024/response_availability_Bawadi_10_28_59_1732876139.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_28_59_1732876139.json', 'ratehawk', '2024-11-29 10:29:07', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_28_59_1732876139.json');
[11/29/2024 10:29:25], [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_10_29_19_1732876159.json', 'rh/29_11_2024/response_availability_Bawadi_10_29_19_1732876159.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_29_19_1732876159.json', 'ratehawk', '2024-11-29 10:29:25', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_29_19_1732876159.json');
[11/29/2024 10:29:42], [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_10_29_35_1732876175.json', 'rh/29_11_2024/response_availability_Bawadi_10_29_35_1732876175.json', 'rh/29_11_2024/response_header_availability_Bawadi_10_29_35_1732876175.json', 'ratehawk', '2024-11-29 10:29:42', '', '52920241110264565794723856', '17840836', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/29_11_2024/response_availability_Bawadi_10_29_35_1732876175.json');
