[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '77' ,status = '' ,priority = '14' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '98' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '101' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '97' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:12:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-08-21 07:12:41',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 98 ,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;2406\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2406 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[08/21/2024 07:12:44], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-21 07:12:44',login_attempt=0 where id = '2406';
[08/21/2024 07:12:44], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-08-21 07:12:44', ip = '43.239.53.130', action = 'Login' ;
[08/21/2024 07:13:54], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'amsterdam' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/20' , departure_date = '2024/09/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:13:54' , site_id = '' , country_code = '80' , city_code = '55876' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:13:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807135495634056115', session_id='24062120240807135495634056115', Collection_create_time='2024-08-21 07:13:55';
[08/21/2024 07:13:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807135495634056115',
        duration = '1.069',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.20',
        system_load_5_min = '2.61',
        system_load_15_min = '2.44',
        system_memory_usage = '34.52',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15000982') + '2848280',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15000982';
[08/21/2024 07:14:13], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/20' , departure_date = '2024/09/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:14:13' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:14:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807141381137284219', session_id='24062120240807141381137284219', Collection_create_time='2024-08-21 07:14:14';
[08/21/2024 07:14:15], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807141381137284219',
        duration = '1.076',
        merge_duration = '0.030',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.86',
        system_load_5_min = '2.51',
        system_load_15_min = '2.41',
        system_memory_usage = '34.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15000992') + '2848992',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15000992';
[08/21/2024 07:14:27], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/02' , departure_date = '2024/09/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:14:27' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:14:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807142745822920841', session_id='24062120240807142745822920841', Collection_create_time='2024-08-21 07:14:27';
[08/21/2024 07:14:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '299',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807142745822920841',
        duration = '8.096',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.67',
        system_load_5_min = '2.43',
        system_load_15_min = '2.39',
        system_memory_usage = '34.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001001') + '2849296',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001001';
[08/21/2024 07:14:46], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'vienna' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/22' , departure_date = '2024/09/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:14:46' , site_id = '' , country_code = '46' , city_code = '48895' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:14:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807144634644749254', session_id='24062120240807144634644749254', Collection_create_time='2024-08-21 07:14:47';
[08/21/2024 07:14:48], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807144634644749254',
        duration = '1.076',
        merge_duration = '0.019',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.52',
        system_load_5_min = '2.36',
        system_load_15_min = '2.37',
        system_memory_usage = '34.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001003') + '2848896',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001003';
[08/21/2024 07:15:36], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'amsterdam' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/02' , departure_date = '2024/09/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:15:36' , site_id = '' , country_code = '80' , city_code = '55876' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:15:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807153635646324471', session_id='24062120240807153635646324471', Collection_create_time='2024-08-21 07:15:37';
[08/21/2024 07:15:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '373',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807153635646324471',
        duration = '8.232',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.99',
        system_load_5_min = '2.76',
        system_load_15_min = '2.51',
        system_memory_usage = '34.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001024') + '2849384',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001024';
[08/21/2024 07:16:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/22' , departure_date = '2024/09/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:16:35' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:16:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_2406212024080716353339870050', session_id='2406212024080716353339870050', Collection_create_time='2024-08-21 07:16:36';
[08/21/2024 07:16:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=2406212024080716353339870050',
        duration = '1.076',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.40',
        system_load_5_min = '2.64',
        system_load_15_min = '2.48',
        system_memory_usage = '34.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001109') + '2848864',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001109';
[08/21/2024 07:16:51], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/22' , departure_date = '2024/09/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:16:51' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:16:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807165142208438186', session_id='24062120240807165142208438186', Collection_create_time='2024-08-21 07:16:51';
[08/21/2024 07:16:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807165142208438186',
        duration = '1.057',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.31',
        system_load_5_min = '2.61',
        system_load_15_min = '2.48',
        system_memory_usage = '34.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001156') + '2848256',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001156';
[08/21/2024 07:17:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'rome' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/22' , departure_date = '2024/09/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:17:25' , site_id = '' , country_code = '68' , city_code = '68_ROM_4455' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:17:26], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807172514776236572', session_id='24062120240807172514776236572', Collection_create_time='2024-08-21 07:17:26';
[08/21/2024 07:17:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807172514776236572',
        duration = '1.090',
        merge_duration = '0.013',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.23',
        system_load_5_min = '2.54',
        system_load_15_min = '2.46',
        system_memory_usage = '34.46',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001187') + '2848904',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001187';
[08/21/2024 07:17:37], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'rome' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/03' , departure_date = '2024/09/04' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:17:37' , site_id = '' , country_code = '68' , city_code = '68_ROM_4455' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:17:38], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807173742390352865', session_id='24062120240807173742390352865', Collection_create_time='2024-08-21 07:17:38';
[08/21/2024 07:17:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1341',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807173742390352865',
        duration = '11.103',
        merge_duration = '0.022',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '3.07',
        system_load_5_min = '2.71',
        system_load_15_min = '2.52',
        system_memory_usage = '34.64',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001191') + '2849480',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001191';
[08/21/2024 07:18:34], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'berlin' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/03' , departure_date = '2024/09/04' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:18:34' , site_id = '' , country_code = '60' , city_code = '52173' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:18:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807183457283925083', session_id='24062120240807183457283925083', Collection_create_time='2024-08-21 07:18:35';
[08/21/2024 07:18:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '389',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807183457283925083',
        duration = '7.098',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.49',
        system_load_5_min = '2.64',
        system_load_15_min = '2.50',
        system_memory_usage = '34.69',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001233') + '2849320',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001233';
[08/21/2024 07:18:57], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'berlin' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/20' , departure_date = '2024/09/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:18:57' , site_id = '' , country_code = '60' , city_code = '52173' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:18:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807185748566572885', session_id='24062120240807185748566572885', Collection_create_time='2024-08-21 07:18:57';
[08/21/2024 07:18:58], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807185748566572885',
        duration = '1.096',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.06',
        system_load_5_min = '2.52',
        system_load_15_min = '2.47',
        system_memory_usage = '34.69',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001238') + '2848256',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001238';
[08/21/2024 07:19:42], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/20' , departure_date = '2024/09/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:19:42' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:19:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807194289573814115', session_id='24062120240807194289573814115', Collection_create_time='2024-08-21 07:19:43';
[08/21/2024 07:19:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807194289573814115',
        duration = '1.130',
        merge_duration = '0.036',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.14',
        system_load_5_min = '2.48',
        system_load_15_min = '2.46',
        system_memory_usage = '34.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001277') + '2848720',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001277';
[08/21/2024 07:19:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/02' , departure_date = '2024/09/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:19:53' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:19:54], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807195396353680128', session_id='24062120240807195396353680128', Collection_create_time='2024-08-21 07:19:54';
[08/21/2024 07:20:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1988',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807195396353680128',
        duration = '14.754',
        merge_duration = '1.669',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.97',
        system_load_5_min = '2.43',
        system_load_15_min = '2.44',
        system_memory_usage = '34.77',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001279') + '8200888',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001279';
[08/21/2024 07:20:22], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/25' , departure_date = '2024/09/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:20:22' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:20:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807202253650797069', session_id='24062120240807202253650797069', Collection_create_time='2024-08-21 07:20:23';
[08/21/2024 07:20:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807202253650797069',
        duration = '1.098',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.79',
        system_load_5_min = '2.34',
        system_load_15_min = '2.41',
        system_memory_usage = '34.95',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001292') + '2848720',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001292';
[08/21/2024 07:21:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/03' , departure_date = '2024/09/04' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:21:29' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:21:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807212939450517675', session_id='24062120240807212939450517675', Collection_create_time='2024-08-21 07:21:30';
[08/21/2024 07:21:46], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1928',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807212939450517675',
        duration = '16.686',
        merge_duration = '1.581',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.49',
        system_load_5_min = '2.14',
        system_load_15_min = '2.33',
        system_memory_usage = '34.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001353') + '7924752',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001353';
[08/21/2024 07:21:56], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1724224916','43.239.53.130');
[08/21/2024 07:21:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'tr/21_08_2024/request_valuation_Qtech_pranali_07_21_56_1724224916.json', 'tr/21_08_2024/response_valuation_Qtech_pranali_07_21_56_1724224916.json', 'tr/21_08_2024/response_header_valuation_Qtech_pranali_07_21_56_1724224916.json', 'tripathonxml', '2024-08-21 07:21:57', '', '24062120240807212939450517675', '15001353', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/tr/21_08_2024/response_valuation_Qtech_pranali_07_21_56_1724224916.json');
[08/21/2024 07:22:13], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/24' , departure_date = '2024/09/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:22:13' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:22:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807221377275381844', session_id='24062120240807221377275381844', Collection_create_time='2024-08-21 07:22:13';
[08/21/2024 07:22:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807221377275381844',
        duration = '1.095',
        merge_duration = '0.012',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.32',
        system_load_5_min = '2.01',
        system_load_15_min = '2.28',
        system_memory_usage = '34.72',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001377') + '2848720',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001377';
[08/21/2024 07:22:42], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/10' , departure_date = '2024/09/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:22:42' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:22:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807224233996603784', session_id='24062120240807224233996603784', Collection_create_time='2024-08-21 07:22:43';
[08/21/2024 07:22:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1896',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807224233996603784',
        duration = '16.658',
        merge_duration = '1.567',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.27',
        system_load_5_min = '1.93',
        system_load_15_min = '2.25',
        system_memory_usage = '34.72',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001393') + '7516552',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001393';
[08/21/2024 07:23:11], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'paris' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/09/11' , departure_date = '2024/09/12' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:23:11' , site_id = '' , country_code = '58' , city_code = '51090' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:23:12], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062120240807231145607237011', session_id='24062120240807231145607237011', Collection_create_time='2024-08-21 07:23:12';
[08/21/2024 07:23:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2406&sessionid=24062120240807231145607237011',
        duration = '1.088',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '1.39',
        system_load_5_min = '1.89',
        system_load_15_min = '2.22',
        system_memory_usage = '34.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15001458') + '2848880',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15001458';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '98' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '101' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '97' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/21/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-08-21 07:54:54',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 98 ,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;1089\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#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;1089\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1089 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[08/21/2024 07:54:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-21 07:54:58',login_attempt=0 where id = '1089';
[08/21/2024 07:54:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-08-21 07:54:58', ip = '43.239.53.130', action = 'Login' ;
[08/21/2024 07:55:34], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'rome' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/09/27' , departure_date = '2024/09/28' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-08-21 07:55:34' , site_id = '' , country_code = '68' , city_code = '68_ROM_4455' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[08/21/2024 07:55:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892120240807553420734332276', session_id='10892120240807553420734332276', Collection_create_time='2024-08-21 07:55:35';
[08/21/2024 07:55:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1089&sessionid=10892120240807553420734332276',
        duration = '1.110',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '',
        system_load_1_min = '2.66',
        system_load_5_min = '2.49',
        system_load_15_min = '2.36',
        system_memory_usage = '34.41',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '15004702') + '2848952',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '15004702';
[08/21/2024 07:55:49], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892120240807553420734332276', session_id='10892120240807553420734332276', Collection_create_time='2024-08-21 07:55:49';
[08/21/2024 07:59:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892120240807553420734332276', session_id='10892120240807553420734332276', Collection_create_time='2024-08-21 07:59:05';
[08/21/2024 07:59:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892120240807553420734332276', session_id='10892120240807553420734332276', Collection_create_time='2024-08-21 07:59:09';
