[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '58' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '102' ,status = '' ,priority = '21' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '21';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '98' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '86' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '101' ,status = '1' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:14], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '66' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2406',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/24/2024 05:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-24 05:27:15',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 77 ,status = \&#039;1\&#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;2406\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;21\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;21\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;120\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 101 ,status = \&#039;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;2406\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 66 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2406\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2406 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-2406 ## supplier_id- 67 ## company_name - Local System ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2406 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2406 ## supplier_id- 66 ## company_name - Viator Sight Seeing - Live ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[09/24/2024 05:27:20], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-24 05:27:20',login_attempt=0 where id = '2406';
[09/24/2024 05:27:20], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_pranali', user_type = 'A', branch_id = '26', login_datetime = '2024-09-24 05:27:20', ip = '43.239.53.130', action = 'Login' ;
[09/24/2024 05:27:35], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/17' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-24 05:27:35' , 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' ;
[09/24/2024 05:27:36], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062420240905273515956376594', session_id='24062420240905273515956376594', Collection_create_time='2024-09-24 05:27:36';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_4.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_4.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_4.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_4.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=4&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.107'
        , request_start_time = '0.049'
        , parsing_start_time = '0.435'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.026'
        , search_end_time = '0.000'
        , total_duration = '0.543'
        , error_description = ''
        , memory_used = '1809768'
        WHERE id = '187352202';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_5.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_5.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_5.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_5.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_3.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_3.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_3.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_3.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_7.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_7.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_7.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_7.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=5&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.110'
        , request_start_time = '0.048'
        , parsing_start_time = '0.464'
        , mapping_complete_time = '0.017'
        , mongo_start_time = '0.024'
        , search_end_time = '0.000'
        , total_duration = '0.566'
        , error_description = ''
        , memory_used = '1809912'
        WHERE id = '187352203';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=3&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.105'
        , request_start_time = '0.052'
        , parsing_start_time = '0.466'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.030'
        , search_end_time = '0.000'
        , total_duration = '0.580'
        , error_description = ''
        , memory_used = '1809768'
        WHERE id = '187352204';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_11.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_11.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_11.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_11.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_9.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_9.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_9.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_9.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_12.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_12.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_12.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_12.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_2.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_2.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_2.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_2.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_6.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_6.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_6.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_6.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_15.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_15.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_15.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_15.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=11&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.125'
        , request_start_time = '0.029'
        , parsing_start_time = '0.484'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.037'
        , search_end_time = '0.000'
        , total_duration = '0.584'
        , error_description = ''
        , memory_used = '1625624'
        WHERE id = '187352206';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=7&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.116'
        , request_start_time = '0.032'
        , parsing_start_time = '0.465'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.056'
        , search_end_time = '0.000'
        , total_duration = '0.593'
        , error_description = ''
        , memory_used = '1809744'
        WHERE id = '187352205';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_10.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_10.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_10.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_10.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=2&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.105'
        , request_start_time = '0.047'
        , parsing_start_time = '0.491'
        , mapping_complete_time = '0.029'
        , mongo_start_time = '0.035'
        , search_end_time = '0.000'
        , total_duration = '0.608'
        , error_description = ''
        , memory_used = '1818056'
        WHERE id = '187352208';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=9&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.124'
        , request_start_time = '0.032'
        , parsing_start_time = '0.487'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.039'
        , search_end_time = '0.000'
        , total_duration = '0.589'
        , error_description = ''
        , memory_used = '1809952'
        WHERE id = '187352207';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_14.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_14.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_14.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_14.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_17.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_17.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_17.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_17.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_8.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_8.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_8.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_8.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=6&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.112'
        , request_start_time = '0.037'
        , parsing_start_time = '0.496'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.045'
        , search_end_time = '0.000'
        , total_duration = '0.617'
        , error_description = ''
        , memory_used = '1809240'
        WHERE id = '187352209';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=12&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.130'
        , request_start_time = '0.022'
        , parsing_start_time = '0.485'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.058'
        , search_end_time = '0.000'
        , total_duration = '0.601'
        , error_description = ''
        , memory_used = '1622440'
        WHERE id = '187352210';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_13.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_13.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_13.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_13.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_19.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_19.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_19.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_19.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=10&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.124'
        , request_start_time = '0.030'
        , parsing_start_time = '0.503'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.040'
        , search_end_time = '0.000'
        , total_duration = '0.608'
        , error_description = ''
        , memory_used = '1622648'
        WHERE id = '187352212';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=15&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.136'
        , request_start_time = '0.015'
        , parsing_start_time = '0.497'
        , mapping_complete_time = '0.037'
        , mongo_start_time = '0.053'
        , search_end_time = '0.000'
        , total_duration = '0.602'
        , error_description = ''
        , memory_used = '1625648'
        WHERE id = '187352211';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=14&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.134'
        , request_start_time = '0.014'
        , parsing_start_time = '0.504'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.045'
        , search_end_time = '0.000'
        , total_duration = '0.605'
        , error_description = ''
        , memory_used = '1622440'
        WHERE id = '187352213';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_16.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_16.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_16.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_16.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=17&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.143'
        , request_start_time = '0.014'
        , parsing_start_time = '0.497'
        , mapping_complete_time = '0.036'
        , mongo_start_time = '0.044'
        , search_end_time = '0.000'
        , total_duration = '0.601'
        , error_description = ''
        , memory_used = '1622520'
        WHERE id = '187352214';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_0.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_0.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_0.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_0.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=8&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.118'
        , request_start_time = '0.040'
        , parsing_start_time = '0.512'
        , mapping_complete_time = '0.040'
        , mongo_start_time = '0.046'
        , search_end_time = '0.000'
        , total_duration = '0.631'
        , error_description = ''
        , memory_used = '1774088'
        WHERE id = '187352215';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_1.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_1.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_1.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_1.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=19&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.149'
        , request_start_time = '0.014'
        , parsing_start_time = '0.504'
        , mapping_complete_time = '0.032'
        , mongo_start_time = '0.039'
        , search_end_time = '0.000'
        , total_duration = '0.605'
        , error_description = ''
        , memory_used = '1622152'
        WHERE id = '187352217';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_20.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_20.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_20.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_20.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=16&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.141'
        , request_start_time = '0.013'
        , parsing_start_time = '0.509'
        , mapping_complete_time = '0.038'
        , mongo_start_time = '0.045'
        , search_end_time = '0.000'
        , total_duration = '0.619'
        , error_description = ''
        , memory_used = '1622456'
        WHERE id = '187352218';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=13&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.133'
        , request_start_time = '0.017'
        , parsing_start_time = '0.528'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.047'
        , search_end_time = '0.000'
        , total_duration = '0.630'
        , error_description = ''
        , memory_used = '1627456'
        WHERE id = '187352216';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.105'
        , request_start_time = '0.047'
        , parsing_start_time = '0.528'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.048'
        , search_end_time = '0.000'
        , total_duration = '0.659'
        , error_description = ''
        , memory_used = '1811912'
        WHERE id = '187352219';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_23.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_23.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_23.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_23.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_18.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_18.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_18.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_18.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_26.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_26.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_26.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_26.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_25.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_25.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_25.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_25.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=1&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.105'
        , request_start_time = '0.051'
        , parsing_start_time = '0.530'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.060'
        , search_end_time = '0.000'
        , total_duration = '0.673'
        , error_description = ''
        , memory_used = '1819752'
        WHERE id = '187352220';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_21.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_21.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_21.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_21.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_22.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_22.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_22.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_22.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=20&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.151'
        , request_start_time = '0.013'
        , parsing_start_time = '0.508'
        , mapping_complete_time = '0.055'
        , mongo_start_time = '0.061'
        , search_end_time = '0.000'
        , total_duration = '0.630'
        , error_description = ''
        , memory_used = '1622520'
        WHERE id = '187352221';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=23&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.162'
        , request_start_time = '0.013'
        , parsing_start_time = '0.505'
        , mapping_complete_time = '0.051'
        , mongo_start_time = '0.057'
        , search_end_time = '0.000'
        , total_duration = '0.627'
        , error_description = ''
        , memory_used = '1622080'
        WHERE id = '187352222';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_28.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_28.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_28.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_28.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=18&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.151'
        , request_start_time = '0.013'
        , parsing_start_time = '0.520'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.061'
        , search_end_time = '0.000'
        , total_duration = '0.642'
        , error_description = ''
        , memory_used = '1622384'
        WHERE id = '187352223';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=26&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.177'
        , request_start_time = '0.015'
        , parsing_start_time = '0.496'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.058'
        , search_end_time = '0.000'
        , total_duration = '0.616'
        , error_description = ''
        , memory_used = '1622152'
        WHERE id = '187352224';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_30.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_30.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_30.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_30.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=25&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.167'
        , request_start_time = '0.014'
        , parsing_start_time = '0.509'
        , mapping_complete_time = '0.050'
        , mongo_start_time = '0.057'
        , search_end_time = '0.000'
        , total_duration = '0.631'
        , error_description = ''
        , memory_used = '1622424'
        WHERE id = '187352225';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=21&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.160'
        , request_start_time = '0.015'
        , parsing_start_time = '0.514'
        , mapping_complete_time = '0.048'
        , mongo_start_time = '0.055'
        , search_end_time = '0.000'
        , total_duration = '0.639'
        , error_description = ''
        , memory_used = '1622392'
        WHERE id = '187352226';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_24.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_24.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_24.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_24.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=22&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.155'
        , request_start_time = '0.014'
        , parsing_start_time = '0.519'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.050'
        , search_end_time = '0.000'
        , total_duration = '0.644'
        , error_description = ''
        , memory_used = '1622520'
        WHERE id = '187352227';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_33.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_33.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_33.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_33.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=28&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.183'
        , request_start_time = '0.012'
        , parsing_start_time = '0.511'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.053'
        , search_end_time = '0.000'
        , total_duration = '0.626'
        , error_description = ''
        , memory_used = '1622440'
        WHERE id = '187352228';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_31.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_31.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_31.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_31.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_32.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_32.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_32.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_32.json');
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_29.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_29.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_29.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_29.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=30&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.183'
        , request_start_time = '0.013'
        , parsing_start_time = '0.510'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.061'
        , search_end_time = '0.000'
        , total_duration = '0.635'
        , error_description = ''
        , memory_used = '1622064'
        WHERE id = '187352229';
[09/24/2024 05:27: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_27_37_1727155657_27.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_27.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_1727155657_27.json', 'agoda', '2024-09-24 05:27:37', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_27_37_1727155657_27.json');
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=24&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.163'
        , request_start_time = '0.015'
        , parsing_start_time = '0.532'
        , mapping_complete_time = '0.063'
        , mongo_start_time = '0.070'
        , search_end_time = '0.000'
        , total_duration = '0.671'
        , error_description = ''
        , memory_used = '1622432'
        WHERE id = '187352230';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=31&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.183'
        , request_start_time = '0.014'
        , parsing_start_time = '0.529'
        , mapping_complete_time = '0.058'
        , mongo_start_time = '0.064'
        , search_end_time = '0.000'
        , total_duration = '0.651'
        , error_description = ''
        , memory_used = '1622424'
        WHERE id = '187352232';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=33&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.185'
        , request_start_time = '0.013'
        , parsing_start_time = '0.523'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.067'
        , search_end_time = '0.000'
        , total_duration = '0.649'
        , error_description = ''
        , memory_used = '1621696'
        WHERE id = '187352231';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=29&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.182'
        , request_start_time = '0.019'
        , parsing_start_time = '0.525'
        , mapping_complete_time = '0.061'
        , mongo_start_time = '0.067'
        , search_end_time = '0.000'
        , total_duration = '0.658'
        , error_description = ''
        , memory_used = '1622520'
        WHERE id = '187352234';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=32&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.185'
        , request_start_time = '0.014'
        , parsing_start_time = '0.525'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.066'
        , search_end_time = '0.000'
        , total_duration = '0.655'
        , error_description = ''
        , memory_used = '1622520'
        WHERE id = '187352233';
[09/24/2024 05:27:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=27&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.182'
        , request_start_time = '0.076'
        , parsing_start_time = '0.479'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.066'
        , search_end_time = '0.000'
        , total_duration = '0.671'
        , error_description = ''
        , memory_used = '1622456'
        WHERE id = '187352235';
[09/24/2024 05:27:45], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556579.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556579.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556579.json', 'ratehawk', '2024-09-24 05:27:45', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556579.json');
[09/24/2024 05:27:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '38'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=9&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.215'
        , request_start_time = '0.555'
        , parsing_start_time = '7.318'
        , mapping_complete_time = '0.094'
        , mongo_start_time = '0.160'
        , search_end_time = '0.106'
        , total_duration = '8.186'
        , error_description = ''
        , memory_used = '59270408'
        WHERE id = '187352236';
[09/24/2024 05:27:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556576.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556576.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556576.json', 'ratehawk', '2024-09-24 05:27:46', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556576.json');
[09/24/2024 05:27:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '35'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=6&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.209'
        , request_start_time = '0.430'
        , parsing_start_time = '8.916'
        , mapping_complete_time = '0.078'
        , mongo_start_time = '0.134'
        , search_end_time = '0.088'
        , total_duration = '9.619'
        , error_description = ''
        , memory_used = '58179576'
        WHERE id = '187352237';
[09/24/2024 05:27:47], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_172715565710.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565710.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_172715565710.json', 'ratehawk', '2024-09-24 05:27:47', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565710.json');
[09/24/2024 05:27:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '20'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=10&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.216'
        , request_start_time = '0.588'
        , parsing_start_time = '9.103'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.053'
        , search_end_time = '0.036'
        , total_duration = '9.890'
        , error_description = ''
        , memory_used = '15885040'
        WHERE id = '187352238';
[09/24/2024 05:27:47], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_172715565712.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565712.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_172715565712.json', 'ratehawk', '2024-09-24 05:27:47', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565712.json');
[09/24/2024 05:27:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '31'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=12&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.218'
        , request_start_time = '0.652'
        , parsing_start_time = '9.519'
        , mapping_complete_time = '0.062'
        , mongo_start_time = '0.102'
        , search_end_time = '0.065'
        , total_duration = '10.451'
        , error_description = ''
        , memory_used = '37447872'
        WHERE id = '187352239';
[09/24/2024 05:27:51], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556571.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556571.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556571.json', 'ratehawk', '2024-09-24 05:27:51', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556571.json');
[09/24/2024 05:27:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '138'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=1&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.191'
        , request_start_time = '0.106'
        , parsing_start_time = '13.782'
        , mapping_complete_time = '0.311'
        , mongo_start_time = '0.643'
        , search_end_time = '0.327'
        , total_duration = '14.938'
        , error_description = ''
        , memory_used = '217308264'
        WHERE id = '187352240';
[09/24/2024 05:27:52], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556570.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556570.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556570.json', 'ratehawk', '2024-09-24 05:27:52', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556570.json');
[09/24/2024 05:27:52], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556577.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556577.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556577.json', 'ratehawk', '2024-09-24 05:27:52', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556577.json');
[09/24/2024 05:27:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '69'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=0&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.191'
        , request_start_time = '0.083'
        , parsing_start_time = '14.832'
        , mapping_complete_time = '0.145'
        , mongo_start_time = '0.274'
        , search_end_time = '0.149'
        , total_duration = '15.399'
        , error_description = ''
        , memory_used = '105137240'
        WHERE id = '187352241';
[09/24/2024 05:27:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '37'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=7&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.209'
        , request_start_time = '0.377'
        , parsing_start_time = '14.733'
        , mapping_complete_time = '0.090'
        , mongo_start_time = '0.146'
        , search_end_time = '0.105'
        , total_duration = '15.404'
        , error_description = ''
        , memory_used = '57224120'
        WHERE id = '187352242';
[09/24/2024 05:27:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556572.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556572.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556572.json', 'ratehawk', '2024-09-24 05:27:53', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556572.json');
[09/24/2024 05:27:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_172715565711.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565711.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_172715565711.json', 'ratehawk', '2024-09-24 05:27:53', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_172715565711.json');
[09/24/2024 05:27:53], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556575.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556575.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556575.json', 'ratehawk', '2024-09-24 05:27:53', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556575.json');
[09/24/2024 05:27:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '21'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=11&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.217'
        , request_start_time = '0.595'
        , parsing_start_time = '15.867'
        , mapping_complete_time = '0.047'
        , mongo_start_time = '0.075'
        , search_end_time = '0.061'
        , total_duration = '16.656'
        , error_description = ''
        , memory_used = '26049840'
        WHERE id = '187352244';
[09/24/2024 05:27:53], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '22'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=5&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.203'
        , request_start_time = '0.513'
        , parsing_start_time = '15.983'
        , mapping_complete_time = '0.071'
        , mongo_start_time = '0.113'
        , search_end_time = '0.054'
        , total_duration = '16.715'
        , error_description = ''
        , memory_used = '43701456'
        WHERE id = '187352245';
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556578.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556578.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556578.json', 'ratehawk', '2024-09-24 05:27:54', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556578.json');
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '106'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=2&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.193'
        , request_start_time = '0.218'
        , parsing_start_time = '16.012'
        , mapping_complete_time = '0.269'
        , mongo_start_time = '0.524'
        , search_end_time = '0.291'
        , total_duration = '17.120'
        , error_description = ''
        , memory_used = '186056040'
        WHERE id = '187352243';
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556574.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556574.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556574.json', 'ratehawk', '2024-09-24 05:27:54', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556574.json');
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/24_09_2024/request_availability_Qtech_pranali_05_27_37_17271556573.json', 'rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556573.json', 'rh/24_09_2024/response_header_availability_Qtech_pranali_05_27_37_17271556573.json', 'ratehawk', '2024-09-24 05:27:54', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/24_09_2024/response_availability_Qtech_pranali_05_27_37_17271556573.json');
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '32'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=8&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.209'
        , request_start_time = '0.492'
        , parsing_start_time = '16.433'
        , mapping_complete_time = '0.091'
        , mongo_start_time = '0.142'
        , search_end_time = '0.072'
        , total_duration = '17.189'
        , error_description = ''
        , memory_used = '57354224'
        WHERE id = '187352246';
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '41'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=4&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.201'
        , request_start_time = '0.371'
        , parsing_start_time = '16.701'
        , mapping_complete_time = '0.120'
        , mongo_start_time = '0.185'
        , search_end_time = '0.088'
        , total_duration = '17.399'
        , error_description = ''
        , memory_used = '73675384'
        WHERE id = '187352247';
[09/24/2024 05:27:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=24062420240905273515956376594&destination_code=6053839&city_name=Dubai&country_code=AE&country_name=United+Arab+Emirates&xml_user_id=2406&db_caching=1&wh_agent_id=&erequest=3&total_request=13&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:27:37.198'
        , request_start_time = '0.340'
        , parsing_start_time = '16.742'
        , mapping_complete_time = '0.130'
        , mongo_start_time = '0.203'
        , search_end_time = '0.111'
        , total_duration = '17.456'
        , error_description = ''
        , memory_used = '81679864'
        WHERE id = '187352248';
[09/24/2024 05:27:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '613',
        request_path = '/xml_all.php?userid=2406&sessionid=24062420240905273515956376594',
        duration = '19.381',
        merge_duration = '0.069',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.13',
        system_load_5_min = '0.09',
        system_load_15_min = '0.20',
        system_memory_usage = '45.34',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16486030') + '4206960',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16486030';
[09/24/2024 05:27:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062420240905273515956376594', session_id='24062420240905273515956376594', Collection_create_time='2024-09-24 05:27:55';
[09/24/2024 05:28:07], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'a5/24_09_2024/request_availability_Qtech_pranali_05_28_06_1727155686_0.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_28_06_1727155686_0.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_28_06_1727155686_0.json', 'agoda', '2024-09-24 05:28:07', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_28_06_1727155686_0.json');
[09/24/2024 05:28:07], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-24 05:28:06.687'
        , request_start_time = '0.011'
        , parsing_start_time = '0.411'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.031'
        , search_end_time = '0.000'
        , total_duration = '0.485'
        , error_description = ''
        , memory_used = '1717424'
        WHERE id = '187352250';
[09/24/2024 05: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', 'a5/24_09_2024/request_availability_Qtech_pranali_05_28_11_1727155691_0.json', 'a5/24_09_2024/response_availability_Qtech_pranali_05_28_11_1727155691_0.json', 'a5/24_09_2024/response_header_availability_Qtech_pranali_05_28_11_1727155691_0.json', 'agoda', '2024-09-24 05:28:12', '', '24062420240905273515956376594', '16486030', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/24_09_2024/response_availability_Qtech_pranali_05_28_11_1727155691_0.json');
[09/24/2024 05:28:12], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=agoda&sessionid=24062420240905273515956376594&xml_user_id=2406&db_caching=1&web_service=no&city_code=2994&city_name=Dubai&country_code=64&country_name=United+Arab+Emirates&agoda_currency=USD&erequest=0&total_request=34&hotels_ids=&web_service=no&site_id=&save_log=yes&debug=1'
        , http_hit_time = '2024-09-24 05:28:11.521'
        , request_start_time = '0.010'
        , parsing_start_time = '0.447'
        , mapping_complete_time = '0.023'
        , mongo_start_time = '0.029'
        , search_end_time = '0.000'
        , total_duration = '0.543'
        , error_description = ''
        , memory_used = '1718208'
        WHERE id = '187352251';
