[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '102' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '99' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '56' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '84' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '101' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '97' ,status = '' ,priority = '' ,lead_time = '1440',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '81' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '78' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '83' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '68' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '90' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '66' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '64' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '65' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1239',supplier_id = '69' ,status = '' ,priority = '27' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '27';
[07/16/2024 05:01:52], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-16 05:01:52',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#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;1239\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#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;1239\&#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;1239\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#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;1239\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#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;1239\&#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;1239\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#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;1239\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#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;1239\&#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;1239\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#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;1239\&#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;1239\&#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;1239\&#039;,supplier_id = 103 ,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;1239\&#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;1239\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#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;1239\&#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;1239\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1440\&#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;1239\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1239\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;27\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;27\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1239 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/16/2024 05:01:57], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-16 05:01:57',login_attempt=0 where id = '1239';
[07/16/2024 05:01:57], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'agent_qtech', user_type = 'A', branch_id = '26', login_datetime = '2024-07-16 05:01:57', ip = '43.239.53.130', action = 'Login' ;
[07/16/2024 05:04:22], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/17' , departure_date = '2024/07/18' , nights = '1' , nationality = '112' , room_types = '2.1, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":1},{"numberOfAdults":2,"numberOfChild":2}]' , available='0' , create_date = '2024-07-16 05:04:22' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/16/2024 05:04:36], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_61_5.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_61_5.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_61_5.json', 'ebookingcenter', '2024-07-16 05:04:36', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_61_5.json');
[07/16/2024 05:04:36], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_90_9.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_90_9.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_90_9.json', 'ebookingcenter', '2024-07-16 05:04:36', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_90_9.json');
[07/16/2024 05:04:36], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_23_2.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_23_2.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_23_2.json', 'ebookingcenter', '2024-07-16 05:04:36', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_23_2.json');
[07/16/2024 05:04:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=9&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.899'
        , request_start_time = '0.179'
        , parsing_start_time = '10.120'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '10.963'
        , error_description = ''
        , memory_used = '34577744'
        WHERE id = '160822744';
[07/16/2024 05:04:37], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_45_3.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_45_3.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_45_3.json', 'ebookingcenter', '2024-07-16 05:04:37', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_45_3.json');
[07/16/2024 05:04:37], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_92_7.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_7.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_92_7.json', 'ebookingcenter', '2024-07-16 05:04:37', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_7.json');
[07/16/2024 05:04:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=5&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.898'
        , request_start_time = '0.179'
        , parsing_start_time = '10.070'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '11.694'
        , error_description = ''
        , memory_used = '61987376'
        WHERE id = '160822743';
[07/16/2024 05:04:37], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_40_1.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_40_1.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_40_1.json', 'ebookingcenter', '2024-07-16 05:04:37', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_40_1.json');
[07/16/2024 05:04:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=2&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.900'
        , request_start_time = '0.179'
        , parsing_start_time = '10.585'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.018'
        , error_description = ''
        , memory_used = '73983272'
        WHERE id = '160822745';
[07/16/2024 05:04:37], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_92_6.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_6.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_92_6.json', 'ebookingcenter', '2024-07-16 05:04:37', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_6.json');
[07/16/2024 05:04:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=3&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.898'
        , request_start_time = '0.180'
        , parsing_start_time = '10.954'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.543'
        , error_description = ''
        , memory_used = '96918968'
        WHERE id = '160822746';
[07/16/2024 05:04:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=7&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.900'
        , request_start_time = '0.180'
        , parsing_start_time = '11.186'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.829'
        , error_description = ''
        , memory_used = '93276240'
        WHERE id = '160822747';
[07/16/2024 05:04:38], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=1&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.899'
        , request_start_time = '0.180'
        , parsing_start_time = '11.493'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '12.975'
        , error_description = ''
        , memory_used = '87630920'
        WHERE id = '160822748';
[07/16/2024 05:04:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=6&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.900'
        , request_start_time = '0.179'
        , parsing_start_time = '11.822'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '13.184'
        , error_description = ''
        , memory_used = '85853832'
        WHERE id = '160822749';
[07/16/2024 05:04: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_86_8.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_86_8.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_86_8.json', 'ebookingcenter', '2024-07-16 05:04:39', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_86_8.json');
[07/16/2024 05:04:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=8&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.899'
        , request_start_time = '0.179'
        , parsing_start_time = '13.124'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '14.619'
        , error_description = ''
        , memory_used = '122664824'
        WHERE id = '160822750';
[07/16/2024 05:04: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_92_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_92_0.json', 'ebookingcenter', '2024-07-16 05:04:40', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_92_0.json');
[07/16/2024 05:04: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_04_26_1721106266_29_4.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_29_4.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_04_26_1721106266_29_4.json', 'ebookingcenter', '2024-07-16 05:04:41', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_04_26_1721106266_29_4.json');
[07/16/2024 05:04:42], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.900'
        , request_start_time = '0.180'
        , parsing_start_time = '14.782'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '16.382'
        , error_description = ''
        , memory_used = '128086136'
        WHERE id = '160822751';
[07/16/2024 05:04:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=4&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:04:25.898'
        , request_start_time = '0.179'
        , parsing_start_time = '15.884'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '17.743'
        , error_description = ''
        , memory_used = '139404632'
        WHERE id = '160822752';
[07/16/2024 05:04:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391620240705042278693160929',
        duration = '20.809',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.49',
        system_load_5_min = '1.45',
        system_load_15_min = '1.23',
        system_memory_usage = '26.85',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13358211') + '202021632',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13358211';
[07/16/2024 05:05:10], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_05_06_1721106306_93_7.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_05_06_1721106306_93_7.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_05_06_1721106306_93_7.json', 'ebookingcenter', '2024-07-16 05:05:10', '', '12391620240705042278693160929', '13358211', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_05_06_1721106306_93_7.json');
[07/16/2024 05:05:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705042278693160929&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=7&total_request=10&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:05:06.623'
        , request_start_time = '0.012'
        , parsing_start_time = '4.287'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.729'
        , error_description = ''
        , memory_used = '93332096'
        WHERE id = '160822755';
[07/16/2024 05:21:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/17' , departure_date = '2024/07/18' , nights = '1' , nationality = '112' , room_types = '2.1, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"7,6"}]' , available='1' , create_date = '2024-07-16 05:21:23' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/16/2024 05:21:27], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_24_1721107284_12_2.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_12_2.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_24_1721107284_12_2.json', 'ebookingcenter', '2024-07-16 05:21:27', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_12_2.json');
[07/16/2024 05:21:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=2&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:24.435'
        , request_start_time = '0.228'
        , parsing_start_time = '2.433'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.811'
        , error_description = ''
        , memory_used = '10053032'
        WHERE id = '160822794';
[07/16/2024 05:21: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_24_1721107284_1_1.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_1_1.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_24_1721107284_1_1.json', 'ebookingcenter', '2024-07-16 05:21:29', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_1_1.json');
[07/16/2024 05:21:30], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=1&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:24.435'
        , request_start_time = '0.230'
        , parsing_start_time = '4.654'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.736'
        , error_description = ''
        , memory_used = '75710656'
        WHERE id = '160822795';
[07/16/2024 05:21: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_24_1721107284_60_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_60_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_24_1721107284_60_0.json', 'ebookingcenter', '2024-07-16 05:21:32', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_24_1721107284_60_0.json');
[07/16/2024 05:21:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:24.436'
        , request_start_time = '0.221'
        , parsing_start_time = '7.414'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.789'
        , error_description = ''
        , memory_used = '115174616'
        WHERE id = '160822796';
[07/16/2024 05:21:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391620240705212353575394307',
        duration = '8.930',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.08',
        system_load_5_min = '1.13',
        system_load_15_min = '1.20',
        system_memory_usage = '55.56',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13358219') + '140226736',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13358219';
[07/16/2024 05:21:55], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_47_1721107307_97_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_47_1721107307_97_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_47_1721107307_97_0.json', 'ebookingcenter', '2024-07-16 05:21:55', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_47_1721107307_97_0.json');
[07/16/2024 05:21:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:47.880'
        , request_start_time = '0.009'
        , parsing_start_time = '7.291'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.901'
        , error_description = ''
        , memory_used = '115215400'
        WHERE id = '160822797';
[07/16/2024 05:21:56], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1239' , 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 = '112' , service_type = 'hotel' , arrival_date = '2024/07/17' , departure_date = '2024/07/18' , nights = '1' , nationality = '112' , room_types = '2.1, 2.2' , room_type='[{"numberOfAdults":2,"numberOfChild":1,"ChildAge":"4"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"7,6"}]' , available='0' , create_date = '2024-07-16 05:21:56' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/16/2024 05:21:59], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_57_1721107317_90_2.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_90_2.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_57_1721107317_90_2.json', 'ebookingcenter', '2024-07-16 05:21:59', '', '12391620240705215611955861569', '13358220', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_90_2.json');
[07/16/2024 05:21:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705215611955861569&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=2&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:57.754'
        , request_start_time = '0.171'
        , parsing_start_time = '1.777'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '2.084'
        , error_description = ''
        , memory_used = '10055064'
        WHERE id = '160822798';
[07/16/2024 05:22:02], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_57_1721107317_32_1.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_32_1.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_57_1721107317_32_1.json', 'ebookingcenter', '2024-07-16 05:22:02', '', '12391620240705215611955861569', '13358220', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_32_1.json');
[07/16/2024 05:22:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705215611955861569&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=1&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:57.755'
        , request_start_time = '0.167'
        , parsing_start_time = '4.501'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '5.602'
        , error_description = ''
        , memory_used = '75767240'
        WHERE id = '160822799';
[07/16/2024 05:22:05], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_21_57_1721107317_74_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_74_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_21_57_1721107317_74_0.json', 'ebookingcenter', '2024-07-16 05:22:05', '', '12391620240705215611955861569', '13358220', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_21_57_1721107317_74_0.json');
[07/16/2024 05:22:06], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705215611955861569&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:21:57.755'
        , request_start_time = '0.162'
        , parsing_start_time = '7.348'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.658'
        , error_description = ''
        , memory_used = '114856776'
        WHERE id = '160822800';
[07/16/2024 05:22:06], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=1239&sessionid=12391620240705215611955861569',
        duration = '8.791',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.36',
        system_load_5_min = '1.20',
        system_load_15_min = '1.22',
        system_memory_usage = '55.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '13358220') + '139956696',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '13358220';
[07/16/2024 05:28:41], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:28:41', ip = '205.210.31.26', action = 'Login' ;
[07/16/2024 05:30:03], [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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_29_56_1721107796_95_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_29_56_1721107796_95_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_29_56_1721107796_95_0.json', 'ebookingcenter', '2024-07-16 05:30:03', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_29_56_1721107796_95_0.json');
[07/16/2024 05:30:05], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:29:56.633'
        , request_start_time = '0.013'
        , parsing_start_time = '7.211'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '9.016'
        , error_description = ''
        , memory_used = '114925992'
        WHERE id = '160823413';
[07/16/2024 05:30:28], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-16 05:30:28', ip = '205.234.144.77', action = 'Login' ;
[07/16/2024 05:30:29], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-16 05:30:29', ip = '205.234.144.77', action = 'Login' ;
[07/16/2024 05:30:29], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-07-16 05:30:29', ip = '205.234.144.77', action = 'Login' ;
[07/16/2024 05:31:06], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_30_59_1721107859_67_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_30_59_1721107859_67_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_30_59_1721107859_67_0.json', 'ebookingcenter', '2024-07-16 05:31:06', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_30_59_1721107859_67_0.json');
[07/16/2024 05:31:08], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:30:59.198'
        , request_start_time = '0.011'
        , parsing_start_time = '7.234'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.997'
        , error_description = ''
        , memory_used = '114880296'
        WHERE id = '160823419';
[07/16/2024 05:33: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', 'ebookingcenter/16_07_2024/request_availability_agent_qtech_05_33_24_1721108004_80_0.json', 'ebookingcenter/16_07_2024/response_availability_agent_qtech_05_33_24_1721108004_80_0.json', 'ebookingcenter/16_07_2024/response_header_availability_agent_qtech_05_33_24_1721108004_80_0.json', 'ebookingcenter', '2024-07-16 05:33:31', '', '12391620240705212353575394307', '13358219', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/ebookingcenter/16_07_2024/response_availability_agent_qtech_05_33_24_1721108004_80_0.json');
[07/16/2024 05:33:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=ebookingcenter&sessionid=12391620240705212353575394307&xml_user_id=1239&db_caching=1&wh_agent_id=&erequest=0&total_request=3&city_code=2555&city_name=DUBAI&country_code=350&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-16 05:33:24.157'
        , request_start_time = '0.011'
        , parsing_start_time = '7.370'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '8.964'
        , error_description = ''
        , memory_used = '114907640'
        WHERE id = '160823420';
[07/16/2024 05:47:03], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:03', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:08], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:08', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:08], [file name :-/efsdata/otrams/public_html/beta/about_us.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:08', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:09', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:13], [file name :-/efsdata/otrams/public_html/beta/terms.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:13', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:13], [file name :-/efsdata/otrams/public_html/beta/supplier_registration.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:13', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:13], [file name :-/efsdata/otrams/public_html/beta/contact_us.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:13', ip = '154.28.229.246', action = 'Login' ;
[07/16/2024 05:47:14], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-16 05:47:14', ip = '154.28.229.246', action = 'Login' ;
