[09/20/2024 04:20:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-20 04:20:47',login_attempt=0 where id = '949';
[09/20/2024 04:20:47], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-09-20 04:20:47', ip = '43.239.53.130', action = 'Login' ;
[09/20/2024 04:23:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/23' , departure_date = '2024/10/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-20 04:23:07' , 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/20/2024 04:23:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9492020240904230755677701025', session_id='9492020240904230755677701025', Collection_create_time='2024-09-20 04:23:09';
[09/20/2024 04:23:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_09_1726806189_7_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_7_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_09_1726806189_7_.json', 'hotelspro', '2024-09-20 04:23:12', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_7_.json');
[09/20/2024 04:23:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_10_1726806190_5_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_5_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_10_1726806190_5_.json', 'hotelspro', '2024-09-20 04:23:12', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_5_.json');
[09/20/2024 04:23:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.856'
        , request_start_time = '0.087'
        , parsing_start_time = '2.125'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.247'
        , search_end_time = '0.214'
        , total_duration = '2.731'
        , error_description = ''
        , memory_used = '24701224'
        WHERE id = '186184811';
[09/20/2024 04:23:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_10_1726806190_1_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_1_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_10_1726806190_1_.json', 'hotelspro', '2024-09-20 04:23:13', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_1_.json');
[09/20/2024 04:23:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.852'
        , request_start_time = '0.100'
        , parsing_start_time = '2.467'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.417'
        , search_end_time = '0.494'
        , total_duration = '3.554'
        , error_description = ''
        , memory_used = '54810568'
        WHERE id = '186184812';
[09/20/2024 04:23:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_09_1726806189_3_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_3_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_09_1726806189_3_.json', 'hotelspro', '2024-09-20 04:23:13', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_3_.json');
[09/20/2024 04:23:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.841'
        , request_start_time = '0.080'
        , parsing_start_time = '3.026'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.562'
        , search_end_time = '0.551'
        , total_duration = '4.320'
        , error_description = ''
        , memory_used = '61710296'
        WHERE id = '186184813';
[09/20/2024 04:23: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_10_1726806190_2_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_2_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_10_1726806190_2_.json', 'hotelspro', '2024-09-20 04:23:14', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_2_.json');
[09/20/2024 04:23: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_10_1726806190_6_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_6_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_10_1726806190_6_.json', 'hotelspro', '2024-09-20 04:23:14', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_10_1726806190_6_.json');
[09/20/2024 04:23: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_09_1726806189_0_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_0_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_09_1726806189_0_.json', 'hotelspro', '2024-09-20 04:23:15', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_0_.json');
[09/20/2024 04:23:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.848'
        , request_start_time = '0.075'
        , parsing_start_time = '3.851'
        , mapping_complete_time = '0.094'
        , mongo_start_time = '0.688'
        , search_end_time = '0.660'
        , total_duration = '5.362'
        , error_description = ''
        , memory_used = '82112384'
        WHERE id = '186184814';
[09/20/2024 04:23: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_23_09_1726806189_4_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_4_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_23_09_1726806189_4_.json', 'hotelspro', '2024-09-20 04:23:15', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_23_09_1726806189_4_.json');
[09/20/2024 04:23:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.844'
        , request_start_time = '0.090'
        , parsing_start_time = '4.259'
        , mapping_complete_time = '0.113'
        , mongo_start_time = '1.129'
        , search_end_time = '0.849'
        , total_duration = '6.449'
        , error_description = ''
        , memory_used = '101443456'
        WHERE id = '186184815';
[09/20/2024 04:23:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.853'
        , request_start_time = '0.120'
        , parsing_start_time = '4.855'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.768'
        , search_end_time = '0.777'
        , total_duration = '6.605'
        , error_description = ''
        , memory_used = '86046752'
        WHERE id = '186184816';
[09/20/2024 04:23:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '100'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.840'
        , request_start_time = '0.052'
        , parsing_start_time = '5.019'
        , mapping_complete_time = '0.108'
        , mongo_start_time = '0.742'
        , search_end_time = '0.840'
        , total_duration = '6.744'
        , error_description = ''
        , memory_used = '97678664'
        WHERE id = '186184817';
[09/20/2024 04:23:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904230755677701025&xml_user_id=949&db_caching=1&&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:23:09.851'
        , request_start_time = '0.082'
        , parsing_start_time = '5.880'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.792'
        , search_end_time = '0.725'
        , total_duration = '7.566'
        , error_description = ''
        , memory_used = '88466368'
        WHERE id = '186184818';
[09/20/2024 04:23:20], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061905.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061905.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061905.json', 'ratehawk', '2024-09-20 04:23:20', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061905.json');
[09/20/2024 04:23:20], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061908.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061908.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061908.json', 'ratehawk', '2024-09-20 04:23:20', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061908.json');
[09/20/2024 04:23:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.817'
        , request_start_time = '0.461'
        , parsing_start_time = '9.957'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.102'
        , search_end_time = '0.051'
        , total_duration = '10.606'
        , error_description = ''
        , memory_used = '41039264'
        WHERE id = '186184819';
[09/20/2024 04:23:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.826'
        , request_start_time = '0.449'
        , parsing_start_time = '10.063'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.138'
        , search_end_time = '0.074'
        , total_duration = '10.766'
        , error_description = ''
        , memory_used = '57901368'
        WHERE id = '186184820';
[09/20/2024 04:23:21], [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/20_09_2024/request_availability_yogeshqtech_04_23_09_17268061890.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_09_17268061890.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_09_17268061890.json', 'ratehawk', '2024-09-20 04:23:21', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_09_17268061890.json');
[09/20/2024 04:23:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.813'
        , request_start_time = '0.107'
        , parsing_start_time = '11.892'
        , mapping_complete_time = '0.160'
        , mongo_start_time = '0.295'
        , search_end_time = '0.147'
        , total_duration = '12.491'
        , error_description = ''
        , memory_used = '108662184'
        WHERE id = '186184821';
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_172680619010.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619010.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_172680619010.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619010.json');
[09/20/2024 04:23:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.830'
        , request_start_time = '0.697'
        , parsing_start_time = '15.585'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.060'
        , search_end_time = '0.070'
        , total_duration = '16.451'
        , error_description = ''
        , memory_used = '17064680'
        WHERE id = '186184822';
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_172680619012.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619012.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_172680619012.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619012.json');
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_172680619011.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619011.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_172680619011.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_172680619011.json');
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061909.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061909.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061909.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061909.json');
[09/20/2024 04:23:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.837'
        , request_start_time = '0.661'
        , parsing_start_time = '15.939'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.110'
        , search_end_time = '0.069'
        , total_duration = '16.822'
        , error_description = ''
        , memory_used = '41861824'
        WHERE id = '186184823';
[09/20/2024 04:23:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.833'
        , request_start_time = '0.649'
        , parsing_start_time = '16.025'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.074'
        , search_end_time = '0.047'
        , total_duration = '16.832'
        , error_description = ''
        , memory_used = '26409712'
        WHERE id = '186184824';
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061906.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061906.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061906.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061906.json');
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061907.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061907.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061907.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061907.json');
[09/20/2024 04:23:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.827'
        , request_start_time = '0.605'
        , parsing_start_time = '16.143'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.143'
        , search_end_time = '0.086'
        , total_duration = '17.019'
        , error_description = ''
        , memory_used = '56135744'
        WHERE id = '186184825';
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061903.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061903.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061903.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061903.json');
[09/20/2024 04:23:26], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061904.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061904.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061904.json', 'ratehawk', '2024-09-20 04:23:26', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061904.json');
[09/20/2024 04:23:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.823'
        , request_start_time = '0.625'
        , parsing_start_time = '16.277'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.161'
        , search_end_time = '0.096'
        , total_duration = '17.203'
        , error_description = ''
        , memory_used = '64868344'
        WHERE id = '186184826';
[09/20/2024 04:23:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.823'
        , request_start_time = '0.495'
        , parsing_start_time = '16.456'
        , mapping_complete_time = '0.093'
        , mongo_start_time = '0.154'
        , search_end_time = '0.094'
        , total_duration = '17.243'
        , error_description = ''
        , memory_used = '59873000'
        WHERE id = '186184827';
[09/20/2024 04:23:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.814'
        , request_start_time = '0.463'
        , parsing_start_time = '16.662'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.187'
        , search_end_time = '0.096'
        , total_duration = '17.456'
        , error_description = ''
        , memory_used = '85777872'
        WHERE id = '186184829';
[09/20/2024 04:23:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.815'
        , request_start_time = '0.445'
        , parsing_start_time = '16.653'
        , mapping_complete_time = '0.127'
        , mongo_start_time = '0.206'
        , search_end_time = '0.118'
        , total_duration = '17.469'
        , error_description = ''
        , memory_used = '82176688'
        WHERE id = '186184828';
[09/20/2024 04:23:28], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061901.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061901.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061901.json', 'ratehawk', '2024-09-20 04:23:28', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061901.json');
[09/20/2024 04:23:28], [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/20_09_2024/request_availability_yogeshqtech_04_23_10_17268061902.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061902.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_23_10_17268061902.json', 'ratehawk', '2024-09-20 04:23:28', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_23_10_17268061902.json');
[09/20/2024 04:23:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '106'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.814'
        , request_start_time = '0.472'
        , parsing_start_time = '18.034'
        , mapping_complete_time = '0.299'
        , mongo_start_time = '0.569'
        , search_end_time = '0.273'
        , total_duration = '19.411'
        , error_description = ''
        , memory_used = '205508512'
        WHERE id = '186184831';
[09/20/2024 04:23:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '138'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904230755677701025&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:23:09.813'
        , request_start_time = '0.249'
        , parsing_start_time = '18.153'
        , mapping_complete_time = '0.349'
        , mongo_start_time = '0.716'
        , search_end_time = '0.358'
        , total_duration = '19.546'
        , error_description = ''
        , memory_used = '240141416'
        WHERE id = '186184830';
[09/20/2024 04:23:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '784',
        request_path = '/xml_all.php?userid=949&sessionid=9492020240904230755677701025',
        duration = '23.976',
        merge_duration = '1.735',
        assigned_supplier_count = '5',
        searched_supplier_count = '3',
        system_load_1_min = '0.00',
        system_load_5_min = '0.12',
        system_load_15_min = '0.19',
        system_memory_usage = '14.05',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16406757') + '14365000',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16406757';
[09/20/2024 04:25:39], [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/20_09_2024/request_availability_yogeshqtech_04_25_38_1726806338.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_25_38_1726806338.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_25_38_1726806338.json', 'ratehawk', '2024-09-20 04:25:39', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_25_38_1726806338.json');
[09/20/2024 04:26:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726806363','43.239.53.130');
[09/20/2024 04:26:06], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'PRE_RESERVATION', 'h2/20_09_2024/request_pre_reservation_yogeshqtech_04_26_03_1726806363_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_04_26_03_1726806363_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_04_26_03_1726806363_.json', 'hotelspro', '2024-09-20 04:26:06', '', '9492020240904230755677701025', '16406757', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_04_26_03_1726806363_.json');
[09/20/2024 04:30:04], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/23' , departure_date = '2024/10/24' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-20 04:30:04' , 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/20/2024 04:30:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9492020240904300482190077939', session_id='9492020240904300482190077939', Collection_create_time='2024-09-20 04:30:05';
[09/20/2024 04:30: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_06_1726806606_7_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_06_1726806606_7_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_06_1726806606_7_.json', 'hotelspro', '2024-09-20 04:30:06', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_06_1726806606_7_.json');
[09/20/2024 04:30:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '30'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.790'
        , request_start_time = '0.110'
        , parsing_start_time = '0.810'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.247'
        , search_end_time = '0.227'
        , total_duration = '1.512'
        , error_description = ''
        , memory_used = '24774248'
        WHERE id = '186184932';
[09/20/2024 04:30:07], [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', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_4_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_4_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_4_.json', 'hotelspro', '2024-09-20 04:30:07', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_4_.json');
[09/20/2024 04:30:09], [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', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_5_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_5_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_5_.json', 'hotelspro', '2024-09-20 04:30:09', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_5_.json');
[09/20/2024 04:30:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.782'
        , request_start_time = '0.035'
        , parsing_start_time = '1.695'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.782'
        , search_end_time = '0.796'
        , total_duration = '3.424'
        , error_description = ''
        , memory_used = '87566048'
        WHERE id = '186184933';
[09/20/2024 04:30:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.785'
        , request_start_time = '0.090'
        , parsing_start_time = '3.019'
        , mapping_complete_time = '0.075'
        , mongo_start_time = '0.456'
        , search_end_time = '0.451'
        , total_duration = '4.098'
        , error_description = ''
        , memory_used = '57895192'
        WHERE id = '186184934';
[09/20/2024 04:30:10], [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', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_1_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_1_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_1_.json', 'hotelspro', '2024-09-20 04:30:10', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_1_.json');
[09/20/2024 04:30: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', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_3_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_3_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_3_.json', 'hotelspro', '2024-09-20 04:30:11', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_3_.json');
[09/20/2024 04:30:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '62'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.774'
        , request_start_time = '0.049'
        , parsing_start_time = '4.739'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.731'
        , search_end_time = '0.583'
        , total_duration = '6.175'
        , error_description = ''
        , memory_used = '64306432'
        WHERE id = '186184935';
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066067.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066067.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066067.json', 'ratehawk', '2024-09-20 04:30:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066067.json');
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_2_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_2_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_2_.json', 'hotelspro', '2024-09-20 04:30:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_2_.json');
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_06_1726806606_6_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_06_1726806606_6_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_06_1726806606_6_.json', 'hotelspro', '2024-09-20 04:30:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_06_1726806606_6_.json');
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_172680660612.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660612.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_172680660612.json', 'ratehawk', '2024-09-20 04:30:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660612.json');
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066065.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066065.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066065.json', 'ratehawk', '2024-09-20 04:30:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066065.json');
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.754'
        , request_start_time = '0.607'
        , parsing_start_time = '5.732'
        , mapping_complete_time = '0.105'
        , mongo_start_time = '0.167'
        , search_end_time = '0.096'
        , total_duration = '6.660'
        , error_description = ''
        , memory_used = '61082232'
        WHERE id = '186184937';
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.766'
        , request_start_time = '0.685'
        , parsing_start_time = '5.791'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.118'
        , search_end_time = '0.105'
        , total_duration = '6.755'
        , error_description = ''
        , memory_used = '42126792'
        WHERE id = '186184940';
[09/20/2024 04:30:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.747'
        , request_start_time = '0.407'
        , parsing_start_time = '6.175'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.130'
        , search_end_time = '0.053'
        , total_duration = '6.808'
        , error_description = ''
        , memory_used = '42658880'
        WHERE id = '186184941';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_172680660610.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660610.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_172680660610.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660610.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.780'
        , request_start_time = '0.120'
        , parsing_start_time = '5.852'
        , mapping_complete_time = '0.094'
        , mongo_start_time = '0.676'
        , search_end_time = '0.809'
        , total_duration = '7.538'
        , error_description = ''
        , memory_used = '80514112'
        WHERE id = '186184936';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066069.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066069.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066069.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066069.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.761'
        , request_start_time = '0.588'
        , parsing_start_time = '6.888'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.059'
        , search_end_time = '0.060'
        , total_duration = '7.652'
        , error_description = ''
        , memory_used = '17064560'
        WHERE id = '186184942';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066064.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066064.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066064.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066064.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_172680660611.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660611.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_172680660611.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_172680660611.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066066.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066066.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066066.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066066.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.758'
        , request_start_time = '0.556'
        , parsing_start_time = '7.002'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.145'
        , search_end_time = '0.086'
        , total_duration = '7.844'
        , error_description = ''
        , memory_used = '56363928'
        WHERE id = '186184943';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.767'
        , request_start_time = '0.545'
        , parsing_start_time = '7.088'
        , mapping_complete_time = '0.041'
        , mongo_start_time = '0.069'
        , search_end_time = '0.047'
        , total_duration = '7.839'
        , error_description = ''
        , memory_used = '26436888'
        WHERE id = '186184945';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.744'
        , request_start_time = '0.448'
        , parsing_start_time = '7.188'
        , mapping_complete_time = '0.132'
        , mongo_start_time = '0.202'
        , search_end_time = '0.112'
        , total_duration = '7.998'
        , error_description = ''
        , memory_used = '85987640'
        WHERE id = '186184944';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '36'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.750'
        , request_start_time = '0.443'
        , parsing_start_time = '7.304'
        , mapping_complete_time = '0.101'
        , mongo_start_time = '0.163'
        , search_end_time = '0.107'
        , total_duration = '8.067'
        , error_description = ''
        , memory_used = '65709088'
        WHERE id = '186184946';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066060.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066060.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066060.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066060.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.788'
        , request_start_time = '0.106'
        , parsing_start_time = '6.149'
        , mapping_complete_time = '0.113'
        , mongo_start_time = '0.842'
        , search_end_time = '0.820'
        , total_duration = '8.075'
        , error_description = ''
        , memory_used = '87789792'
        WHERE id = '186184939';
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066068.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066068.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066068.json', 'ratehawk', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066068.json');
[09/20/2024 04:30:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'h2/20_09_2024/request_availability_yogeshqtech_04_30_05_1726806605_0_.json', 'h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_0_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_04_30_05_1726806605_0_.json', 'hotelspro', '2024-09-20 04:30:13', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_04_30_05_1726806605_0_.json');
[09/20/2024 04:30:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.756'
        , request_start_time = '0.514'
        , parsing_start_time = '7.556'
        , mapping_complete_time = '0.088'
        , mongo_start_time = '0.142'
        , search_end_time = '0.076'
        , total_duration = '8.364'
        , error_description = ''
        , memory_used = '57731096'
        WHERE id = '186184948';
[09/20/2024 04:30: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/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066063.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066063.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066063.json', 'ratehawk', '2024-09-20 04:30:14', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066063.json');
[09/20/2024 04:30:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.737'
        , request_start_time = '0.249'
        , parsing_start_time = '7.800'
        , mapping_complete_time = '0.205'
        , mongo_start_time = '0.346'
        , search_end_time = '0.192'
        , total_duration = '8.645'
        , error_description = ''
        , memory_used = '108403152'
        WHERE id = '186184947';
[09/20/2024 04:30:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '81'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.777'
        , request_start_time = '0.091'
        , parsing_start_time = '6.222'
        , mapping_complete_time = '0.117'
        , mongo_start_time = '1.337'
        , search_end_time = '0.944'
        , total_duration = '8.687'
        , error_description = ''
        , memory_used = '105432280'
        WHERE id = '186184938';
[09/20/2024 04:30:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.743'
        , request_start_time = '0.303'
        , parsing_start_time = '8.176'
        , mapping_complete_time = '0.099'
        , mongo_start_time = '0.178'
        , search_end_time = '0.115'
        , total_duration = '8.814'
        , error_description = ''
        , memory_used = '82970168'
        WHERE id = '186184950';
[09/20/2024 04:30: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/20_09_2024/request_availability_yogeshqtech_04_30_06_17268066062.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066062.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_06_17268066062.json', 'ratehawk', '2024-09-20 04:30:14', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_06_17268066062.json');
[09/20/2024 04:30: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/20_09_2024/request_availability_yogeshqtech_04_30_05_17268066051.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_05_17268066051.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_05_17268066051.json', 'ratehawk', '2024-09-20 04:30:15', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_05_17268066051.json');
[09/20/2024 04:30:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '98'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240904300482190077939&xml_user_id=949&db_caching=1&&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 04:30:05.770'
        , request_start_time = '0.061'
        , parsing_start_time = '7.873'
        , mapping_complete_time = '0.147'
        , mongo_start_time = '0.791'
        , search_end_time = '0.841'
        , total_duration = '9.692'
        , error_description = ''
        , memory_used = '97747880'
        WHERE id = '186184949';
[09/20/2024 04:30:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '106'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.740'
        , request_start_time = '0.231'
        , parsing_start_time = '8.646'
        , mapping_complete_time = '0.298'
        , mongo_start_time = '0.566'
        , search_end_time = '0.271'
        , total_duration = '9.780'
        , error_description = ''
        , memory_used = '205718464'
        WHERE id = '186184951';
[09/20/2024 04:30:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '138'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240904300482190077939&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=949&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-20 04:30:05.737'
        , request_start_time = '0.124'
        , parsing_start_time = '9.503'
        , mapping_complete_time = '0.360'
        , mongo_start_time = '0.720'
        , search_end_time = '0.338'
        , total_duration = '10.757'
        , error_description = ''
        , memory_used = '242166896'
        WHERE id = '186184952';
[09/20/2024 04:30:19], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '785',
        request_path = '/xml_all.php?userid=949&sessionid=9492020240904300482190077939',
        duration = '14.714',
        merge_duration = '1.754',
        assigned_supplier_count = '5',
        searched_supplier_count = '3',
        system_load_1_min = '0.08',
        system_load_5_min = '0.21',
        system_load_15_min = '0.22',
        system_memory_usage = '15.61',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16406761') + '15331232',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16406761';
[09/20/2024 04:30:54], [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/20_09_2024/request_availability_yogeshqtech_04_30_51_1726806651.json', 'rh/20_09_2024/response_availability_yogeshqtech_04_30_51_1726806651.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_04_30_51_1726806651.json', 'ratehawk', '2024-09-20 04:30:54', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_04_30_51_1726806651.json');
[09/20/2024 04:31:05], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726806665','43.239.53.130');
[09/20/2024 04:31:12], [file name :-/efsdata/otrams/public_html/beta/book_now.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 ('', 'PRE_RESERVATION', 'h2/20_09_2024/request_pre_reservation_yogeshqtech_04_31_06_1726806666_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_04_31_06_1726806666_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_04_31_06_1726806666_.json', 'hotelspro', '2024-09-20 04:31:12', '', '9492020240904300482190077939', '16406761', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_04_31_06_1726806666_.json');
