[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '' ,priority = '25' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '1' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '103' ,status = '' ,priority = '15' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/19/2024 11:42:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-19 11:42:37',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,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;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;24\&#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;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 81 ,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;949\&#039;,supplier_id = 78 ,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;949\&#039;,supplier_id = 83 ,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;949\&#039;,supplier_id = 68 ,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;949\&#039;,supplier_id = 90 ,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;949\&#039;,supplier_id = 66 ,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;949\&#039;,supplier_id = 64 ,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;949\&#039;,supplier_id = 65 ,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;949\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 72 ',`ip`= '43.239.53.130';
[09/19/2024 11:42:41], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-19 11:42:41',login_attempt=0 where id = '949';
[09/19/2024 11:42:41], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-09-19 11:42:41', ip = '43.239.53.130', action = 'Login' ;
[09/19/2024 11:43:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'madrid' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/11/28' , departure_date = '2024/11/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-19 11:43:09' , site_id = '' , country_code = '90' , city_code = '60279' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/19/2024 11:43:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9491920240911430925351625874', session_id='9491920240911430925351625874', Collection_create_time='2024-09-19 11:43:10';
[09/19/2024 11:43:14], [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/19_09_2024/request_availability_yogeshqtech_11_43_12_17267461927.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_12_17267461927.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_12_17267461927.json', 'ratehawk', '2024-09-19 11:43:14', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_12_17267461927.json');
[09/19/2024 11:43:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '1'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=7&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.535'
        , request_start_time = '0.531'
        , parsing_start_time = '2.294'
        , mapping_complete_time = '0.011'
        , mongo_start_time = '0.045'
        , search_end_time = '0.001'
        , total_duration = '2.904'
        , error_description = ''
        , memory_used = '3325640'
        WHERE id = '185960237';
[09/19/2024 11:43:18], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461910.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461910.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461910.json', 'ratehawk', '2024-09-19 11:43:18', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461910.json');
[09/19/2024 11:43:18], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.519'
        , request_start_time = '0.112'
        , parsing_start_time = '6.505'
        , mapping_complete_time = '0.054'
        , mongo_start_time = '0.149'
        , search_end_time = '0.112'
        , total_duration = '6.921'
        , error_description = ''
        , memory_used = '36897440'
        WHERE id = '185960245';
[09/19/2024 11:43:22], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461915.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461915.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461915.json', 'ratehawk', '2024-09-19 11:43:22', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461915.json');
[09/19/2024 11:43:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '17'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=5&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.532'
        , request_start_time = '0.392'
        , parsing_start_time = '10.312'
        , mapping_complete_time = '0.024'
        , mongo_start_time = '0.082'
        , search_end_time = '0.052'
        , total_duration = '10.876'
        , error_description = ''
        , memory_used = '13691840'
        WHERE id = '185960269';
[09/19/2024 11:43:22], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461913.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461913.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461913.json', 'ratehawk', '2024-09-19 11:43:22', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461913.json');
[09/19/2024 11:43:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '52'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.526'
        , request_start_time = '0.219'
        , parsing_start_time = '10.699'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.125'
        , search_end_time = '0.077'
        , total_duration = '11.158'
        , error_description = ''
        , memory_used = '31122656'
        WHERE id = '185960270';
[09/19/2024 11:43:22], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461912.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461912.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461912.json', 'ratehawk', '2024-09-19 11:43:22', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461912.json');
[09/19/2024 11:43:22], [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/19_09_2024/request_availability_yogeshqtech_11_43_12_17267461926.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_12_17267461926.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_12_17267461926.json', 'ratehawk', '2024-09-19 11:43:22', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_12_17267461926.json');
[09/19/2024 11:43:22], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461914.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461914.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461914.json', 'ratehawk', '2024-09-19 11:43:22', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461914.json');
[09/19/2024 11:43:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '42'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=6&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.533'
        , request_start_time = '0.516'
        , parsing_start_time = '10.662'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.116'
        , search_end_time = '0.080'
        , total_duration = '11.414'
        , error_description = ''
        , memory_used = '30822792'
        WHERE id = '185960272';
[09/19/2024 11:43:22], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '55'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.521'
        , request_start_time = '0.164'
        , parsing_start_time = '10.962'
        , mapping_complete_time = '0.070'
        , mongo_start_time = '0.171'
        , search_end_time = '0.089'
        , total_duration = '11.431'
        , error_description = ''
        , memory_used = '49786472'
        WHERE id = '185960271';
[09/19/2024 11:43:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '44'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=4&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.528'
        , request_start_time = '0.349'
        , parsing_start_time = '10.928'
        , mapping_complete_time = '0.042'
        , mongo_start_time = '0.125'
        , search_end_time = '0.066'
        , total_duration = '11.508'
        , error_description = ''
        , memory_used = '35244920'
        WHERE id = '185960273';
[09/19/2024 11:43:24], [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/19_09_2024/request_availability_yogeshqtech_11_43_11_17267461911.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461911.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_11_17267461911.json', 'ratehawk', '2024-09-19 11:43:24', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_11_17267461911.json');
[09/19/2024 11:43:25], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '160'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911430925351625874&destination_code=2198&city_name=Madrid&country_code=ES&country_name=Spain&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=8&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:43:11.519'
        , request_start_time = '0.124'
        , parsing_start_time = '13.006'
        , mapping_complete_time = '0.243'
        , mongo_start_time = '0.625'
        , search_end_time = '0.410'
        , total_duration = '14.255'
        , error_description = ''
        , memory_used = '175436592'
        WHERE id = '185960276';
[09/19/2024 11:43:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '417',
        request_path = '/xml_all.php?userid=949&sessionid=9491920240911430925351625874',
        duration = '16.836',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '10.35',
        system_load_5_min = '11.33',
        system_load_15_min = '13.41',
        system_memory_usage = '36.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16390544') + '5657040',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16390544';
[09/19/2024 11:43:58], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_43_55_1726746235.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_43_55_1726746235.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_43_55_1726746235.json', 'ratehawk', '2024-09-19 11:43:58', '', '9491920240911430925351625874', '16390544', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_43_55_1726746235.json');
[09/19/2024 11:52:17], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'istanbul' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/11/27' , departure_date = '2024/11/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-19 11:52:17' , site_id = '' , country_code = '93' , city_code = '61872' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/19/2024 11:52:21], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_949_9491920240911521690386410570', session_id='9491920240911521690386410570', Collection_create_time='2024-09-19 11:52:21';
[09/19/2024 11:52:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467421.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467421.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467421.json', 'ratehawk', '2024-09-19 11:52:31', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467421.json');
[09/19/2024 11:52:31], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674417.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674417.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674417.json', 'ratehawk', '2024-09-19 11:52:31', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674417.json');
[09/19/2024 11:52:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '73'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.410'
        , request_start_time = '0.121'
        , parsing_start_time = '8.476'
        , mapping_complete_time = '0.086'
        , mongo_start_time = '0.183'
        , search_end_time = '0.179'
        , total_duration = '9.114'
        , error_description = ''
        , memory_used = '48437528'
        WHERE id = '185969079';
[09/19/2024 11:52:31], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '90'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=17&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.547'
        , request_start_time = '0.565'
        , parsing_start_time = '6.935'
        , mapping_complete_time = '0.046'
        , mongo_start_time = '0.138'
        , search_end_time = '0.119'
        , total_duration = '8.096'
        , error_description = ''
        , memory_used = '31674472'
        WHERE id = '185969081';
[09/19/2024 11:52:32], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467420.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467420.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467420.json', 'ratehawk', '2024-09-19 11:52:32', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467420.json');
[09/19/2024 11:52:32], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674424.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674424.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674424.json', 'ratehawk', '2024-09-19 11:52:32', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674424.json');
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '74'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.334'
        , request_start_time = '0.187'
        , parsing_start_time = '10.130'
        , mapping_complete_time = '0.077'
        , mongo_start_time = '0.173'
        , search_end_time = '0.155'
        , total_duration = '10.841'
        , error_description = ''
        , memory_used = '49073848'
        WHERE id = '185969086';
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '64'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=24&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:24.86'
        , request_start_time = '0.627'
        , parsing_start_time = '8.007'
        , mapping_complete_time = '0.072'
        , mongo_start_time = '0.170'
        , search_end_time = '0.111'
        , total_duration = '9.093'
        , error_description = ''
        , memory_used = '29754744'
        WHERE id = '185969088';
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674423.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674423.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674423.json', 'ratehawk', '2024-09-19 11:52:33', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674423.json');
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '63'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=23&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.951'
        , request_start_time = '0.595'
        , parsing_start_time = '8.657'
        , mapping_complete_time = '0.045'
        , mongo_start_time = '0.106'
        , search_end_time = '0.115'
        , total_duration = '9.746'
        , error_description = ''
        , memory_used = '29591600'
        WHERE id = '185969094';
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674422.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674422.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674422.json', 'ratehawk', '2024-09-19 11:52:33', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674422.json');
[09/19/2024 11:52:33], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674421.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674421.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674421.json', 'ratehawk', '2024-09-19 11:52:33', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674421.json');
[09/19/2024 11:52:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '97'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=22&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.796'
        , request_start_time = '0.557'
        , parsing_start_time = '8.983'
        , mapping_complete_time = '0.044'
        , mongo_start_time = '0.111'
        , search_end_time = '0.136'
        , total_duration = '10.211'
        , error_description = ''
        , memory_used = '31954800'
        WHERE id = '185969099';
[09/19/2024 11:52:34], [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/19_09_2024/request_availability_yogeshqtech_11_52_23_172674674314.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674314.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_172674674314.json', 'ratehawk', '2024-09-19 11:52:34', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674314.json');
[09/19/2024 11:52:34], [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/19_09_2024/request_availability_yogeshqtech_11_52_23_172674674310.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674310.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_172674674310.json', 'ratehawk', '2024-09-19 11:52:34', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674310.json');
[09/19/2024 11:52:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '88'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=21&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.744'
        , request_start_time = '0.607'
        , parsing_start_time = '9.374'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.122'
        , search_end_time = '0.106'
        , total_duration = '10.470'
        , error_description = ''
        , memory_used = '41435496'
        WHERE id = '185969102';
[09/19/2024 11:52:34], [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/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674420.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674420.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674420.json', 'ratehawk', '2024-09-19 11:52:34', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674420.json');
[09/19/2024 11:52:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '79'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=14&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.206'
        , request_start_time = '0.389'
        , parsing_start_time = '10.156'
        , mapping_complete_time = '0.097'
        , mongo_start_time = '0.187'
        , search_end_time = '0.146'
        , total_duration = '11.238'
        , error_description = ''
        , memory_used = '51169936'
        WHERE id = '185969105';
[09/19/2024 11:52:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '82'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=10&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.980'
        , request_start_time = '0.292'
        , parsing_start_time = '10.549'
        , mapping_complete_time = '0.068'
        , mongo_start_time = '0.164'
        , search_end_time = '0.147'
        , total_duration = '11.542'
        , error_description = ''
        , memory_used = '45971880'
        WHERE id = '185969106';
[09/19/2024 11:52:34], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '70'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=20&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.730'
        , request_start_time = '0.600'
        , parsing_start_time = '9.792'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.124'
        , search_end_time = '0.107'
        , total_duration = '10.818'
        , error_description = ''
        , memory_used = '38070288'
        WHERE id = '185969107';
[09/19/2024 11:52:34], [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/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674418.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674418.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674418.json', 'ratehawk', '2024-09-19 11:52:34', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674418.json');
[09/19/2024 11:52:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '87'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=18&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.655'
        , request_start_time = '0.532'
        , parsing_start_time = '10.043'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.168'
        , search_end_time = '0.247'
        , total_duration = '11.353'
        , error_description = ''
        , memory_used = '54458624'
        WHERE id = '185969109';
[09/19/2024 11:52:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467426.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467426.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467426.json', 'ratehawk', '2024-09-19 11:52:36', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467426.json');
[09/19/2024 11:52:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467423.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467423.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467423.json', 'ratehawk', '2024-09-19 11:52:36', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467423.json');
[09/19/2024 11:52:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=6&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.563'
        , request_start_time = '0.198'
        , parsing_start_time = '13.645'
        , mapping_complete_time = '0.060'
        , mongo_start_time = '0.145'
        , search_end_time = '0.144'
        , total_duration = '14.336'
        , error_description = ''
        , memory_used = '47102976'
        WHERE id = '185969115';
[09/19/2024 11:52:36], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467422.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467422.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467422.json', 'ratehawk', '2024-09-19 11:52:36', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467422.json');
[09/19/2024 11:52:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '84'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.416'
        , request_start_time = '0.234'
        , parsing_start_time = '14.126'
        , mapping_complete_time = '0.079'
        , mongo_start_time = '0.193'
        , search_end_time = '0.176'
        , total_duration = '14.889'
        , error_description = ''
        , memory_used = '56632392'
        WHERE id = '185969119';
[09/19/2024 11:52:37], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '118'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.414'
        , request_start_time = '0.168'
        , parsing_start_time = '14.073'
        , mapping_complete_time = '0.095'
        , mongo_start_time = '0.238'
        , search_end_time = '0.235'
        , total_duration = '14.937'
        , error_description = ''
        , memory_used = '70382384'
        WHERE id = '185969118';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_17267467438.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467438.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_17267467438.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467438.json');
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_17267467437.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467437.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_17267467437.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467437.json');
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_17267467439.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467439.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_17267467439.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_17267467439.json');
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '96'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=8&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.714'
        , request_start_time = '0.331'
        , parsing_start_time = '15.744'
        , mapping_complete_time = '0.073'
        , mongo_start_time = '0.190'
        , search_end_time = '0.174'
        , total_duration = '16.721'
        , error_description = ''
        , memory_used = '52403912'
        WHERE id = '185969124';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '76'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=7&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.562'
        , request_start_time = '0.338'
        , parsing_start_time = '15.833'
        , mapping_complete_time = '0.064'
        , mongo_start_time = '0.146'
        , search_end_time = '0.132'
        , total_duration = '16.881'
        , error_description = ''
        , memory_used = '46879856'
        WHERE id = '185969125';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_172674674313.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674313.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_172674674313.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674313.json');
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_172674674312.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674312.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_172674674312.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674312.json');
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '74'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=9&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.813'
        , request_start_time = '0.251'
        , parsing_start_time = '15.859'
        , mapping_complete_time = '0.074'
        , mongo_start_time = '0.153'
        , search_end_time = '0.133'
        , total_duration = '16.727'
        , error_description = ''
        , memory_used = '48610840'
        WHERE id = '185969126';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '77'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=13&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.142'
        , request_start_time = '0.430'
        , parsing_start_time = '15.740'
        , mapping_complete_time = '0.059'
        , mongo_start_time = '0.131'
        , search_end_time = '0.099'
        , total_duration = '16.608'
        , error_description = ''
        , memory_used = '41271256'
        WHERE id = '185969127';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '97'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=12&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.129'
        , request_start_time = '0.355'
        , parsing_start_time = '15.780'
        , mapping_complete_time = '0.102'
        , mongo_start_time = '0.226'
        , search_end_time = '0.187'
        , total_duration = '16.838'
        , error_description = ''
        , memory_used = '66007416'
        WHERE id = '185969128';
[09/19/2024 11:52:39], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674415.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674415.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674415.json', 'ratehawk', '2024-09-19 11:52:39', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674415.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674416.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674416.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674416.json', 'ratehawk', '2024-09-19 11:52:40', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674416.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '68'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=15&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.380'
        , request_start_time = '0.523'
        , parsing_start_time = '15.900'
        , mapping_complete_time = '0.039'
        , mongo_start_time = '0.100'
        , search_end_time = '0.097'
        , total_duration = '16.819'
        , error_description = ''
        , memory_used = '32040024'
        WHERE id = '185969129';
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467425.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467425.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467425.json', 'ratehawk', '2024-09-19 11:52:40', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467425.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_23_172674674311.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674311.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_23_172674674311.json', 'ratehawk', '2024-09-19 11:52:40', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_23_172674674311.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_22_17267467424.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467424.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_22_17267467424.json', 'ratehawk', '2024-09-19 11:52:40', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_22_17267467424.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '83'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=16&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.420'
        , request_start_time = '0.468'
        , parsing_start_time = '16.069'
        , mapping_complete_time = '0.057'
        , mongo_start_time = '0.130'
        , search_end_time = '0.116'
        , total_duration = '17.034'
        , error_description = ''
        , memory_used = '42614688'
        WHERE id = '185969130';
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '53'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=11&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.983'
        , request_start_time = '0.322'
        , parsing_start_time = '16.533'
        , mapping_complete_time = '0.066'
        , mongo_start_time = '0.130'
        , search_end_time = '0.091'
        , total_duration = '17.493'
        , error_description = ''
        , memory_used = '41617360'
        WHERE id = '185969132';
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_52_24_172674674419.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674419.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_52_24_172674674419.json', 'ratehawk', '2024-09-19 11:52:40', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_52_24_172674674419.json');
[09/19/2024 11:52:40], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '75'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=19&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:23.729'
        , request_start_time = '0.568'
        , parsing_start_time = '15.923'
        , mapping_complete_time = '0.053'
        , mongo_start_time = '0.118'
        , search_end_time = '0.097'
        , total_duration = '17.015'
        , error_description = ''
        , memory_used = '36533440'
        WHERE id = '185969134';
[09/19/2024 11:52:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '139'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=5&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.544'
        , request_start_time = '0.241'
        , parsing_start_time = '17.260'
        , mapping_complete_time = '0.158'
        , mongo_start_time = '0.382'
        , search_end_time = '0.404'
        , total_duration = '18.483'
        , error_description = ''
        , memory_used = '104645632'
        WHERE id = '185969131';
[09/19/2024 11:52:41], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '155'
        , request_url = '/call.php?s=ratehawk&sessionid=9491920240911521690386410570&destination_code=1639&city_name=Istanbul&country_code=TR&country_name=Turkey&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=4&total_request=25&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-09-19 11:52:22.469'
        , request_start_time = '0.193'
        , parsing_start_time = '17.529'
        , mapping_complete_time = '0.191'
        , mongo_start_time = '0.460'
        , search_end_time = '0.369'
        , total_duration = '18.824'
        , error_description = ''
        , memory_used = '129813504'
        WHERE id = '185969133';
[09/19/2024 11:52:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2060',
        request_path = '/xml_all.php?userid=949&sessionid=9491920240911521690386410570',
        duration = '22.073',
        merge_duration = '0.116',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '38.37',
        system_load_5_min = '21.94',
        system_load_15_min = '16.97',
        system_memory_usage = '44.99',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16390889') + '7049504',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16390889';
[09/19/2024 11:53:18], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/19_09_2024/request_availability_yogeshqtech_11_53_16_1726746796.json', 'rh/19_09_2024/response_availability_yogeshqtech_11_53_16_1726746796.json', 'rh/19_09_2024/response_header_availability_yogeshqtech_11_53_16_1726746796.json', 'ratehawk', '2024-09-19 11:53:18', '', '9491920240911521690386410570', '16390889', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/19_09_2024/response_availability_yogeshqtech_11_53_16_1726746796.json');
