[09/20/2024 07:03:09], [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 = 'madrid' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-20 07:03:09' , site_id = '' , country_code = '90' , city_code = '60279' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/20/2024 07:03:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_949202024090703099113616877', session_id='949202024090703099113616877', Collection_create_time='2024-09-20 07:03:10';
[09/20/2024 07:03: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_07_03_11_1726815791_9_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_9_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_9_.json', 'hotelspro', '2024-09-20 07:03:12', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_9_.json');
[09/20/2024 07:03:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=9&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.439'
        , request_start_time = '0.266'
        , parsing_start_time = '0.482'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.032'
        , search_end_time = '0.036'
        , total_duration = '0.925'
        , error_description = ''
        , memory_used = '2263120'
        WHERE id = '186204836';
[09/20/2024 07:03: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_07_03_11_1726815791_2_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_2_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_2_.json', 'hotelspro', '2024-09-20 07:03:12', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_2_.json');
[09/20/2024 07:03:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=2&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.415'
        , request_start_time = '0.197'
        , parsing_start_time = '0.737'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.061'
        , search_end_time = '0.111'
        , total_duration = '1.182'
        , error_description = ''
        , memory_used = '6247608'
        WHERE id = '186204837';
[09/20/2024 07:03: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_07_03_11_1726815791_6_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_6_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_6_.json', 'hotelspro', '2024-09-20 07:03:12', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_6_.json');
[09/20/2024 07:03: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_07_03_11_1726815791_3_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_3_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_3_.json', 'hotelspro', '2024-09-20 07:03:12', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_3_.json');
[09/20/2024 07:03:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=6&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.430'
        , request_start_time = '0.234'
        , parsing_start_time = '0.941'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.080'
        , search_end_time = '0.067'
        , total_duration = '1.461'
        , error_description = ''
        , memory_used = '6895816'
        WHERE id = '186204843';
[09/20/2024 07:03:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=3&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.420'
        , request_start_time = '0.222'
        , parsing_start_time = '1.037'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.090'
        , search_end_time = '0.087'
        , total_duration = '1.525'
        , error_description = ''
        , memory_used = '11280384'
        WHERE id = '186204844';
[09/20/2024 07:03: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_07_03_11_1726815791_7_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_7_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_7_.json', 'hotelspro', '2024-09-20 07:03:13', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_7_.json');
[09/20/2024 07:03:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '65'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=7&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.433'
        , request_start_time = '0.188'
        , parsing_start_time = '1.508'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.142'
        , search_end_time = '0.126'
        , total_duration = '2.091'
        , error_description = ''
        , memory_used = '16799432'
        WHERE id = '186204845';
[09/20/2024 07:03: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_07_03_11_1726815791_5_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_5_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_5_.json', 'hotelspro', '2024-09-20 07:03:13', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_5_.json');
[09/20/2024 07:03:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=5&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.426'
        , request_start_time = '0.257'
        , parsing_start_time = '1.831'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.089'
        , search_end_time = '0.160'
        , total_duration = '2.451'
        , error_description = ''
        , memory_used = '11538368'
        WHERE id = '186204846';
[09/20/2024 07:03: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_07_03_11_1726815791_8_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_8_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_8_.json', 'hotelspro', '2024-09-20 07:03:14', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_8_.json');
[09/20/2024 07:03:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '19'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=8&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.435'
        , request_start_time = '0.245'
        , parsing_start_time = '2.632'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.051'
        , search_end_time = '0.034'
        , total_duration = '3.075'
        , error_description = ''
        , memory_used = '4368840'
        WHERE id = '186204848';
[09/20/2024 07:03:16], [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_07_03_11_1726815791_0_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_0_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_0_.json', 'hotelspro', '2024-09-20 07:03:16', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_0_.json');
[09/20/2024 07:03:16], [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_07_03_11_1726815791_4_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_4_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_4_.json', 'hotelspro', '2024-09-20 07:03:16', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_4_.json');
[09/20/2024 07:03:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '26'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=4&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.422'
        , request_start_time = '0.243'
        , parsing_start_time = '5.226'
        , mapping_complete_time = '0.025'
        , mongo_start_time = '0.096'
        , search_end_time = '0.114'
        , total_duration = '5.768'
        , error_description = ''
        , memory_used = '12987000'
        WHERE id = '186204850';
[09/20/2024 07:03: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', 'h2/20_09_2024/request_availability_yogeshqtech_07_03_11_1726815791_1_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_1_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_03_11_1726815791_1_.json', 'hotelspro', '2024-09-20 07:03:17', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_03_11_1726815791_1_.json');
[09/20/2024 07:03:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '96'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=0&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.409'
        , request_start_time = '0.191'
        , parsing_start_time = '5.201'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.351'
        , search_end_time = '0.424'
        , total_duration = '6.262'
        , error_description = ''
        , memory_used = '51488248'
        WHERE id = '186204849';
[09/20/2024 07:03:17], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '91'
        , request_url = '/call.php?s=hotelspro&sessionid=949202024090703099113616877&xml_user_id=949&db_caching=1&&erequest=1&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.412'
        , request_start_time = '0.258'
        , parsing_start_time = '5.479'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.325'
        , search_end_time = '0.378'
        , total_duration = '6.500'
        , error_description = ''
        , memory_used = '48281928'
        WHERE id = '186204851';
[09/20/2024 07:03:18], [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_07_03_11_17268157913.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157913.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157913.json', 'ratehawk', '2024-09-20 07:03:18', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157913.json');
[09/20/2024 07:03:18], [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_07_03_11_17268157910.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157910.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157910.json', 'ratehawk', '2024-09-20 07:03:18', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157910.json');
[09/20/2024 07:03:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '41'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.392'
        , request_start_time = '0.306'
        , parsing_start_time = '6.697'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.099'
        , search_end_time = '0.047'
        , total_duration = '7.179'
        , error_description = ''
        , memory_used = '21339728'
        WHERE id = '186204852';
[09/20/2024 07:03:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.386'
        , request_start_time = '0.132'
        , parsing_start_time = '6.966'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.130'
        , search_end_time = '0.074'
        , total_duration = '7.339'
        , error_description = ''
        , memory_used = '33489528'
        WHERE id = '186204853';
[09/20/2024 07:03: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/20_09_2024/request_availability_yogeshqtech_07_03_11_17268157915.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157915.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157915.json', 'ratehawk', '2024-09-20 07:03:19', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157915.json');
[09/20/2024 07:03:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.399'
        , request_start_time = '0.476'
        , parsing_start_time = '7.305'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.065'
        , search_end_time = '0.030'
        , total_duration = '7.904'
        , error_description = ''
        , memory_used = '9680840'
        WHERE id = '186204854';
[09/20/2024 07:03: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/20_09_2024/request_availability_yogeshqtech_07_03_11_17268157916.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157916.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157916.json', 'ratehawk', '2024-09-20 07:03:19', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157916.json');
[09/20/2024 07:03:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.402'
        , request_start_time = '0.555'
        , parsing_start_time = '7.780'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.099'
        , search_end_time = '0.056'
        , total_duration = '8.519'
        , error_description = ''
        , memory_used = '22944520'
        WHERE id = '186204855';
[09/20/2024 07:03: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_07_03_12_17268157927.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_12_17268157927.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_12_17268157927.json', 'ratehawk', '2024-09-20 07:03:20', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_12_17268157927.json');
[09/20/2024 07:03:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.406'
        , request_start_time = '0.604'
        , parsing_start_time = '8.364'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.043'
        , search_end_time = '0.001'
        , total_duration = '9.036'
        , error_description = ''
        , memory_used = '1572784'
        WHERE id = '186204856';
[09/20/2024 07:03: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_07_03_11_17268157914.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157914.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157914.json', 'ratehawk', '2024-09-20 07:03:20', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157914.json');
[09/20/2024 07:03:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '39'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.397'
        , request_start_time = '0.331'
        , parsing_start_time = '9.044'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.109'
        , search_end_time = '0.055'
        , total_duration = '9.568'
        , error_description = ''
        , memory_used = '29856592'
        WHERE id = '186204857';
[09/20/2024 07:03: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_07_03_11_17268157912.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157912.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157912.json', 'ratehawk', '2024-09-20 07:03:20', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157912.json');
[09/20/2024 07:03:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.389'
        , request_start_time = '0.262'
        , parsing_start_time = '9.296'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.140'
        , search_end_time = '0.078'
        , total_duration = '9.809'
        , error_description = ''
        , memory_used = '38457312'
        WHERE id = '186204858';
[09/20/2024 07:03: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/20_09_2024/request_availability_yogeshqtech_07_03_11_17268157911.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157911.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_03_11_17268157911.json', 'ratehawk', '2024-09-20 07:03:22', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_03_11_17268157911.json');
[09/20/2024 07:03:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '155'
        , request_url = '/call.php?s=ratehawk&sessionid=949202024090703099113616877&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:03:11.387'
        , request_start_time = '0.122'
        , parsing_start_time = '11.255'
        , mapping_complete_time = '0.224'
        , mongo_start_time = '0.553'
        , search_end_time = '0.347'
        , total_duration = '12.338'
        , error_description = ''
        , memory_used = '153975920'
        WHERE id = '186204859';
[09/20/2024 07:03:25], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '493',
        request_path = '/xml_all.php?userid=949&sessionid=949202024090703099113616877',
        duration = '14.758',
        merge_duration = '0.685',
        assigned_supplier_count = '5',
        searched_supplier_count = '3',
        system_load_1_min = '0.09',
        system_load_5_min = '1.01',
        system_load_15_min = '1.16',
        system_memory_usage = '28.18',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16408184') + '6652960',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16408184';
[09/20/2024 07:14:35], [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_07_14_33_1726816473.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_14_33_1726816473.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_14_33_1726816473.json', 'ratehawk', '2024-09-20 07:14:35', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_14_33_1726816473.json');
[09/20/2024 07:14:45], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816485','43.239.53.130');
[09/20/2024 07:14:47], [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_07_14_45_1726816485_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_14_45_1726816485_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_14_45_1726816485_.json', 'hotelspro', '2024-09-20 07:14:47', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_14_45_1726816485_.json');
[09/20/2024 07:14:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816494','43.239.53.130');
[09/20/2024 07:14:55], [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_07_14_54_1726816494_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_14_54_1726816494_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_14_54_1726816494_.json', 'hotelspro', '2024-09-20 07:14:55', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_14_54_1726816494_.json');
[09/20/2024 07:15:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816512','43.239.53.130');
[09/20/2024 07:15:13], [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_07_15_12_1726816512_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_12_1726816512_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_15_12_1726816512_.json', 'hotelspro', '2024-09-20 07:15:13', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_12_1726816512_.json');
[09/20/2024 07:15:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816513','43.239.53.130');
[09/20/2024 07:15:14], [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_07_15_13_1726816513_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_13_1726816513_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_15_13_1726816513_.json', 'hotelspro', '2024-09-20 07:15:14', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_13_1726816513_.json');
[09/20/2024 07:15:18], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816518','43.239.53.130');
[09/20/2024 07:15:21], [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_07_15_18_1726816518_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_18_1726816518_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_15_18_1726816518_.json', 'hotelspro', '2024-09-20 07:15:21', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_18_1726816518_.json');
[09/20/2024 07:15:23], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816523','43.239.53.130');
[09/20/2024 07:15:24], [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_07_15_23_1726816523_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_23_1726816523_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_15_23_1726816523_.json', 'hotelspro', '2024-09-20 07:15:24', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_15_23_1726816523_.json');
[09/20/2024 07:16:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816574','43.239.53.130');
[09/20/2024 07:16:15], [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_07_16_14_1726816574_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_16_14_1726816574_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_16_14_1726816574_.json', 'hotelspro', '2024-09-20 07:16:15', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_16_14_1726816574_.json');
[09/20/2024 07:16:44], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726816604','43.239.53.130');
[09/20/2024 07:16:47], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.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_07_16_46_1726816606_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_16_46_1726816606_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_16_46_1726816606_.json', 'hotelspro', '2024-09-20 07:16:47', '', '949202024090703099113616877', '16408184', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_16_46_1726816606_.json');
[09/20/2024 07:40:13], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-20 07:40:13',login_attempt=0 where id = '949';
[09/20/2024 07:40:13], [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 07:40:13', ip = '43.239.53.130', action = 'Login' ;
[09/20/2024 07:40:28], [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 = 'madrid' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-20 07:40:28' , site_id = '' , country_code = '90' , city_code = '60279' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/20/2024 07:40:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9492020240907402827188001813', session_id='9492020240907402827188001813', Collection_create_time='2024-09-20 07:40:29';
[09/20/2024 07:40:31], [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_07_40_30_1726818030_9_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_9_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_9_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_9_.json');
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '4'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=9&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.242'
        , request_start_time = '0.261'
        , parsing_start_time = '0.482'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.031'
        , search_end_time = '0.038'
        , total_duration = '0.927'
        , error_description = ''
        , memory_used = '2454032'
        WHERE id = '186220316';
[09/20/2024 07:40:31], [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_07_40_30_1726818030_6_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_6_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_6_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_6_.json');
[09/20/2024 07:40:31], [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_07_40_30_1726818030_2_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_2_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_2_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_2_.json');
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '11'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=6&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.232'
        , request_start_time = '0.261'
        , parsing_start_time = '0.591'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.067'
        , search_end_time = '0.053'
        , total_duration = '1.079'
        , error_description = ''
        , memory_used = '6982144'
        WHERE id = '186220319';
[09/20/2024 07:40:31], [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_07_40_30_1726818030_8_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_8_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_8_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_8_.json');
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=2&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.219'
        , request_start_time = '0.274'
        , parsing_start_time = '0.695'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.067'
        , search_end_time = '0.121'
        , total_duration = '1.227'
        , error_description = ''
        , memory_used = '6786208'
        WHERE id = '186220322';
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=8&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.240'
        , request_start_time = '0.285'
        , parsing_start_time = '0.722'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.110'
        , search_end_time = '0.036'
        , total_duration = '1.251'
        , error_description = ''
        , memory_used = '4510424'
        WHERE id = '186220325';
[09/20/2024 07:40:31], [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_07_40_30_1726818030_5_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_5_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_5_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_5_.json');
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=5&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.229'
        , request_start_time = '0.249'
        , parsing_start_time = '1.018'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.109'
        , search_end_time = '0.093'
        , total_duration = '1.525'
        , error_description = ''
        , memory_used = '12326656'
        WHERE id = '186220329';
[09/20/2024 07:40:31], [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_07_40_30_1726818030_3_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_3_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_3_.json', 'hotelspro', '2024-09-20 07:40:31', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_3_.json');
[09/20/2024 07:40:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=3&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.222'
        , request_start_time = '0.311'
        , parsing_start_time = '1.186'
        , mapping_complete_time = '0.026'
        , mongo_start_time = '0.103'
        , search_end_time = '0.098'
        , total_duration = '1.755'
        , error_description = ''
        , memory_used = '13266064'
        WHERE id = '186220331';
[09/20/2024 07:40:32], [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_07_40_30_1726818030_7_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_7_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_7_.json', 'hotelspro', '2024-09-20 07:40:32', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_7_.json');
[09/20/2024 07:40:32], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '66'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=7&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.236'
        , request_start_time = '0.248'
        , parsing_start_time = '1.498'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.122'
        , search_end_time = '0.131'
        , total_duration = '2.125'
        , error_description = ''
        , memory_used = '17044192'
        WHERE id = '186220335';
[09/20/2024 07:40:33], [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_07_40_30_1726818030_1_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_1_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_1_.json', 'hotelspro', '2024-09-20 07:40:33', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_1_.json');
[09/20/2024 07:40:33], [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_07_40_30_1726818030_0_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_0_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_0_.json', 'hotelspro', '2024-09-20 07:40:33', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_0_.json');
[09/20/2024 07:40:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '96'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=0&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.213'
        , request_start_time = '0.230'
        , parsing_start_time = '2.654'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.375'
        , search_end_time = '0.425'
        , total_duration = '3.731'
        , error_description = ''
        , memory_used = '53973328'
        WHERE id = '186220347';
[09/20/2024 07:40:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '95'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=1&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.216'
        , request_start_time = '0.267'
        , parsing_start_time = '2.555'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.382'
        , search_end_time = '0.482'
        , total_duration = '3.762'
        , error_description = ''
        , memory_used = '56137176'
        WHERE id = '186220346';
[09/20/2024 07:40: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', 'h2/20_09_2024/request_availability_yogeshqtech_07_40_30_1726818030_4_.json', 'h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_4_.json', 'h2/20_09_2024/response_header_availability_yogeshqtech_07_40_30_1726818030_4_.json', 'hotelspro', '2024-09-20 07:40:34', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_availability_yogeshqtech_07_40_30_1726818030_4_.json');
[09/20/2024 07:40: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/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180306.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180306.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180306.json', 'ratehawk', '2024-09-20 07:40:34', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180306.json');
[09/20/2024 07:40:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '27'
        , request_url = '/call.php?s=hotelspro&sessionid=9492020240907402827188001813&xml_user_id=949&db_caching=1&&erequest=4&total_request=10&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.225'
        , request_start_time = '0.148'
        , parsing_start_time = '3.956'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.116'
        , search_end_time = '0.117'
        , total_duration = '4.433'
        , error_description = ''
        , memory_used = '14606400'
        WHERE id = '186220366';
[09/20/2024 07:40:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.205'
        , request_start_time = '0.577'
        , parsing_start_time = '3.696'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.104'
        , search_end_time = '0.059'
        , total_duration = '4.474'
        , error_description = ''
        , memory_used = '24280280'
        WHERE id = '186220368';
[09/20/2024 07:40:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180303.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180303.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180303.json', 'ratehawk', '2024-09-20 07:40:41', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180303.json');
[09/20/2024 07:40:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180307.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180307.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180307.json', 'ratehawk', '2024-09-20 07:40:41', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180307.json');
[09/20/2024 07:40:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.209'
        , request_start_time = '0.630'
        , parsing_start_time = '10.968'
        , mapping_complete_time = '0.010'
        , mongo_start_time = '0.046'
        , search_end_time = '0.001'
        , total_duration = '11.679'
        , error_description = ''
        , memory_used = '1572736'
        WHERE id = '186220552';
[09/20/2024 07:40:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180305.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180305.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180305.json', 'ratehawk', '2024-09-20 07:40:41', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180305.json');
[09/20/2024 07:40:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.195'
        , request_start_time = '0.351'
        , parsing_start_time = '11.234'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.106'
        , search_end_time = '0.047'
        , total_duration = '11.774'
        , error_description = ''
        , memory_used = '21959744'
        WHERE id = '186220551';
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180300.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180300.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180300.json', 'ratehawk', '2024-09-20 07:40:42', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180300.json');
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.201'
        , request_start_time = '0.383'
        , parsing_start_time = '11.344'
        , mapping_complete_time = '0.021'
        , mongo_start_time = '0.070'
        , search_end_time = '0.037'
        , total_duration = '11.867'
        , error_description = ''
        , memory_used = '11026240'
        WHERE id = '186220557';
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180304.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180304.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180304.json', 'ratehawk', '2024-09-20 07:40:42', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180304.json');
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180302.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180302.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180302.json', 'ratehawk', '2024-09-20 07:40:42', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180302.json');
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.184'
        , request_start_time = '0.270'
        , parsing_start_time = '11.532'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.131'
        , search_end_time = '0.075'
        , total_duration = '12.049'
        , error_description = ''
        , memory_used = '35339456'
        WHERE id = '186220558';
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '39'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.197'
        , request_start_time = '0.361'
        , parsing_start_time = '11.525'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.127'
        , search_end_time = '0.058'
        , total_duration = '12.107'
        , error_description = ''
        , memory_used = '32265296'
        WHERE id = '186220565';
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.189'
        , request_start_time = '0.176'
        , parsing_start_time = '11.731'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.146'
        , search_end_time = '0.080'
        , total_duration = '12.174'
        , error_description = ''
        , memory_used = '40334904'
        WHERE id = '186220568';
[09/20/2024 07:40:42], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_40_30_17268180301.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180301.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_30_17268180301.json', 'ratehawk', '2024-09-20 07:40:42', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_30_17268180301.json');
[09/20/2024 07:40:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '156'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907402827188001813&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:40:30.185'
        , request_start_time = '0.111'
        , parsing_start_time = '12.251'
        , mapping_complete_time = '0.241'
        , mongo_start_time = '0.573'
        , search_end_time = '0.317'
        , total_duration = '13.321'
        , error_description = ''
        , memory_used = '171654824'
        WHERE id = '186220587';
[09/20/2024 07:40:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '500',
        request_path = '/xml_all.php?userid=949&sessionid=9492020240907402827188001813',
        duration = '15.942',
        merge_duration = '0.716',
        assigned_supplier_count = '5',
        searched_supplier_count = '3',
        system_load_1_min = '3.92',
        system_load_5_min = '3.03',
        system_load_15_min = '1.94',
        system_memory_usage = '34.06',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16409318') + '6898024',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16409318';
[09/20/2024 07:41:01], [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_07_40_59_1726818059.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_40_59_1726818059.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_40_59_1726818059.json', 'ratehawk', '2024-09-20 07:41:01', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_40_59_1726818059.json');
[09/20/2024 07:41:06], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818066','43.239.53.130');
[09/20/2024 07:41:08], [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_07_41_06_1726818066_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_06_1726818066_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_41_06_1726818066_.json', 'hotelspro', '2024-09-20 07:41:08', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_06_1726818066_.json');
[09/20/2024 07:41:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818073','43.239.53.130');
[09/20/2024 07:41:19], [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_07_41_13_1726818073_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_13_1726818073_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_41_13_1726818073_.json', 'hotelspro', '2024-09-20 07:41:19', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_13_1726818073_.json');
[09/20/2024 07:41:27], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818087','43.239.53.130');
[09/20/2024 07:41:28], [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_07_41_27_1726818087_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_27_1726818087_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_41_27_1726818087_.json', 'hotelspro', '2024-09-20 07:41:28', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_27_1726818087_.json');
[09/20/2024 07:41:53], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818113','43.239.53.130');
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.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_07_41_55_1726818115_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_55_1726818115_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_41_55_1726818115_.json', 'hotelspro', '2024-09-20 07:41:57', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_55_1726818115_.json');
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'hotelspro', reservation_id = '2031789', create_date = '2024-09-20 07:41:55', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'madrid', country_id = '90', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '209.7', display_currency_code = 'USD', native_room_rate = '204.59', native_currency_code = 'USD', supplier_profile_id = '6', service_type = 'hotel', service_date = '2024/10/31', check_out_date = '2024/11/01', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Bhavesh', leader_last_name = 'Gurav', status_date = '2024-09-20 07:41:55';
[09/20/2024 07:41:57], [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 ('141435','HOTEL EUROSTARS CENTRAL','Hotel Eurostars Central','190446','OT000431719','madrid','hotelspro',NOW());
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='141435'
		;
[09/20/2024 07:41:57], [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('141435','2031789','','1','2','0','-','','','190446','Hotel Eurostars Central','Calle Mejia Lequerica, 10 ','+34913967180','4.0','1','2024/10/31','2024/11/01','','https://betalive.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vbG9kZ2luZy8yMDAwMDAwLzE3NTAwMDAvMTc0MzYwMC8xNzQzNTc2L2RkNzgzYTQ0X2IuanBn');
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '141435', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'Standard Room-Double room 2 Adults 0 Child Room only Double', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:209.69999999999999;s:25:"displayNightlyRateDisplay";s:164:"Rate - 204.59 USD, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 2.50%, Markup Amount - 0,Markup Amount in USD - 0.00, Supplier Commission - 0,  #hotelspro";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:204.59;}}', native_room_rate_total = '204.59', display_room_rate_total = '209.7', number_of_rooms = '1', room_category = 'Standard Room-Double room', meal_basis = 'Room only';
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '141435', booking_detail_id = '1', rid = '155348', room = '0', salutations = 'Mr', first_name = 'Bhavesh', last_name = 'Gurav', passenger_type = 'adult', age = '';
[09/20/2024 07:41:57], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '141435', booking_detail_id = '1', rid = '155348', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[09/20/2024 07:42:02], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.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_07_41_57_1726818117_.json', 'h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_57_1726818117_.json', 'h2/20_09_2024/response_header_pre_reservation_yogeshqtech_07_41_57_1726818117_.json', 'hotelspro', '2024-09-20 07:42:02', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_pre_reservation_yogeshqtech_07_41_57_1726818117_.json');
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.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 ('', 'RESERVATION', 'h2/20_09_2024/request_reservation_yogeshqtech_07_42_02_1726818122_.json', 'h2/20_09_2024/response_reservation_yogeshqtech_07_42_02_1726818122_.json', 'h2/20_09_2024/response_header_reservation_yogeshqtech_07_42_02_1726818122_.json', 'hotelspro', '2024-09-20 07:42:05', '', '9492020240907402827188001813', '16409318', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_reservation_yogeshqtech_07_42_02_1726818122_.json');
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '25541335', confirmation_number = '102-17866475', display_discount = '0', cancellation_policy = 'The latest deadline to cancel this booking without charges is 26-10-2024 05:30 hrs.<BR>Late amendment charges may apply.<br><BR><B><U>Detailed Cancellation Policy:</U></B><br>Cancellation after 26-10-2024 05:30 hrs will be as 209.7 USD Charge(s) .<br>', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-10-26 00:00:00', comment_contract = ' .  Car park NO.Check-in hour 18:00-00:00.Identification card at arrival.Online Check-out.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' .  Car park NO.Check-in hour 18:00-00:00.Identification card at arrival.Online Check-out.', backoffice_user = 'Bhavesh_qtech', customer_id = '', applied_multiplier='1.00000',  applied_markup='2.5',  agent_markup='2.5',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='209.7',  applicable_service_tax='0',  supplier_rate='204.59',  uid='78614e4df57fee93fbc1f02c1d4a895a'  where id='141435';
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='141435';
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('141435','40.42706372','-3.69853998');
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-09-20 07:42:05',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;141435\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -141435 And Booking Status - confirmed',`ip`= '43.239.53.130';
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='141435' ;
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('2031789','141435','confirmed','2024-09-20 07:42:05','Booking confirmed. Booked by Back Office Bhavesh_qtech on behalf of Agent - Deepak  Trivedi(CD0949)','949','43.239.53.130','0','949');
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,applied_agent_charges)  VALUES('141435','209.7');
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='141435',status='1' where reservation_id='2031789' and booking_id ='0';
[09/20/2024 07:42:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='141435' where agent_logs_id='16409318' and source_type='hotelspro';
[09/20/2024 07:42:06], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('141435','deepak.trivedi@qtechsoftware.com');
[09/20/2024 07:42:06], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('141435','demo@demo.demo');
[09/20/2024 07:42:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('141435','ops@astrabookings.com');
[09/20/2024 07:42:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('141435','info@astrabookings.com');
[09/20/2024 07:42:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('141435','ops@astrabookings.com');
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '33' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '33' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '33' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '1' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:44:22], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-20 07:44:22',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-949 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-949 ## supplier_id- 96 ## company_name - GRNConnect - TGX ## supplier_code-grnconnecttgx  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-949 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-949 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 72 ',`ip`= '43.239.53.130';
[09/20/2024 07:44:38], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-20 07:44:38',login_attempt=0 where id = '949';
[09/20/2024 07:44:38], [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 07:44:38', ip = '43.239.53.130', action = 'Login' ;
[09/20/2024 07:49:35], [file name :-/efsdata/otrams/public_html/beta/tms/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('141435', 'CANCELLATION_FEE', 'h2/20_09_2024/request_cancellation_fee__141435_07_49_34_1726818574_.json', 'h2/20_09_2024/response_cancellation_fee__141435_07_49_34_1726818574_.json', 'h2/20_09_2024/response_header_cancellation_fee__141435_07_49_34_1726818574_.json', 'hotelspro', '2024-09-20 07:49:35', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_cancellation_fee__141435_07_49_34_1726818574_.json');
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('141435', 'CANCEL', 'h2/20_09_2024/request_cancel__141435_07_49_39_1726818579_.json', 'h2/20_09_2024/response_cancel__141435_07_49_39_1726818579_.json', 'h2/20_09_2024/response_header_cancel__141435_07_49_39_1726818579_.json', 'hotelspro', '2024-09-20 07:49:41', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/h2/20_09_2024/response_cancel__141435_07_49_39_1726818579_.json');
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],INSERT INTO history_bookings set history_booking_id ='141435', agent_id ='949', itenirary_id ='25541335', confirmation_number ='102-17866475', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='bahvesh.gurav@qtechsoftware.com', leader_title ='Mr', leader_first_name ='Bhavesh', leader_last_name ='Gurav', city_id ='madrid', country_id ='90', display_room_rate ='209.700', native_room_rate ='204.590', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='The latest deadline to cancel this booking without charges is 26-10-2024 05:30 hrs.<BR>Late amendment charges may apply.<br><BR><B><U>Detailed Cancellation Policy:</U></B><br>Cancellation after 26-10-2024 05:30 hrs will be as 209.7 USD Charge(s) .<br>', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2024-09-20 07:41:55', create_date ='2024-09-20 07:41:55', source_type ='hotelspro', expiration_date ='2024-10-26 00:00:00', comment_contract =' .  Car park NO.Check-in hour 18:00-00:00.Identification card at arrival.Online Check-out.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='209.700', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='204.590', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Bhavesh_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='2.5', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='2.5', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-09-20 07:49:41', modified_by ='Bhavesh_qtech', display_currency_code ='USD', created_datetime ='2024-09-20 07:49:41', sub_agent_rate ='0.000', created_by ='Bhavesh_qtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='43.239.53.130', is_cancel_history ='1';
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','141435','cancelled','2024-09-20 07:49:41',' by Bhavesh_qtech','Bhavesh_qtech','43.239.53.130','Bhavesh_qtech','','');
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],UPDATE bookings SET current_status='cancelled',status_date='2024-09-20 07:49:41' , pending_cancellation = 'no' WHERE reservation_id = '2031789' AND id = '141435' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],update booking_commission set status='D'  where booking_id ='141435';
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '141435' AND (current_status = 'cancelled' ) ;
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],delete from cancellations where booking_id =? ;
[09/20/2024 07:49:41], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('0','0','USD','USD','2031789','141435','2024-09-20 07:49:41','','Cancelled. ');
[09/20/2024 07:49:43], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('141435','deepak.trivedi@qtechsoftware.com');
[09/20/2024 07:49:43], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('141435','demo@demo.demo');
[09/20/2024 07:49:45], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('141435','ops@astrabookings.com');
[09/20/2024 07:49:45], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('141435','info@astrabookings.com');
[09/20/2024 07:49:45], [file name :-/efsdata/otrams/public_html/beta/tms/view_booking.php],insert into temp(booking_id,mail_send_to)values('141435','ops@astrabookings.com');
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '33' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '33' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '33' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '33';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '1' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/20/2024 07:50:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-20 07:50:36',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;33\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;33\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 72 ',`ip`= '43.239.53.130';
[09/20/2024 07:50:39], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-20 07:50:39',login_attempt=0 where id = '949';
[09/20/2024 07:50:39], [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 07:50:39', ip = '43.239.53.130', action = 'Login' ;
[09/20/2024 07:50:56], [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 = 'madrid' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-20 07:50:56' , site_id = '' , country_code = '90' , city_code = '60279' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/20/2024 07:50:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9492020240907505611938944234', session_id='9492020240907505611938944234', Collection_create_time='2024-09-20 07:50:57';
[09/20/2024 07:51:02], [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_07_50_58_17268186585.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186585.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186585.json', 'ratehawk', '2024-09-20 07:51:02', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186585.json');
[09/20/2024 07:51:02], [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_07_50_58_17268186586.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186586.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186586.json', 'ratehawk', '2024-09-20 07:51:02', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186586.json');
[09/20/2024 07:51:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '16'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.884'
        , request_start_time = '0.397'
        , parsing_start_time = '4.302'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.075'
        , search_end_time = '0.052'
        , total_duration = '4.851'
        , error_description = ''
        , memory_used = '11124584'
        WHERE id = '186225786';
[09/20/2024 07:51:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.888'
        , request_start_time = '0.519'
        , parsing_start_time = '4.277'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.107'
        , search_end_time = '0.082'
        , total_duration = '5.015'
        , error_description = ''
        , memory_used = '24220440'
        WHERE id = '186225787';
[09/20/2024 07:51:02], [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_07_50_58_17268186587.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186587.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186587.json', 'ratehawk', '2024-09-20 07:51:02', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186587.json');
[09/20/2024 07:51:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.889'
        , request_start_time = '0.524'
        , parsing_start_time = '4.552'
        , mapping_complete_time = '0.015'
        , mongo_start_time = '0.048'
        , search_end_time = '0.001'
        , total_duration = '5.150'
        , error_description = ''
        , memory_used = '1572736'
        WHERE id = '186225788';
[09/20/2024 07:51:03], [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_07_50_58_17268186583.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186583.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186583.json', 'ratehawk', '2024-09-20 07:51:03', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186583.json');
[09/20/2024 07:51:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.880'
        , request_start_time = '0.204'
        , parsing_start_time = '5.219'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.102'
        , search_end_time = '0.050'
        , total_duration = '5.604'
        , error_description = ''
        , memory_used = '21913792'
        WHERE id = '186225789';
[09/20/2024 07:51:04], [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_07_50_58_17268186581.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186581.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186581.json', 'ratehawk', '2024-09-20 07:51:04', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186581.json');
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '156'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.875'
        , request_start_time = '0.106'
        , parsing_start_time = '6.208'
        , mapping_complete_time = '0.233'
        , mongo_start_time = '0.565'
        , search_end_time = '0.317'
        , total_duration = '7.255'
        , error_description = ''
        , memory_used = '169056408'
        WHERE id = '186225790';
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_50_58_17268186582.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186582.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186582.json', 'ratehawk', '2024-09-20 07:51:05', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186582.json');
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_50_58_17268186580.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186580.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186580.json', 'ratehawk', '2024-09-20 07:51:05', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186580.json');
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '51'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.876'
        , request_start_time = '0.151'
        , parsing_start_time = '7.119'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.149'
        , search_end_time = '0.089'
        , total_duration = '7.539'
        , error_description = ''
        , memory_used = '41070768'
        WHERE id = '186225791';
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.872'
        , request_start_time = '0.109'
        , parsing_start_time = '7.392'
        , mapping_complete_time = '0.056'
        , mongo_start_time = '0.135'
        , search_end_time = '0.072'
        , total_duration = '7.739'
        , error_description = ''
        , memory_used = '34085936'
        WHERE id = '186225792';
[09/20/2024 07:51:05], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/20_09_2024/request_availability_yogeshqtech_07_50_58_17268186584.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186584.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_50_58_17268186584.json', 'ratehawk', '2024-09-20 07:51:05', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_50_58_17268186584.json');
[09/20/2024 07:51:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '39'
        , request_url = '/call.php?s=ratehawk&sessionid=9492020240907505611938944234&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-20 07:50:57.881'
        , request_start_time = '0.338'
        , parsing_start_time = '7.739'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.131'
        , search_end_time = '0.055'
        , total_duration = '8.293'
        , error_description = ''
        , memory_used = '31598320'
        WHERE id = '186225793';
[09/20/2024 07:51:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '389',
        request_path = '/xml_all.php?userid=949&sessionid=9492020240907505611938944234',
        duration = '10.747',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.27',
        system_load_5_min = '0.92',
        system_load_15_min = '1.31',
        system_memory_usage = '34.71',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16409720') + '2923064',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16409720';
[09/20/2024 07:51:23], [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_07_51_21_1726818681.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_51_21_1726818681.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_51_21_1726818681.json', 'ratehawk', '2024-09-20 07:51:23', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_51_21_1726818681.json');
[09/20/2024 07:51:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818694','43.239.53.130');
[09/20/2024 07:51:40], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818700','43.239.53.130');
[09/20/2024 07:51:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818701','43.239.53.130');
[09/20/2024 07:52:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818724','43.239.53.130');
[09/20/2024 07:52:05], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: yogeshqtech)<br><br>City:madrid<br><br>Arrival Date:31/10/2024<br><br>Departure Date:01/11/2024<br><br>Supplier:ratehawk<br><br>Hotel:HOTEL EUROSTARS CENTRAL<br><br>Room:Double room (full double bed) (queen size bed) (Room Only)
',  email_sent ='yes', create_date ='2024-09-20 07:52:05', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[09/20/2024 07:52:26], [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_07_52_24_1726818744.json', 'rh/20_09_2024/response_availability_yogeshqtech_07_52_24_1726818744.json', 'rh/20_09_2024/response_header_availability_yogeshqtech_07_52_24_1726818744.json', 'ratehawk', '2024-09-20 07:52:26', '', '9492020240907505611938944234', '16409720', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/20_09_2024/response_availability_yogeshqtech_07_52_24_1726818744.json');
[09/20/2024 07:52:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818751','43.239.53.130');
[09/20/2024 07:52:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818754','43.239.53.130');
[09/20/2024 07:52:40], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1726818760','43.239.53.130');
[09/20/2024 07:52:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: yogeshqtech)<br><br>City:madrid<br><br>Arrival Date:31/10/2024<br><br>Departure Date:01/11/2024<br><br>Supplier:ratehawk<br><br>Hotel:HOTEL EUROSTARS CENTRAL<br><br>Room:Double room (full double bed) (Room Only)
',  email_sent ='yes', create_date ='2024-09-20 07:52:41', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
