[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '1' ,priority = '8' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:48:44], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-08-23 07:48:44',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,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;7839\&#039;,supplier_id = 52 ,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;7839\&#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;7839\&#039;,supplier_id = 24 ,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;7839\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 64 ,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;7839\&#039;,supplier_id = 65 ,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;7839\&#039;,supplier_id = 34 ,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;7839\&#039;,supplier_id = 20 ,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;7839\&#039;,supplier_id = 55 ,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;7839\&#039;,supplier_id = 62 ,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;7839\&#039;,supplier_id = 53 ,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;7839\&#039;,supplier_id = 16 ,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;7839\&#039;,supplier_id = 75 ,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;7839\&#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;7839\&#039;,supplier_id = 18 ,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;7839\&#039;,supplier_id = 19 ,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;7839\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 71 ,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;7839\&#039;,supplier_id = 69 ,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;7839\&#039;,supplier_id = 68 ,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;7839\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 35 ,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;7839\&#039;,supplier_id = 70 ,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;7839\&#039;,supplier_id = 59 ,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;7839\&#039;,supplier_id = 32 ,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;7839\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 56 ,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;7839\&#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;7839\&#039;,supplier_id = 61 ,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;7839\&#039;,supplier_id = 63 ,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;7839\&#039;,supplier_id = 54 ,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;7839\&#039;,supplier_id = 66 ,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;7839\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7839 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[08/23/2023 07:48:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-08-23 07:48:49',login_attempt=0 where id = '752';
[08/23/2023 07:48:49], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'suhasqtech', user_type = 'A', branch_id = '1', login_datetime = '2023-08-23 07:48:49', ip = '43.239.53.130', action = 'Login' ;
[08/23/2023 07:48:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='752', session_id='84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4',create_date='2023-08-23 07:48:49', update_date='2023-08-23 07:48:49',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[08/23/2023 07:48:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:48:56' WHERE id= '65';
[08/23/2023 07:49:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:00' WHERE id= '65';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '1' ,priority = '8' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[08/23/2023 07:49:17], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-08-23 07:49:17',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,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;7839\&#039;,supplier_id = 52 ,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;7839\&#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;7839\&#039;,supplier_id = 24 ,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;7839\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 64 ,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;7839\&#039;,supplier_id = 65 ,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;7839\&#039;,supplier_id = 34 ,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;7839\&#039;,supplier_id = 20 ,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;7839\&#039;,supplier_id = 55 ,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;7839\&#039;,supplier_id = 62 ,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;7839\&#039;,supplier_id = 53 ,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;7839\&#039;,supplier_id = 16 ,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;7839\&#039;,supplier_id = 75 ,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;7839\&#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;7839\&#039;,supplier_id = 18 ,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;7839\&#039;,supplier_id = 19 ,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;7839\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 71 ,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;7839\&#039;,supplier_id = 69 ,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;7839\&#039;,supplier_id = 68 ,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;7839\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 35 ,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;7839\&#039;,supplier_id = 70 ,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;7839\&#039;,supplier_id = 59 ,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;7839\&#039;,supplier_id = 32 ,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;7839\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 56 ,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;7839\&#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;7839\&#039;,supplier_id = 61 ,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;7839\&#039;,supplier_id = 63 ,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;7839\&#039;,supplier_id = 54 ,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;7839\&#039;,supplier_id = 66 ,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;7839\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7839 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[08/23/2023 07:49:25], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:25' WHERE id= '65';
[08/23/2023 07:49:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-08-23 07:49:25',login_attempt=0 where id = '7839';
[08/23/2023 07:49:25], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '4', login_datetime = '2023-08-23 07:49:25', ip = '43.239.53.130', action = 'Login' ;
[08/23/2023 07:49:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:25' WHERE id= '65';
[08/23/2023 07:49:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:31' WHERE id= '65';
[08/23/2023 07:49:45], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:45' WHERE id= '65';
[08/23/2023 07:49:45], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:49:45' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[08/23/2023 07:49:45], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:49:45' WHERE id= '65';
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_63_3.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_63_3.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_63_3.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_63_3.json', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_21_15.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_21_15.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_21_15.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_21_15.json', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_33_7.xml', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_33_7.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_33_7.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_33_7.json', 'ebookingcenter', '2023-08-23 07:49:54', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=15&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.421'
            , error_description = ''
            , memory_used = '7745416'
            WHERE id = '5023';
[08/23/2023 07:49:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=3&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.424'
            , error_description = ''
            , memory_used = '9656120'
            WHERE id = '5020';
[08/23/2023 07:49:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=7&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.449'
            , error_description = ''
            , memory_used = '8585368'
            WHERE id = '5026';
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_99_16.xml', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_99_16.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_99_16.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_99_16.json', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=16&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '9.569'
            , error_description = ''
            , memory_used = '11438408'
            WHERE id = '5029';
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_58_5.xml', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_58_5.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_58_5.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_58_5.json', 'ebookingcenter', '2023-08-23 07:49:55', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:55], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=5&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '9.868'
            , error_description = ''
            , memory_used = '8823072'
            WHERE id = '5032';
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_25_14.xml', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_25_14.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_25_14.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_25_14.json', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_92_13.xml', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_92_13.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_92_13.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_92_13.json', 'ebookingcenter', '2023-08-23 07:49:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=14&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '10.571'
            , error_description = ''
            , memory_used = '13381224'
            WHERE id = '5035';
[08/23/2023 07:49:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=13&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '10.674'
            , error_description = ''
            , memory_used = '25415904'
            WHERE id = '5038';
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_18_6.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_18_6.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_18_6.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_18_6.json', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_37_0.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_37_0.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_37_0.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_37_0.json', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=6&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.455'
            , error_description = ''
            , memory_used = '29002424'
            WHERE id = '5041';
[08/23/2023 07:49:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=0&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.529'
            , error_description = ''
            , memory_used = '19896608'
            WHERE id = '5044';
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_2.xml', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_2.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_2.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_2.json', 'ebookingcenter', '2023-08-23 07:49:57', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=2&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.908'
            , error_description = ''
            , memory_used = '37435728'
            WHERE id = '5047';
[08/23/2023 07:49:58], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter', '2023-08-23 07:49:58', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:58], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_43_10.xml', 'ebookingcenter', '2023-08-23 07:49:58', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:58], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_43_10.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_43_10.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_43_10.json', 'ebookingcenter', '2023-08-23 07:49:58', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=10&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.219'
            , error_description = ''
            , memory_used = '38945304'
            WHERE id = '5050';
[08/23/2023 07:49:59], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter', '2023-08-23 07:49:59', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:59], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_11.xml', 'ebookingcenter', '2023-08-23 07:49:59', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:59], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_87_11.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_87_11.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_87_11.json', 'ebookingcenter', '2023-08-23 07:49:59', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:49:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=11&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.591'
            , error_description = ''
            , memory_used = '33233744'
            WHERE id = '5053';
[08/23/2023 07:50:00], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter', '2023-08-23 07:50:00', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:00], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_51_4.xml', 'ebookingcenter', '2023-08-23 07:50:00', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:00], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_51_4.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_51_4.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_51_4.json', 'ebookingcenter', '2023-08-23 07:50:00', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=4&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '14.480'
            , error_description = ''
            , memory_used = '45999488'
            WHERE id = '5056';
[08/23/2023 07:50:01], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter', '2023-08-23 07:50:01', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:01], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_6_12.xml', 'ebookingcenter', '2023-08-23 07:50:01', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:01], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_6_12.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_6_12.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_6_12.json', 'ebookingcenter', '2023-08-23 07:50:01', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:01], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=12&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '15.947'
            , error_description = ''
            , memory_used = '103635568'
            WHERE id = '5059';
[08/23/2023 07:50:03], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter', '2023-08-23 07:50:03', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:03], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_50_9.xml', 'ebookingcenter', '2023-08-23 07:50:03', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:03], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_50_9.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_50_9.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_50_9.json', 'ebookingcenter', '2023-08-23 07:50:03', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=9&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '17.388'
            , error_description = ''
            , memory_used = '24780888'
            WHERE id = '5062';
[08/23/2023 07:50:05], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter', '2023-08-23 07:50:05', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:05], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_52_8.xml', 'ebookingcenter', '2023-08-23 07:50:05', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:05], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_52_8.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_52_8.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_52_8.json', 'ebookingcenter', '2023-08-23 07:50:05', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=8&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '19.690'
            , error_description = ''
            , memory_used = '25652960'
            WHERE id = '5065';
[08/23/2023 07:50:06], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter', '2023-08-23 07:50:06', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:06], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_36_1.xml', 'ebookingcenter', '2023-08-23 07:50:06', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:06], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_49_46_1692776986_36_1.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_49_46_1692776986_36_1.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_49_46_1692776986_36_1.json', 'ebookingcenter', '2023-08-23 07:50:06', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=1&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:49:45.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '20.277'
            , error_description = ''
            , memory_used = '3202776'
            WHERE id = '5068';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:06' WHERE id= '65';
[08/23/2023 07:50:09], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:09' WHERE id= '65';
[08/23/2023 07:50:29], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:29' WHERE id= '65';
[08/23/2023 07:50:29], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:50:29' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/23/2023 07:50:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:30' WHERE id= '65';
[08/23/2023 07:50:36], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter', '2023-08-23 07:50:36', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:36], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_91_5.xml', 'ebookingcenter', '2023-08-23 07:50:36', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:36], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_91_5.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_91_5.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_91_5.json', 'ebookingcenter', '2023-08-23 07:50:36', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=5&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '6.470'
            , error_description = ''
            , memory_used = '8814568'
            WHERE id = '5071';
[08/23/2023 07:50:39], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter', '2023-08-23 07:50:39', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:39], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_95_0.xml', 'ebookingcenter', '2023-08-23 07:50:39', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:39], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_95_0.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_95_0.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_95_0.json', 'ebookingcenter', '2023-08-23 07:50:39', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=0&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.428'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.798'
            , error_description = ''
            , memory_used = '20052464'
            WHERE id = '5074';
[08/23/2023 07:50:40], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter', '2023-08-23 07:50:40', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:40], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_26_3.xml', 'ebookingcenter', '2023-08-23 07:50:40', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:40], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_26_3.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_26_3.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_26_3.json', 'ebookingcenter', '2023-08-23 07:50:40', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=3&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '10.108'
            , error_description = ''
            , memory_used = '9661736'
            WHERE id = '5077';
[08/23/2023 07:50:40], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter', '2023-08-23 07:50:40', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_18_7.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_18_7.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_18_7.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_18_7.json', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=7&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '10.669'
            , error_description = ''
            , memory_used = '8609312'
            WHERE id = '5080';
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_14.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_14.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_14.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_14.json', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_37_16.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_37_16.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_37_16.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_37_16.json', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=14&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.064'
            , error_description = ''
            , memory_used = '13304760'
            WHERE id = '5083';
[08/23/2023 07:50:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=16&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.100'
            , error_description = ''
            , memory_used = '11476720'
            WHERE id = '5086';
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_13_9.xml', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_13_9.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_13_9.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_13_9.json', 'ebookingcenter', '2023-08-23 07:50:41', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=9&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.381'
            , error_description = ''
            , memory_used = '24899688'
            WHERE id = '5089';
[08/23/2023 07:50:42], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter', '2023-08-23 07:50:42', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:42], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_52_6.xml', 'ebookingcenter', '2023-08-23 07:50:42', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:42], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_52_6.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_52_6.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_52_6.json', 'ebookingcenter', '2023-08-23 07:50:42', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=6&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '12.490'
            , error_description = ''
            , memory_used = '29023384'
            WHERE id = '5092';
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_2_1.xml', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_2_1.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_2_1.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_2_1.json', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=1&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.428'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '12.999'
            , error_description = ''
            , memory_used = '22724536'
            WHERE id = '5095';
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_3_4.xml', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_3_4.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_3_4.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_3_4.json', 'ebookingcenter', '2023-08-23 07:50:43', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=4&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.344'
            , error_description = ''
            , memory_used = '46328280'
            WHERE id = '5098';
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_47_13.xml', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_47_13.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_47_13.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_47_13.json', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=13&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.826'
            , error_description = ''
            , memory_used = '25049416'
            WHERE id = '5101';
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_59_11.xml', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_59_11.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_59_11.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_59_11.json', 'ebookingcenter', '2023-08-23 07:50:44', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=11&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '14.140'
            , error_description = ''
            , memory_used = '33729624'
            WHERE id = '5104';
[08/23/2023 07:50:46], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter', '2023-08-23 07:50:46', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:46], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_80_8.xml', 'ebookingcenter', '2023-08-23 07:50:46', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:46], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_80_8.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_80_8.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_80_8.json', 'ebookingcenter', '2023-08-23 07:50:46', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=8&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '16.549'
            , error_description = ''
            , memory_used = '25596872'
            WHERE id = '5107';
[08/23/2023 07:50:47], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter', '2023-08-23 07:50:47', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:47], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_16_12.xml', 'ebookingcenter', '2023-08-23 07:50:47', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:47], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_16_12.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_16_12.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_16_12.json', 'ebookingcenter', '2023-08-23 07:50:47', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=12&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '17.718'
            , error_description = ''
            , memory_used = '103467288'
            WHERE id = '5110';
[08/23/2023 07:50:49], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter', '2023-08-23 07:50:49', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:49], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_45_2.xml', 'ebookingcenter', '2023-08-23 07:50:49', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:49], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_45_2.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_45_2.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_45_2.json', 'ebookingcenter', '2023-08-23 07:50:49', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=2&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '18.842'
            , error_description = ''
            , memory_used = '37926352'
            WHERE id = '5113';
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_10.xml', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_7_10.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_7_10.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_7_10.json', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_100_15.xml', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=10&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '20.036'
            , error_description = ''
            , memory_used = '3202056'
            WHERE id = '5117';
[08/23/2023 07:50:50], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_50_30_1692777030_100_15.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_50_30_1692777030_100_15.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_50_30_1692777030_100_15.json', 'ebookingcenter', '2023-08-23 07:50:50', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=15&total_request=17&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:50:30.429'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '20.041'
            , error_description = ''
            , memory_used = '3201552'
            WHERE id = '5119';
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:50' WHERE id= '65';
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:50' WHERE id= '65';
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:50' WHERE id= '65';
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:50' WHERE id= '65';
[08/23/2023 07:50:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:50' WHERE id= '65';
[08/23/2023 07:50:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:51' WHERE id= '65';
[08/23/2023 07:50:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:51' WHERE id= '65';
[08/23/2023 07:50:53], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:50:53' WHERE id= '65';
[08/23/2023 07:51:31], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:31' WHERE id= '65';
[08/23/2023 07:51:32], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:32' WHERE id= '65';
[08/23/2023 07:51:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1692777092','43.239.53.130');
[08/23/2023 07:51:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'ebookingcenter/23_08_2023/request_valuation_sqtech_07_51_32_1692777092_28.json', 'ebookingcenter/23_08_2023/response_valuation_sqtech_07_51_32_1692777092_28.json', 'ebookingcenter/23_08_2023/response_header_valuation_sqtech_07_51_32_1692777092_28.json', 'ebookingcenter', '2023-08-23 07:51:32', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:51:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Clink 261 Hostel (no Front Desk Need To Contact Property 7 Days In Advance)', 'london', '95', '7839', '', '4', '', 'hotelcancellationpolicy', '2023-08-23 :07:51:32','');
[08/23/2023 07:51:36], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:36' WHERE id= '65';
[08/23/2023 07:51:36], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:36' WHERE id= '65';
[08/23/2023 07:51:36], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1692777096','43.239.53.130');
[08/23/2023 07:51:36], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'ebookingcenter/23_08_2023/request_valuation_sqtech_07_51_36_1692777096_74.json', 'ebookingcenter/23_08_2023/response_valuation_sqtech_07_51_36_1692777096_74.json', 'ebookingcenter/23_08_2023/response_header_valuation_sqtech_07_51_36_1692777096_74.json', 'ebookingcenter', '2023-08-23 07:51:36', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:51:41], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:41' WHERE id= '65';
[08/23/2023 07:51:46], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:46' WHERE id= '65';
[08/23/2023 07:51:47], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:47' WHERE id= '65';
[08/23/2023 07:51:53], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:53' WHERE id= '65';
[08/23/2023 07:51:53], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1692777113','43.239.53.130');
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:51:55' WHERE id= '65';
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'ebookingcenter', reservation_id = '384', create_date = '2023-08-23 07:51:55', agent_id = '7839', parent_agent_id = '7839', agent_ref_no = '', nationality = 'Indian', city_id = 'london', country_id = '95', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '38.62', display_currency_code = 'USD', native_room_rate = '37.31', native_currency_code = 'USD', supplier_profile_id = '46', service_type = 'hotel', service_date = '2023/11/20', check_out_date = '2023/11/21', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'sujay', leader_last_name = 'Raut', status_date = '2023-08-23 07:51:55';
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '4'
		WHERE
		id='15'
		;
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('15','384','ebookingcenter','1','1','0','-','','','303369','CLINK 261 HOSTEL (NO FRONT DESK NEED TO CONTACT PROPERTY 7 DAYS IN ADVANCE)','261-265 Grays Inn Road, Camden, London','+442078339400','3','1','2023/11/20','2023/11/21','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly93d3cuZWJvb2tpbmdjZW50ZXIuY29tL3Ricy9maWxlcy9pbWFnZXMvaG90ZWwvNS83LzMvMzAzMzY5LzQ5NzZkMDc4MTNjN2E4ZGI1MDkxMzg2ZTNlNGE0ODg1OWExYmE4NmEuanBn');
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '15', booking_detail_id = '1', room_type_code = '303369~|@|~7cba23d6-4c49-49dc-8907-55eaec379519~|@|~eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzZWFyY2hSZXN1bHRzS2V5IjoiN2NiYTIzZDYtNGM0OS00OWRjLTg5MDctNTVlYWVjMzc5NTE5Iiwic2hvd1N1cHBsaWVyIjpmYWxzZSwidmlld0N1cnJlbmN5IjoiVVNEIiwic2hvd05ldFByaWNlIjp0cnVlLCJzaG93UHJpY2VDb21wb25lbnRzIjoiIiwiaWF0IjoxNjkyNzc3MDQxLCJuYmYiOjE2OTI3NzcwNDEsImV4cCI6MTY5MjgxMzA0MSwidXVpZCI6ImI4ZjUzMDU4LWExYzMtNDgxZS1hNzhkLTE5ZGRhZjIzOTc4NiIsInYiOiIyMjI0ZDE3ZGUyMDA4NTExNDA3MTIzMjI1Mzg3NjljMTkwNjZlZjlmIn0.GRV1tIhGv8AuqRT3gNSvv3zbcrJCkcbZRBVbOVR7e2U~|@|~1', room_name = 'single', room_type_description = 'Shared Dormitory (One bed in a 18 Bedded Dorm) (Room Only)<font color=\'red\'>(Package Rate. Save10%. Free WiFi. Beds: 1 BunkBed.)</font>', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:38.619999999999997;s:25:"displayNightlyRateDisplay";s:184:"Supplier Name - ebookingcenter , Rate - 37.31 USD, Currency Multiplier (USD - USD) - 1.00000 Markup in % - 3.50%, Markup Amount - 0, , Markup Amount in SAR - 0.00,Supplier Commission-0";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:37.310000000000002;}}', native_room_rate_total = '37.31', display_room_rate_total = '38.62', number_of_rooms = '1', room_category = 'Shared Dormitory (One bed in a 18 Bedded Dorm) (Room Only)<font color=\'red\'>(Package Rate. Save10%. Free WiFi. Beds: 1 BunkBed.)</font>', meal_basis = 'Room Only';
[08/23/2023 07:51:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '15', booking_detail_id = '1', rid = '19', room = '0', salutations = 'Mr', first_name = 'sujay', last_name = 'Raut', passenger_type = 'adult', age = '';
[08/23/2023 07:51:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'pre_reservation', 'ebookingcenter/23_08_2023/request_pre_reservation_sqtech_07_51_56_1692777116_59.json', 'ebookingcenter/23_08_2023/response_pre_reservation_sqtech_07_51_56_1692777116_59.json', 'ebookingcenter/23_08_2023/response_header_pre_reservation_sqtech_07_51_56_1692777116_59.json', 'ebookingcenter', '2023-08-23 07:51:56', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', cancellation_policy = '<br>If you cancel between 2023-11-11 02:00:00 and 2023-11-20 00:00:00 , you will be charged 38.62 USD<br>No show is subject to a 100 % cancellation charge<br>', supplier_cancellation_policy = '', current_status = 'failed', expiration_date = '2023-11-11 00:00:00', comment_contract = ' <b>Cancellation notes :</b><br>If you fail to check-in for this reservation, or if you cancel or change this reservation after check-in, you may incur penalty charges at the discretion of the property of up to 100% of the booking value.<br><b>Taxes and fees :</b><br>Price includes: 
- Taxes and Fees: 6.4 USD
* This charge includes estimated amounts the travel service provider (i.e. hotel, car rental company) pays for their taxes, and/or taxes that we pay, to taxing authorities on your booking (including but not limited to sales, occupancy, and value added tax). This amount may also include any amounts charged to us for resort fees, cleaning fees, and other fees and/or a fee we, the hotel supplier and/or the website you booked on, retain as part of the compensation for our and/or their services, which varies based on factors such as location, the amount, and how you booked. For more details, please see the Terms and Conditions.<br><b>Essential information :</b><br>Choices between multiple bed types for the same room are requests only and may not be honored at the hotel if availability does not permit.<br>Optional fees: 
- Offsite parking fee: GBP 28 per day (1 mi away) 
 
The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change<br>Know before you go:
 - This property\'s policy is to refuse certain bookings for the purpose of group events or parties, including pre-wedding stag/bachelor and hen/bachelorette parties. 
- Only registered guests are allowed in the guestrooms. 
- Alcohol is not served at this property. 
- This property advises that enhanced cleaning and guest safety measures are currently in place.
- Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60°C/140°F.
- Social distancing measures are in place; staff at the property wear personal protective equipment; a shield is in place between staff and guests in main contact areas; guests are provided with hand sanitizer.
- Contactless check-in and contactless check-out are available.
- This property affirms that it adheres to the cleaning and disinfection practices of Safe Travels (WTTC - Global).<br><b>Check-in / Check-out notes :</b><br>Check-in instructions:
  Check-in hours: 4:00 PM ~ 10:00 PM. 
Check-out hours: 10:00 AM. 
Minimum check-in age: 18. 

 
- Extra-person charges may apply and vary depending on property policy
- Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges
- Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
- This property accepts credit cards; cash is not accepted
- Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property 
 
 
- Children under 12 years of age are not permitted in group bookings and advance notice is required to make bedding and parking arrangements.
- Please note, that if the name on your booking is different to the name on the card used to the confirm the booking, the hostel may request a copy of your ID or card for legal reasons.
- When booking more than one dorm bed there is no guarantee that they will be located in the same room. 
. 
This property doesn\'t offer after-hours check-in. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation.', consultant_id = 'Demo@User', sales_manager_id = '0', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '3.7507', ip_addr = '43.239.53.130', comment_contract = ' <b>Cancellation notes :</b><br>If you fail to check-in for this reservation, or if you cancel or change this reservation after check-in, you may incur penalty charges at the discretion of the property of up to 100% of the booking value.<br><b>Taxes and fees :</b><br>Price includes: 
- Taxes and Fees: 6.4 USD
* This charge includes estimated amounts the travel service provider (i.e. hotel, car rental company) pays for their taxes, and/or taxes that we pay, to taxing authorities on your booking (including but not limited to sales, occupancy, and value added tax). This amount may also include any amounts charged to us for resort fees, cleaning fees, and other fees and/or a fee we, the hotel supplier and/or the website you booked on, retain as part of the compensation for our and/or their services, which varies based on factors such as location, the amount, and how you booked. For more details, please see the Terms and Conditions.<br><b>Essential information :</b><br>Choices between multiple bed types for the same room are requests only and may not be honored at the hotel if availability does not permit.<br>Optional fees: 
- Offsite parking fee: GBP 28 per day (1 mi away) 
 
The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change<br>Know before you go:
 - This property\'s policy is to refuse certain bookings for the purpose of group events or parties, including pre-wedding stag/bachelor and hen/bachelorette parties. 
- Only registered guests are allowed in the guestrooms. 
- Alcohol is not served at this property. 
- This property advises that enhanced cleaning and guest safety measures are currently in place.
- Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60°C/140°F.
- Social distancing measures are in place; staff at the property wear personal protective equipment; a shield is in place between staff and guests in main contact areas; guests are provided with hand sanitizer.
- Contactless check-in and contactless check-out are available.
- This property affirms that it adheres to the cleaning and disinfection practices of Safe Travels (WTTC - Global).<br><b>Check-in / Check-out notes :</b><br>Check-in instructions:
  Check-in hours: 4:00 PM ~ 10:00 PM. 
Check-out hours: 10:00 AM. 
Minimum check-in age: 18. 

 
- Extra-person charges may apply and vary depending on property policy
- Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges
- Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
- This property accepts credit cards; cash is not accepted
- Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property 
 
 
- Children under 12 years of age are not permitted in group bookings and advance notice is required to make bedding and parking arrangements.
- Please note, that if the name on your booking is different to the name on the card used to the confirm the booking, the hostel may request a copy of your ID or card for legal reasons.
- When booking more than one dorm bed there is no guarantee that they will be located in the same room. 
. 
This property doesn\'t offer after-hours check-in. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='3.51',  agent_markup='3.51',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7839',  sub_agent_rate='0',  agent_rate='38.62',  applicable_service_tax='0',  supplier_rate='37.31',  uid='474d67056a6d8ec581381d684d3c420b'  where id='15';
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='15';
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('15','51.5291','-0.11998');
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('384','15','failed','2023-08-23 07:51:59','Booking failed Error: Credit Low. Booked by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','0','7839');
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('15','1970-01-01 00:00:00','1970-01-05 00:00:00','1970-01-01 00:00:00','1970-01-05 00:00:00','','','96','2023-08-23 07:51:59','38.62');
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='15',status='1' where reservation_id='384' and booking_id ='0';
[08/23/2023 07:51:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='15' where agent_logs_id='0' and source_type='ebookingcenter';
[08/23/2023 07:53:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:53:38' WHERE id= '65';
[08/23/2023 07:53:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:53:56' WHERE id= '65';
[08/23/2023 07:53:56], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:53:56' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '1.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/23/2023 07:53:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:53:57' WHERE id= '65';
[08/23/2023 07:53:57], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:53:57' WHERE id= '65';
[08/23/2023 07:53:59], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:53:59' WHERE id= '65';
[08/23/2023 07:54:04], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:04' WHERE id= '65';
[08/23/2023 07:54:04], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:54:04' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '2.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/23/2023 07:54:05], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:05' WHERE id= '65';
[08/23/2023 07:54:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:06' WHERE id= '65';
[08/23/2023 07:54:07], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:07' WHERE id= '65';
[08/23/2023 07:54:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:12' WHERE id= '65';
[08/23/2023 07:54:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:54:12' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '3.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/23/2023 07:54:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:13' WHERE id= '65';
[08/23/2023 07:54:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter', '2023-08-23 07:54:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_46_5.xml', 'ebookingcenter', '2023-08-23 07:54:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_46_5.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_46_5.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_46_5.json', 'ebookingcenter', '2023-08-23 07:54:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=5&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.819'
            , error_description = ''
            , memory_used = '8620376'
            WHERE id = '5125';
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_0.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_0.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_0.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_0.json', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=0&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.031'
            , error_description = ''
            , memory_used = '20079664'
            WHERE id = '5128';
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_15_7.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_15_7.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_15_7.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_15_7.json', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_9.xml', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_9.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_9.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_9.json', 'ebookingcenter', '2023-08-23 07:54:21', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=7&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.555'
            , error_description = ''
            , memory_used = '8612616'
            WHERE id = '5131';
[08/23/2023 07:54:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=9&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.768'
            , error_description = ''
            , memory_used = '24894920'
            WHERE id = '5134';
[08/23/2023 07:54:22], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter', '2023-08-23 07:54:22', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:22], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_64_8.xml', 'ebookingcenter', '2023-08-23 07:54:22', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:22], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_64_8.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_64_8.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_64_8.json', 'ebookingcenter', '2023-08-23 07:54:22', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:22], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=8&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '9.371'
            , error_description = ''
            , memory_used = '25844832'
            WHERE id = '5137';
[08/23/2023 07:54:23], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter', '2023-08-23 07:54:23', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:23], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_45_3.xml', 'ebookingcenter', '2023-08-23 07:54:23', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:23], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_45_3.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_45_3.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_45_3.json', 'ebookingcenter', '2023-08-23 07:54:23', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=3&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '9.965'
            , error_description = ''
            , memory_used = '9682776'
            WHERE id = '5140';
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_11_6.xml', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_11_6.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_11_6.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_11_6.json', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=6&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '12.232'
            , error_description = ''
            , memory_used = '28995096'
            WHERE id = '5143';
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_10.xml', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_28_10.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_28_10.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_28_10.json', 'ebookingcenter', '2023-08-23 07:54:25', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=10&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '12.541'
            , error_description = ''
            , memory_used = '39825328'
            WHERE id = '5146';
[08/23/2023 07:54:26], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter', '2023-08-23 07:54:26', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:26], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_16_4.xml', 'ebookingcenter', '2023-08-23 07:54:26', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:26], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_16_4.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_16_4.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_16_4.json', 'ebookingcenter', '2023-08-23 07:54:26', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=4&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.491'
            , error_description = ''
            , memory_used = '46324280'
            WHERE id = '5149';
[08/23/2023 07:54:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter', '2023-08-23 07:54:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_86_1.xml', 'ebookingcenter', '2023-08-23 07:54:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_86_1.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_86_1.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_86_1.json', 'ebookingcenter', '2023-08-23 07:54:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=1&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '14.305'
            , error_description = ''
            , memory_used = '22713616'
            WHERE id = '5152';
[08/23/2023 07:54:30], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter', '2023-08-23 07:54:30', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:30], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_11.xml', 'ebookingcenter', '2023-08-23 07:54:30', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:30], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_17_11.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_17_11.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_17_11.json', 'ebookingcenter', '2023-08-23 07:54:30', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:31], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=11&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '17.717'
            , error_description = ''
            , memory_used = '33259008'
            WHERE id = '5155';
[08/23/2023 07:54:33], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter', '2023-08-23 07:54:33', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:33], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_42_2.xml', 'ebookingcenter', '2023-08-23 07:54:33', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:33], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_54_13_1692777253_42_2.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_54_13_1692777253_42_2.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_54_13_1692777253_42_2.json', 'ebookingcenter', '2023-08-23 07:54:33', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=2&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:54:13.305'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '20.040'
            , error_description = ''
            , memory_used = '3199008'
            WHERE id = '5158';
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:33' WHERE id= '65';
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:33' WHERE id= '65';
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:33' WHERE id= '65';
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:33' WHERE id= '65';
[08/23/2023 07:54:33], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:33' WHERE id= '65';
[08/23/2023 07:54:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:34' WHERE id= '65';
[08/23/2023 07:54:35], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:54:35' WHERE id= '65';
[08/23/2023 07:55:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:11' WHERE id= '65';
[08/23/2023 07:55:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:19' WHERE id= '65';
[08/23/2023 07:55:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:35' WHERE id= '65';
[08/23/2023 07:55:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:35' WHERE id= '65';
[08/23/2023 07:55:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:43' WHERE id= '65';
[08/23/2023 07:55:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:55:52' WHERE id= '65';
[08/23/2023 07:56:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:06' WHERE id= '65';
[08/23/2023 07:56:06], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '4' , ip = '43.239.53.130' , city = 'london' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/20' , departure_date = '2023/11/21' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-08-23 07:56:06' , site_id = '' , country_code = '95' , city_code = '63265' , ratings = '3.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/23/2023 07:56:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:06' WHERE id= '65';
[08/23/2023 07:56:13], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter', '2023-08-23 07:56:13', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:13], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_13_7.xml', 'ebookingcenter', '2023-08-23 07:56:13', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:13], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_13_7.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_13_7.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_13_7.json', 'ebookingcenter', '2023-08-23 07:56:13', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:13], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=7&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.115'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '5.998'
            , error_description = ''
            , memory_used = '8627744'
            WHERE id = '5161';
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_53_1.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_53_1.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_53_1.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_53_1.json', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=1&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.88'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.216'
            , error_description = ''
            , memory_used = '22721720'
            WHERE id = '5164';
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_11_8.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_11_8.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_11_8.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_11_8.json', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_32_5.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_32_5.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_32_5.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_32_5.json', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=8&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.88'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.499'
            , error_description = ''
            , memory_used = '25599120'
            WHERE id = '5167';
[08/23/2023 07:56:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=5&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.138'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.464'
            , error_description = ''
            , memory_used = '8812520'
            WHERE id = '5170';
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_78_0.xml', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_78_0.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_78_0.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_78_0.json', 'ebookingcenter', '2023-08-23 07:56:14', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=0&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.143'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '7.849'
            , error_description = ''
            , memory_used = '19916672'
            WHERE id = '5173';
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_66_9.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_61_11.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_66_9.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_66_9.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_66_9.json', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_61_11.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_61_11.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_61_11.json', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_35_6.xml', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_35_6.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_35_6.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_35_6.json', 'ebookingcenter', '2023-08-23 07:56:15', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=9&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.143'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.439'
            , error_description = ''
            , memory_used = '24784456'
            WHERE id = '5178';
[08/23/2023 07:56:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=11&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.87'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.570'
            , error_description = ''
            , memory_used = '33760360'
            WHERE id = '5179';
[08/23/2023 07:56:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=6&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.123'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '8.561'
            , error_description = ''
            , memory_used = '29233096'
            WHERE id = '5182';
[08/23/2023 07:56:17], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter', '2023-08-23 07:56:17', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:17], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_71_10.xml', 'ebookingcenter', '2023-08-23 07:56:17', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:18], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_71_10.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_71_10.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_71_10.json', 'ebookingcenter', '2023-08-23 07:56:18', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:18], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=10&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.113'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '11.053'
            , error_description = ''
            , memory_used = '38602328'
            WHERE id = '5185';
[08/23/2023 07:56:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter', '2023-08-23 07:56:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_9_4.xml', 'ebookingcenter', '2023-08-23 07:56:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:20], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_9_4.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_9_4.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_9_4.json', 'ebookingcenter', '2023-08-23 07:56:20', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=4&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.132'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '13.900'
            , error_description = ''
            , memory_used = '45709056'
            WHERE id = '5188';
[08/23/2023 07:56:24], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter', '2023-08-23 07:56:24', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:24], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_60_2.xml', 'ebookingcenter', '2023-08-23 07:56:24', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:24], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_60_2.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_60_2.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_60_2.json', 'ebookingcenter', '2023-08-23 07:56:24', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=2&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.133'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '18.022'
            , error_description = ''
            , memory_used = '35884432'
            WHERE id = '5191';
[08/23/2023 07:56:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter', '2023-08-23 07:56:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_89_3.xml', 'ebookingcenter', '2023-08-23 07:56:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:27], [file name :-/home/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)
                VALUE ('', 'availability', 'ebookingcenter/23_08_2023/request_availability_sqtech_07_56_07_1692777367_89_3.json', 'ebookingcenter/23_08_2023/response_availability_sqtech_07_56_07_1692777367_89_3.json', 'ebookingcenter/23_08_2023/response_header_availability_sqtech_07_56_07_1692777367_89_3.json', 'ebookingcenter', '2023-08-23 07:56:27', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=ebookingcenter&sessionid=84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4&xml_user_id=7839&db_caching=1&wh_agent_id=&erequest=3&total_request=12&city_code=2243&city_name=LONDON&country_code=351&hotels_ids=&web_service=no'
            , http_hit_time = '2023-08-23 07:56:07.138'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '20.062'
            , error_description = ''
            , memory_used = '3198352'
            WHERE id = '5194';
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:27' WHERE id= '65';
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:27' WHERE id= '65';
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:27' WHERE id= '65';
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:27' WHERE id= '65';
[08/23/2023 07:56:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:27' WHERE id= '65';
[08/23/2023 07:56:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:28' WHERE id= '65';
[08/23/2023 07:56:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:28' WHERE id= '65';
[08/23/2023 07:56:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:32' WHERE id= '65';
[08/23/2023 07:56:52], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:52' WHERE id= '65';
[08/23/2023 07:56:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:56:52' WHERE id= '65';
[08/23/2023 07:56:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1692777412','43.239.53.130');
[08/23/2023 07:56:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'ebookingcenter/23_08_2023/request_valuation_sqtech_07_56_52_1692777412_38.json', 'ebookingcenter/23_08_2023/response_valuation_sqtech_07_56_52_1692777412_38.json', 'ebookingcenter/23_08_2023/response_header_valuation_sqtech_07_56_52_1692777412_38.json', 'ebookingcenter', '2023-08-23 07:56:52', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:57:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:57:03' WHERE id= '65';
[08/23/2023 07:57:08], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:57:08' WHERE id= '65';
[08/23/2023 07:57:08], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1692777428','43.239.53.130');
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-08-23 07:57:09' WHERE id= '65';
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'ebookingcenter', reservation_id = '386', create_date = '2023-08-23 07:57:09', agent_id = '7839', parent_agent_id = '7839', agent_ref_no = '', nationality = 'Indian', city_id = 'london', country_id = '95', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '39.57', display_currency_code = 'USD', native_room_rate = '38.23', native_currency_code = 'USD', supplier_profile_id = '46', service_type = 'hotel', service_date = '2023/11/20', check_out_date = '2023/11/21', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Sujay', leader_last_name = 'raut', status_date = '2023-08-23 07:57:09';
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '4'
		WHERE
		id='16'
		;
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('16','386','ebookingcenter','1','1','0','-','','','303369','CLINK 261 HOSTEL (NO FRONT DESK NEED TO CONTACT PROPERTY 7 DAYS IN ADVANCE)','261-265 Grays Inn Road, Camden, London','+442078339400','3','1','2023/11/20','2023/11/21','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly93d3cuZWJvb2tpbmdjZW50ZXIuY29tL3Ricy9maWxlcy9pbWFnZXMvaG90ZWwvNS83LzMvMzAzMzY5LzQ5NzZkMDc4MTNjN2E4ZGI1MDkxMzg2ZTNlNGE0ODg1OWExYmE4NmEuanBn');
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '16', booking_detail_id = '1', room_type_code = '303369~|@|~6c180460-e56a-45b1-8130-ec4426630b17~|@|~eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzZWFyY2hSZXN1bHRzS2V5IjoiNmMxODA0NjAtZTU2YS00NWIxLTgxMzAtZWM0NDI2NjMwYjE3Iiwic2hvd1N1cHBsaWVyIjpmYWxzZSwidmlld0N1cnJlbmN5IjoiVVNEIiwic2hvd05ldFByaWNlIjp0cnVlLCJzaG93UHJpY2VDb21wb25lbnRzIjoiIiwiaWF0IjoxNjkyNzc3Mzc1LCJuYmYiOjE2OTI3NzczNzUsImV4cCI6MTY5MjgxMzM3NSwidXVpZCI6Ijg5MGE5ZjEyLWM0MTItNDNmMC04Yjk0LWE2MDI2Y2FhMDllZCIsInYiOiIyMjI0ZDE3ZGUyMDA4NTExNDA3MTIzMjI1Mzg3NjljMTkwNjZlZjlmIn0.BhDUtPSAVOVUbZzVLOP0bXz4_E5cJKqRRA3hr91PYcM~|@|~1', room_name = 'single', room_type_description = 'Shared Dormitory (One bed in a 18 Bedded Dorm) (Room Only)<font color=\'red\'>(Package Rate. Save10%. Free WiFi. Beds: 1 BunkBed.)</font>', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:39.57;s:25:"displayNightlyRateDisplay";s:184:"Supplier Name - ebookingcenter , Rate - 38.23 USD, Currency Multiplier (USD - USD) - 1.00000 Markup in % - 3.50%, Markup Amount - 0, , Markup Amount in SAR - 0.00,Supplier Commission-0";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:38.229999999999997;}}', native_room_rate_total = '38.23', display_room_rate_total = '39.57', number_of_rooms = '1', room_category = 'Shared Dormitory (One bed in a 18 Bedded Dorm) (Room Only)<font color=\'red\'>(Package Rate. Save10%. Free WiFi. Beds: 1 BunkBed.)</font>', meal_basis = 'Room Only';
[08/23/2023 07:57:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '16', booking_detail_id = '1', rid = '20', room = '0', salutations = 'Mr', first_name = 'Sujay', last_name = 'raut', passenger_type = 'adult', age = '';
[08/23/2023 07:57:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'pre_reservation', 'ebookingcenter/23_08_2023/request_pre_reservation_sqtech_07_57_10_1692777430_61.json', 'ebookingcenter/23_08_2023/response_pre_reservation_sqtech_07_57_10_1692777430_61.json', 'ebookingcenter/23_08_2023/response_header_pre_reservation_sqtech_07_57_10_1692777430_61.json', 'ebookingcenter', '2023-08-23 07:57:10', '', '84df6200bc84aeb43f4b6449c234425c894d7399f2c476b3d874aa051e4beca4', '0');
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', cancellation_policy = '<br>If you cancel between 2023-11-05 02:00:00 and 2023-11-20 00:00:00 , you will be charged 39.57 USD<br>No show is subject to a 100 % cancellation charge<br>', supplier_cancellation_policy = '', current_status = 'failed', expiration_date = '2023-11-05 00:00:00', comment_contract = ' <b>Cancellation notes :</b><br>If you fail to check-in for this reservation, or if you cancel or change this reservation after check-in, you may incur penalty charges at the discretion of the property of up to 100% of the booking value.<br><b>Taxes and fees :</b><br>Price includes: 
- Taxes and Fees: 6.88 USD
* This charge includes estimated amounts the travel service provider (i.e. hotel, car rental company) pays for their taxes, and/or taxes that we pay, to taxing authorities on your booking (including but not limited to sales, occupancy, and value added tax). This amount may also include any amounts charged to us for resort fees, cleaning fees, and other fees and/or a fee we, the hotel supplier and/or the website you booked on, retain as part of the compensation for our and/or their services, which varies based on factors such as location, the amount, and how you booked. For more details, please see the Terms and Conditions.<br><b>Essential information :</b><br>Choices between multiple bed types for the same room are requests only and may not be honored at the hotel if availability does not permit.<br>Optional fees: 
- Offsite parking fee: GBP 28 per day (1 mi away) 
 
The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change<br>Know before you go:
 - This property\'s policy is to refuse certain bookings for the purpose of group events or parties, including pre-wedding stag/bachelor and hen/bachelorette parties. 
- Only registered guests are allowed in the guestrooms. 
- Alcohol is not served at this property. 
- This property advises that enhanced cleaning and guest safety measures are currently in place.
- Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60°C/140°F.
- Social distancing measures are in place; staff at the property wear personal protective equipment; a shield is in place between staff and guests in main contact areas; guests are provided with hand sanitizer.
- Contactless check-in and contactless check-out are available.
- This property affirms that it adheres to the cleaning and disinfection practices of Safe Travels (WTTC - Global).<br><b>Check-in / Check-out notes :</b><br>Check-in instructions:
  Check-in hours: 4:00 PM ~ 10:00 PM. 
Check-out hours: 10:00 AM. 
Minimum check-in age: 18. 

 
- Extra-person charges may apply and vary depending on property policy
- Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges
- Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
- This property accepts credit cards; cash is not accepted
- Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property 
 
 
- Children under 12 years of age are not permitted in group bookings and advance notice is required to make bedding and parking arrangements.
- Please note, that if the name on your booking is different to the name on the card used to the confirm the booking, the hostel may request a copy of your ID or card for legal reasons.
- When booking more than one dorm bed there is no guarantee that they will be located in the same room. 
. 
This property doesn\'t offer after-hours check-in. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation.', consultant_id = 'Demo@User', sales_manager_id = '0', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '3.7507', ip_addr = '43.239.53.130', comment_contract = ' <b>Cancellation notes :</b><br>If you fail to check-in for this reservation, or if you cancel or change this reservation after check-in, you may incur penalty charges at the discretion of the property of up to 100% of the booking value.<br><b>Taxes and fees :</b><br>Price includes: 
- Taxes and Fees: 6.88 USD
* This charge includes estimated amounts the travel service provider (i.e. hotel, car rental company) pays for their taxes, and/or taxes that we pay, to taxing authorities on your booking (including but not limited to sales, occupancy, and value added tax). This amount may also include any amounts charged to us for resort fees, cleaning fees, and other fees and/or a fee we, the hotel supplier and/or the website you booked on, retain as part of the compensation for our and/or their services, which varies based on factors such as location, the amount, and how you booked. For more details, please see the Terms and Conditions.<br><b>Essential information :</b><br>Choices between multiple bed types for the same room are requests only and may not be honored at the hotel if availability does not permit.<br>Optional fees: 
- Offsite parking fee: GBP 28 per day (1 mi away) 
 
The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change<br>Know before you go:
 - This property\'s policy is to refuse certain bookings for the purpose of group events or parties, including pre-wedding stag/bachelor and hen/bachelorette parties. 
- Only registered guests are allowed in the guestrooms. 
- Alcohol is not served at this property. 
- This property advises that enhanced cleaning and guest safety measures are currently in place.
- Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60°C/140°F.
- Social distancing measures are in place; staff at the property wear personal protective equipment; a shield is in place between staff and guests in main contact areas; guests are provided with hand sanitizer.
- Contactless check-in and contactless check-out are available.
- This property affirms that it adheres to the cleaning and disinfection practices of Safe Travels (WTTC - Global).<br><b>Check-in / Check-out notes :</b><br>Check-in instructions:
  Check-in hours: 4:00 PM ~ 10:00 PM. 
Check-out hours: 10:00 AM. 
Minimum check-in age: 18. 

 
- Extra-person charges may apply and vary depending on property policy
- Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges
- Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
- This property accepts credit cards; cash is not accepted
- Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property 
 
 
- Children under 12 years of age are not permitted in group bookings and advance notice is required to make bedding and parking arrangements.
- Please note, that if the name on your booking is different to the name on the card used to the confirm the booking, the hostel may request a copy of your ID or card for legal reasons.
- When booking more than one dorm bed there is no guarantee that they will be located in the same room. 
. 
This property doesn\'t offer after-hours check-in. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='3.51',  agent_markup='3.51',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7839',  sub_agent_rate='0',  agent_rate='39.57',  applicable_service_tax='0',  supplier_rate='38.23',  uid='a2c264d5a3be285c8f7222f7afc9b4f7'  where id='16';
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='16';
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('16','51.5291','-0.11998');
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('386','16','failed','2023-08-23 07:57:11','Booking failed Error: Credit Low. Booked by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','0','7839');
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('16','1970-01-01 00:00:00','1970-01-05 00:00:00','1970-01-01 00:00:00','1970-01-05 00:00:00','','','96','2023-08-23 07:57:11','39.57');
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='16',status='1' where reservation_id='386' and booking_id ='0';
[08/23/2023 07:57:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='16' where agent_logs_id='0' and source_type='ebookingcenter';
