[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/30/2024 10:24:39], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'shiv_qtech',`create_date`= '2024-09-30 10:24:39',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;120\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 101 ,status = \&#039;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;1284\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[09/30/2024 10:24:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-30 10:24:43',login_attempt=0 where id = '1284';
[09/30/2024 10:24:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-09-30 10:24:43', ip = '43.239.53.130', action = 'Login' ;
[09/30/2024 10:27:21], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/19' , nights = '3' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-30 10:27:21' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 10:27:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240910272126087776672', session_id='12843020240910272126087776672', Collection_create_time='2024-09-30 10:27:22';
[09/30/2024 10:27:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_172769204311.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204311.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_172769204311.json', 'ratehawk', '2024-09-30 10:27:31', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204311.json');
[09/30/2024 10:27:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.735'
        , request_start_time = '0.715'
        , parsing_start_time = '7.949'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.080'
        , search_end_time = '0.070'
        , total_duration = '8.847'
        , error_description = ''
        , memory_used = '29957504'
        WHERE id = '189105925';
[09/30/2024 10:27: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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_172769204312.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204312.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_172769204312.json', 'ratehawk', '2024-09-30 10:27:33', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204312.json');
[09/30/2024 10:27:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.738'
        , request_start_time = '0.673'
        , parsing_start_time = '9.654'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.103'
        , search_end_time = '0.063'
        , total_duration = '10.526'
        , error_description = ''
        , memory_used = '38379432'
        WHERE id = '189105928';
[09/30/2024 10:27: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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_172769204313.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204313.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_172769204313.json', 'ratehawk', '2024-09-30 10:27:38', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204313.json');
[09/30/2024 10:27:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=13&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.740'
        , request_start_time = '0.762'
        , parsing_start_time = '15.327'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.023'
        , search_end_time = '0.014'
        , total_duration = '16.152'
        , error_description = ''
        , memory_used = '4407056'
        WHERE id = '189105957';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_172769204310.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204310.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_172769204310.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_172769204310.json');
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920437.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920437.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920437.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920437.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.734'
        , request_start_time = '0.579'
        , parsing_start_time = '15.709'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.061'
        , search_end_time = '0.067'
        , total_duration = '16.449'
        , error_description = ''
        , memory_used = '17645648'
        WHERE id = '189105958';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920439.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920439.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920439.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920439.json');
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920438.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920438.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920438.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920438.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.726'
        , request_start_time = '0.590'
        , parsing_start_time = '15.830'
        , mapping_complete_time = '0.098'
        , mongo_start_time = '0.173'
        , search_end_time = '0.096'
        , total_duration = '16.729'
        , error_description = ''
        , memory_used = '67101040'
        WHERE id = '189105959';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_22_17276920420.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920420.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_22_17276920420.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920420.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '40'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.734'
        , request_start_time = '0.586'
        , parsing_start_time = '15.843'
        , mapping_complete_time = '0.108'
        , mongo_start_time = '0.194'
        , search_end_time = '0.100'
        , total_duration = '16.765'
        , error_description = ''
        , memory_used = '74957168'
        WHERE id = '189105960';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920436.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920436.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920436.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920436.json');
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920435.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920435.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920435.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920435.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '33'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.728'
        , request_start_time = '0.540'
        , parsing_start_time = '16.109'
        , mapping_complete_time = '0.087'
        , mongo_start_time = '0.151'
        , search_end_time = '0.073'
        , total_duration = '16.909'
        , error_description = ''
        , memory_used = '59426360'
        WHERE id = '189105963';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920434.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920434.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920434.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920434.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.721'
        , request_start_time = '0.497'
        , parsing_start_time = '16.292'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.125'
        , search_end_time = '0.055'
        , total_duration = '17.003'
        , error_description = ''
        , memory_used = '48387896'
        WHERE id = '189105967';
[09/30/2024 10:27:39], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_23_17276920433.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920433.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_23_17276920433.json', 'ratehawk', '2024-09-30 10:27:39', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_23_17276920433.json');
[09/30/2024 10:27:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '33'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.725'
        , request_start_time = '0.462'
        , parsing_start_time = '16.312'
        , mapping_complete_time = '0.104'
        , mongo_start_time = '0.185'
        , search_end_time = '0.110'
        , total_duration = '17.111'
        , error_description = ''
        , memory_used = '68864936'
        WHERE id = '189105966';
[09/30/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.715'
        , request_start_time = '0.121'
        , parsing_start_time = '16.625'
        , mapping_complete_time = '0.167'
        , mongo_start_time = '0.343'
        , search_end_time = '0.156'
        , total_duration = '17.297'
        , error_description = ''
        , memory_used = '112426928'
        WHERE id = '189105965';
[09/30/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.721'
        , request_start_time = '0.537'
        , parsing_start_time = '16.410'
        , mapping_complete_time = '0.124'
        , mongo_start_time = '0.223'
        , search_end_time = '0.103'
        , total_duration = '17.316'
        , error_description = ''
        , memory_used = '83084920'
        WHERE id = '189105969';
[09/30/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.718'
        , request_start_time = '0.319'
        , parsing_start_time = '16.718'
        , mapping_complete_time = '0.128'
        , mongo_start_time = '0.233'
        , search_end_time = '0.114'
        , total_duration = '17.430'
        , error_description = ''
        , memory_used = '84344312'
        WHERE id = '189105970';
[09/30/2024 10:27:40], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_22_17276920422.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920422.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_22_17276920422.json', 'ratehawk', '2024-09-30 10:27:40', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920422.json');
[09/30/2024 10:27: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', 'rh/30_09_2024/request_availability_qtech_agent_10_27_22_17276920421.json', 'rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920421.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_27_22_17276920421.json', 'ratehawk', '2024-09-30 10:27:41', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_27_22_17276920421.json');
[09/30/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '101'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.718'
        , request_start_time = '0.232'
        , parsing_start_time = '17.585'
        , mapping_complete_time = '0.279'
        , mongo_start_time = '0.608'
        , search_end_time = '0.286'
        , total_duration = '18.777'
        , error_description = ''
        , memory_used = '191324816'
        WHERE id = '189105974';
[09/30/2024 10:27:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '135'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:27:22.715'
        , request_start_time = '0.202'
        , parsing_start_time = '18.327'
        , mapping_complete_time = '0.323'
        , mongo_start_time = '0.693'
        , search_end_time = '0.360'
        , total_duration = '19.657'
        , error_description = ''
        , memory_used = '229220552'
        WHERE id = '189105976';
[09/30/2024 10:27:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '626',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240910272126087776672',
        duration = '22.080',
        merge_duration = '0.043',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.57',
        system_load_5_min = '2.23',
        system_load_15_min = '4.10',
        system_memory_usage = '27.17',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16612719') + '5902112',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16612719';
[09/30/2024 10:27:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240910272126087776672', session_id='12843020240910272126087776672', Collection_create_time='2024-09-30 10:27:44';
[09/30/2024 10:28: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', 'rh/30_09_2024/request_availability_qtech_agent_10_28_25_17276921050.json', 'rh/30_09_2024/response_availability_qtech_agent_10_28_25_17276921050.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_28_25_17276921050.json', 'ratehawk', '2024-09-30 10:28:33', '', '12843020240910272126087776672', '16612719', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_28_25_17276921050.json');
[09/30/2024 10:28:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910272126087776672&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-09-30 10:28:25.670'
        , request_start_time = '0.088'
        , parsing_start_time = '7.373'
        , mapping_complete_time = '0.161'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.755'
        , error_description = ''
        , memory_used = '110575296'
        WHERE id = '189106397';
[09/30/2024 10:29:16], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/19' , nights = '3' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-30 10:29:16' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[09/30/2024 10:29:17], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12843020240910291670307519569', session_id='12843020240910291670307519569', Collection_create_time='2024-09-30 10:29:17';
[09/30/2024 10:29:25], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921584.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921584.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921584.json', 'ratehawk', '2024-09-30 10:29:25', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921584.json');
[09/30/2024 10:29:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '43'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=4&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.920'
        , request_start_time = '0.323'
        , parsing_start_time = '7.135'
        , mapping_complete_time = '0.126'
        , mongo_start_time = '0.218'
        , search_end_time = '0.134'
        , total_duration = '7.858'
        , error_description = ''
        , memory_used = '83840688'
        WHERE id = '189106668';
[09/30/2024 10:29:28], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921589.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921589.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921589.json', 'ratehawk', '2024-09-30 10:29:28', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921589.json');
[09/30/2024 10:29:28], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_172769215811.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215811.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_172769215811.json', 'ratehawk', '2024-09-30 10:29:28', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215811.json');
[09/30/2024 10:29:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=11&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.935'
        , request_start_time = '0.684'
        , parsing_start_time = '9.802'
        , mapping_complete_time = '0.049'
        , mongo_start_time = '0.090'
        , search_end_time = '0.069'
        , total_duration = '10.681'
        , error_description = ''
        , memory_used = '31542504'
        WHERE id = '189106680';
[09/30/2024 10:29:28], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_172769215812.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215812.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_172769215812.json', 'ratehawk', '2024-09-30 10:29:28', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215812.json');
[09/30/2024 10:29:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '40'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=9&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.932'
        , request_start_time = '0.609'
        , parsing_start_time = '9.824'
        , mapping_complete_time = '0.112'
        , mongo_start_time = '0.197'
        , search_end_time = '0.100'
        , total_duration = '10.806'
        , error_description = ''
        , memory_used = '74356720'
        WHERE id = '189106679';
[09/30/2024 10:29:28], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921587.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921587.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921587.json', 'ratehawk', '2024-09-30 10:29:28', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921587.json');
[09/30/2024 10:29:28], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '29'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=12&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.940'
        , request_start_time = '0.740'
        , parsing_start_time = '9.882'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.115'
        , search_end_time = '0.074'
        , total_duration = '10.915'
        , error_description = ''
        , memory_used = '37384496'
        WHERE id = '189106681';
[09/30/2024 10:29:28], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921583.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921583.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921583.json', 'ratehawk', '2024-09-30 10:29:28', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921583.json');
[09/30/2024 10:29:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=7&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.926'
        , request_start_time = '0.670'
        , parsing_start_time = '10.143'
        , mapping_complete_time = '0.100'
        , mongo_start_time = '0.175'
        , search_end_time = '0.093'
        , total_duration = '11.121'
        , error_description = ''
        , memory_used = '67171728'
        WHERE id = '189106683';
[09/30/2024 10:29:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '50'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=3&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.917'
        , request_start_time = '0.521'
        , parsing_start_time = '10.499'
        , mapping_complete_time = '0.121'
        , mongo_start_time = '0.216'
        , search_end_time = '0.116'
        , total_duration = '11.392'
        , error_description = ''
        , memory_used = '83723256'
        WHERE id = '189106686';
[09/30/2024 10:29: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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921580.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921580.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921580.json', 'ratehawk', '2024-09-30 10:29:29', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921580.json');
[09/30/2024 10:29:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=0&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.910'
        , request_start_time = '0.126'
        , parsing_start_time = '11.383'
        , mapping_complete_time = '0.164'
        , mongo_start_time = '0.336'
        , search_end_time = '0.156'
        , total_duration = '12.051'
        , error_description = ''
        , memory_used = '110948600'
        WHERE id = '189106690';
[09/30/2024 10:29:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_172769215813.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215813.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_172769215813.json', 'ratehawk', '2024-09-30 10:29:31', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215813.json');
[09/30/2024 10:29:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '2'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=13&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.939'
        , request_start_time = '0.558'
        , parsing_start_time = '12.654'
        , mapping_complete_time = '0.012'
        , mongo_start_time = '0.022'
        , search_end_time = '0.014'
        , total_duration = '13.278'
        , error_description = ''
        , memory_used = '4407112'
        WHERE id = '189106719';
[09/30/2024 10:29:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921585.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921585.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921585.json', 'ratehawk', '2024-09-30 10:29:31', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921585.json');
[09/30/2024 10:29:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921588.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921588.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921588.json', 'ratehawk', '2024-09-30 10:29:31', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921588.json');
[09/30/2024 10:29:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_172769215810.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215810.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_172769215810.json', 'ratehawk', '2024-09-30 10:29:31', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_172769215810.json');
[09/30/2024 10:29:31], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921586.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921586.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921586.json', 'ratehawk', '2024-09-30 10:29:31', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921586.json');
[09/30/2024 10:29:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '25'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=5&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.921'
        , request_start_time = '0.363'
        , parsing_start_time = '13.042'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.121'
        , search_end_time = '0.056'
        , total_duration = '13.622'
        , error_description = ''
        , memory_used = '48620496'
        WHERE id = '189106720';
[09/30/2024 10:29:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=10&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.932'
        , request_start_time = '0.557'
        , parsing_start_time = '12.894'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.059'
        , search_end_time = '0.107'
        , total_duration = '13.656'
        , error_description = ''
        , memory_used = '17382744'
        WHERE id = '189106722';
[09/30/2024 10:29:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '33'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=8&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.930'
        , request_start_time = '0.575'
        , parsing_start_time = '12.850'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.159'
        , search_end_time = '0.073'
        , total_duration = '13.695'
        , error_description = ''
        , memory_used = '63449056'
        WHERE id = '189106721';
[09/30/2024 10:29:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '33'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=6&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.924'
        , request_start_time = '0.566'
        , parsing_start_time = '12.947'
        , mapping_complete_time = '0.099'
        , mongo_start_time = '0.175'
        , search_end_time = '0.094'
        , total_duration = '13.824'
        , error_description = ''
        , memory_used = '67891776'
        WHERE id = '189106723';
[09/30/2024 10:29:32], [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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921581.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921581.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921581.json', 'ratehawk', '2024-09-30 10:29:32', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921581.json');
[09/30/2024 10:29:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '135'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=1&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.913'
        , request_start_time = '0.136'
        , parsing_start_time = '14.516'
        , mapping_complete_time = '0.328'
        , mongo_start_time = '0.711'
        , search_end_time = '0.378'
        , total_duration = '15.814'
        , error_description = ''
        , memory_used = '230931648'
        WHERE id = '189106724';
[09/30/2024 10:29: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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_18_17276921582.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921582.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_18_17276921582.json', 'ratehawk', '2024-09-30 10:29:33', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_18_17276921582.json');
[09/30/2024 10:29:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '101'
        , request_url = '/call.php?s=ratehawk&sessionid=12843020240910291670307519569&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=1284&db_caching=1&wh_agent_id=&erequest=2&total_request=14&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-30 10:29:17.915'
        , request_start_time = '0.393'
        , parsing_start_time = '15.495'
        , mapping_complete_time = '0.281'
        , mongo_start_time = '0.612'
        , search_end_time = '0.303'
        , total_duration = '16.868'
        , error_description = ''
        , memory_used = '194132032'
        WHERE id = '189106725';
[09/30/2024 10:29:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '627',
        request_path = '/xml_all.php?userid=1284&sessionid=12843020240910291670307519569',
        duration = '18.993',
        merge_duration = '0.050',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.30',
        system_load_5_min = '2.07',
        system_load_15_min = '3.82',
        system_memory_usage = '27.55',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16612774') + '5435760',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16612774';
[09/30/2024 10:30:02], [file name :-/efsdata/otrams/public_html/beta/method_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', 'rh/30_09_2024/request_availability_qtech_agent_10_29_59_1727692199.json', 'rh/30_09_2024/response_availability_qtech_agent_10_29_59_1727692199.json', 'rh/30_09_2024/response_header_availability_qtech_agent_10_29_59_1727692199.json', 'ratehawk', '2024-09-30 10:30:02', '', '12843020240910291670307519569', '16612774', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/30_09_2024/response_availability_qtech_agent_10_29_59_1727692199.json');
[09/30/2024 10:30:22], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727692222','43.239.53.130');
