[05/22/2024 06:00:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',accounting_name= '',first_name= 'hotelyards',middle_name= '',last_name= 'whitelabel',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '6666666.000',credit_limit= '6666666.000',credit_distribution= '0',temp_credit_limit= '',address= 'address lane 1',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='32',phone= '91-9876598765',mobile= '91-9876598765',fax= '91-',currency= '6',email= 'deepak.trivedi@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= 'Associate',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= 'Hotel Yards',allow_quotation= '1',can_voucher= '',markup= '0.5',allow_book_under_cancellation='0',modify_date='2024-05-22 06:00:19',consultant_id= 'hotelyards',agency_email= '',acc_name= 'HOTEL YARDS',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '1234567890',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '' WHERE id= '7868';
[05/22/2024 06:00:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'hotelyards',`create_date`= '2024-05-22 06:00:19',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;hotelyards\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;whitelabel\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;6666666.000\&#039;,credit_limit= \&#039;6666666.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;address lane 1\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;32\&#039;,phone= \&#039;91-9876598765\&#039;,mobile= \&#039;91-9876598765\&#039;,fax= \&#039;91-\&#039;,currency= \&#039;6\&#039;,email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;Associate\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;Hotel Yards\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 0,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-05-22 06:00:19\&#039;,consultant_id= \&#039;hotelyards\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;HOTEL YARDS\&#039;,acc_email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,acc_phone= \&#039;1234567890\&#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 WHERE id= \&#039;7868\&#039;',`log_description`= 'Agent 7868 updated For  - modify_date=2024-05-22+05%3A59%3A30 changed to - modify_date=2024-05-22+06%3A00%3A19',`ip`= '43.239.53.130';
[05/22/2024 06:00:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7868' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[05/22/2024 06:00:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by hotelyards',create_date='2024-05-22 06:05:19';
[05/22/2024 06:00:19], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '32',consultant_id= 'hotelyards',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7868';
[05/22/2024 06:00:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',accounting_name= '',first_name= 'hotelyards',middle_name= '',last_name= 'whitelabel',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '6666666.000',credit_limit= '6666666.000',credit_distribution= '0',temp_credit_limit= '',address= 'address lane 1',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='32',phone= '91-9876598765',mobile= '91-9876598765',fax= '91-',currency= '6',email= 'deepak.trivedi@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= 'Associate',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= 'Hotel Yards',allow_quotation= '1',can_voucher= '',markup= '0.5',allow_book_under_cancellation='0',modify_date='2024-05-22 06:00:49',consultant_id= 'hotelyards',agency_email= '',acc_name= 'HOTEL YARDS',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '1234567890',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '' WHERE id= '7868';
[05/22/2024 06:00:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'hotelyards',`create_date`= '2024-05-22 06:00:49',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;hotelyards\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;whitelabel\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;6666666.000\&#039;,credit_limit= \&#039;6666666.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;address lane 1\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;32\&#039;,phone= \&#039;91-9876598765\&#039;,mobile= \&#039;91-9876598765\&#039;,fax= \&#039;91-\&#039;,currency= \&#039;6\&#039;,email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;Associate\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;Hotel Yards\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 0,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-05-22 06:00:49\&#039;,consultant_id= \&#039;hotelyards\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;HOTEL YARDS\&#039;,acc_email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,acc_phone= \&#039;1234567890\&#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 WHERE id= \&#039;7868\&#039;',`log_description`= 'Agent 7868 updated For  - modify_date=2024-05-22+06%3A00%3A19 changed to - modify_date=2024-05-22+06%3A00%3A49',`ip`= '43.239.53.130';
[05/22/2024 06:00:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7868' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[05/22/2024 06:00:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by hotelyards',create_date='2024-05-22 06:05:49';
[05/22/2024 06:00:49], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '32',consultant_id= 'hotelyards',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7868';
[05/22/2024 06:01:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',accounting_name= '',first_name= 'hotelyards',middle_name= '',last_name= 'whitelabel',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '6666666.000',credit_limit= '6666666.000',credit_distribution= '0',temp_credit_limit= '',address= 'address lane 1',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='32',phone= '91-9876598765',mobile= '91-9876598765',fax= '91-',currency= '6',email= 'deepak.trivedi@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= 'Associate',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= 'Hotel Yards',allow_quotation= '1',can_voucher= '',markup= '0.5',allow_book_under_cancellation='0',modify_date='2024-05-22 06:01:34',consultant_id= 'hotelyards',agency_email= '',acc_name= 'HOTEL YARDS',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '1234567890',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '' WHERE id= '7868';
[05/22/2024 06:01:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'hotelyards',`create_date`= '2024-05-22 06:01:34',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;hotelyards\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;whitelabel\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;6666666.000\&#039;,credit_limit= \&#039;6666666.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;address lane 1\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;32\&#039;,phone= \&#039;91-9876598765\&#039;,mobile= \&#039;91-9876598765\&#039;,fax= \&#039;91-\&#039;,currency= \&#039;6\&#039;,email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;Associate\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;Hotel Yards\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 0,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-05-22 06:01:34\&#039;,consultant_id= \&#039;hotelyards\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;HOTEL YARDS\&#039;,acc_email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,acc_phone= \&#039;1234567890\&#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 WHERE id= \&#039;7868\&#039;',`log_description`= 'Agent 7868 updated For  - modify_date=2024-05-22+06%3A00%3A49 changed to - modify_date=2024-05-22+06%3A01%3A34',`ip`= '43.239.53.130';
[05/22/2024 06:01:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7868' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[05/22/2024 06:01:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by hotelyards',create_date='2024-05-22 06:05:34';
[05/22/2024 06:01:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '32',consultant_id= 'hotelyards',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7868';
[05/22/2024 06:03:05], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1}]' , available='0' , create_date = '2024-05-22 06:03:05' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:03:06], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:03:06', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1858', 'localsystem/response_placeholder.xml');
[05/22/2024 06:03:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:03:06.381'
        , request_start_time = '0.029'
        , parsing_start_time = '0.013'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.011'
        , search_end_time = '0.000'
        , total_duration = '0.120'
        , error_description = ''
        , memory_used = '1895992'
        WHERE id = '554813';
[05/22/2024 06:03:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.283',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.23',
        system_load_5_min = '0.48',
        system_load_15_min = '0.49',
        system_memory_usage = '91.44',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1858') + '2009520',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1858';
[05/22/2024 06:03:17], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"2"}]' , available='0' , create_date = '2024-05-22 06:03:17' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:03:18], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:03:18', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1859', 'localsystem/response_placeholder.xml');
[05/22/2024 06:03:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:03:18.526'
        , request_start_time = '0.022'
        , parsing_start_time = '0.018'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.019'
        , search_end_time = '0.013'
        , total_duration = '0.131'
        , error_description = ''
        , memory_used = '1648144'
        WHERE id = '554814';
[05/22/2024 06:03:18], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.297',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.71',
        system_load_5_min = '0.78',
        system_load_15_min = '0.59',
        system_memory_usage = '92.30',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1859') + '2009608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1859';
[05/22/2024 06:06:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"2"}]' , available='0' , create_date = '2024-05-22 06:06:28' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:06:30], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:06:30', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1860', 'localsystem/response_placeholder.xml');
[05/22/2024 06:06:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:06:29.532'
        , request_start_time = '0.136'
        , parsing_start_time = '0.267'
        , mapping_complete_time = '0.308'
        , mongo_start_time = '0.330'
        , search_end_time = '0.108'
        , total_duration = '1.403'
        , error_description = ''
        , memory_used = '1899632'
        WHERE id = '554815';
[05/22/2024 06:06:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '2.024',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.57',
        system_load_5_min = '0.83',
        system_load_15_min = '0.65',
        system_memory_usage = '93.79',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1860') + '2009616',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1860';
[05/22/2024 06:12:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":2}]' , available='0' , create_date = '2024-05-22 06:12:37' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:12:38], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:12:38', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1861', 'localsystem/response_placeholder.xml');
[05/22/2024 06:12:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:12:38.77'
        , request_start_time = '0.016'
        , parsing_start_time = '0.009'
        , mapping_complete_time = '0.005'
        , mongo_start_time = '0.006'
        , search_end_time = '0.000'
        , total_duration = '0.104'
        , error_description = ''
        , memory_used = '1899088'
        WHERE id = '554816';
[05/22/2024 06:12:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.263',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.20',
        system_load_5_min = '0.38',
        system_load_15_min = '0.51',
        system_memory_usage = '93.57',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1861') + '2009424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1861';
[05/22/2024 06:13:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1}]' , available='0' , create_date = '2024-05-22 06:13:10' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:13:11], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:13:11', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1862', 'localsystem/response_placeholder.xml');
[05/22/2024 06:13:11], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:13:11.497'
        , request_start_time = '0.014'
        , parsing_start_time = '0.006'
        , mapping_complete_time = '0.004'
        , mongo_start_time = '0.005'
        , search_end_time = '0.000'
        , total_duration = '0.094'
        , error_description = ''
        , memory_used = '1581376'
        WHERE id = '554817';
[05/22/2024 06:13:11], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.236',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.16',
        system_load_5_min = '0.36',
        system_load_15_min = '0.49',
        system_memory_usage = '93.59',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1862') + '2009520',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1862';
[05/22/2024 06:13:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"5"}]' , available='0' , create_date = '2024-05-22 06:13:25' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:13:29], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:13:29', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1863', 'localsystem/response_placeholder.xml');
[05/22/2024 06:13:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:13:29.863'
        , request_start_time = '0.039'
        , parsing_start_time = '0.012'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.012'
        , search_end_time = '0.009'
        , total_duration = '0.159'
        , error_description = ''
        , memory_used = '1648144'
        WHERE id = '554818';
[05/22/2024 06:13:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.833',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '17.16',
        system_load_5_min = '4.22',
        system_load_15_min = '1.76',
        system_memory_usage = '94.35',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1863') + '2009608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1863';
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:27], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/22/2024 06:14:28], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 06:14:28',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#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;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,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;7857\&#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;7857\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,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;7857\&#039;,supplier_id = 62 ,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;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,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;7857\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#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;7857\&#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;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#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;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,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-7857 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/22/2024 06:14:32], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"5"}]' , available='0' , create_date = '2024-05-22 06:14:32' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:14:33], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:14:33', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1864', 'localsystem/response_placeholder.xml');
[05/22/2024 06:14:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:14:33.653'
        , request_start_time = '0.014'
        , parsing_start_time = '0.008'
        , mapping_complete_time = '0.006'
        , mongo_start_time = '0.006'
        , search_end_time = '0.009'
        , total_duration = '0.150'
        , error_description = ''
        , memory_used = '1637288'
        WHERE id = '554819';
[05/22/2024 06:14:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.318',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.42',
        system_load_5_min = '4.76',
        system_load_15_min = '2.09',
        system_memory_usage = '91.52',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1864') + '2009608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1864';
[05/22/2024 06:17:50], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"5"}]' , available='0' , create_date = '2024-05-22 06:17:50' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:17:51], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:17:51', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1865', 'localsystem/response_placeholder.xml');
[05/22/2024 06:17:51], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:17:51.414'
        , request_start_time = '0.015'
        , parsing_start_time = '0.009'
        , mapping_complete_time = '0.006'
        , mongo_start_time = '0.006'
        , search_end_time = '0.008'
        , total_duration = '0.127'
        , error_description = ''
        , memory_used = '1900872'
        WHERE id = '554820';
[05/22/2024 06:17:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.251',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.66',
        system_load_5_min = '2.63',
        system_load_15_min = '1.77',
        system_memory_usage = '92.31',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1865') + '2009616',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1865';
[05/22/2024 06:18:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '3.1' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"5"}]' , available='0' , create_date = '2024-05-22 06:18:09' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:18:10], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:18:10', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1866', 'localsystem/response_placeholder.xml');
[05/22/2024 06:18:10], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:18:09.994'
        , request_start_time = '0.018'
        , parsing_start_time = '0.011'
        , mapping_complete_time = '0.007'
        , mongo_start_time = '0.007'
        , search_end_time = '0.010'
        , total_duration = '0.107'
        , error_description = ''
        , memory_used = '1637752'
        WHERE id = '554821';
[05/22/2024 06:18:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.270',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.14',
        system_load_5_min = '2.60',
        system_load_15_min = '1.78',
        system_memory_usage = '90.50',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1866') + '2009824',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1866';
[05/22/2024 06:32:41], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotels SET name = 'Qtech_test2',rating = '4.0',first_name = 'deepak',middle_name = '' ,last_name = '' ,city = '64440',country = '106',location_id = '',area = '',address = 'mumbai' ,phone ='',fax = '',email = '',website = '',latitude = '',longitude = '',driving_direction = '',near_by = '',weekend = '',main_image = '',optional_images = '#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#',main_image_desc = '',optional_images_desc = '',hotelbeds_code ='',status ='A',short_desc = '',long_desc = '';
[05/22/2024 06:32:41], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 06:32:41',`log_type`= 'Hotel Added',`sql_query`= 'INSERT INTO hotels SET name = \&#039;Qtech_test2\&#039;,rating = \&#039;4.0\&#039;,first_name = \&#039;deepak\&#039;,middle_name = \&#039;\&#039; ,last_name = \&#039;\&#039; ,city = \&#039;64440\&#039;,country = \&#039;106\&#039;,location_id = ,area = ,address = \&#039;mumbai\&#039; ,phone =\&#039;\&#039;,fax = \&#039;\&#039;,email = \&#039;\&#039;,website = \&#039;\&#039;,latitude = \&#039;\&#039;,longitude = \&#039;\&#039;,driving_direction = \&#039;\&#039;,near_by = \&#039;\&#039;,weekend = \&#039;\&#039;,main_image = \&#039;\&#039;,optional_images = \&#039;#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#\&#039;,main_image_desc = \&#039;\&#039;,optional_images_desc = \&#039;\&#039;,hotelbeds_code =\&#039;\&#039;,status =\&#039;A\&#039;,short_desc = \&#039;\&#039;,long_desc = \&#039;\&#039;',`log_description`= 'Hotel Added by User v3alpha',`ip`= '43.239.53.130';
[05/22/2024 06:34:47], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],UPDATE hotels SET status='D' where id= ?;
[05/22/2024 06:34:47], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 06:34:47',`log_type`= 'Hotel Deleted',`sql_query`= 'UPDATE hotels SET status=\&#039;D\&#039; where id= ?',`log_description`= 'Qtech_test2 Hotel Deleted by User v3alpha',`ip`= '43.239.53.130';
[05/22/2024 06:35:40], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],INSERT INTO hotels SET name = 'Qtech_test1',rating = '4.0',first_name = '',middle_name = '' ,last_name = '' ,city = '64440',country = '106',location_id = '',area = '',address = '' ,phone ='',fax = '',email = '',website = '',latitude = '',longitude = '',driving_direction = '',near_by = '',weekend = '6,7',main_image = '',optional_images = '#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#',main_image_desc = '',optional_images_desc = '',hotelbeds_code ='',status ='A',short_desc = '',long_desc = '';
[05/22/2024 06:35:40], [file name :-/efsdata/otrams/public_html/beta/tms/hotels.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 06:35:40',`log_type`= 'Hotel Added',`sql_query`= 'INSERT INTO hotels SET name = \&#039;Qtech_test1\&#039;,rating = \&#039;4.0\&#039;,first_name = \&#039;\&#039;,middle_name = \&#039;\&#039; ,last_name = \&#039;\&#039; ,city = \&#039;64440\&#039;,country = \&#039;106\&#039;,location_id = ,area = ,address = \&#039;\&#039; ,phone =\&#039;\&#039;,fax = \&#039;\&#039;,email = \&#039;\&#039;,website = \&#039;\&#039;,latitude = \&#039;\&#039;,longitude = \&#039;\&#039;,driving_direction = \&#039;\&#039;,near_by = \&#039;\&#039;,weekend = \&#039;6,7\&#039;,main_image = \&#039;\&#039;,optional_images = \&#039;#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#\&#039;,main_image_desc = \&#039;\&#039;,optional_images_desc = \&#039;\&#039;,hotelbeds_code =\&#039;\&#039;,status =\&#039;A\&#039;,short_desc = \&#039;\&#039;,long_desc = \&#039;\&#039;',`log_description`= 'Hotel Added by User v3alpha',`ip`= '43.239.53.130';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000001' AND city_code= '64440' AND country_code= '106';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000001',hotel_id = '7',city_code = '64440',country_code = '106';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000001',hotel_id = '4',city_code = '64440',country_code = '106';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000001',hotel_id = '9',city_code = '64440',country_code = '106';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-22 06:36:35',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000001\&#039;,hotel_id = \&#039;7\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000001\&#039;,hotel_id = \&#039;4\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039; ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000001\&#039;,hotel_id = \&#039;9\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000001, City : 64440, Country : 106, Hotels are : 7,4,9',`ip`= '43.239.53.130';
[05/22/2024 06:36:35], [file name :-/efsdata/otrams/public_html/beta/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='1', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:38:41], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],UPDATE hotels SET weekend='6,7', infant_lower_limit='0', infant_upper_limit='2', tiny_child_lower_limit='3', tiny_child_upper_limit='6', child_lower_limit='7', child_upper_limit='10', teen_child_lower_limit='11', teen_child_upper_limit='12' WHERE id='9';
[05/22/2024 06:38:41], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:38:41',`log_type`= 'Hotel',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;, infant_lower_limit=\&#039;0\&#039;, infant_upper_limit=\&#039;2\&#039;, tiny_child_lower_limit=\&#039;3\&#039;, tiny_child_upper_limit=\&#039;6\&#039;, child_lower_limit=\&#039;7\&#039;, child_upper_limit=\&#039;10\&#039;, teen_child_lower_limit=\&#039;11\&#039;, teen_child_upper_limit=\&#039;12\&#039; WHERE id=\&#039;9\&#039;',`log_description`= 'Hotel Setting of Qtech_test1 Updated By travelclick',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:38:41], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3413', `entity`='Hotels', `value`='9' ;
[05/22/2024 06:38:41], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3413', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into inventory_room_class SET
						inventory_room_class='2',
						added_by='supplier',
						supplierId='S000000001';
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into room_class SET
			room_class='Double'
			,type='supplier'
			,min_adult='2'
			,max_adult='2'
			,max_capacity='3'
			,supplier_id='S000000001'
			,inventory_class_id='27'
			,is_adult_extrabed='yes'
			,is_child_extrabed='yes'
			,non_refundable='0'
			,create_date='2024-05-22'
			,adult_extrabed='1'
			,child_extrabed='1';
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:42:07',`log_type`= 'Roomclass',`sql_query`= 'insert into room_class SET
			room_class=\&#039;Double\&#039;
			,type=\&#039;supplier\&#039;
			,min_adult=\&#039;2\&#039;
			,max_adult=\&#039;2\&#039;
			,max_capacity=3
			,supplier_id=\&#039;S000000001\&#039;
			,inventory_class_id=\&#039;27\&#039;
			,is_adult_extrabed=\&#039;yes\&#039;
			,is_child_extrabed=\&#039;yes\&#039;
			,non_refundable=\&#039;0\&#039;
			,create_date=\&#039;2024-05-22\&#039;
			,adult_extrabed=1
			,child_extrabed=1',`log_description`= 'Room Category :-2-Double Added by travelclick',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3414', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3414', `entity`='Inventory', `value`='' ;
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3414', `entity`='Roomclass', `value`='' ;
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT into hotel_room_class_mapping SET hotel_id='9', supplier_id='S000000001', class_id='498';
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:42:07',`log_type`= 'Hotel Room Class Mapping',`sql_query`= 'INSERT into hotel_room_class_mapping SET hotel_id=:hotel_id, supplier_id=:supplier_id, class_id=:room_class_id',`log_description`= 'Hotel Room Class Mapping for hotel Qtech_test1 Room Category :-Double',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3415', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:42:07], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3415', `entity`='Roomclass', `value`='498' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-22',to_date='2024-05-22',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-23',to_date='2024-05-23',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-24',to_date='2024-05-24',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-25',to_date='2024-05-25',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-26',to_date='2024-05-26',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-27',to_date='2024-05-27',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-28',to_date='2024-05-28',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-29',to_date='2024-05-29',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-30',to_date='2024-05-30',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-05-31',to_date='2024-05-31',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-01',to_date='2024-06-01',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-02',to_date='2024-06-02',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-03',to_date='2024-06-03',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-04',to_date='2024-06-04',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-05',to_date='2024-06-05',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-06',to_date='2024-06-06',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-07',to_date='2024-06-07',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-08',to_date='2024-06-08',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-09',to_date='2024-06-09',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-10',to_date='2024-06-10',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-11',to_date='2024-06-11',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-12',to_date='2024-06-12',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-13',to_date='2024-06-13',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-14',to_date='2024-06-14',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-15',to_date='2024-06-15',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-16',to_date='2024-06-16',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-17',to_date='2024-06-17',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-18',to_date='2024-06-18',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-19',to_date='2024-06-19',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-20',to_date='2024-06-20',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2024-06-21',to_date='2024-06-21',supplier_id='S000000001',hotel_id='9',room_basis_id='2',room_class_id='498',child_no='',infant_wtc_rate= '5',infant_wtc_weekend_rate= '5',infant_display= 'yes',tiny_child_wtb_rate= '10',tiny_child_wtb_weekend_rate= '10',tiny_display= 'yes',child_wtb_rate= '15',child_wtb_weekend_rate= '15',child_display= 'yes',teen_child_wtb_rate= '25',teen_child_wtb_weekend_rate= '25',teen_display= 'yes',adult_wb_rate= '30',adult_wb_weekend_rate= '30',adult_display= 'yes';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:44:28',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For Qtech_test1 added successfully. Room Category :- 2 - Double(Room Only) From :- 22-05-2024 To :- 21-06-2024',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3416', `entity`='Hotels', `value`='9' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3416', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3416', `entity`='Inventory', `value`='27' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3416', `entity`='Room', `value`='498' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO hotel_supplier_currency_mapping SET SupplierId ='S000000001',hotel_id ='9',currency_code ='USD',city_code ='64440',country_code ='106',created_datetime ='2024-05-22 06:44:28',created_by ='#supplier#',ip_addr ='43.239.53.130';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('9@S000000001@2024-05-22@2024-05-22@@498@2@19@@@0','22-05-2024~22-05-2024','9','S000000001','2024-05-22','2024-05-22','498','2','43.239.53.130','0','0','578fe89b73a486426de71f56a6056d93','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','578fe89b73a486426de71f56a6056d93','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0','');
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:44:28',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For Qtech_test1 Rate:- 20 Room Category :- 2 - Double (Room Only) Market :- localsystem From:- 22-05-2024 To:- 21-06-2024',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3417', `entity`='Hotels', `value`='9' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3417', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3417', `entity`='Inventory', `value`='27' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3417', `entity`='Room', `value`='498' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3417', `entity`='Market', `value`='19' ;
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('9@S000000001@2024-05-23@2024-05-23@@498@2@19@@@0','23-05-2024~23-05-2024','9','S000000001','2024-05-23','2024-05-23','498','2','43.239.53.130','0','0','1d81046db81f6f928988f15c0503e199','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','1d81046db81f6f928988f15c0503e199','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-24@2024-05-24@@498@2@19@@@0','24-05-2024~24-05-2024','9','S000000001','2024-05-24','2024-05-24','498','2','43.239.53.130','0','0','d26a2ec6841d70864a35a8a55aa4805f','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','d26a2ec6841d70864a35a8a55aa4805f','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-25@2024-05-25@@498@2@19@@@0','25-05-2024~25-05-2024','9','S000000001','2024-05-25','2024-05-25','498','2','43.239.53.130','0','0','7e07d43d6ad252dc36bd29cf9b638551','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','7e07d43d6ad252dc36bd29cf9b638551','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-26@2024-05-26@@498@2@19@@@0','26-05-2024~26-05-2024','9','S000000001','2024-05-26','2024-05-26','498','2','43.239.53.130','0','0','06501c87c6290e5f7e65b908d2af5801','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','06501c87c6290e5f7e65b908d2af5801','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-27@2024-05-27@@498@2@19@@@0','27-05-2024~27-05-2024','9','S000000001','2024-05-27','2024-05-27','498','2','43.239.53.130','0','0','a96b1fef642dcc7353b6cafffe8cf85d','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','a96b1fef642dcc7353b6cafffe8cf85d','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-28@2024-05-28@@498@2@19@@@0','28-05-2024~28-05-2024','9','S000000001','2024-05-28','2024-05-28','498','2','43.239.53.130','0','0','2f10c3dd8c1262a4e46f34bcc7ad5d27','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','2f10c3dd8c1262a4e46f34bcc7ad5d27','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-29@2024-05-29@@498@2@19@@@0','29-05-2024~29-05-2024','9','S000000001','2024-05-29','2024-05-29','498','2','43.239.53.130','0','0','b880b344af7251fddfca37ed9279769a','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','b880b344af7251fddfca37ed9279769a','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-30@2024-05-30@@498@2@19@@@0','30-05-2024~30-05-2024','9','S000000001','2024-05-30','2024-05-30','498','2','43.239.53.130','0','0','3d11b73d2c134d220d69ef9b9152b30e','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','3d11b73d2c134d220d69ef9b9152b30e','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-05-31@2024-05-31@@498@2@19@@@0','31-05-2024~31-05-2024','9','S000000001','2024-05-31','2024-05-31','498','2','43.239.53.130','0','0','410c3f4fedc73b3a7d80631ba0885bcf','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','410c3f4fedc73b3a7d80631ba0885bcf','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-01@2024-06-01@@498@2@19@@@0','01-06-2024~01-06-2024','9','S000000001','2024-06-01','2024-06-01','498','2','43.239.53.130','0','0','c11a46a325c37ddc984e9b3002788f02','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','c11a46a325c37ddc984e9b3002788f02','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-02@2024-06-02@@498@2@19@@@0','02-06-2024~02-06-2024','9','S000000001','2024-06-02','2024-06-02','498','2','43.239.53.130','0','0','76aa1e149001bd34e7a2a27e79c8c755','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','76aa1e149001bd34e7a2a27e79c8c755','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-03@2024-06-03@@498@2@19@@@0','03-06-2024~03-06-2024','9','S000000001','2024-06-03','2024-06-03','498','2','43.239.53.130','0','0','0009e496c39364a274cb0217543d3b6d','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','0009e496c39364a274cb0217543d3b6d','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-04@2024-06-04@@498@2@19@@@0','04-06-2024~04-06-2024','9','S000000001','2024-06-04','2024-06-04','498','2','43.239.53.130','0','0','8207825a70baba5e53129ebafb364cab','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','8207825a70baba5e53129ebafb364cab','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-05@2024-06-05@@498@2@19@@@0','05-06-2024~05-06-2024','9','S000000001','2024-06-05','2024-06-05','498','2','43.239.53.130','0','0','41b6bf381735c130f3b29cb17f087329','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','41b6bf381735c130f3b29cb17f087329','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-06@2024-06-06@@498@2@19@@@0','06-06-2024~06-06-2024','9','S000000001','2024-06-06','2024-06-06','498','2','43.239.53.130','0','0','7bb0ae449888c10adc495b6e5a6a9a8b','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','7bb0ae449888c10adc495b6e5a6a9a8b','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-07@2024-06-07@@498@2@19@@@0','07-06-2024~07-06-2024','9','S000000001','2024-06-07','2024-06-07','498','2','43.239.53.130','0','0','0a041fe179adfe4d33f3e4f3300ef13e','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','0a041fe179adfe4d33f3e4f3300ef13e','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-08@2024-06-08@@498@2@19@@@0','08-06-2024~08-06-2024','9','S000000001','2024-06-08','2024-06-08','498','2','43.239.53.130','0','0','5fbf58fced5192a7369dae230c5dd7cb','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','5fbf58fced5192a7369dae230c5dd7cb','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-09@2024-06-09@@498@2@19@@@0','09-06-2024~09-06-2024','9','S000000001','2024-06-09','2024-06-09','498','2','43.239.53.130','0','0','8696bac3d2286eb53dfe3db4c0f6b41b','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','8696bac3d2286eb53dfe3db4c0f6b41b','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-10@2024-06-10@@498@2@19@@@0','10-06-2024~10-06-2024','9','S000000001','2024-06-10','2024-06-10','498','2','43.239.53.130','0','0','b493883a40c353be913ca94fbcbd2cad','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','b493883a40c353be913ca94fbcbd2cad','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-11@2024-06-11@@498@2@19@@@0','11-06-2024~11-06-2024','9','S000000001','2024-06-11','2024-06-11','498','2','43.239.53.130','0','0','fa5304cad871fa8690ddda64d7017bba','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','fa5304cad871fa8690ddda64d7017bba','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-12@2024-06-12@@498@2@19@@@0','12-06-2024~12-06-2024','9','S000000001','2024-06-12','2024-06-12','498','2','43.239.53.130','0','0','a036862ee2ad45fb512d003d022b9562','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','a036862ee2ad45fb512d003d022b9562','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-13@2024-06-13@@498@2@19@@@0','13-06-2024~13-06-2024','9','S000000001','2024-06-13','2024-06-13','498','2','43.239.53.130','0','0','5897cbdc4f6ad18e7b10f2d234e201fd','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','5897cbdc4f6ad18e7b10f2d234e201fd','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-14@2024-06-14@@498@2@19@@@0','14-06-2024~14-06-2024','9','S000000001','2024-06-14','2024-06-14','498','2','43.239.53.130','0','0','c4df351cec643f197299d8d51a6df8d9','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','c4df351cec643f197299d8d51a6df8d9','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-15@2024-06-15@@498@2@19@@@0','15-06-2024~15-06-2024','9','S000000001','2024-06-15','2024-06-15','498','2','43.239.53.130','0','0','7d9d3933ca6463c3cdbd4f4adc63e4df','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','7d9d3933ca6463c3cdbd4f4adc63e4df','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-16@2024-06-16@@498@2@19@@@0','16-06-2024~16-06-2024','9','S000000001','2024-06-16','2024-06-16','498','2','43.239.53.130','0','0','d2747ce90cffb2c74a1c2b9e35b750b2','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','d2747ce90cffb2c74a1c2b9e35b750b2','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-17@2024-06-17@@498@2@19@@@0','17-06-2024~17-06-2024','9','S000000001','2024-06-17','2024-06-17','498','2','43.239.53.130','0','0','787f66f3dc35adc1c8cb88c23048e50f','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','787f66f3dc35adc1c8cb88c23048e50f','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-18@2024-06-18@@498@2@19@@@0','18-06-2024~18-06-2024','9','S000000001','2024-06-18','2024-06-18','498','2','43.239.53.130','0','0','0a4dcc1f9e6cdf41ff604d79b3724a3d','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','0a4dcc1f9e6cdf41ff604d79b3724a3d','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-19@2024-06-19@@498@2@19@@@0','19-06-2024~19-06-2024','9','S000000001','2024-06-19','2024-06-19','498','2','43.239.53.130','0','0','6ea70e4b21d3de904897646f3372f37d','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','6ea70e4b21d3de904897646f3372f37d','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-20@2024-06-20@@498@2@19@@@0','20-06-2024~20-06-2024','9','S000000001','2024-06-20','2024-06-20','498','2','43.239.53.130','0','0','acb70453555780028019bdef5a5b9b29','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','acb70453555780028019bdef5a5b9b29','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0',''),('9@S000000001@2024-06-21@2024-06-21@@498@2@19@@@0','21-06-2024~21-06-2024','9','S000000001','2024-06-21','2024-06-21','498','2','43.239.53.130','0','0','4cc955ad2bd1f2e43710ff498146c2e4','Sa,Su','19','Supplier','27','A','20','20','USD','0','0','24','0','','','0','4cc955ad2bd1f2e43710ff498146c2e4','2024-05-22 06:44:28','2024-05-22','Supplier','','','','','0','');
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[05/22/2024 06:44:28], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rate_profile (rate_profile,time_stamp) values(19,'578fe89b73a486426de71f56a6056d93'),(19,'1d81046db81f6f928988f15c0503e199'),(19,'d26a2ec6841d70864a35a8a55aa4805f'),(19,'7e07d43d6ad252dc36bd29cf9b638551'),(19,'06501c87c6290e5f7e65b908d2af5801'),(19,'a96b1fef642dcc7353b6cafffe8cf85d'),(19,'2f10c3dd8c1262a4e46f34bcc7ad5d27'),(19,'b880b344af7251fddfca37ed9279769a'),(19,'3d11b73d2c134d220d69ef9b9152b30e'),(19,'410c3f4fedc73b3a7d80631ba0885bcf'),(19,'c11a46a325c37ddc984e9b3002788f02'),(19,'76aa1e149001bd34e7a2a27e79c8c755'),(19,'0009e496c39364a274cb0217543d3b6d'),(19,'8207825a70baba5e53129ebafb364cab'),(19,'41b6bf381735c130f3b29cb17f087329'),(19,'7bb0ae449888c10adc495b6e5a6a9a8b'),(19,'0a041fe179adfe4d33f3e4f3300ef13e'),(19,'5fbf58fced5192a7369dae230c5dd7cb'),(19,'8696bac3d2286eb53dfe3db4c0f6b41b'),(19,'b493883a40c353be913ca94fbcbd2cad'),(19,'fa5304cad871fa8690ddda64d7017bba'),(19,'a036862ee2ad45fb512d003d022b9562'),(19,'5897cbdc4f6ad18e7b10f2d234e201fd'),(19,'c4df351cec643f197299d8d51a6df8d9'),(19,'7d9d3933ca6463c3cdbd4f4adc63e4df'),(19,'d2747ce90cffb2c74a1c2b9e35b750b2'),(19,'787f66f3dc35adc1c8cb88c23048e50f'),(19,'0a4dcc1f9e6cdf41ff604d79b3724a3d'),(19,'6ea70e4b21d3de904897646f3372f37d'),(19,'acb70453555780028019bdef5a5b9b29'),(19,'4cc955ad2bd1f2e43710ff498146c2e4');
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='2', consumed_inventory='0' where supplier_id='S000000001' AND hotel_id='9' AND inventory_class_id='27'  AND date_from >='2024-05-22' AND date_from <='2024-06-21' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='3', consumed_inventory='0' where supplier_id='S000000001' AND hotel_id='9' AND inventory_class_id='27'  AND date_from >='2024-05-22' AND date_from <='2024-06-21' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-22 06:45:56',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;2\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;9\&#039; AND inventory_class_id=\&#039;27\&#039;  AND date_from &gt;=\&#039;2024-05-22\&#039; AND date_from &lt;=\&#039;2024-06-21\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;3\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000001\&#039; AND hotel_id=\&#039;9\&#039; AND inventory_class_id=\&#039;27\&#039;  AND date_from &gt;=\&#039;2024-05-22\&#039; AND date_from &lt;=\&#039;2024-06-21\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel Qtech_test1- Inventory:-2 From:-22-05-2024 To:-21-06-2024 Weekday Inventory Allocation:-2 Weekend Inventory Allocation:-3',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000001';
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3418', `entity`='Hotels', `value`='9' ;
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3418', `entity`='Suppliers', `value`='S000000001' ;
[05/22/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3418', `entity`='Inventory', `value`='27' ;
[05/22/2024 06:46:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-22 06:46:50',login_attempt=0 where id = '7857';
[05/22/2024 06:46:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-05-22 06:46:50', ip = '43.239.53.130', action = 'Login' ;
[05/22/2024 06:47:05], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-22 06:47:05' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:47:07], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:47:07', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1867', 'localsystem/response_placeholder.xml');
[05/22/2024 06:47:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '3'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&#039;,&#039;9&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:47:07.291'
        , request_start_time = '0.026'
        , parsing_start_time = '0.025'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.013'
        , search_end_time = '0.011'
        , total_duration = '0.179'
        , error_description = ''
        , memory_used = '1933792'
        WHERE id = '554822';
[05/22/2024 06:47:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '3',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.346',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.75',
        system_load_5_min = '2.59',
        system_load_15_min = '2.26',
        system_memory_usage = '88.50',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1867') + '2012328',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1867';
[05/22/2024 06:47:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1}]' , available='0' , create_date = '2024-05-22 06:47:29' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:47:30], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:47:30', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1868', 'localsystem/response_placeholder.xml');
[05/22/2024 06:47:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&#039;,&#039;9&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:47:30.778'
        , request_start_time = '0.020'
        , parsing_start_time = '0.013'
        , mapping_complete_time = '0.006'
        , mongo_start_time = '0.006'
        , search_end_time = '0.009'
        , total_duration = '0.126'
        , error_description = ''
        , memory_used = '1655112'
        WHERE id = '554823';
[05/22/2024 06:47:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.272',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.49',
        system_load_5_min = '2.38',
        system_load_15_min = '2.20',
        system_memory_usage = '88.49',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1868') + '2013032',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1868';
[05/22/2024 06:47:40], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/30' , departure_date = '2024/05/31' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"6"}]' , available='0' , create_date = '2024-05-22 06:47:40' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:47:41], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:47:41', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1869', 'localsystem/response_placeholder.xml');
[05/22/2024 06:47:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&#039;,&#039;9&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:47:41.82'
        , request_start_time = '0.017'
        , parsing_start_time = '0.013'
        , mapping_complete_time = '0.007'
        , mongo_start_time = '0.008'
        , search_end_time = '0.009'
        , total_duration = '0.099'
        , error_description = ''
        , memory_used = '1685504'
        WHERE id = '554824';
[05/22/2024 06:47:41], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.255',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.49',
        system_load_5_min = '2.32',
        system_load_15_min = '2.19',
        system_memory_usage = '88.50',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1869') + '2013440',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1869';
[05/22/2024 06:48:52], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/31' , departure_date = '2024/06/01' , nights = '1' , nationality = '106' , room_types = '2.1' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"5"}]' , available='0' , create_date = '2024-05-22 06:48:52' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/22/2024 06:48:52], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-22 06:48:52', '', '2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755', '1870', 'localsystem/response_placeholder.xml');
[05/22/2024 06:48:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=localsystem&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755&xml_user_id=7857&request_no=0&local_hotel_code=4&#039;,&#039;7&#039;,&#039;9&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-22 06:48:52.811'
        , request_start_time = '0.019'
        , parsing_start_time = '0.018'
        , mapping_complete_time = '0.007'
        , mongo_start_time = '0.008'
        , search_end_time = '0.009'
        , total_duration = '0.134'
        , error_description = ''
        , memory_used = '1684864'
        WHERE id = '554825';
[05/22/2024 06:48:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7857&sessionid=2db738f2763b36eb103c8a3d0fa79bfb9814be085c373bbcca12dc38b52cb755',
        duration = '0.210',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.15',
        system_load_5_min = '1.84',
        system_load_15_min = '2.03',
        system_memory_usage = '88.61',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1870') + '2013304',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1870';
[05/22/2024 06:56:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',accounting_name= '',first_name= 'hotelyards',middle_name= '',last_name= 'whitelabel',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '6666666.000',credit_limit= '6666666.000',credit_distribution= '0',temp_credit_limit= '',address= 'address lane 1',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='32',phone= '91-9876598765',mobile= '91-9876598765',fax= '91-',currency= '6',email= 'deepak.trivedi@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= 'Associate',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= 'Hotel Yards',allow_quotation= '1',can_voucher= '',markup= '0.5',allow_book_under_cancellation='0',modify_date='2024-05-22 06:56:34',consultant_id= 'hotelyards',agency_email= '',acc_name= 'HOTEL YARDS',acc_email= 'deepak.trivedi@qtechsoftware.com',acc_phone= '1234567890',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '' WHERE id= '7868';
[05/22/2024 06:56:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'hotelyards',`create_date`= '2024-05-22 06:56:34',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;hotelyards\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;whitelabel\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;6666666.000\&#039;,credit_limit= \&#039;6666666.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;address lane 1\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;32\&#039;,phone= \&#039;91-9876598765\&#039;,mobile= \&#039;91-9876598765\&#039;,fax= \&#039;91-\&#039;,currency= \&#039;6\&#039;,email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;Associate\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;Hotel Yards\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 0,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2024-05-22 06:56:34\&#039;,consultant_id= \&#039;hotelyards\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;HOTEL YARDS\&#039;,acc_email= \&#039;deepak.trivedi@qtechsoftware.com\&#039;,acc_phone= \&#039;1234567890\&#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 WHERE id= \&#039;7868\&#039;',`log_description`= 'Agent 7868 updated For  - modify_date=2024-05-22+06%3A01%3A34 changed to - modify_date=2024-05-22+06%3A56%3A34',`ip`= '43.239.53.130';
[05/22/2024 06:56:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7868' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[05/22/2024 06:56:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by hotelyards',create_date='2024-05-22 06:05:34';
[05/22/2024 06:56:34], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '32',consultant_id= 'hotelyards',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7868';
