[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [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';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '1' ,priority = '' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [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 = '';
[09/28/2023 05:53:55], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-09-28 05:53:55',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;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;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;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;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;96\&#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;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;96\&#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;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;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;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;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- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 24 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[09/28/2023 05:54:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-09-28 05:54:04',login_attempt=0 where id = '7839';
[09/28/2023 05:54:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '28', login_datetime = '2023-09-28 05:54:04', ip = '43.239.53.130', action = 'Login' ;
[09/28/2023 05:54:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7839', session_id='d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e',create_date='2023-09-28 05:54:05', update_date='2023-09-28 05:54:05',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[09/28/2023 05:54:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:10' WHERE id= '96';
[09/28/2023 05:54:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:22' WHERE id= '96';
[09/28/2023 05:54:22], [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 = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/10/01' , departure_date = '2023/10/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 05:54:22' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[09/28/2023 05:54:23], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:23' WHERE id= '96';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.8'
                , total_duration = '0.023'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.8'
                , total_duration = '0.024'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.8'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.9'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.9'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.8'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.9'
                , total_duration = '0.025'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.8'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559648';
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:54:24.9'
                , total_duration = '0.027'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:54:24'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1559696';
[09/28/2023 05:54: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_81.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_81.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_81.json', 'expedia', '2023-09-28 05:54:24', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '0.374'
            , error_description = ''
            , memory_used = '1302776'
            WHERE id = '7879';
[09/28/2023 05:54: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_23.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_23.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_23.json', 'expediapackage', '2023-09-28 05:54:24', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.9'
            , 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 = '0.416'
            , error_description = ''
            , memory_used = '1303720'
            WHERE id = '7880';
[09/28/2023 05: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_46.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_46.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_46.json', 'expedia', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_73.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_73.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_73.json', 'expedia', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_70.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_70.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_70.json', 'expedia', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_3.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_3.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_3.json', 'expedia', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '1.490'
            , error_description = ''
            , memory_used = '41079176'
            WHERE id = '7881';
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '1.503'
            , error_description = ''
            , memory_used = '42511384'
            WHERE id = '7882';
[09/28/2023 05: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_70.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_70.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_70.json', 'expediapackage', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_28.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_28.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_28.json', 'expediapackage', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '1.702'
            , error_description = ''
            , memory_used = '44710184'
            WHERE id = '7883';
[09/28/2023 05: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_20.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_20.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_20.json', 'expediapackage', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_99.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_99.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_99.json', 'expediapackage', '2023-09-28 05:54:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '1.792'
            , error_description = ''
            , memory_used = '48043808'
            WHERE id = '7884';
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.9'
            , 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 = '1.850'
            , error_description = ''
            , memory_used = '33761184'
            WHERE id = '7886';
[09/28/2023 05:54:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '1.922'
            , error_description = ''
            , memory_used = '49926464'
            WHERE id = '7885';
[09/28/2023 05: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', 'e1p/28_09_2023/request_availability_sqtech_05_54_24_1695880464_89.json', 'e1p/28_09_2023/response_availability_sqtech_05_54_24_1695880464_89.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_89.json', 'expediapackage', '2023-09-28 05:54:26', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '2.220'
            , error_description = ''
            , memory_used = '49321784'
            WHERE id = '7888';
[09/28/2023 05:54:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.9'
            , 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 = '2.224'
            , error_description = ''
            , memory_used = '52724520'
            WHERE id = '7887';
[09/28/2023 05:54:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '2.533'
            , error_description = ''
            , memory_used = '53111160'
            WHERE id = '7889';
[09/28/2023 05: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', 'e1/28_09_2023/request_availability_sqtech_05_54_24_1695880464_80.json', 'e1/28_09_2023/response_availability_sqtech_05_54_24_1695880464_80.json', 'e1/28_09_2023/response_header_availability_sqtech_05_54_24_1695880464_80.json', 'expedia', '2023-09-28 05:54:26', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:54:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:54:24.8'
            , 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 = '3.018'
            , error_description = ''
            , memory_used = '30586016'
            WHERE id = '7890';
[09/28/2023 05:54:34], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:34' WHERE id= '96';
[09/28/2023 05:54:35], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:35' WHERE id= '96';
[09/28/2023 05:54:35], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:35' WHERE id= '96';
[09/28/2023 05:54:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:54:39' WHERE id= '96';
[09/28/2023 05:56:02], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:56:02' WHERE id= '96';
[09/28/2023 05:56:02], [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 = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/10/01' , departure_date = '2023/10/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 05:56:02' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[09/28/2023 05:56:02], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:56:02' WHERE id= '96';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549128';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549128';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549128';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-09-28 05:56:03.44'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-09-28 05:56:03'
                , session_id = 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1549152';
[09/28/2023 05:56: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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_79.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_79.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_79.json', 'expedia', '2023-09-28 05:56:03', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '0.345'
            , error_description = ''
            , memory_used = '1292256'
            WHERE id = '7900';
[09/28/2023 05:56:04], [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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_60.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_60.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_60.json', 'expedia', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_79.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_79.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_79.json', 'expedia', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_36.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_36.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_36.json', 'expedia', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_13.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_13.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_13.json', 'expedia', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.43'
            , 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 = '1.332'
            , error_description = ''
            , memory_used = '30565184'
            WHERE id = '7901';
[09/28/2023 05:56:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '1.422'
            , error_description = ''
            , memory_used = '41068832'
            WHERE id = '7902';
[09/28/2023 05:56:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '1.520'
            , error_description = ''
            , memory_used = '42498896'
            WHERE id = '7904';
[09/28/2023 05:56:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '1.520'
            , error_description = ''
            , memory_used = '45161104'
            WHERE id = '7903';
[09/28/2023 05:56:04], [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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_21.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_21.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_21.json', 'expediapackage', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1/28_09_2023/request_availability_sqtech_05_56_03_1695880563_68.json', 'e1/28_09_2023/response_availability_sqtech_05_56_03_1695880563_68.json', 'e1/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_68.json', 'expedia', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_64.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_64.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_64.json', 'expediapackage', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_2.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_2.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_2.json', 'expediapackage', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_18.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_18.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_18.json', 'expediapackage', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:04], [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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_89.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_89.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_89.json', 'expediapackage', '2023-09-28 05:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '1.966'
            , error_description = ''
            , memory_used = '49382032'
            WHERE id = '7905';
[09/28/2023 05:56: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', 'e1p/28_09_2023/request_availability_sqtech_05_56_03_1695880563_91.json', 'e1p/28_09_2023/response_availability_sqtech_05_56_03_1695880563_91.json', 'e1p/28_09_2023/response_header_availability_sqtech_05_56_03_1695880563_91.json', 'expediapackage', '2023-09-28 05:56:05', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.43'
            , 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 = '2.008'
            , error_description = ''
            , memory_used = '1293248'
            WHERE id = '7911';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '2.079'
            , error_description = ''
            , memory_used = '48021264'
            WHERE id = '7906';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '2.139'
            , error_description = ''
            , memory_used = '49970024'
            WHERE id = '7907';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '2.192'
            , error_description = ''
            , memory_used = '34029592'
            WHERE id = '7909';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '2.283'
            , error_description = ''
            , memory_used = '53052280'
            WHERE id = '7908';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 05:56:03.44'
            , 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 = '2.358'
            , error_description = ''
            , memory_used = '52319552'
            WHERE id = '7910';
[09/28/2023 05:56:05], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:56:05' WHERE id= '96';
[09/28/2023 05:56:09], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:56:09' WHERE id= '96';
[09/28/2023 05:57:27], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:57:27' WHERE id= '96';
[09/28/2023 05:57:28], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:57:28' WHERE id= '96';
[09/28/2023 05:57:28], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695880648','43.239.53.130');
[09/28/2023 05:57:28], [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', 'e1p/28_09_2023/request_valuation_sqtech_05_57_28_1695880648_32.json', 'e1p/28_09_2023/response_valuation_sqtech_05_57_28_1695880648_32.json', 'e1p/28_09_2023/response_header_valuation_sqtech_05_57_28_1695880648_32.json', 'expediapackage', '2023-09-28 05:57:28', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:57:28], [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 ('Oyo 75321 Gemma Patong', 'phuket', '136', '7839', '', '28', '', 'hotelcancellationpolicy', '2023-09-28 :05:57:28','');
[09/28/2023 05:57:33], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:57:33' WHERE id= '96';
[09/28/2023 05:57:33], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:57:33' WHERE id= '96';
[09/28/2023 05:57:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695880653','43.239.53.130');
[09/28/2023 05:57:34], [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', 'e1p/28_09_2023/request_valuation_sqtech_05_57_33_1695880653_10.json', 'e1p/28_09_2023/response_valuation_sqtech_05_57_33_1695880653_10.json', 'e1p/28_09_2023/response_header_valuation_sqtech_05_57_33_1695880653_10.json', 'expediapackage', '2023-09-28 05:57:34', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:57:49], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:57:49' WHERE id= '96';
[09/28/2023 05:58:32], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:58:32' WHERE id= '96';
[09/28/2023 05:58:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695880712','43.239.53.130');
[09/28/2023 05:58:32], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 05:58:32' WHERE id= '96';
[09/28/2023 05:58:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '723', create_date = '2023-09-28 05:58:33', agent_id = '7839', parent_agent_id = '7839', agent_ref_no = '', nationality = 'Indian', city_id = 'phuket', country_id = '136', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '8.57', display_currency_code = 'USD', native_room_rate = '8.57', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2023/10/01', check_out_date = '2023/10/02', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Sujay', leader_last_name = 'Raut', status_date = '2023-09-28 05:58:33';
[09/28/2023 05:58:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='23'
		;
[09/28/2023 05:58:33], [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('23','723','','1','2','0','-','','','7826104','OYO 75321 Gemma Patong','I Karoon, Soi Nanairoumjai, Karon','66-0-20261271','3.0','1','2023/10/01','2023/10/02','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzgwMDAwMDAvNzgzMDAwMC83ODI2MjAwLzc4MjYxMDQvNTlkYzkyZWNfYi5qcGc=');
[09/28/2023 05:58:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '23', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Save45%)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:8.5700000000000003;s:25:"displayNightlyRateDisplay";s:151:"Rate - 8.57,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 0.6 USD, Marketing Fee - 0.6  USD Discount - 0  #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:8.5700000000000003;}}', native_room_rate_total = '8.57', display_room_rate_total = '8.57', number_of_rooms = '1', room_category = 'FullBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Save45%)</font></b><br>(1 Double Bed)', meal_basis = 'Room Only';
[09/28/2023 05:58:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '23', booking_detail_id = '1', rid = '28', room = '0', salutations = 'Mr', first_name = 'Sujay', last_name = 'Raut', passenger_type = 'adult', age = '';
[09/28/2023 05:58:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '23', booking_detail_id = '1', rid = '28', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[09/28/2023 05:58:34], [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 ('', 'reservation', 'e1p/28_09_2023/request_reservation_sqtech_05_58_33_1695880713_26.json', 'e1p/28_09_2023/response_reservation_sqtech_05_58_33_1695880713_26.json', 'e1p/28_09_2023/response_header_reservation_sqtech_05_58_33_1695880713_26.json', 'expediapackage', '2023-09-28 05:58:34', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7625016725029', confirmation_number = '7625016725029', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:59:59 on  2023-09-25<br>If you cancel between 2023-09-25 13:00:00 and 2023-10-01 00:00:00 , you will be charged 8.57 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 13:00 on 25th of September 2023.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2023-09-25 11:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Save45%,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Demo@User', sales_manager_id = '0', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '3.7507', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Save45%,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7839',  sub_agent_rate='0',  agent_rate='8.57',  applicable_service_tax='0',  supplier_rate='8.57',  uid='21b84c41af580f01935c9abec0388e75'  where id='23';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='23';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('23','7.883317','98.296885');
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'sqtech',`create_date`= '2023-09-28 05:58:34',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;23\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -23 And Booking Status - confirmed',`ip`= '43.239.53.130';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='223', `entity`='BookingId', `value`='23' ;
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set invoice_number= 'INV28092300027', voucher_id='1111',status_date='2023-09-28 05:58:34',current_status='vouchered',voucher_hashcode='577b543548e224ea8d9a4020cd7e61fc8095223',vouchered_by ='' where id='23';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set is_invoiced='yes',invoice_number= 'INV28092300027' where id='23' and is_invoiced!='yes';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE agents SET credit_usage=credit_usage+('32.143499'),   credit_value= credit_value-('32.143499') ,  cd_credit_usage=cd_credit_usage+('32.143499') , cd_credit_value=cd_credit_value-('32.143499')  WHERE id = '7839';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into  agent_credit_log SET agent_id= '7839',credit_value= '998306.267',credit_usage= '1693.733',credit_limit= '1000000.000',receipt_id= '',amount= '32.143499',booking_id='23',booking_cost= '8.57',receipt_allocation= '',balance= '8.57',ip='43.239.53.130',user_type='User',admin_id='Agent - Sujay  Test(CD7839)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2023-09-28 05:09:34';
[09/28/2023 05:58:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_rate_info set  booking_id = '23', booking_log = 'Booking Vouchered', create_date = '2023-09-28 05:58:34', supplier_currency ='USD', type = 'Sale', agent_price = '8.57', sub_agent_price ='', supplier_price = '8.570', supplier_id = 'expediapackage', supplier_type = 'online';
[09/28/2023 05:58:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','23','vouchered-invoiced','2023-09-28 05:58:36','Booking invoiced by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','','','');
[09/28/2023 05:58:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO agent_commission SET booking_id ='23',booking_detail_id ='23',agent_id ='7839',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2023-09-28 05:58:36';
[09/28/2023 05:58:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','23','vouchered','2023-09-28 05:58:36','Voucherd by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','','','');
[09/28/2023 05:58:38], [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 ('723','23','confirmed','2023-09-28 05:58:34','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','0','7839');
[09/28/2023 05:58:38], [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('23','2023-09-25 13:00:00','2023-09-29 13:00:00','2023-10-01 00:00:00','2023-10-05 00:00:00','8.57','8.57','96','2023-09-28 05:58:38','8.57');
[09/28/2023 05:58:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='23',status='1' where reservation_id='723' and booking_id ='0';
[09/28/2023 05:58:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='23' where agent_logs_id='0' and source_type='expediapackage';
[09/28/2023 05:58:38], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='0.6',  commission_tax='',  booking_id ='23',  supplier_tax='0.9',  supplier_base_fare='7.67',  supplier_commissionable_fare='0.6'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-09-28 05:58:38';
