[08/26/2024 10:05:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 10:05:37' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:05:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810053759605806464', session_id='12842620240810053759605806464', Collection_create_time='2024-08-26 10:05:38';
[08/26/2024 10:05:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810053759605806464',
        duration = '2.076',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.61',
        system_load_5_min = '2.90',
        system_load_15_min = '4.66',
        system_memory_usage = '26.75',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245010') + '2302592',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245010';
[08/26/2024 10:10:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"5,7"},{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"}]' , available='0' , create_date = '2024-08-26 10:10:07' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:10:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810100729089148908', session_id='12842620240810100729089148908', Collection_create_time='2024-08-26 10:10:09';
[08/26/2024 10:10:12], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '15',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810100729089148908',
        duration = '3.091',
        merge_duration = '0.019',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.10',
        system_load_5_min = '3.62',
        system_load_15_min = '4.45',
        system_memory_usage = '26.88',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245404') + '2302424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245404';
[08/26/2024 10:10:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810100729089148908', session_id='12842620240810100729089148908', Collection_create_time='2024-08-26 10:10:22';
[08/26/2024 10:11:13], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-08-26 10:11:13' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:11:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810111378478119151', session_id='12842620240810111378478119151', Collection_create_time='2024-08-26 10:11:14';
[08/26/2024 10:11:18], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '38',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810111378478119151',
        duration = '4.076',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.45',
        system_load_5_min = '3.43',
        system_load_15_min = '4.33',
        system_memory_usage = '26.74',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245501') + '2297384',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245501';
[08/26/2024 10:11:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810111378478119151', session_id='12842620240810111378478119151', Collection_create_time='2024-08-26 10:11:37';
[08/26/2024 10:12:50], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '1.1, 1, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"8,9"},{"numberOfAdults":1},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-08-26 10:12:50' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:12:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810125032705347898', session_id='12842620240810125032705347898', Collection_create_time='2024-08-26 10:12:51';
[08/26/2024 10:12:54], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '8',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810125032705347898',
        duration = '3.081',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.36',
        system_load_5_min = '3.61',
        system_load_15_min = '4.31',
        system_memory_usage = '26.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245671') + '2305120',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245671';
[08/26/2024 10:13:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810125032705347898', session_id='12842620240810125032705347898', Collection_create_time='2024-08-26 10:13:06';
[08/26/2024 10:13:08], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '8',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810125032705347898',
        duration = '2.058',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.25',
        system_load_5_min = '3.99',
        system_load_15_min = '4.42',
        system_memory_usage = '26.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245671') + '2304120',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245671';
[08/26/2024 10:13:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810125032705347898', session_id='12842620240810125032705347898', Collection_create_time='2024-08-26 10:13:10';
[08/26/2024 10:14:05], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 1, 1.1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"8,9"},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"6"},{"numberOfAdults":1}]' , available='0' , create_date = '2024-08-26 10:14:05' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:14:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810140597213664371', session_id='12842620240810140597213664371', Collection_create_time='2024-08-26 10:14:06';
[08/26/2024 10:14:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '7',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810140597213664371',
        duration = '3.074',
        merge_duration = '0.012',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.61',
        system_load_5_min = '4.23',
        system_load_15_min = '4.49',
        system_memory_usage = '26.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245753') + '2303976',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245753';
[08/26/2024 10:14:29], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667269','43.239.53.130');
[08/26/2024 10:14: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', 'd1/26_08_2024/request_valuation_qtech_agent_10_14_30_1724667270.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_14_30_1724667270.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_14_30_1724667270.xml', 'dotw', '2024-08-26 10:14:30', '', '12842620240810140597213664371', '15245753', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_14_30_1724667270.xml');
[08/26/2024 10:14:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:erbil<br><br>Arrival Date:06/09/2024<br><br>Departure Date:07/09/2024<br><br>Supplier:dotw<br><br>Hotel:PARIS PLAZA HOTEL<br><br>Room:Deluxe Suite Breakfast Included
',  email_sent ='yes', create_date ='2024-08-26 10:14:31', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/26/2024 10:14:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667278','43.239.53.130');
[08/26/2024 10:14:42], [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', 'd1/26_08_2024/request_valuation_qtech_agent_10_14_38_1724667278.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_14_38_1724667278.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_14_38_1724667278.xml', 'dotw', '2024-08-26 10:14:42', '', '12842620240810140597213664371', '15245753', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_14_38_1724667278.xml');
[08/26/2024 10:14:42], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:erbil<br><br>Arrival Date:06/09/2024<br><br>Departure Date:07/09/2024<br><br>Supplier:dotw<br><br>Hotel:PARIS PLAZA HOTEL<br><br>Room:Deluxe Suite Breakfast Included
',  email_sent ='yes', create_date ='2024-08-26 10:14:42', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[08/26/2024 10:14:50], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'erbil' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/09/06' , departure_date = '2024/09/07' , nights = '1' , nationality = '129' , room_types = '2.2, 1.1, 1' , room_type='[{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"8,9"},{"numberOfAdults":1},{"numberOfAdults":1,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-08-26 10:14:50' , site_id = '' , country_code = '109' , city_code = '109_23475-EBL_5735' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[08/26/2024 10:14:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12842620240810145049969946737', session_id='12842620240810145049969946737', Collection_create_time='2024-08-26 10:14:51';
[08/26/2024 10:14:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '8',
        request_path = '/xml_all.php?userid=1284&sessionid=12842620240810145049969946737',
        duration = '2.062',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.94',
        system_load_5_min = '4.32',
        system_load_15_min = '4.51',
        system_memory_usage = '26.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15245825') + '2303552',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15245825';
[08/26/2024 10:15:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667314','43.239.53.130');
[08/26/2024 10:15: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', 'd1/26_08_2024/request_valuation_qtech_agent_10_15_14_1724667314.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_15_14_1724667314.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_15_14_1724667314.xml', 'dotw', '2024-08-26 10:15:15', '', '12842620240810145049969946737', '15245825', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_15_14_1724667314.xml');
[08/26/2024 10:15:19], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667319','43.239.53.130');
[08/26/2024 10:15: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', 'd1/26_08_2024/request_valuation_qtech_agent_10_15_19_1724667319.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_15_19_1724667319.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_15_19_1724667319.xml', 'dotw', '2024-08-26 10:15:20', '', '12842620240810145049969946737', '15245825', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_15_19_1724667319.xml');
[08/26/2024 10:15:27], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667327','43.239.53.130');
[08/26/2024 10:15:28], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'd1/26_08_2024/request_valuation_qtech_agent_10_15_27_1724667327.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_15_27_1724667327.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_15_27_1724667327.xml', 'dotw', '2024-08-26 10:15:28', '', '12842620240810145049969946737', '15245825', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_15_27_1724667327.xml');
[08/26/2024 10:15:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667334','43.239.53.130');
[08/26/2024 10:15:35], [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', 'd1/26_08_2024/request_valuation_qtech_agent_10_15_34_1724667334.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_15_34_1724667334.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_15_34_1724667334.xml', 'dotw', '2024-08-26 10:15:35', '', '12842620240810145049969946737', '15245825', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_15_34_1724667334.xml');
[08/26/2024 10:15:43], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724667343','43.239.53.130');
[08/26/2024 10:15: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', 'd1/26_08_2024/request_valuation_qtech_agent_10_15_43_1724667343.xml', 'd1/26_08_2024/response_valuation_qtech_agent_10_15_43_1724667343.xml', 'd1/26_08_2024/response_header_valuation_qtech_agent_10_15_43_1724667343.xml', 'dotw', '2024-08-26 10:15:44', '', '12842620240810145049969946737', '15245825', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/d1/26_08_2024/response_valuation_qtech_agent_10_15_43_1724667343.xml');
