[06/20/2024 01:03:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-20 01:03:01',login_attempt=0 where id = '7857';
[06/20/2024 01:03:01], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-06-20 13:03:01', ip = '43.239.53.130', action = 'Login' ;
[06/20/2024 01:03:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/17' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-20 13:03:23' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[06/20/2024 01:03:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=78572020240613032386266576872',
        duration = '0.131',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.67',
        system_load_5_min = '15.19',
        system_load_15_min = '13.59',
        system_memory_usage = '90.45',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2352') + '2709936',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2352';
[06/20/2024 01:12:14], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_key SET supplier='travco',`key`='TRAVCO_PATH_7';
[06/20/2024 01:12:14], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'VjdrUlU0a1NQUGFUWitvVE9KNGsxdz09',key_value = 'alFGZ3R4di9ka2dFSUVUKy8wRUZXTnFBZWZpdnp0NWZUMVFCM2dkU0FWb3hxVzNVOVRla05SV3VaOW16clIvSDVURGNwM3BmdUdEck5zU05pODM4Nnc9PQ==' ;
[06/20/2024 01:12:54], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_key SET supplier='travco',`key`='TRAVCO_SCHEMA_7';
[06/20/2024 01:12:54], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'SC9MdDUrODhaT0FGQkg0ZS95S2pjdz09',key_value = 'SnZIU0t4Skw3cHJTMmhBTmUxV21vTE1DTXZHbUpXcWdBNTA1TjNDak1JQW1qU09JS2JaUjEyZkt4M1N3Q1NZcQ==' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='yes' where supplier_profile_id= ?;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='no' where supplier_id= 'travco'  and supplier_profile_id!= '10';
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET modify_by = 'v3alpha',modify_date = '2024-06-20 01:13:09' where supplier_id= 'travco'  and supplier_profile_id= '10';
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_countries  where supplier_profile_id= ?;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_countries SET country_id =? ,supplier_profile_id = ? ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_access  where supplier_profile_id= ? ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'd1RHcVo4alkycDg4WEFyVlRiU2tpZlZmVSs4N05vK2FkbDJFOVdORWdTbz0=',key_value = 'OVNFZ1M2ZS9EbFJUWnVyQ1ZtNWNUUT09' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'dkFzT3FKZGtiS1BUbjlITXhaVVp6Zz09',key_value = 'YXljYWxMMGNQdUNCUldSMmRFOHk4QT09' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'SC9MdDUrODhaT0FGQkg0ZS95S2pjdz09',key_value = 'SnZIU0t4Skw3cHJTMmhBTmUxV21vTE1DTXZHbUpXcWdBNTA1TjNDak1JQW1qU09JS2JaUjEyZkt4M1N3Q1NZcQ==' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'SXBFNlpqNGxQdGRjYytZbnk0ZDdndz09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5a0tPanVmZEhIVzZ2TkpSL0NISjYrSTl5d1poSUczUXVGcWp6S3hCRGRJOG1iWGlDbXRubHdxeWZ5aHZIVk9rb0E9PQ==' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'VjdrUlU0a1NQUGFUWitvVE9KNGsxdz09',key_value = 'alFGZ3R4di9ka2dFSUVUKy8wRUZXTnFBZWZpdnp0NWZUMVFCM2dkU0FWb3hxVzNVOVRla05SV3VaOW16clIvSDVURGNwM3BmdUdEck5zU05pODM4Nnc9PQ==' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZjJXcW8zaXh3MjVsaG0rcnZrRjBNQmdRc2RpQTlUd0R4dmkwcUM0dndSOD0=',key_value = 'M0d2SS8ra0szNFpTcUVEQm43SUVNUT09' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZnQzMTd4cjJXdEorSGQ5RFJqUmFLUT09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5cVhTRTNsUHVEQzVxVmdLbzBablFwUT0=' ;
[06/20/2024 01:13:09], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZWlBWTFTQjJIQUNUbTZRQ3JsQTE5QT09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5a0tPanVmZEhIVzZ2TkpSL0NISjYrTEdxQ09VWGlUbmFtTnE4ZlBMRHNEZw==' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='yes' where supplier_profile_id= ?;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='no' where supplier_id= 'travco'  and supplier_profile_id!= '10';
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET modify_by = 'v3alpha',modify_date = '2024-06-20 01:15:15' where supplier_id= 'travco'  and supplier_profile_id= '10';
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_countries  where supplier_profile_id= ?;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_countries SET country_id =? ,supplier_profile_id = ? ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_access  where supplier_profile_id= ? ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'd1RHcVo4alkycDg4WEFyVlRiU2tpZlZmVSs4N05vK2FkbDJFOVdORWdTbz0=',key_value = 'R3ZHbE0zMGpCYmpvMmNxejBOMm9Wdz09' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'dkFzT3FKZGtiS1BUbjlITXhaVVp6Zz09',key_value = 'bGpKQW8zK2cwK2tpa1YyNW90cG5Sdz09' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'SC9MdDUrODhaT0FGQkg0ZS95S2pjdz09',key_value = 'SnZIU0t4Skw3cHJTMmhBTmUxV21vTE1DTXZHbUpXcWdBNTA1TjNDak1JQW1qU09JS2JaUjEyZkt4M1N3Q1NZcQ==' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'SXBFNlpqNGxQdGRjYytZbnk0ZDdndz09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5a0tPanVmZEhIVzZ2TkpSL0NISjYrSTl5d1poSUczUXVGcWp6S3hCRGRJOG1iWGlDbXRubHdxeWZ5aHZIVk9rb0E9PQ==' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'VjdrUlU0a1NQUGFUWitvVE9KNGsxdz09',key_value = 'alFGZ3R4di9ka2dFSUVUKy8wRUZXTnFBZWZpdnp0NWZUMVFCM2dkU0FWb3hxVzNVOVRla05SV3VaOW16clIvSDVURGNwM3BmdUdEck5zU05pODM4Nnc9PQ==' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZjJXcW8zaXh3MjVsaG0rcnZrRjBNQmdRc2RpQTlUd0R4dmkwcUM0dndSOD0=',key_value = 'M0d2SS8ra0szNFpTcUVEQm43SUVNUT09' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZnQzMTd4cjJXdEorSGQ5RFJqUmFLUT09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5cVhTRTNsUHVEQzVxVmdLbzBablFwUT0=' ;
[06/20/2024 01:15:15], [file name :-/efsdata/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '10',supplier_key = 'ZWlBWTFTQjJIQUNUbTZRQ3JsQTE5QT09',key_value = 'eWxpT25aZlpJQVFxeFRDVHZRbkZ5a0tPanVmZEhIVzZ2TkpSL0NISjYrTEdxQ09VWGlUbmFtTnE4ZlBMRHNEZw==' ;
[06/20/2024 01:15:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-20 01:15:43',login_attempt=0 where id = '7857';
[06/20/2024 01:15:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-06-20 13:15:43', ip = '43.239.53.130', action = 'Login' ;
[06/20/2024 01:16:06], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/17' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-20 13:16:06' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[06/20/2024 01:16:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=78572020240613160683989450895',
        duration = '0.152',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.81',
        system_load_5_min = '4.76',
        system_load_15_min = '8.15',
        system_memory_usage = '97.01',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2353') + '2710168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2353';
[06/20/2024 01:47:03], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-20 01:47:03',login_attempt=0 where id = '7857';
[06/20/2024 01:47:03], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-06-20 13:47:03', ip = '43.239.53.130', action = 'Login' ;
[06/20/2024 01:47:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/16' , departure_date = '2024/10/17' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-20 13:47:28' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[06/20/2024 01:47:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=78572020240613472878879753083',
        duration = '0.166',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.21',
        system_load_5_min = '2.83',
        system_load_15_min = '7.04',
        system_memory_usage = '94.61',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2354') + '2710168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2354';
[06/20/2024 01:50:27], [file name :-/efsdata/otrams/public_html/beta/about_us.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-06-20 13:50:27', ip = '40.77.167.15', action = 'Login' ;
[06/20/2024 01:50:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-20 01:50:50',login_attempt=0 where id = '7857';
[06/20/2024 01:50:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-06-20 13:50:50', ip = '43.239.53.130', action = 'Login' ;
[06/20/2024 01:51:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/08/07' , departure_date = '2024/08/08' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-20 13:51:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[06/20/2024 01:51:34], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=78572020240613513330528548320',
        duration = '0.200',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.39',
        system_load_5_min = '1.47',
        system_load_15_min = '5.50',
        system_memory_usage = '95.02',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2355') + '2710168',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2355';
