[10/03/2024 05:00:05], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931605','43.239.53.130');
[10/03/2024 05:00:05], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_05_1727931605_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_05_1727931605_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_05_1727931605_.json', 'agoda', '2024-10-03 05:00:05', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_05_1727931605_.json');
[10/03/2024 05:00:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931612','43.239.53.130');
[10/03/2024 05:00:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_12_1727931612_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_12_1727931612_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_12_1727931612_.json', 'agoda', '2024-10-03 05:00:12', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_12_1727931612_.json');
[10/03/2024 05:00:15], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931615','43.239.53.130');
[10/03/2024 05:00: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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_15_1727931615_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_15_1727931615_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_15_1727931615_.json', 'agoda', '2024-10-03 05:00:15', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_15_1727931615_.json');
[10/03/2024 05:00:16], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931616','43.239.53.130');
[10/03/2024 05:00:16], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_16_1727931616_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_16_1727931616_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_16_1727931616_.json', 'agoda', '2024-10-03 05:00:16', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_16_1727931616_.json');
[10/03/2024 05:00:23], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931623','43.239.53.130');
[10/03/2024 05:00:23], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_23_1727931623_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_23_1727931623_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_23_1727931623_.json', 'agoda', '2024-10-03 05:00:23', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_23_1727931623_.json');
[10/03/2024 05:00:29], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931629','43.239.53.130');
[10/03/2024 05:00:30], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_29_1727931629_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_29_1727931629_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_29_1727931629_.json', 'agoda', '2024-10-03 05:00:30', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_29_1727931629_.json');
[10/03/2024 05:00:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931634','43.239.53.130');
[10/03/2024 05:00:34], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_34_1727931634_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_34_1727931634_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_34_1727931634_.json', 'agoda', '2024-10-03 05:00:34', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_34_1727931634_.json');
[10/03/2024 05:00:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931638','43.239.53.130');
[10/03/2024 05:00:38], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_00_38_1727931638_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_38_1727931638_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_00_38_1727931638_.json', 'agoda', '2024-10-03 05:00:38', '', '1089032024100459345476504853', '16663738', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_00_38_1727931638_.json');
[10/03/2024 05:03:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/11/13' , departure_date = '2024/11/14' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:03:37' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:03:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005033769289257939', session_id='10890320241005033769289257939', Collection_create_time='2024-10-03 05:03:37';
[10/03/2024 05:03:39], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '103',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005033769289257939',
        duration = '2.056',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.65',
        system_load_5_min = '0.79',
        system_load_15_min = '0.40',
        system_memory_usage = '13.17',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663742') + '2037632',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663742';
[10/03/2024 05:04:09], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931849','43.239.53.130');
[10/03/2024 05:04:10], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_04_09_1727931849_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_09_1727931849_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_04_09_1727931849_.json', 'agoda', '2024-10-03 05:04:10', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_09_1727931849_.json');
[10/03/2024 05:04:20], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931860','43.239.53.130');
[10/03/2024 05:04:20], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_04_20_1727931860_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_20_1727931860_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_04_20_1727931860_.json', 'agoda', '2024-10-03 05:04:20', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_20_1727931860_.json');
[10/03/2024 05:04:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727931866','43.239.53.130');
[10/03/2024 05:04:27], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_04_26_1727931866_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_26_1727931866_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_04_26_1727931866_.json', 'agoda', '2024-10-03 05:04:27', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_04_26_1727931866_.json');
[10/03/2024 05:08:27], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932107','43.239.53.130');
[10/03/2024 05:08:27], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_08_27_1727932107_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_27_1727932107_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_08_27_1727932107_.json', 'agoda', '2024-10-03 05:08:27', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_27_1727932107_.json');
[10/03/2024 05:08:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932113','43.239.53.130');
[10/03/2024 05:08:33], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_08_33_1727932113_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_33_1727932113_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_08_33_1727932113_.json', 'agoda', '2024-10-03 05:08:33', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_33_1727932113_.json');
[10/03/2024 05:08:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932118','43.239.53.130');
[10/03/2024 05:08:39], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_08_38_1727932118_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_38_1727932118_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_08_38_1727932118_.json', 'agoda', '2024-10-03 05:08:39', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_38_1727932118_.json');
[10/03/2024 05:08:44], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932124','43.239.53.130');
[10/03/2024 05:08:44], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_08_44_1727932124_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_44_1727932124_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_08_44_1727932124_.json', 'agoda', '2024-10-03 05:08:44', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_44_1727932124_.json');
[10/03/2024 05:08:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932134','43.239.53.130');
[10/03/2024 05:08:54], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_08_54_1727932134_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_54_1727932134_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_08_54_1727932134_.json', 'agoda', '2024-10-03 05:08:54', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_08_54_1727932134_.json');
[10/03/2024 05:09:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932140','43.239.53.130');
[10/03/2024 05:09:00], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_09_00_1727932140_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_09_00_1727932140_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_09_00_1727932140_.json', 'agoda', '2024-10-03 05:09:00', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_09_00_1727932140_.json');
[10/03/2024 05:09:11], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932151','43.239.53.130');
[10/03/2024 05:09:11], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_09_11_1727932151_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_09_11_1727932151_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_09_11_1727932151_.json', 'agoda', '2024-10-03 05:09:11', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_09_11_1727932151_.json');
[10/03/2024 05:09:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'PRECHECK', 'a5/03_10_2024/request_precheck_Test_DoNotUse_05_09_11_1727932151_.json', 'a5/03_10_2024/response_precheck_Test_DoNotUse_05_09_11_1727932151_.json', 'a5/03_10_2024/response_header_precheck_Test_DoNotUse_05_09_11_1727932151_.json', 'agoda', '2024-10-03 05:09:12', '', '10890320241005033769289257939', '16663742', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_precheck_Test_DoNotUse_05_09_11_1727932151_.json');
[10/03/2024 05:09:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/11/13' , departure_date = '2024/11/14' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:09:29' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:09:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005092996056049690', session_id='10890320241005092996056049690', Collection_create_time='2024-10-03 05:09:29';
[10/03/2024 05:09:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '102',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005092996056049690',
        duration = '2.056',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.19',
        system_load_5_min = '0.43',
        system_load_15_min = '0.37',
        system_memory_usage = '24.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663750') + '2037544',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663750';
[10/03/2024 05:09:48], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/11/13' , departure_date = '2024/11/14' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:09:48' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:09:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005094866001948391', session_id='10890320241005094866001948391', Collection_create_time='2024-10-03 05:09:49';
[10/03/2024 05:09:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '105',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005094866001948391',
        duration = '2.056',
        merge_duration = '0.012',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.14',
        system_load_5_min = '0.40',
        system_load_15_min = '0.36',
        system_memory_usage = '24.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663751') + '2038064',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663751';
[10/03/2024 05:10:01], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932201','43.239.53.130');
[10/03/2024 05:10:02], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_10_01_1727932201_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_10_01_1727932201_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_10_01_1727932201_.json', 'agoda', '2024-10-03 05:10:02', '', '10890320241005094866001948391', '16663751', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_10_01_1727932201_.json');
[10/03/2024 05:13:30], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/11/13' , departure_date = '2024/11/14' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:13:30' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:13:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005133099555372772', session_id='10890320241005133099555372772', Collection_create_time='2024-10-03 05:13:31';
[10/03/2024 05:13:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '103',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005133099555372772',
        duration = '2.055',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.40',
        system_load_5_min = '0.75',
        system_load_15_min = '0.56',
        system_memory_usage = '26.72',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663768') + '2037544',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663768';
[10/03/2024 05:17:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932624','43.239.53.130');
[10/03/2024 05:17:04], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_17_04_1727932624_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_17_04_1727932624_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_17_04_1727932624_.json', 'agoda', '2024-10-03 05:17:04', '', '10890320241005133099555372772', '16663768', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_17_04_1727932624_.json');
[10/03/2024 05:18:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727932734','43.239.53.130');
[10/03/2024 05:18:54], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_18_54_1727932734_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_18_54_1727932734_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_18_54_1727932734_.json', 'agoda', '2024-10-03 05:18:54', '', '10890320241005133099555372772', '16663768', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_18_54_1727932734_.json');
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '101' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:40:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-10-03 05:40:55',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;4320\&#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;1089\&#039;,supplier_id = 58 ,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;1089\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;120\&#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;1089\&#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;1089\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#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;1089\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 102 ,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;1089\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#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;1089\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 103 ,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;1089\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#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;1089\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1089\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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-1089 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 4320 ',`ip`= '43.239.53.130';
[10/03/2024 05:40:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-10-03 05:40:59',login_attempt=0 where id = '1089';
[10/03/2024 05:40:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-10-03 05:40:59', ip = '43.239.53.130', action = 'Login' ;
[10/03/2024 05:41:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/15' , departure_date = '2024/10/16' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:41:10' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:41:11], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005411074503459551', session_id='10890320241005411074503459551', Collection_create_time='2024-10-03 05:41:11';
[10/03/2024 05:41:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '544',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005411074503459551',
        duration = '3.069',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.96',
        system_load_5_min = '2.41',
        system_load_15_min = '1.09',
        system_memory_usage = '41.83',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663852') + '2037192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663852';
[10/03/2024 05:41:32], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/22' , departure_date = '2024/10/23' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:41:32' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:41:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005413260534154487', session_id='10890320241005413260534154487', Collection_create_time='2024-10-03 05:41:33';
[10/03/2024 05:41:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '89',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005413260534154487',
        duration = '2.061',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.27',
        system_load_5_min = '2.30',
        system_load_15_min = '1.08',
        system_memory_usage = '41.58',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663853') + '2037552',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663853';
[10/03/2024 05:42:08], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934128','43.239.53.130');
[10/03/2024 05:42:09], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_42_08_1727934128_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_42_08_1727934128_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_42_08_1727934128_.json', 'agoda', '2024-10-03 05:42:09', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_42_08_1727934128_.json');
[10/03/2024 05:42:18], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934138','43.239.53.130');
[10/03/2024 05:42:18], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_42_18_1727934138_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_42_18_1727934138_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_42_18_1727934138_.json', 'agoda', '2024-10-03 05:42:18', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_42_18_1727934138_.json');
[10/03/2024 05:42: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 ('', 'PRECHECK', 'a5/03_10_2024/request_precheck_Test_DoNotUse_05_42_18_1727934138_.json', 'a5/03_10_2024/response_precheck_Test_DoNotUse_05_42_18_1727934138_.json', 'a5/03_10_2024/response_header_precheck_Test_DoNotUse_05_42_18_1727934138_.json', 'agoda', '2024-10-03 05:42:19', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_precheck_Test_DoNotUse_05_42_18_1727934138_.json');
[10/03/2024 05:43:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET credit_value=credit_value+'1'1089''1089''1089''1089'' WHERE id= ?;
[10/03/2024 05:43:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',search_merging_method= '',accounting_name= '',first_name= 'Jaison',middle_name= '',last_name= 'Jamess',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '10100',credit_limit= '10100',credit_distribution= '0',temp_credit_limit= '0',address= 'Mumbai',other_language_address= '',city= '71649',pincode= '',country= '138',time_zone_offset= '3',enable_dst= '',branch_id='26',phone= '91-99999999',mobile= '91-9999999999',fax= '',currency= '6',email= 'jaison.james@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2024-10-03 05:43:52',consultant_id= 'jaison_qtech',agency_email= '',acc_name= 'SAYALI',acc_email= 'jaison.james@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '', allow_login_otp= '', allow_booking_otp= '',allow_credit_use= '1' WHERE id= '1089';
[10/03/2024 05:43:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-10-03 05:43:52',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,search_merging_method= ,accounting_name= \&#039;\&#039;,first_name= \&#039;Jaison\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Jamess\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;10100\&#039;,credit_limit= \&#039;10100\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;0\&#039;,address= \&#039;Mumbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;71649\&#039;,pincode= \&#039;\&#039;,country= \&#039;138\&#039;,time_zone_offset= \&#039;3\&#039;,enable_dst= 0,branch_id=\&#039;26\&#039;,phone= \&#039;91-99999999\&#039;,mobile= \&#039;91-9999999999\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;jaison.james@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 1,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2024-10-03 05:43:52\&#039;,consultant_id= \&#039;jaison_qtech\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;SAYALI\&#039;,acc_email= \&#039;jaison.james@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0, allow_login_otp= 0, allow_booking_otp= 0,allow_credit_use= 1 WHERE id= \&#039;1089\&#039;',`log_description`= 'Agent 1089 updated For  - credit_limit=100.000&credit_limit_assigned=100.000&credit_value=100.000&modify_date=2024-10-02+05%3A13%3A14 changed to - credit_limit=10100.000&credit_limit_assigned=10100&credit_value=10100.000&modify_date=2024-10-03+05%3A43%3A52',`ip`= '43.239.53.130';
[10/03/2024 05:43:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'1089' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[10/03/2024 05:43:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '1089',credit_value= '10100.000',credit_usage= '0.000',credit_limit= '10100.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='Qtech_pranali',temp_credit_limit='0',log_type='Edit_Agent',note='Agent Edited by Qtech_pranali',create_date='2024-10-03 05:10:53';
[10/03/2024 05:43:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '26',consultant_id= 'jaison_qtech',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '1089';
[10/03/2024 05:48:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934511','43.239.53.130');
[10/03/2024 05:48:31], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_48_31_1727934511_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_48_31_1727934511_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_48_31_1727934511_.json', 'agoda', '2024-10-03 05:48:31', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_48_31_1727934511_.json');
[10/03/2024 05:48:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934518','43.239.53.130');
[10/03/2024 05:48:38], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_48_38_1727934518_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_48_38_1727934518_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_48_38_1727934518_.json', 'agoda', '2024-10-03 05:48:38', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_48_38_1727934518_.json');
[10/03/2024 05:48:39], [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 ('', 'PRECHECK', 'a5/03_10_2024/request_precheck_Test_DoNotUse_05_48_38_1727934518_.json', 'a5/03_10_2024/response_precheck_Test_DoNotUse_05_48_38_1727934518_.json', 'a5/03_10_2024/response_header_precheck_Test_DoNotUse_05_48_38_1727934518_.json', 'agoda', '2024-10-03 05:48:39', '', '10890320241005413260534154487', '16663853', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_precheck_Test_DoNotUse_05_48_38_1727934518_.json');
[10/03/2024 05:49:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/22' , departure_date = '2024/10/23' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:49:35' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:49:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005493541667693905', session_id='10890320241005493541667693905', Collection_create_time='2024-10-03 05:49:35';
[10/03/2024 05:49:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '92',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005493541667693905',
        duration = '2.057',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.43',
        system_load_5_min = '1.83',
        system_load_15_min = '1.57',
        system_memory_usage = '48.14',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663860') + '2037208',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663860';
[10/03/2024 05:49:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934594','43.239.53.130');
[10/03/2024 05:49:54], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_49_54_1727934594_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_49_54_1727934594_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_49_54_1727934594_.json', 'agoda', '2024-10-03 05:49:54', '', '10890320241005493541667693905', '16663860', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_49_54_1727934594_.json');
[10/03/2024 05:51:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/22' , departure_date = '2024/10/23' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:51:37' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:51:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005513798857159400', session_id='10890320241005513798857159400', Collection_create_time='2024-10-03 05:51:38';
[10/03/2024 05:51:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '92',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005513798857159400',
        duration = '2.054',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.59',
        system_load_5_min = '1.50',
        system_load_15_min = '1.49',
        system_memory_usage = '48.18',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663861') + '2037208',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663861';
[10/03/2024 05:52:03], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/22' , departure_date = '2024/10/23' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-03 05:52:03' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/03/2024 05:52:04], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890320241005520394705094676', session_id='10890320241005520394705094676', Collection_create_time='2024-10-03 05:52:04';
[10/03/2024 05:52:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '92',
        request_path = '/xml_all.php?userid=1089&sessionid=10890320241005520394705094676',
        duration = '2.062',
        merge_duration = '0.010',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.52',
        system_load_5_min = '1.42',
        system_load_15_min = '1.46',
        system_memory_usage = '48.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16663862') + '2037152',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16663862';
[10/03/2024 05:52:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934744','43.239.53.130');
[10/03/2024 05:52: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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_52_24_1727934744_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_52_24_1727934744_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_52_24_1727934744_.json', 'agoda', '2024-10-03 05:52:24', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_52_24_1727934744_.json');
[10/03/2024 05:52:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727934753','43.239.53.130');
[10/03/2024 05:52:33], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_52_33_1727934753_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_52_33_1727934753_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_52_33_1727934753_.json', 'agoda', '2024-10-03 05:52:33', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_52_33_1727934753_.json');
[10/03/2024 05:52:34], [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 ('', 'PRECHECK', 'a5/03_10_2024/request_precheck_Test_DoNotUse_05_52_33_1727934753_.json', 'a5/03_10_2024/response_precheck_Test_DoNotUse_05_52_33_1727934753_.json', 'a5/03_10_2024/response_header_precheck_Test_DoNotUse_05_52_33_1727934753_.json', 'agoda', '2024-10-03 05:52:34', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_precheck_Test_DoNotUse_05_52_33_1727934753_.json');
[10/03/2024 05:56:46], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727935006','43.239.53.130');
[10/03/2024 05:56:46], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_56_46_1727935006_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_56_46_1727935006_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_56_46_1727935006_.json', 'agoda', '2024-10-03 05:56:46', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_56_46_1727935006_.json');
[10/03/2024 05:57:05], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727935025','43.239.53.130');
[10/03/2024 05:57:05], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_57_05_1727935025_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_05_1727935025_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_57_05_1727935025_.json', 'agoda', '2024-10-03 05:57:05', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_05_1727935025_.json');
[10/03/2024 05:57:10], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727935030','43.239.53.130');
[10/03/2024 05:57:11], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_57_10_1727935030_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_10_1727935030_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_57_10_1727935030_.json', 'agoda', '2024-10-03 05:57:11', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_10_1727935030_.json');
[10/03/2024 05:57:53], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727935073','43.239.53.130');
[10/03/2024 05:57:53], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_57_53_1727935073_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_53_1727935073_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_57_53_1727935073_.json', 'agoda', '2024-10-03 05:57:53', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_57_53_1727935073_.json');
[10/03/2024 05:58:20], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727935100','43.239.53.130');
[10/03/2024 05:58:20], [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 ('', 'VALUATION', 'a5/03_10_2024/request_valuation_Test_DoNotUse_05_58_20_1727935100_.json', 'a5/03_10_2024/response_valuation_Test_DoNotUse_05_58_20_1727935100_.json', 'a5/03_10_2024/response_header_valuation_Test_DoNotUse_05_58_20_1727935100_.json', 'agoda', '2024-10-03 05:58:20', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_valuation_Test_DoNotUse_05_58_20_1727935100_.json');
[10/03/2024 05:58: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 ('', 'PRECHECK', 'a5/03_10_2024/request_precheck_Test_DoNotUse_05_58_20_1727935100_.json', 'a5/03_10_2024/response_precheck_Test_DoNotUse_05_58_20_1727935100_.json', 'a5/03_10_2024/response_header_precheck_Test_DoNotUse_05_58_20_1727935100_.json', 'agoda', '2024-10-03 05:58:21', '', '10890320241005520394705094676', '16663862', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/03_10_2024/response_precheck_Test_DoNotUse_05_58_20_1727935100_.json');
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[10/03/2024 05:59:38], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-10-03 05:59:38',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#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;1284\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;120\&#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;1284\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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;1284\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#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-1284 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[10/03/2024 05:59:42], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-10-03 05:59:42',login_attempt=0 where id = '1284';
[10/03/2024 05:59:42], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-10-03 05:59:42', ip = '43.239.53.130', action = 'Login' ;
