[09/30/2024 02:00:00], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/10/13' , departure_date = '2024/10/20' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 14:00:00' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 02:00:01], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240914000024034607418', session_id='12843020240914000024034607418', Collection_create_time='2024-09-30 14:00:01';
[09/30/2024 02:00: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', 'rh/30_09_2024/request_availability_qtech_agent_14_00_02_17277048023.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048023.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_02_17277048023.json', 'ratehawk', '2024-09-30 02:00:08', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048023.json');
[09/30/2024 02:00:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.739'
        , request_start_time = '0.298'
        , parsing_start_time = '6.783'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.035'
        , search_end_time = '0.046'
        , total_duration = '7.199'
        , error_description = ''
        , memory_used = '5929880'
        WHERE id = '189186715';
[09/30/2024 02:00: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', 'rh/30_09_2024/request_availability_qtech_agent_14_00_02_17277048024.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048024.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_02_17277048024.json', 'ratehawk', '2024-09-30 02:00:09', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048024.json');
[09/30/2024 02:00: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', 'rh/30_09_2024/request_availability_qtech_agent_14_00_02_17277048022.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048022.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_02_17277048022.json', 'ratehawk', '2024-09-30 02:00:09', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048022.json');
[09/30/2024 02:00: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', 'rh/30_09_2024/request_availability_qtech_agent_14_00_02_17277048025.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048025.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_02_17277048025.json', 'ratehawk', '2024-09-30 02:00:09', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048025.json');
[09/30/2024 02:00:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.742'
        , request_start_time = '0.415'
        , parsing_start_time = '7.038'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.071'
        , search_end_time = '0.048'
        , total_duration = '7.609'
        , error_description = ''
        , memory_used = '17539152'
        WHERE id = '189186731';
[09/30/2024 02:00:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.743'
        , request_start_time = '0.536'
        , parsing_start_time = '6.987'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.086'
        , search_end_time = '0.070'
        , total_duration = '7.718'
        , error_description = ''
        , memory_used = '21676984'
        WHERE id = '189186741';
[09/30/2024 02:00:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.740'
        , request_start_time = '0.217'
        , parsing_start_time = '7.247'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.166'
        , search_end_time = '0.111'
        , total_duration = '7.787'
        , error_description = ''
        , memory_used = '49461920'
        WHERE id = '189186733';
[09/30/2024 02:00: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/30_09_2024/request_availability_qtech_agent_14_00_02_17277048026.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048026.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_02_17277048026.json', 'ratehawk', '2024-09-30 02:00:12', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_02_17277048026.json');
[09/30/2024 02:00:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.747'
        , request_start_time = '0.545'
        , parsing_start_time = '10.319'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.023'
        , search_end_time = '0.017'
        , total_duration = '10.933'
        , error_description = ''
        , memory_used = '4092816'
        WHERE id = '189186769';
[09/30/2024 02:00:17], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_00_01_17277048010.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_01_17277048010.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_01_17277048010.json', 'ratehawk', '2024-09-30 02:00:17', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_01_17277048010.json');
[09/30/2024 02:00:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.737'
        , request_start_time = '0.142'
        , parsing_start_time = '16.025'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.089'
        , search_end_time = '0.066'
        , total_duration = '16.359'
        , error_description = ''
        , memory_used = '22649736'
        WHERE id = '189186783';
[09/30/2024 02:00:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_00_01_17277048011.json', 'rh/30_09_2024/response_availability_qtech_agent_14_00_01_17277048011.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_00_01_17277048011.json', 'ratehawk', '2024-09-30 02:00:19', '', '12843020240914000024034607418', '16619646', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_00_01_17277048011.json');
[09/30/2024 02:00:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914000024034607418&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:00:01.737'
        , request_start_time = '0.147'
        , parsing_start_time = '17.587'
        , mapping_complete_time = '0.115'
        , mongo_start_time = '0.347'
        , search_end_time = '0.209'
        , total_duration = '18.352'
        , error_description = ''
        , memory_used = '93823976'
        WHERE id = '189186784';
[09/30/2024 02:00:21], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '240',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240914000024034607418',
        duration = '20.773',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.21',
        system_load_5_min = '3.71',
        system_load_15_min = '5.01',
        system_memory_usage = '31.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16619646') + '5049248',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16619646';
[09/30/2024 02:01:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/10/13' , departure_date = '2024/10/20' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 14:01:07' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 02:01:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240914010798300376068', session_id='12843020240914010798300376068', Collection_create_time='2024-09-30 14:01:07';
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048686.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048686.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048686.json', 'ratehawk', '2024-09-30 02:01:19', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048686.json');
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048683.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048683.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048683.json', 'ratehawk', '2024-09-30 02:01:19', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048683.json');
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.405'
        , request_start_time = '0.514'
        , parsing_start_time = '10.471'
        , mapping_complete_time = '0.012'
        , mongo_start_time = '0.025'
        , search_end_time = '0.038'
        , total_duration = '11.073'
        , error_description = ''
        , memory_used = '4092800'
        WHERE id = '189186916';
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '10'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.397'
        , request_start_time = '0.268'
        , parsing_start_time = '10.750'
        , mapping_complete_time = '0.012'
        , mongo_start_time = '0.043'
        , search_end_time = '0.020'
        , total_duration = '11.106'
        , error_description = ''
        , memory_used = '5930360'
        WHERE id = '189186917';
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048680.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048680.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048680.json', 'ratehawk', '2024-09-30 02:01:19', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048680.json');
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048685.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048685.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048685.json', 'ratehawk', '2024-09-30 02:01:19', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048685.json');
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '28'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.390'
        , request_start_time = '0.119'
        , parsing_start_time = '11.004'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.080'
        , search_end_time = '0.049'
        , total_duration = '11.280'
        , error_description = ''
        , memory_used = '22106128'
        WHERE id = '189186918';
[09/30/2024 02:01:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.402'
        , request_start_time = '0.505'
        , parsing_start_time = '10.640'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.079'
        , search_end_time = '0.061'
        , total_duration = '11.315'
        , error_description = ''
        , memory_used = '21554488'
        WHERE id = '189186919';
[09/30/2024 02:01:22], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048682.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048682.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048682.json', 'ratehawk', '2024-09-30 02:01:22', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048682.json');
[09/30/2024 02:01:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.394'
        , request_start_time = '0.202'
        , parsing_start_time = '13.607'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.017'
        , search_end_time = '0.001'
        , total_duration = '13.849'
        , error_description = ''
        , memory_used = '2747832'
        WHERE id = '189186922';
[09/30/2024 02:01:22], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_01_08_17277048684.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048684.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048684.json', 'ratehawk', '2024-09-30 02:01:22', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048684.json');
[09/30/2024 02:01:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '34'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.401'
        , request_start_time = '0.393'
        , parsing_start_time = '13.990'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.070'
        , search_end_time = '0.042'
        , total_duration = '14.525'
        , error_description = ''
        , memory_used = '17422768'
        WHERE id = '189186924';
[09/30/2024 02:01:24], [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/30_09_2024/request_availability_qtech_agent_14_01_08_17277048681.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048681.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_08_17277048681.json', 'ratehawk', '2024-09-30 02:01:24', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_08_17277048681.json');
[09/30/2024 02:01:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914010798300376068&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:01:08.392'
        , request_start_time = '0.120'
        , parsing_start_time = '15.543'
        , mapping_complete_time = '0.110'
        , mongo_start_time = '0.339'
        , search_end_time = '0.177'
        , total_duration = '16.227'
        , error_description = ''
        , memory_used = '90454304'
        WHERE id = '189186925';
[09/30/2024 02:01:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '199',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240914010798300376068',
        duration = '17.832',
        merge_duration = '0.009',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.73',
        system_load_5_min = '3.21',
        system_load_15_min = '4.75',
        system_memory_usage = '32.58',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16619665') + '4939968',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16619665';
[09/30/2024 02:01:47], [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/30_09_2024/request_availability_qtech_agent_14_01_45_1727704905.json', 'rh/30_09_2024/response_availability_qtech_agent_14_01_45_1727704905.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_01_45_1727704905.json', 'ratehawk', '2024-09-30 02:01:47', '', '12843020240914010798300376068', '16619665', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_01_45_1727704905.json');
[09/30/2024 02:02:25], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727704945','43.239.53.130');
[09/30/2024 02:03:17], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/10/30' , departure_date = '2024/11/06' , nights = '7' , nationality = '129' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-09-30 14:03:17' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 02:03:18], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240914031712255783713', session_id='12843020240914031712255783713', Collection_create_time='2024-09-30 14:03:18';
[09/30/2024 02:03:25], [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/30_09_2024/request_availability_qtech_agent_14_03_19_17277049996.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049996.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049996.json', 'ratehawk', '2024-09-30 02:03:25', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049996.json');
[09/30/2024 02:03:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.66'
        , request_start_time = '0.512'
        , parsing_start_time = '5.465'
        , mapping_complete_time = '0.014'
        , mongo_start_time = '0.031'
        , search_end_time = '0.041'
        , total_duration = '6.075'
        , error_description = ''
        , memory_used = '3927432'
        WHERE id = '189187418';
[09/30/2024 02:03:25], [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/30_09_2024/request_availability_qtech_agent_14_03_19_17277049993.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049993.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049993.json', 'ratehawk', '2024-09-30 02:03:25', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049993.json');
[09/30/2024 02:03:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.58'
        , request_start_time = '0.277'
        , parsing_start_time = '5.780'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.049'
        , search_end_time = '0.031'
        , total_duration = '6.168'
        , error_description = ''
        , memory_used = '10752408'
        WHERE id = '189187419';
[09/30/2024 02:03: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/30_09_2024/request_availability_qtech_agent_14_03_19_17277049995.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049995.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049995.json', 'ratehawk', '2024-09-30 02:03:26', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049995.json');
[09/30/2024 02:03:26], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '48'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.61'
        , request_start_time = '0.509'
        , parsing_start_time = '6.784'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.105'
        , search_end_time = '0.091'
        , total_duration = '7.523'
        , error_description = ''
        , memory_used = '28271336'
        WHERE id = '189187420';
[09/30/2024 02:03:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_03_19_17277049994.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049994.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049994.json', 'ratehawk', '2024-09-30 02:03:34', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049994.json');
[09/30/2024 02:03:34], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_03_19_17277049990.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049990.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049990.json', 'ratehawk', '2024-09-30 02:03:34', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049990.json');
[09/30/2024 02:03:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '40'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.60'
        , request_start_time = '0.388'
        , parsing_start_time = '14.694'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.087'
        , search_end_time = '0.053'
        , total_duration = '15.256'
        , error_description = ''
        , memory_used = '22259592'
        WHERE id = '189187547';
[09/30/2024 02:03:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.53'
        , request_start_time = '0.124'
        , parsing_start_time = '15.083'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.101'
        , search_end_time = '0.060'
        , total_duration = '15.403'
        , error_description = ''
        , memory_used = '28314936'
        WHERE id = '189187548';
[09/30/2024 02:03:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/30_09_2024/request_availability_qtech_agent_14_03_19_17277049992.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049992.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049992.json', 'ratehawk', '2024-09-30 02:03:35', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049992.json');
[09/30/2024 02:03:36], [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/30_09_2024/request_availability_qtech_agent_14_03_19_17277049991.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049991.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_19_17277049991.json', 'ratehawk', '2024-09-30 02:03:36', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_19_17277049991.json');
[09/30/2024 02:03:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '61'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.58'
        , request_start_time = '0.195'
        , parsing_start_time = '16.450'
        , mapping_complete_time = '0.083'
        , mongo_start_time = '0.221'
        , search_end_time = '0.138'
        , total_duration = '17.049'
        , error_description = ''
        , memory_used = '66187376'
        WHERE id = '189187551';
[09/30/2024 02:03:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '118'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240914031712255783713&destination_code=3704&city_name=Vienna&country_code=AT&country_name=Austria&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 14:03:19.55'
        , request_start_time = '0.112'
        , parsing_start_time = '16.876'
        , mapping_complete_time = '0.136'
        , mongo_start_time = '0.419'
        , search_end_time = '0.252'
        , total_duration = '17.721'
        , error_description = ''
        , memory_used = '114480520'
        WHERE id = '189187552';
[09/30/2024 02:03:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '319',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240914031712255783713',
        duration = '19.788',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.63',
        system_load_5_min = '2.29',
        system_load_15_min = '4.21',
        system_memory_usage = '31.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16619715') + '5249904',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16619715';
[09/30/2024 02:03:48], [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/30_09_2024/request_availability_qtech_agent_14_03_46_1727705026.json', 'rh/30_09_2024/response_availability_qtech_agent_14_03_46_1727705026.json', 'rh/30_09_2024/response_header_availability_qtech_agent_14_03_46_1727705026.json', 'ratehawk', '2024-09-30 02:03:48', '', '12843020240914031712255783713', '16619715', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_14_03_46_1727705026.json');
[09/30/2024 02:03:53], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727705033','43.239.53.130');
[09/30/2024 02:03:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727705039','43.239.53.130');
[09/30/2024 02:04:22], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727705062','43.239.53.130');
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'ratehawk', reservation_id = '2050795', create_date = '2024-09-30 14:04:23', agent_id = '1284', parent_agent_id = '1284', agent_ref_no = '', nationality = 'Saudi', city_id = 'vienna', country_id = '46', current_status = 'inprocess-booking', booking_branch_id = '26', is_xml = '0', display_room_rate = '40889.94', display_currency_code = 'INR', native_room_rate = '489', native_currency_code = 'USD', supplier_profile_id = '47', service_type = 'hotel', service_date = '2024/10/30', check_out_date = '2024/11/06', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'shiv', leader_last_name = 'chauhan', status_date = '2024-09-30 14:04:23';
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('142510','KYRIAD VIENNA ALTMANNSDORF','Kyriad Vienna Altmannsdorf','gartenhotel_altmannsdorf_hotel_2','OT000202858','vienna','ratehawk',NOW());
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '26'
		WHERE
		id='142510'
		;
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('142510','2050795','','1','1','0','-','','','gartenhotel_altmannsdorf_hotel_2','Kyriad Vienna Altmannsdorf','Hoffingergasse 33 1120 Wien','','3.0','7','2024/10/30','2024/11/06','','https://betalive.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9jZG4ud29ybGRvdGEubmV0L3QvMTAyNHg3NjgvY29udGVudC8xNS82MC8xNTYwNDcyNTc4NTM3NTBiZmI1YTc2MGI5ODVjZjg4Y2FmZDhkYTAwLmpwZWc=');
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '142510', booking_detail_id = '1', room_type_code = 'm-263b2533-9b49-5e15-ade7-b38244c3291b', room_name = 'single', room_type_description = 'Standard Double room (twin beds) (Room Only)', display_nightly_rates = 'a:7:{i:0;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:1;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:2;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:3;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:4;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:5;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}i:6;a:2:{s:18:"displayNightlyRate";d:5841.4200000000001;s:25:"displayNightlyRateDisplay";s:161:"Rate - 69.86, Currency Multiplier (USD-INR) - 83.61605, Markup in % - 0.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0.00% #ratehawk";}}', native_nightly_rates = 'a:7:{i:0;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:1;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:2;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:3;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:4;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:5;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}i:6;a:1:{s:17:"nativeNightlyRate";d:69.859999999999999;}}', native_room_rate_total = '489', display_room_rate_total = '40889.94', number_of_rooms = '1', room_category = 'Standard Double room (twin beds)', meal_basis = 'Room Only';
[09/30/2024 02:04:24], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '142510', booking_detail_id = '1', rid = '156611', room = '0', salutations = 'Mr', first_name = 'shiv', last_name = 'chauhan', passenger_type = 'adult', age = '';
