[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '77' ,status = '1' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '89' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '102' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '76' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '98' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '58' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '99' ,status = '1' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:40], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '74' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '75' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '96' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '56' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '60' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '84' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '67' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '1' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '101' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '73' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '85' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '103' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '100' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '93' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '57' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '97' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '81' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '78' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '83' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '68' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '90' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '66' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '64' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '65' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '69' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/23/2024 10:27:41], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-23 10:27:41',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#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;2484\&#039;,supplier_id = 89 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 102 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 76 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 98 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#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;2484\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 96 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 60 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 73 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 85 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 103 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 100 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 93 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 81 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 78 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 83 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 68 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 90 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 66 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 69 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2484 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 89 ## company_name - Aos Connect ## supplier_code-aosc  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 102 ## company_name - Bedzinn ## supplier_code-bedzinn  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 74 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 96 ## company_name - GRNConnect - TGX ## supplier_code-grnconnecttgx  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 84 ## company_name - Jumbotours ## supplier_code-jumbotours  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 67 ## company_name - Local System ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 1 ## company_name - Miki ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 73 ## company_name - Restel ## supplier_code-restel  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 85 ## company_name - rooms24x7xml ## supplier_code-rooms24x7xml  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 57 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 81 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 78 ## company_name - Pyton ## supplier_code-pyton  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 83 ## company_name - Hotelbeds Transfer ## supplier_code-hotelbedstransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 68 ## company_name - Local Transfer System ## supplier_code-localtransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 90 ## company_name - Local Sightseeing ## supplier_code-localsightseeing  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 66 ## company_name - Viator Sight Seeing - Live ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2484 ## supplier_id- 64 ## company_name - Groups ## s',`ip`= '43.239.53.130';
[12/23/2024 10:27:45], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-23 10:27:45',login_attempt=0 where id = '2484';
[12/23/2024 10:27:45], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-23 10:27:45', ip = '43.239.53.130', action = 'Login' ;
[12/23/2024 10:27:56], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/12/27' , departure_date = '2024/12/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-23 10:27:56' , 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' ;
[12/23/2024 10:27:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24842320241210275694183598319', session_id='24842320241210275694183598319', Collection_create_time='2024-12-23 10:27:57';
[12/23/2024 10:27:58], [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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_87_4.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_87_4.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_87_4.json', 'hotelbeds', '2024-12-23 10:27:58', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_87_4.json');
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_50_6.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_50_6.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_50_6.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_50_6.json');
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_43_2.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_43_2.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_43_2.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_43_2.json');
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_50_3.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_50_3.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_50_3.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_50_3.json');
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_78_1.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_78_1.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_78_1.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_78_1.json');
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_72_0.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_72_0.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_72_0.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_72_0.json');
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.573'
        , request_start_time = '0.038'
        , parsing_start_time = '1.452'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.107'
        , search_end_time = '0.236'
        , total_duration = '1.871'
        , error_description = ''
        , memory_used = '19330608'
        WHERE id = '208922717';
[12/23/2024 10:27: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', 'h1/23_12_2024/request_availability_Qtech_Goagent_10_27_57_1734949677_100_5.json', 'h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_100_5.json', 'h1/23_12_2024/response_header_availability_Qtech_Goagent_10_27_57_1734949677_100_5.json', 'hotelbeds', '2024-12-23 10:27:59', '\n', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Qtech_Goagent_10_27_57_1734949677_100_5.json');
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '78'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.568'
        , request_start_time = '0.038'
        , parsing_start_time = '1.203'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.194'
        , search_end_time = '0.415'
        , total_duration = '1.895'
        , error_description = ''
        , memory_used = '33799296'
        WHERE id = '208922705';
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.562'
        , request_start_time = '0.042'
        , parsing_start_time = '1.471'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.197'
        , search_end_time = '0.449'
        , total_duration = '2.207'
        , error_description = ''
        , memory_used = '33518032'
        WHERE id = '208922718';
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.560'
        , request_start_time = '0.040'
        , parsing_start_time = '1.562'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.180'
        , search_end_time = '0.405'
        , total_duration = '2.234'
        , error_description = ''
        , memory_used = '31501088'
        WHERE id = '208922725';
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.565'
        , request_start_time = '0.040'
        , parsing_start_time = '1.536'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.190'
        , search_end_time = '0.446'
        , total_duration = '2.261'
        , error_description = ''
        , memory_used = '31881984'
        WHERE id = '208922723';
[12/23/2024 10:27:59], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.558'
        , request_start_time = '0.047'
        , parsing_start_time = '1.611'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.169'
        , search_end_time = '0.413'
        , total_duration = '2.287'
        , error_description = ''
        , memory_used = '31602096'
        WHERE id = '208922728';
[12/23/2024 10:28:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '80'
        , request_url = '/call.php?s=hotelbeds&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:27:57.571'
        , request_start_time = '0.034'
        , parsing_start_time = '1.774'
        , mapping_complete_time = '0.052'
        , mongo_start_time = '0.227'
        , search_end_time = '0.483'
        , total_duration = '2.563'
        , error_description = ''
        , memory_used = '38761976'
        WHERE id = '208922732';
[12/23/2024 10:28:12], [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', 'r2/23_12_2024/request_availability__10_27_57_Qtech_Goagent_1734949677_.xml', 'r2/23_12_2024/response_availability__10_27_57_Qtech_Goagent_1734949677_.xml', 'r2/23_12_2024/response_header_availability__10_27_57_Qtech_Goagent_1734949677_.xml', 'roomsxml', '2024-12-23 10:28:12', '', '24842320241210275694183598319', '18625387', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/23_12_2024/response_availability__10_27_57_Qtech_Goagent_1734949677_.xml');
[12/23/2024 10:28:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '405'
        , request_url = '/call.php?s=roomsxml&sessionid=24842320241210275694183598319&xml_user_id=2484&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2024-12-23 10:27:57.559'
        , request_start_time = '0.049'
        , parsing_start_time = '14.554'
        , mapping_complete_time = '0.626'
        , mongo_start_time = '1.084'
        , search_end_time = '0.908'
        , total_duration = '16.676'
        , error_description = ''
        , memory_used = '106756176'
        WHERE id = '208922891';
[12/23/2024 10:28:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1123',
        request_path = '/xml_all.php?userid=2484&sessionid=24842320241210275694183598319',
        duration = '36.122',
        merge_duration = '5.757',
        assigned_supplier_count = '20',
        searched_supplier_count = '3',
        system_load_1_min = '1.25',
        system_load_5_min = '1.31',
        system_load_15_min = '1.31',
        system_memory_usage = '47.16',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18625387') + '46697088',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18625387';
[12/23/2024 10:43:17], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-23 10:43:17',login_attempt=0 where id = '1089';
[12/23/2024 10:43:17], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-12-23 10:43:17', ip = '43.239.53.130', action = 'Login' ;
[12/23/2024 10:43:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/28' , departure_date = '2024/12/29' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-23 10:43:29' , 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' ;
[12/23/2024 10:43:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10892320241210432925120010001', session_id='10892320241210432925120010001', Collection_create_time='2024-12-23 10:43:30';
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_7_3.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_7_3.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_7_3.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_7_3.json');
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_77_4.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_77_4.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_77_4.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_77_4.json');
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_85_1.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_85_1.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_85_1.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_85_1.json');
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_8_0.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_8_0.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_8_0.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_8_0.json');
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_59_6.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_59_6.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_59_6.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_59_6.json');
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_35_5.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_35_5.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_35_5.json', 'hotelbeds', '2024-12-23 10:43:32', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_35_5.json');
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.405'
        , request_start_time = '0.093'
        , parsing_start_time = '1.989'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.177'
        , search_end_time = '0.403'
        , total_duration = '2.725'
        , error_description = ''
        , memory_used = '31880872'
        WHERE id = '208932807';
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '72'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.407'
        , request_start_time = '0.121'
        , parsing_start_time = '2.011'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.177'
        , search_end_time = '0.371'
        , total_duration = '2.736'
        , error_description = ''
        , memory_used = '30645168'
        WHERE id = '208932808';
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '71'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.406'
        , request_start_time = '0.122'
        , parsing_start_time = '2.190'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.154'
        , search_end_time = '0.338'
        , total_duration = '2.859'
        , error_description = ''
        , memory_used = '28452240'
        WHERE id = '208932814';
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.412'
        , request_start_time = '0.120'
        , parsing_start_time = '2.349'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.112'
        , search_end_time = '0.230'
        , total_duration = '2.855'
        , error_description = ''
        , memory_used = '19583152'
        WHERE id = '208932819';
[12/23/2024 10:43: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_43_30_1734950610_29_2.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_29_2.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_43_30_1734950610_29_2.json', 'hotelbeds', '2024-12-23 10:43:33', '\n', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_43_30_1734950610_29_2.json');
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.410'
        , request_start_time = '0.118'
        , parsing_start_time = '2.297'
        , mapping_complete_time = '0.092'
        , mongo_start_time = '0.237'
        , search_end_time = '0.413'
        , total_duration = '3.123'
        , error_description = ''
        , memory_used = '34755936'
        WHERE id = '208932820';
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.407'
        , request_start_time = '0.107'
        , parsing_start_time = '2.347'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.200'
        , search_end_time = '0.429'
        , total_duration = '3.135'
        , error_description = ''
        , memory_used = '36233936'
        WHERE id = '208932818';
[12/23/2024 10:43:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '74'
        , request_url = '/call.php?s=hotelbeds&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:43:30.406'
        , request_start_time = '0.082'
        , parsing_start_time = '2.794'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.220'
        , search_end_time = '0.389'
        , total_duration = '3.575'
        , error_description = ''
        , memory_used = '35626712'
        WHERE id = '208932825';
[12/23/2024 10:43: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', 'r2/23_12_2024/request_availability__10_43_30_Test_DoNotUse_1734950610_.xml', 'r2/23_12_2024/response_availability__10_43_30_Test_DoNotUse_1734950610_.xml', 'r2/23_12_2024/response_header_availability__10_43_30_Test_DoNotUse_1734950610_.xml', 'roomsxml', '2024-12-23 10:43:41', '', '10892320241210432925120010001', '18626372', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/23_12_2024/response_availability__10_43_30_Test_DoNotUse_1734950610_.xml');
[12/23/2024 10:43:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '473'
        , request_url = '/call.php?s=roomsxml&sessionid=10892320241210432925120010001&xml_user_id=1089&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2024-12-23 10:43:30.406'
        , request_start_time = '0.101'
        , parsing_start_time = '10.973'
        , mapping_complete_time = '0.787'
        , mongo_start_time = '1.323'
        , search_end_time = '1.106'
        , total_duration = '13.599'
        , error_description = ''
        , memory_used = '129866248'
        WHERE id = '208932927';
[12/23/2024 10:44:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1097',
        request_path = '/xml_all.php?userid=1089&sessionid=10892320241210432925120010001',
        duration = '35.527',
        merge_duration = '5.210',
        assigned_supplier_count = '20',
        searched_supplier_count = '3',
        system_load_1_min = '1.40',
        system_load_5_min = '1.39',
        system_load_15_min = '1.32',
        system_memory_usage = '47.91',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18626372') + '38219232',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18626372';
[12/23/2024 10:54:23], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-23 10:54:23',login_attempt=0 where id = '1089';
[12/23/2024 10:54:23], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-12-23 10:54:23', ip = '43.239.53.130', action = 'Login' ;
[12/23/2024 10:54:29], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/24' , departure_date = '2024/12/25' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-23 10:54:29' , 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' ;
[12/23/2024 10:54:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_1089232024121054295162227023', session_id='1089232024121054295162227023', Collection_create_time='2024-12-23 10:54:30';
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_49_6.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_49_6.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_49_6.json', 'hotelbeds', '2024-12-23 10:54:31', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_49_6.json');
[12/23/2024 10:54:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=6&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.451'
        , request_start_time = '0.109'
        , parsing_start_time = '0.845'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.085'
        , search_end_time = '0.191'
        , total_duration = '1.268'
        , error_description = ''
        , memory_used = '14891904'
        WHERE id = '208938222';
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_5_3.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_5_3.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_5_3.json', 'hotelbeds', '2024-12-23 10:54:32', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_5_3.json');
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_56_2.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_56_2.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_56_2.json', 'hotelbeds', '2024-12-23 10:54:32', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_56_2.json');
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_76_1.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_76_1.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_76_1.json', 'hotelbeds', '2024-12-23 10:54:32', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_76_1.json');
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_33_4.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_33_4.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_33_4.json', 'hotelbeds', '2024-12-23 10:54:32', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_33_4.json');
[12/23/2024 10:54:32], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=3&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.440'
        , request_start_time = '0.086'
        , parsing_start_time = '1.928'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.141'
        , search_end_time = '0.259'
        , total_duration = '2.456'
        , error_description = ''
        , memory_used = '23351272'
        WHERE id = '208938278';
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_64_0.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_64_0.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_64_0.json', 'hotelbeds', '2024-12-23 10:54:33', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_64_0.json');
[12/23/2024 10:54:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=2&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.435'
        , request_start_time = '0.153'
        , parsing_start_time = '2.002'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.156'
        , search_end_time = '0.323'
        , total_duration = '2.682'
        , error_description = ''
        , memory_used = '27816616'
        WHERE id = '208938287';
[12/23/2024 10:54:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=1&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.432'
        , request_start_time = '0.090'
        , parsing_start_time = '2.137'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.148'
        , search_end_time = '0.320'
        , total_duration = '2.746'
        , error_description = ''
        , memory_used = '27612136'
        WHERE id = '208938288';
[12/23/2024 10:54: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', 'h1/23_12_2024/request_availability_Test_DoNotUse_10_54_30_1734951270_50_5.json', 'h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_50_5.json', 'h1/23_12_2024/response_header_availability_Test_DoNotUse_10_54_30_1734951270_50_5.json', 'hotelbeds', '2024-12-23 10:54:33', '\n', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/h1/23_12_2024/response_availability_Test_DoNotUse_10_54_30_1734951270_50_5.json');
[12/23/2024 10:54:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=4&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.444'
        , request_start_time = '0.144'
        , parsing_start_time = '2.156'
        , mapping_complete_time = '0.043'
        , mongo_start_time = '0.178'
        , search_end_time = '0.392'
        , total_duration = '2.912'
        , error_description = ''
        , memory_used = '33323928'
        WHERE id = '208938290';
[12/23/2024 10:54:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=0&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.431'
        , request_start_time = '0.088'
        , parsing_start_time = '2.417'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.155'
        , search_end_time = '0.315'
        , total_duration = '3.029'
        , error_description = ''
        , memory_used = '28344848'
        WHERE id = '208938298';
[12/23/2024 10:54:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '81'
        , request_url = '/call.php?s=hotelbeds&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&wh_agent_id=&erequest=5&total_request=7&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-12-23 10:54:30.448'
        , request_start_time = '0.140'
        , parsing_start_time = '2.525'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.218'
        , search_end_time = '0.376'
        , total_duration = '3.299'
        , error_description = ''
        , memory_used = '34440608'
        WHERE id = '208938306';
[12/23/2024 10:54: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', 'r2/23_12_2024/request_availability__10_54_30_Test_DoNotUse_1734951270_.xml', 'r2/23_12_2024/response_availability__10_54_30_Test_DoNotUse_1734951270_.xml', 'r2/23_12_2024/response_header_availability__10_54_30_Test_DoNotUse_1734951270_.xml', 'roomsxml', '2024-12-23 10:54:41', '', '1089232024121054295162227023', '18627139', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/r2/23_12_2024/response_availability__10_54_30_Test_DoNotUse_1734951270_.xml');
[12/23/2024 10:54:44], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '468'
        , request_url = '/call.php?s=roomsxml&sessionid=1089232024121054295162227023&xml_user_id=1089&db_caching=1&web_service=no&site_id=&save_log=yes&city_code=18870&city_name=Dubai&country_code=8939&multicityreq=0&original_source='
        , http_hit_time = '2024-12-23 10:54:30.424'
        , request_start_time = '0.113'
        , parsing_start_time = '11.380'
        , mapping_complete_time = '0.756'
        , mongo_start_time = '1.294'
        , search_end_time = '1.045'
        , total_duration = '13.937'
        , error_description = ''
        , memory_used = '125989640'
        WHERE id = '208938411';
[12/23/2024 10:55:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1133',
        request_path = '/xml_all.php?userid=1089&sessionid=1089232024121054295162227023',
        duration = '32.719',
        merge_duration = '5.292',
        assigned_supplier_count = '20',
        searched_supplier_count = '3',
        system_load_1_min = '1.59',
        system_load_5_min = '1.55',
        system_load_15_min = '1.41',
        system_memory_usage = '48.10',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18627139') + '44913320',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18627139';
