[05/09/2024 07:17:29], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-09 07:17:29',login_attempt=0 where id = '7873';
[05/09/2024 07:17:29], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-05-09 07:17:29', ip = '43.239.53.130', action = 'Login' ;
[05/09/2024 07:17:30], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7873', session_id='e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',create_date='2024-05-09 07:17:30', update_date='2024-05-09 07:17:30',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[05/09/2024 07:17:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:33' WHERE id= '850';
[05/09/2024 07:17:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:36' WHERE id= '850';
[05/09/2024 07:17:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/10' , departure_date = '2024/05/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-09 07:17:36' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/09/2024 07:17:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:36' WHERE id= '850';
[05/09/2024 07:17:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '121',
        request_path = '/xml_all.php?userid=7873&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',
        duration = '0.851',
        merge_duration = '0.016',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '8.62',
        system_load_5_min = '10.32',
        system_load_15_min = '8.06',
        system_memory_usage = '86.69',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1627') + '1930776',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1627';
[05/09/2024 07:17:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:37' WHERE id= '850';
[05/09/2024 07:17:39], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:39' WHERE id= '850';
[05/09/2024 07:17:55], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:55' WHERE id= '850';
[05/09/2024 07:17:56], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:56' WHERE id= '850';
[05/09/2024 07:17:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:17:58' WHERE id= '850';
[05/09/2024 07:18:02], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:02' WHERE id= '850';
[05/09/2024 07:18:19], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:19' WHERE id= '850';
[05/09/2024 07:18:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:21' WHERE id= '850';
[05/09/2024 07:18:23], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:23' WHERE id= '850';
[05/09/2024 07:18:23], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-09 07:18:23',login_attempt=0 where id = '7873';
[05/09/2024 07:18:23], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-05-09 07:18:23', ip = '43.239.53.130', action = 'Login' ;
[05/09/2024 07:18:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:24' WHERE id= '850';
[05/09/2024 07:18:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:27' WHERE id= '850';
[05/09/2024 07:18:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:31' WHERE id= '850';
[05/09/2024 07:18:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/10' , departure_date = '2024/05/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-09 07:18:31' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/09/2024 07:18:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:32' WHERE id= '850';
[05/09/2024 07:18:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '121',
        request_path = '/xml_all.php?userid=7873&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',
        duration = '0.482',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '11.16',
        system_load_5_min = '10.73',
        system_load_15_min = '8.33',
        system_memory_usage = '87.19',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1628') + '1737416',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1628';
[05/09/2024 07:18:32], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:32' WHERE id= '850';
[05/09/2024 07:18:34], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:18:34' WHERE id= '850';
[05/09/2024 07:22:42], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:22:42' WHERE id= '850';
[05/09/2024 07:22:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:22:45' WHERE id= '850';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '67' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '52' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '80' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '24' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '77' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '65' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '34' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '55' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '62' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '53' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '16' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '78' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '75' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '60' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '18' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '73' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '71' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '69' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '68' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '74' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '35' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '70' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '59' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '32' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '58' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '56' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '57' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '61' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '63' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '54' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/09/2024 07:23:23], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-09 07:23:23',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 80 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#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-7873 ## supplier_id- 80 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/09/2024 07:23:28], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:28' WHERE id= '850';
[05/09/2024 07:23:28], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-09 07:23:28',login_attempt=0 where id = '7873';
[05/09/2024 07:23:28], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-05-09 07:23:28', ip = '43.239.53.130', action = 'Login' ;
[05/09/2024 07:23:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:29' WHERE id= '850';
[05/09/2024 07:23:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:33' WHERE id= '850';
[05/09/2024 07:23:38], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:38' WHERE id= '850';
[05/09/2024 07:23:38], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/10' , departure_date = '2024/05/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-09 07:23:38' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/09/2024 07:23:39], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:39' WHERE id= '850';
[05/09/2024 07:23: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', 'e1p/09_05_2024/request_availability_Gajendra_1629_1715239419_24.json', 'e1p/09_05_2024/response_availability_Gajendra_1629_1715239419_24.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1629_1715239419_24.json', 'expediapackage', '2024-05-09 07:23:39', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23:39], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.718'
        , request_start_time = '0.035'
        , parsing_start_time = '0.206'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.256'
        , error_description = ''
        , memory_used = '1362736'
        WHERE id = '544507';
[05/09/2024 07:23: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', 'e1/09_05_2024/request_availability_Gajendra_1629_1715239419_20.json', 'e1/09_05_2024/response_availability_Gajendra_1629_1715239419_20.json', 'e1/09_05_2024/response_header_availability_Gajendra_1629_1715239419_20.json', 'expedia', '2024-05-09 07:23:40', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23:40], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.719'
        , request_start_time = '0.036'
        , parsing_start_time = '0.425'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.473'
        , error_description = ''
        , memory_used = '1362488'
        WHERE id = '544508';
[05/09/2024 07:23: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', 'e1/09_05_2024/request_availability_Gajendra_1629_1715239419_92.json', 'e1/09_05_2024/response_availability_Gajendra_1629_1715239419_92.json', 'e1/09_05_2024/response_header_availability_Gajendra_1629_1715239419_92.json', 'expedia', '2024-05-09 07:23:40', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23: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', 'e1/09_05_2024/request_availability_Gajendra_1629_1715239419_15.json', 'e1/09_05_2024/response_availability_Gajendra_1629_1715239419_15.json', 'e1/09_05_2024/response_header_availability_Gajendra_1629_1715239419_15.json', 'expedia', '2024-05-09 07:23:40', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23: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', 'e1p/09_05_2024/request_availability_Gajendra_1629_1715239419_40.json', 'e1p/09_05_2024/response_availability_Gajendra_1629_1715239419_40.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1629_1715239419_40.json', 'expediapackage', '2024-05-09 07:23:41', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.718'
        , request_start_time = '0.036'
        , parsing_start_time = '1.198'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.256'
        , search_end_time = '0.305'
        , total_duration = '1.846'
        , error_description = ''
        , memory_used = '108119336'
        WHERE id = '544510';
[05/09/2024 07:23: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', 'e1p/09_05_2024/request_availability_Gajendra_1629_1715239419_49.json', 'e1p/09_05_2024/response_availability_Gajendra_1629_1715239419_49.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1629_1715239419_49.json', 'expediapackage', '2024-05-09 07:23:41', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1629');
[05/09/2024 07:23:41], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.718'
        , request_start_time = '0.018'
        , parsing_start_time = '1.458'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.294'
        , search_end_time = '0.362'
        , total_duration = '2.189'
        , error_description = ''
        , memory_used = '122809600'
        WHERE id = '544511';
[05/09/2024 07:23:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.718'
        , request_start_time = '0.018'
        , parsing_start_time = '2.030'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.314'
        , search_end_time = '0.384'
        , total_duration = '2.827'
        , error_description = ''
        , memory_used = '134752856'
        WHERE id = '544512';
[05/09/2024 07:23:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:23:39.718'
        , request_start_time = '0.037'
        , parsing_start_time = '2.435'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.277'
        , search_end_time = '0.365'
        , total_duration = '3.165'
        , error_description = ''
        , memory_used = '118832736'
        WHERE id = '544513';
[05/09/2024 07:23:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '382',
        request_path = '/xml_all.php?userid=7873&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',
        duration = '3.993',
        merge_duration = '0.644',
        assigned_supplier_count = '3',
        searched_supplier_count = '3',
        system_load_1_min = '5.69',
        system_load_5_min = '7.81',
        system_load_15_min = '7.75',
        system_memory_usage = '88.13',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1629') + '24316216',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1629';
[05/09/2024 07:23:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:43' WHERE id= '850';
[05/09/2024 07:23:44], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:44' WHERE id= '850';
[05/09/2024 07:23:45], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:23:45' WHERE id= '850';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '67' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '52' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '80' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '24' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '77' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '65' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '34' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '20' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '55' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '62' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '53' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '16' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '78' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '75' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '60' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '18' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '73' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '71' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '69' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '68' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '74' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '35' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '70' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '59' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '32' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '58' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '56' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '57' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '61' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '63' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '54' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/09/2024 07:30:05], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-09 07:30:05',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 80 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#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-7873 ## supplier_id- 80 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7873 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7873 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/09/2024 07:30:08], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:08' WHERE id= '850';
[05/09/2024 07:30:09], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-09 07:30:09',login_attempt=0 where id = '7873';
[05/09/2024 07:30:09], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-05-09 07:30:09', ip = '43.239.53.130', action = 'Login' ;
[05/09/2024 07:30:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:09' WHERE id= '850';
[05/09/2024 07:30:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:12' WHERE id= '850';
[05/09/2024 07:30:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:15' WHERE id= '850';
[05/09/2024 07:30:15], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/10' , departure_date = '2024/05/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-09 07:30:15' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/09/2024 07:30:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:16' WHERE id= '850';
[05/09/2024 07:30:16], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.835'
            , total_duration = '0.097'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:16'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:16], [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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-09 07:30:16', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.838'
            , total_duration = '0.167'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:17'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.839'
            , total_duration = '0.174'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:17'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.839'
            , total_duration = '0.220'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:17'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.836'
            , total_duration = '0.226'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:17'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:30:16.848'
            , total_duration = '0.225'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:30:17'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1630'
            , error_description = ''
            , memory_used = '2265664';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-09 07:30:16.839'
        , request_start_time = '0.074'
        , parsing_start_time = '0.102'
        , mapping_complete_time = '0.120'
        , mongo_start_time = '0.121'
        , search_end_time = '0.000'
        , total_duration = '0.332'
        , error_description = ''
        , memory_used = '4042456'
        WHERE id = '544515';
[05/09/2024 07:30: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', 'e1p/09_05_2024/request_availability_Gajendra_1630_1715239817_3.json', 'e1p/09_05_2024/response_availability_Gajendra_1630_1715239817_3.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1630_1715239817_3.json', 'expediapackage', '2024-05-09 07:30:17', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30: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', 'e1/09_05_2024/request_availability_Gajendra_1630_1715239817_67.json', 'e1/09_05_2024/response_availability_Gajendra_1630_1715239817_67.json', 'e1/09_05_2024/response_header_availability_Gajendra_1630_1715239817_67.json', 'expedia', '2024-05-09 07:30:17', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.839'
        , request_start_time = '0.142'
        , parsing_start_time = '0.217'
        , mapping_complete_time = '0.020'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.498'
        , error_description = ''
        , memory_used = '1352280'
        WHERE id = '544522';
[05/09/2024 07:30:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.830'
        , request_start_time = '0.118'
        , parsing_start_time = '0.222'
        , mapping_complete_time = '0.018'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.547'
        , error_description = ''
        , memory_used = '1351968'
        WHERE id = '544523';
[05/09/2024 07:30: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', 'e1/09_05_2024/request_availability_Gajendra_1630_1715239817_18.json', 'e1/09_05_2024/response_availability_Gajendra_1630_1715239817_18.json', 'e1/09_05_2024/response_header_availability_Gajendra_1630_1715239817_18.json', 'expedia', '2024-05-09 07:30:18', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30: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', 'e1/09_05_2024/request_availability_Gajendra_1630_1715239817_17.json', 'e1/09_05_2024/response_availability_Gajendra_1630_1715239817_17.json', 'e1/09_05_2024/response_header_availability_Gajendra_1630_1715239817_17.json', 'expedia', '2024-05-09 07:30:18', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30: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', 'e1p/09_05_2024/request_availability_Gajendra_1630_1715239817_87.json', 'e1p/09_05_2024/response_availability_Gajendra_1630_1715239817_87.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1630_1715239817_87.json', 'expediapackage', '2024-05-09 07:30:18', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30: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', 'e1p/09_05_2024/request_availability_Gajendra_1630_1715239817_30.json', 'e1p/09_05_2024/response_availability_Gajendra_1630_1715239817_30.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1630_1715239817_30.json', 'expediapackage', '2024-05-09 07:30:18', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1630');
[05/09/2024 07:30:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.843'
        , request_start_time = '0.151'
        , parsing_start_time = '1.892'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.523'
        , search_end_time = '1.067'
        , total_duration = '3.811'
        , error_description = ''
        , memory_used = '107859288'
        WHERE id = '544526';
[05/09/2024 07:30:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.849'
        , request_start_time = '0.087'
        , parsing_start_time = '2.576'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.563'
        , search_end_time = '0.549'
        , total_duration = '3.936'
        , error_description = ''
        , memory_used = '118301744'
        WHERE id = '544528';
[05/09/2024 07:30:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.832'
        , request_start_time = '0.083'
        , parsing_start_time = '2.677'
        , mapping_complete_time = '0.004'
        , mongo_start_time = '0.585'
        , search_end_time = '0.503'
        , total_duration = '4.131'
        , error_description = ''
        , memory_used = '134535024'
        WHERE id = '544527';
[05/09/2024 07:30:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:30:16.837'
        , request_start_time = '0.115'
        , parsing_start_time = '2.048'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.824'
        , search_end_time = '0.961'
        , total_duration = '4.209'
        , error_description = ''
        , memory_used = '122590568'
        WHERE id = '544525';
[05/09/2024 07:30:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '382',
        request_path = '/xml_all.php?userid=7873&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',
        duration = '5.546',
        merge_duration = '0.741',
        assigned_supplier_count = '5',
        searched_supplier_count = '5',
        system_load_1_min = '3.82',
        system_load_5_min = '9.49',
        system_load_15_min = '9.02',
        system_memory_usage = '84.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1630') + '25252848',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1630';
[05/09/2024 07:30:21], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:21' WHERE id= '850';
[05/09/2024 07:30:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:22' WHERE id= '850';
[05/09/2024 07:30:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:22' WHERE id= '850';
[05/09/2024 07:30:24], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:30:24' WHERE id= '850';
[05/09/2024 07:44:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:44:15' WHERE id= '850';
[05/09/2024 07:44:17], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:44:17' WHERE id= '850';
[05/09/2024 07:51:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:51:56' WHERE id= '850';
[05/09/2024 07:52:03], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:03' WHERE id= '850';
[05/09/2024 07:52:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-09 07:52:03',login_attempt=0 where id = '7873';
[05/09/2024 07:52:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-05-09 07:52:03', ip = '43.239.53.130', action = 'Login' ;
[05/09/2024 07:52:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:03' WHERE id= '850';
[05/09/2024 07:52:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:07' WHERE id= '850';
[05/09/2024 07:52:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:13' WHERE id= '850';
[05/09/2024 07:52:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/10' , departure_date = '2024/05/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-09 07:52:13' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[05/09/2024 07:52:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:13' WHERE id= '850';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.019'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.020'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.022'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.022'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.023'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
            type = 'ERROR'
            , http_hit_time = '2024-05-09 07:52:13.997'
            , total_duration = '0.024'
            , hotel_count = 0
            , source_type = 'hotelbeds'
            , create_date = '2024-05-09 07:52:14'
            , session_id = 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f'
            , agent_logs_id = '1631'
            , error_description = ''
            , memory_used = '2035272';
[05/09/2024 07:52: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', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-09 07:52:14', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&request_no=0&local_hotel_code=5&#039;,&#039;6&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.029'
        , parsing_start_time = '0.011'
        , mapping_complete_time = '0.013'
        , mongo_start_time = '0.013'
        , search_end_time = '0.000'
        , total_duration = '0.069'
        , error_description = ''
        , memory_used = '4489240'
        WHERE id = '544535';
[05/09/2024 07:52: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', 'e1p/09_05_2024/request_availability_Gajendra_1631_1715241134_95.json', 'e1p/09_05_2024/response_availability_Gajendra_1631_1715241134_95.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1631_1715241134_95.json', 'expediapackage', '2024-05-09 07:52:14', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.999'
        , request_start_time = '0.039'
        , parsing_start_time = '0.204'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.259'
        , error_description = ''
        , memory_used = '1352184'
        WHERE id = '544537';
[05/09/2024 07:52: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', 'e1/09_05_2024/request_availability_Gajendra_1631_1715241134_69.json', 'e1/09_05_2024/response_availability_Gajendra_1631_1715241134_69.json', 'e1/09_05_2024/response_header_availability_Gajendra_1631_1715241134_69.json', 'expedia', '2024-05-09 07:52:14', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=2&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.038'
        , parsing_start_time = '0.398'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.453'
        , error_description = ''
        , memory_used = '1351944'
        WHERE id = '544539';
[05/09/2024 07:52: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', 'e1/09_05_2024/request_availability_Gajendra_1631_1715241134_85.json', 'e1/09_05_2024/response_availability_Gajendra_1631_1715241134_85.json', 'e1/09_05_2024/response_header_availability_Gajendra_1631_1715241134_85.json', 'expedia', '2024-05-09 07:52:14', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52: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', 'e1/09_05_2024/request_availability_Gajendra_1631_1715241134_92.json', 'e1/09_05_2024/response_availability_Gajendra_1631_1715241134_92.json', 'e1/09_05_2024/response_header_availability_Gajendra_1631_1715241134_92.json', 'expedia', '2024-05-09 07:52:15', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52: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', 'e1p/09_05_2024/request_availability_Gajendra_1631_1715241134_86.json', 'e1p/09_05_2024/response_availability_Gajendra_1631_1715241134_86.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1631_1715241134_86.json', 'expediapackage', '2024-05-09 07:52:15', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52: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', 'e1p/09_05_2024/request_availability_Gajendra_1631_1715241134_42.json', 'e1p/09_05_2024/response_availability_Gajendra_1631_1715241134_42.json', 'e1p/09_05_2024/response_header_availability_Gajendra_1631_1715241134_42.json', 'expediapackage', '2024-05-09 07:52:15', '', 'e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f', '1631');
[05/09/2024 07:52:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.036'
        , parsing_start_time = '1.212'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.257'
        , search_end_time = '0.384'
        , total_duration = '1.946'
        , error_description = ''
        , memory_used = '107820616'
        WHERE id = '544540';
[05/09/2024 07:52:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '148'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=1&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.039'
        , parsing_start_time = '1.721'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.280'
        , search_end_time = '0.335'
        , total_duration = '2.432'
        , error_description = ''
        , memory_used = '118328256'
        WHERE id = '544542';
[05/09/2024 07:52:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expediapackage&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.021'
        , parsing_start_time = '1.781'
        , mapping_complete_time = '0.001'
        , mongo_start_time = '0.320'
        , search_end_time = '0.410'
        , total_duration = '2.635'
        , error_description = ''
        , memory_used = '134252352'
        WHERE id = '544543';
[05/09/2024 07:52:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = '187'
        , request_url = '/call.php?s=expedia&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f&xml_user_id=7873&db_caching=1&erequest=0&total_request=3&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-05-09 07:52:13.997'
        , request_start_time = '0.021'
        , parsing_start_time = '1.736'
        , mapping_complete_time = '0.002'
        , mongo_start_time = '0.490'
        , search_end_time = '0.389'
        , total_duration = '2.697'
        , error_description = ''
        , memory_used = '122147984'
        WHERE id = '544541';
[05/09/2024 07:52:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '382',
        request_path = '/xml_all.php?userid=7873&sessionid=e53dc7dea8e29bd4a60fea3401169eeec959a40542b7cb2c6e07272bbfe25e4f',
        duration = '3.674',
        merge_duration = '0.691',
        assigned_supplier_count = '5',
        searched_supplier_count = '5',
        system_load_1_min = '4.38',
        system_load_5_min = '8.34',
        system_load_15_min = '9.55',
        system_memory_usage = '89.37',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1631') + '25163664',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1631';
[05/09/2024 07:52:17], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:17' WHERE id= '850';
[05/09/2024 07:52:19], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-05-09 07:52:19' WHERE id= '850';
[05/09/2024 07:59:13], [file name :-/home/otrams/public_html/beta/forgot_password.php],update sub_user set hash='fd'8'55f243f5fa538dc52dc9e46a77ce'8'' where sub_user_id= ? and status !='D';
