[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Hotel Baniyas', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Premier Inn Dubai Investments Park', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ibis Dubai Mall Of The Emirates', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Royal Tulip Hotel Dubai', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Aravi Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Grand Deira', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ibis Dubai Al Barsha', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Premier Inn Dubai International Airport', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Summit Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ibis Dubai Al Rigga', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Ibis Dubai Deira City Centre', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Signature Hotel -  Al Barsha', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Al Khaleej Grand Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Premier Inn Dubai Ibn Battuta Mall Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Al Sarab Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hafez Hotel Apartments', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Royal Falcon Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Howard Johnson By Wyndham Bur Dubai', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Fortune Hotel Deira', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:09:17], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Al Khoory Atrium Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelfiltername', '2024-07-18 :14:09:17','');
[07/18/2024 02:10:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 02:10:01',login_attempt=0 where id = '949';
[07/18/2024 02:10:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-18 14:10:01', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 02:10:26], [file name :-/efsdata/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , service_type = 'Airline' , arrival_date = '2024/07/30' , departure_date = '2024/07/31' , create_date = '2024-07-18 :14:10:26' , origin = 'DXB' , destination = 'BOM' , site_id = '' ;
[07/18/2024 02:10:30], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_10_30_1721311830.xml','amadeus','2024-07-18 02:10:30','13597604');
[07/18/2024 02:10:30], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_10_30_1721311830.xml','Amadeus','2024-07-18 02:10:30','13597604');
[07/18/2024 02:10:31], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_10_31_1721311831.xml','amadeus','2024-07-18 02:10:31','13597604');
[07/18/2024 02:10:31], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_10_31_1721311831.xml','Amadeus','2024-07-18 02:10:31','13597604');
[07/18/2024 02:10:52], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_10_52_1721311852.xml','amadeus','2024-07-18 02:10:52','13597604');
[07/18/2024 02:10:52], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_10_52_1721311852.xml','Amadeus','2024-07-18 02:10:52','13597604');
[07/18/2024 02:11:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-18 14:11:29', ip = '5.255.231.140', action = 'Login' ;
[07/18/2024 02:12:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_12_54_1721311974.xml','amadeus','2024-07-18 02:12:54','13597604');
[07/18/2024 02:12:54], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_12_54_1721311974.xml','Amadeus','2024-07-18 02:12:54','13597604');
[07/18/2024 02:13:52], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_13_52_1721312032.xml','amadeus','2024-07-18 02:13:52','13597604');
[07/18/2024 02:13:52], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_13_52_1721312032.xml','Amadeus','2024-07-18 02:13:52','13597604');
[07/18/2024 02:14:23], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_14_23_1721312063.xml','amadeus','2024-07-18 02:14:23','13597604');
[07/18/2024 02:14:23], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_14_23_1721312063.xml','Amadeus','2024-07-18 02:14:23','13597604');
[07/18/2024 02:15:13], [file name :-/efsdata/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , service_type = 'Airline' , arrival_date = '2024/07/30' , departure_date = '2024/07/31' , create_date = '2024-07-18 :14:15:13' , origin = 'DXB' , destination = 'BOM' , site_id = '' ;
[07/18/2024 02:15:17], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_15_17_1721312117.xml','amadeus','2024-07-18 02:15:17','13597914');
[07/18/2024 02:15:17], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_15_17_1721312117.xml','Amadeus','2024-07-18 02:15:17','13597914');
[07/18/2024 02:15:30], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_15_30_1721312130.xml','amadeus','2024-07-18 02:15:30','13597914');
[07/18/2024 02:15:30], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_15_30_1721312130.xml','Amadeus','2024-07-18 02:15:30','13597914');
[07/18/2024 02:15:57], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_15_57_1721312157.xml','amadeus','2024-07-18 02:15:57','13597914');
[07/18/2024 02:15:57], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_15_57_1721312157.xml','Amadeus','2024-07-18 02:15:57','13597914');
[07/18/2024 02:16:01], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_14_16_01_1721312161.xml','amadeus','2024-07-18 02:16:01','13597914');
[07/18/2024 02:16:01], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_14_16_01_1721312161.xml','Amadeus','2024-07-18 02:16:01','13597914');
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '102' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '76' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '98' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:36], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '83' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '90' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:18:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'SUJAY_QTECH',`create_date`= '2024-07-18 14:18:37',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 76 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2406 ## supplier_id- 74 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2406 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2406 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[07/18/2024 02:18:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 02:18:40',login_attempt=0 where id = '2406';
[07/18/2024 02:18:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-07-18 14:18:40', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 02:18:57], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , 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 = '106' , service_type = 'hotel' , arrival_date = '2024/07/31' , departure_date = '2024/08/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 14:18:57' , 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' ;
[07/18/2024 02:18:58], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24061820240714185765755108793',
        duration = '0.130',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.47',
        system_load_5_min = '8.39',
        system_load_15_min = '7.28',
        system_memory_usage = '89.14',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13598207') + '2752080',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13598207';
[07/18/2024 02:18:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24061820240714185765755108793',
        duration = '0.055',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.47',
        system_load_5_min = '8.39',
        system_load_15_min = '7.28',
        system_memory_usage = '89.15',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13598207') + '2753816',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13598207';
[07/18/2024 02:19:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 02:19:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '102' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '98' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:47], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '57' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '83' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '90' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:48], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 02:19:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'SUJAY_QTECH',`create_date`= '2024-07-18 14:19:49',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2406 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/18/2024 02:19:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 02:19:56',login_attempt=0 where id = '2406';
[07/18/2024 02:19:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-07-18 14:19:56', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 02:20:11], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , 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 = '106' , service_type = 'hotel' , arrival_date = '2024/07/30' , departure_date = '2024/07/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 14:20:11' , 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' ;
[07/18/2024 02:20:14], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_20_12_1721312412_5245.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_5245.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_20_12_1721312412_5245.xml', 'travco', '2024-07-18 02:20:14', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_5245.xml');
[07/18/2024 02:20:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-18 14:20:12.346'
        , request_start_time = '0.145'
        , parsing_start_time = '1.428'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.071'
        , search_end_time = '0.053'
        , total_duration = '1.755'
        , error_description = ''
        , memory_used = '2426024'
        WHERE id = '162157562';
[07/18/2024 02:20:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_20_12_1721312412_8237.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_8237.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_20_12_1721312412_8237.xml', 'travco', '2024-07-18 02:20:19', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_8237.xml');
[07/18/2024 02:20:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-18 14:20:12.350'
        , request_start_time = '0.145'
        , parsing_start_time = '6.853'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.083'
        , search_end_time = '0.028'
        , total_duration = '7.165'
        , error_description = ''
        , memory_used = '5285040'
        WHERE id = '162157600';
[07/18/2024 02:20:24], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_20_12_1721312412_1707.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_1707.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_20_12_1721312412_1707.xml', 'travco', '2024-07-18 02:20:24', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_20_12_1721312412_1707.xml');
[07/18/2024 02:20:24], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-18 14:20:12.347'
        , request_start_time = '0.147'
        , parsing_start_time = '11.992'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.119'
        , search_end_time = '0.039'
        , total_duration = '12.357'
        , error_description = ''
        , memory_used = '7229408'
        WHERE id = '162157601';
[07/18/2024 02:20:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '85',
        request_path = '/xml_all.php?userid=2406&sessionid=2406182024071420115320636239',
        duration = '12.520',
        merge_duration = '0.006',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '22.47',
        system_load_5_min = '11.37',
        system_load_15_min = '8.34',
        system_memory_usage = '96.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13598287') + '2751296',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13598287';
[07/18/2024 02:20:35], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_20_34_1721312434_7288.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_20_34_1721312434_7288.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_20_34_1721312434_7288.xml', 'travco', '2024-07-18 02:20:35', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_20_34_1721312434_7288.xml');
[07/18/2024 02:20:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-07-18 14:20:34.660'
        , request_start_time = '0.120'
        , parsing_start_time = '0.532'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.139'
        , search_end_time = '0.035'
        , total_duration = '0.867'
        , error_description = ''
        , memory_used = '7314352'
        WHERE id = '162157637';
[07/18/2024 02:22:20], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_22_19_1721312539_2278.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_22_19_1721312539_2278.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_22_19_1721312539_2278.xml', 'travco', '2024-07-18 02:22:20', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_22_19_1721312539_2278.xml');
[07/18/2024 02:22:20], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-07-18 14:22:19.787'
        , request_start_time = '0.119'
        , parsing_start_time = '0.409'
        , mapping_complete_time = '0.067'
        , mongo_start_time = '0.217'
        , search_end_time = '0.041'
        , total_duration = '0.838'
        , error_description = ''
        , memory_used = '7315328'
        WHERE id = '162158838';
[07/18/2024 02:26:08], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_26_08_1721312768_1010.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_26_08_1721312768_1010.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_26_08_1721312768_1010.xml', 'travco', '2024-07-18 02:26:08', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_26_08_1721312768_1010.xml');
[07/18/2024 02:26:09], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-07-18 14:26:08.204'
        , request_start_time = '0.126'
        , parsing_start_time = '0.446'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.145'
        , search_end_time = '0.041'
        , total_duration = '0.844'
        , error_description = ''
        , memory_used = '7316088'
        WHERE id = '162161279';
[07/18/2024 02:27:02], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 't1/18_07_2024/request_availability_Qtech_pranali_14_27_01_1721312821_9134.xml', 't1/18_07_2024/response_availability_Qtech_pranali_14_27_01_1721312821_9134.xml', 't1/18_07_2024/response_header_availability_Qtech_pranali_14_27_01_1721312821_9134.xml', 'travco', '2024-07-18 02:27:02', '', '2406182024071420115320636239', '13598287', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t1/18_07_2024/response_availability_Qtech_pranali_14_27_01_1721312821_9134.xml');
[07/18/2024 02:27:02], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=travco&sessionid=2406182024071420115320636239&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=3&hotels_ids=&city_code=DXB&country_code=ARE&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-07-18 14:27:01.518'
        , request_start_time = '0.119'
        , parsing_start_time = '0.393'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.152'
        , search_end_time = '0.043'
        , total_duration = '0.744'
        , error_description = ''
        , memory_used = '7312288'
        WHERE id = '162161435';
